SQL Bits 7 – Registration is Open !
Registration is now open for SQLBits—The 7 Wonders of SQL Conference !!
This year its in York (Sept 30th till October 2nd).
SQLBits is...
2010-07-29
1,491 reads
Blog Posts
SQL Saturday Advice - Communicate Often
It seems that Thursdays are becoming SQL Saturday day here at my blog. I wrote a few posts about SQL...
2010-07-29
1,112 reads
SQLSaturday #40 is Almost Here – July 31, 2010
I’ll be leaving Friday morning with my family to go to Miramar, Fla, for the 2nd annual SQLSaturday there. I’m...
2010-07-29
529 reads
The Dangers of Sub-queries!!!!
Ok, now that I have your attention this really should be titled the danger of not qualifying all objects, but...
2010-07-29
743 reads
The Killer Backslash in TSQL
--it is
quite startling to see that this, in TSQL, executes.
Select \
/*
---------------------
0.00
(1
row(s) affected)
so does
this....
*/
Select null /\/\/\/\/\/\/\/\/\/\/\/\
/*
---------------------
NULL
(1
row(s) affected)...
2010-07-29
5,826 reads
What Indexes are on My Table!
In this quick blog, I want to show you one way of how to find out what indexes you have on a table...
2010-07-29
495 reads
2010 3rd Quarter Goals
Now that we are into the third quarter of 2010 I decided to post an update of my 2nd quarter...
2010-07-28
1,013 reads
Interviewed by Andy Leonard
Andy Leonard is posting interviews of all the candidates PASS Board of Directors on his blog and mine is up...
2010-07-28
389 reads
Interviewing for the PASS Board of Directors
My nomination application made it through the committee. I got an email yesterday telling me that I needed to schedule...
2010-07-28
802 reads
MDX Puzzle #4
This puzzle is rather simple, but it does introduce a few new things. Using T-SQL you typically filter queries with...
2010-07-28
556 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