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
502 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
568 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
338 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
454 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
345 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
359 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
411 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
477 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
535 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,342 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers