SQL Saturday #28 Update
We are just about a week away from probably the biggest FREE training event to ever take place in Baton...
2010-08-06
555 reads
Inconsistent NullIF Behaviour ?
NullIf can be a very handy function sometimes. For those who have not used it, if the result of the...
2010-08-06
678 reads
Planning for Maintenance
On Monday, Microsoft released an out-of-band security patch to address the .LNK vulnerability. This affects Windows XP, including Windows XP...
2010-08-06
691 reads
The Inteview is Done
I completed my interview for the PASS board election today. I don’t want to talk about what was in the...
2010-08-06
408 reads
Free SQL Server Training for the Week of August 9, 2010
Monday
SQL Lunch - SSIS Design Patterns 1a: Introduction to SSIS Design Patterns - Andy Leonard
Tuesday
PASS Application Development Virtual Chapter - Where the bl**dy...
2010-08-06
1,222 reads
eReaders - Kindle v Nook v iPad
A friend of my wife’s posted a note asking what people thought of the various devices and which one would...
2010-08-06
1,200 reads
Simple Script to Determine Who To Kill (SPIDs)
I'm mostly working now supporting the building of SSIS packages for ETL. And on one particular project we've been making heavy...
2010-08-06
758 reads
Tiny Homes
Over the course of my life I’ve lived in a few different places; small home, apartment, pup tent, large tent,...
2010-08-06
537 reads
Hands Off System Databases
I saw a post earlier this week from Buck Woody called Don’t Mess with the System Databases and I agree....
2010-08-06
359 reads
SQL Server Locking & Blocking At DevLink 2010
Wow! Thanks to everyone who came to my SQL Server Locking & Blocking session at devLINK this morning! I’m completely humbled...
2010-08-05
378 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers