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
Blog Posts
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
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
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
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
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
Windows Azure Platform One Month Pass
According to all of their public pronouncements and the flurry of recent activity, Microsoft seems extremely serious about Windows Azure...
2010-08-06
1,004 reads
GTD: Emergency Scanning versus Processing
Cross-posted from The Goal Keeping DBA blog.
I'm making an earnest effort to work through Getting Things Done in an effort...
2010-08-05
755 reads
Middle of the Pack
I noticed the scores for the first part of the PASS nomination process were posted recently. These were the aggregate...
2010-08-05
420 reads
Midlands PASS Meeting - August 10
Topic: Creating a SQL Server Utility Environment
Can SQL Server be offered as a service (SQLaaS)? Can SQL Server be treated like...
2010-08-05
776 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
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...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
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