Stapler Method
This is long overdue and goes out to my buddies from the SSAS Class I taught late last year. Two...
2010-08-19
397 reads
Blog Posts
Thoughts On The 2010 PASS BoD Elections Candidate List
Yesterday PASS published the list of candidates on the ballot for the 2010 Board of Directors election. Much to my...
2010-08-19
613 reads
Undocumented Stored Procedures
Just a quick list of undocumented SPs, many of which are deprecated.
Note, use caution using some of these ! But others...
2010-08-19
2,156 reads
Unique/Non-Unique Clustered Indexes
In the last blog post I have talked about unique/non-unique clustered indexes on a heap
table. A table without a clustered...
2010-08-19
8,219 reads
Upcoming SQL Lessons
Some great SQL Lunch sessions are coming up. Some from Pragmatic folks and some from other great speakers and community...
2010-08-19
374 reads
Upcoming SQL Lunches
Some great SQL Lunch sessions are coming up. Some from Pragmatic folks and some from other great speakers and community...
2010-08-19
393 reads
Week in Review – August 7, 2010
This post is the first in a new weekly series meant to give my readers some insight into my week....
2010-08-19
645 reads
White Paper Wednesday – Bulk Report Generation with SSIS and SSRS 2008 R2
Hey folks,
It’s white paper Wednesday and this week we’re looking at Bulk Report Generation using SSIS and SSRS 2008 R2...
2010-08-19
481 reads
White Paper Wednesday – High Availability with SQL Server 2008
Hey folks,
It’s white paper Wednesday and this week we’re looking at High Availability with SQL Server 2008 by Paul Randal(Blog)|(Twitter)....
2010-08-19
351 reads
Wolfram Alpha – Pretty Cool
Hey folks. I have yet to explore the world of Wolfram Alpha and still don’t claim to be an expert...
2010-08-19
516 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