THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Database Administration   (RSS)
Showing page 8 of 8 (76 total posts)
  • Aviate, Navigate, Communicate

    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 the area). Third, communicate your intentions, needs, etc. with the proper services, be they ...
    Posted to Allen White (Weblog) by AllenMWhite on April 6, 2008
  • PowerShell, SQL Server and Large Resultsets

    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 of rows. In this case a DataTable isn't too practical, and a forward-only DataReader is ...
    Posted to Allen White (Weblog) by AllenMWhite on February 1, 2008
  • Very Large Database Maintenance

    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. I wasn't able to start my process until Friday at noon, and had space on my backup drive to ...
    Posted to Allen White (Weblog) by AllenMWhite on November 26, 2007
  • Pay Attention to Cluster Setup

    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 animal altogether. We have three High Availability clusters in our shop, and they've been ...
    Posted to Allen White (Weblog) by AllenMWhite on October 8, 2007
  • Checklists

    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 much fuel you have (because guages can malfunction, just like everything else)? When you're ...
    Posted to Allen White (Weblog) by AllenMWhite on September 4, 2007
  • Use Trace to capture Production Server Activity

    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 Completed and Batch Completed events, so I know what was submitted to the server for processing ...
    Posted to Allen White (Weblog) by AllenMWhite on August 28, 2007
« First ... < Previous 4 5 6 7 8
Privacy Statement