|
|
|
|
Browse by Tags
All Tags » Database Administration (RSS)
-
Large(r) companies tend to have a defined process for implementing change in their data centers, but small(er) companies tend not to. (Your Mileage May Vary.) This makes sense, as large companies usually have more systems dependent on each other, and Read More...
|
-
We are pleased to invite you to the October 9th 2008 meeting of the Ohio North SQL Server Users Group (ONSSUG). The meetings are held on the 2nd Thursday of every month at 5:45 in the Cleveland Microsoft office. The address of the office is below: Microsoft Read More...
|
-
The partitioned table was one of the great new features of SQL Server 2005. We could now manage data based on some range data, usually a date value, and keep the different ranges in separate physical files, and use rolling range scripts to move old data Read More...
|
-
We all know them, they're usually developers or network admins who show some abilities when database problems arise, so they're "elected" to the role of DBA, whether they want it or not. They often don't have the necessary training or insight into the Read More...
|
-
When SQL Server Agent runs its tasks it normally does so using the context of the service account you assigned to the Agent service. This may or may not be the best context for your application, so you can set up a Proxy. This allows you to run the task Read More...
|
-
Matthias Berndt, Principal Group Program Manager at Microsoft, has just blogged about the new approach for Service Packs and Cumulative Updates. He shared this with us at the MVP Summit and it's nice to have it public now. A Changed Approach to Service Read More...
|
-
Last week I presented a session on Using SMO to Manage SQL Server at SQL Connections in Orlando, Florida. This was the third major conference I've presented this session, and each time I do this session I change more demos from VB.Net to PowerShell. This Read More...
|
-
The most important lesson I learned in flight training was in managing priorities: 1. Aviate 2. Navigate 3. Communicate First, keep the plane flying straight and level. Second, keep it going on the intended flight path (and avoid any other objects in Read More...
|
-
Last week I posted about using PowerShell and SQL Server together, and I used a SQLDataAdapter and populated a DataTable with the results. This approach is fine if what you're doing returns a reasonably small resultset, but what if you're returning millions Read More...
|
-
I've mentioned before my company manages trade shows, and we've got a series of web sites managed by an application which uses a different SQL Server database for each site, with a master database (I'll call it Global, to differentiate it from SQL Server's Read More...
|
-
I've got a third-party app that uses a SQL Server 2005 database. The database has grown to 190GB, with 150GB of that in one table (116M rows). I've been trying to get the greenlight to partition this table since June, and finally got it this weekend. Read More...
|
-
The weekend of September 29/30 we moved our Data Center from one suburb of Cleveland to another. As you install new servers or replace others it's normal to make certain everything is right before you bring them on line. A data center move is another Read More...
|
-
One of the first things a pilot is taught is to use checklists. Everything from preflight to tie down after your return is covered in aviation checklists. Did you check the thickness of the brake pads? Did you actually look in the fuel tanks to see how Read More...
|
-
One of the great things about SQL Server is that there are many ways to accomplish the same task. When problems arise it can be difficult to determine what went wrong, so I keep a trace going on all my production servers. I capture details on all RPC Read More...
|
|
|
|
|
|