Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Keep Your Data Clean

In working with client data you start to notice trends that raise flags in your mind. In my case I'm looking at data and seeing a lot of columns that have NULL in the column where a NULL doesn't mean "I don't know", it means "I was too lazy to…

Read more

1 comments, 123 reads

Posted in Allen White on 5 March 2010

Speaking at SQLSaturday #33 in Charlotte

I'll be presenting two sessions this Saturday (March 6, 2010) in Charlotte - Automate SQL Server Administration with PowerShell and Gather SQL Server Performance Data with PowerShell . The event takes place at the Microsoft Charlotte Offices on 8050 Microsoft...(read more)

Read more

0 comments, 183 reads

Posted in Allen White on 4 March 2010

Bookstores and Databases

My wife is a Board member for Project LEARN in Medina County, Ohio (just southeast of Cleveland). Last night at dinner celebrating my wife's birthday she was telling me about setting up the shelves in the new bookstore they're opening this week in our...(read more)

Read more

0 comments, 125 reads

Posted in Allen White on 3 March 2010

T-SQL Tuesday #3: Database Relationships

In my first T-SQL Tuesday submission I thought I'd mention something that we often take for granted when working with relational databases. At the basic level, a database table is really a relation . You can have a truly relational database with just...(read more)

Read more

0 comments, 193 reads

Posted in Allen White on 10 February 2010

Speaking about Indexing

I'll be presenting two sessions this week (February 9 and 11, 2010), both on SQL Server Indexing. The first is for the PASS AppDev Virtual Chapter, and will take place on Tuesday at noon EST. You can attend the meeting via this link: https://www323.livemeeting.com/cc/usergroups/join?id=8PQHN2&role=attend...(read more)

Read more

0 comments, 122 reads

Posted in Allen White on 8 February 2010

Speaking at SQLSaturday #30 in Richmond

I'll be presenting two sessions this Saturday (January 30, 2010) in Richmond - Automate SQL Server Administration with PowerShell and Gather SQL Server Performance Data with PowerShell . The event takes place at ECPI College of Technology, 4305 Cox Rd,...(read more)

Read more

1 comments, 133 reads

Posted in Allen White on 25 January 2010

PASS 2009 Evaluation Results

The results are in, and I'm pleased, but not satisfied. I delivered a brand new session called Gather SQL Server Performance Data with PowerShell , where I discussed key performance counters you should monitor and why, then a PowerShell script to gather...(read more)

Read more

0 comments, 144 reads

Posted in Allen White on 13 January 2010

Service Broker Basics - Part Deux

Last week I introduced the Service Broker Basics . Today I'd like to cover some of the "plumbing" - the components that allow communication between different servers running Service Broker. Endpoints . There needs to be a channel for the communications...(read more)

Read more

0 comments, 143 reads

Posted in Allen White on 12 January 2010

Service Broker Basics

I'm currently implementing a Service Broker solution at a client site, and it's been an interesting challenge, because there's not a lot of information out there to help guide you through the process. Here I'd like to walk you through the basics. Message...(read more)

Read more

0 comments, 235 reads

Posted in Allen White on 6 January 2010

[OT] Happy New Year

Well, it's been an interesting year. I got to teach four different brand new SQL Server courses, and teach classes in four different countries on two continents. Two books were published with chapters I wrote. Microsoft published a whitepaper I wrote....(read more)

Read more

0 comments, 513 reads

Posted in Allen White on 31 December 2009

Performance Data Gathering

As a DBA, one of the things I struggled with was gathering all my important system information in one place, so I could see easily where my problems might be. Gathering perfmon data, combining it with trace data, adding in disk space information - it...(read more)

Read more

0 comments, 323 reads

Posted in Allen White on 9 October 2009

[Tagged] Anatomy of a Geek

I got tagged by my buddy Michael Coles, aka Sergeant SQL to talk about how I "became" a geek. (I use quotes because I've really always been a geek.) Back in the 9th grade (1968 for those of you counting) my math teacher asked if there was anyone in the...(

Read more

0 comments, 109 reads

Posted in Allen White on 5 October 2009

ADO.NET in PowerShell

I've had to rework some logic for gathering database information in my serverstatus.ps1 script, because SMO doesn't exactly do things the way one would think. The result is that the performance is unacceptable when dealing with multi-terabyte databases....(read more)

Read more

0 comments, 157 reads

Posted in Allen White on 22 September 2009

Browse and Script

One of the cool features of the SQL Server PowerShell snapins is the the ability to browse SQL Server as though it was a file system. While Management Studio has the nice graphical tree structure, sometimes I find it more productive to walk up and down...(read more)

Read more

0 comments, 120 reads

Posted in Allen White on 16 September 2009

Use the Best Tool for the Task - Part 2

Yesterday I posted about how Transact-SQL was better suited than SMO for gathering details about database files for a database with very large files. Today I'd like to point out that creating the database I used to test that fix was far easier with PowerShell...(read more)

Read more

0 comments, 137 reads

Posted in Allen White on 3 September 2009

Use the Best Tool for the Task

Last February I wrote an article for Simple-Talk called Let PowerShell do an Inventory of your Servers . This script was useful to me then, and it continues to be so, but it recently ran into a glitch. Here is the code in the script to gather data on...(read…

Read more

0 comments, 130 reads

Posted in Allen White on 2 September 2009

24 Hours of PASS Tonight

For those of you who may have missed it, the 24 Hours of PASS conference starts tonight at 8pm EDT! I'll be presenting my introductory PowerShell for SQL Server session at 9pm EDT, so if you're interested in getting started with PowerShell, please join...(read more)

Read more

0 comments, 113 reads

Posted in Allen White on 1 September 2009

A Couple of Invoke-SQLCMD Issues

In working on a PowerShell script to load data into SQL Server, I decided to use the Invoke-SQLCMD cmdlet included in the snapins provided with SQL Server 2008, and found a couple of issues you should know about. First, as a matter of best practices,...(read more)

Read more

0 comments, 213 reads

Posted in Allen White on 14 August 2009

User Group Presentation: Essential Database Management - Top Ten Recommendations

In the August 13th 2009 meeting of the Ohio North SQL Server Users Group (ONSSUG), Paul Randal and his wife Kimberly Tripp , will run you through their top-ten database maintenance recommendations, with a lot of tips and tricks along the way. This top...(read more)

Read more

0 comments, 108 reads

Posted in Allen White on 7 August 2009

The Basic Truths about Data

In reviewing database development best practices recently I'm reminded of an attitude I've found prevalent in many development shops, that the database is just "a place to put stuff". As much as I've come to expect this attitude, it continues to upset...(read more)

Read more

0 comments, 108 reads

Posted in Allen White on 3 August 2009

Newer posts

Older posts