What Should I Carry in My Laptop Bag
I have a tendency to carry more than I need, the equivalent of the Batman Utility Belt. I just went...
2011-09-21
855 reads
September Performance Contest
This month SafePeak is sponsoring a contest centered around improving performance in SQL Server. The host of the contest is my friend Robert Pearl. You can read the announcement...
2011-09-21
7 reads
September Performance Contest
This month SafePeak is sponsoring a contest centered around improving performance in SQL Server.
The host of the contest is my...
2011-09-21
1,093 reads
The Ten Thousand Year Clock
Ran across this in my reading about the Ten Thousand Year Clock, a project funded by Jeff Bezos. Awesome dream....
2011-09-21
713 reads
SQL Server Wait Types in SQL 2008
While working on an assignment of troubleshooting performance issue few month back I have come across a situation where I...
2011-09-21
711 reads
September 2011 SQL Server 2008 Diagnostic Queries
Its been a couple of months since I have released an updated version of my SQL Server 2008 Diagnostic Information...
2011-09-21
795 reads
An Informal Compendium of SSAS Errors, Part 2: Data Mining
This is the first in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-09-21
2,261 reads
An Informal Compendium of SSAS Errors, Part 1: Introduction
When practicing for my MCTS in SQL Server Analysis Services (SSAS) 2008 R2 last spring, I was shocked to receive...
2011-09-21
1,492 reads
The Barking Dog Analogy
The Barking Dog Analogy
Maggie and Woody
A discussion started today on Twitter about CXPacket waits. There had been a heated debate...
2011-09-20
1,105 reads
Stored Procedures – Common Security Practice
In SQL Server a good practice is to access the data via calls through stored procedure. Have a look at the document available in that link. To further this...
2011-09-20
26 reads
Blogs
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...
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....
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