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...
2010-03-05
499 reads
Allen White
- Interests: Running, Theatre, Flying, SQL Server
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...
2010-03-04
565 reads
Bookstores and Databases
My wife is a Board member for Project LEARN in Medina County, Ohio (just southeast of Cleveland). Last night at...
2010-03-03
335 reads
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...
2010-02-10
452 reads
Speaking about Indexing
I'll be presenting two sessions this week (February 9 and 11, 2010), both on SQL Server Indexing. The first is...
2010-02-08
343 reads
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...
2010-01-25
356 reads
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...
2010-01-13
408 reads
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...
2010-01-12
474 reads
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...
2010-01-06
533 reads
[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...
2009-12-31
1,341 reads
Blogs
Why is shrinking IT budgets a good thing?
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Prepping for Certification, Part 3 of ?
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers