Interview with SQLServerCentral.com Editor Steve Jones
Steve Jones will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas,...
2011-08-12
1,310 reads
Dallas Tech Fest – Demo Files for SQL Server CLR: An Introduction
Demo files from my presentation at Dallas Tech Fest 2011.
SQL Server CLR – An Introduction – Dallas Tech Fest 2011
2011-08-12
723 reads
SSAS Maestro Program (or SQL BI MCM)
There is a very interesting new Microsoft program that started back in January, called the SSAS Maestro Program. It is a five-day,...
2011-08-12
1,125 reads
Meet the PASS Board at SQLSaturday #79 In South Florida
We’re having a PASS Board meeting and many of us will be staying for the event on Saturday (and an...
2011-08-12
675 reads
Configuring, Benchmarking and Validating an I/O Subsystem for SQL Server, Part 1
One of the main projects I have been working on lately is designing and implementing a completely new data and...
2011-08-12
1,859 reads
Service Broker sample application from SQLskills Immersion Event
You can find my Service Broker sample application which I presented during the SQLskills
Immersion Event in Bellevue here for download:...
2011-08-12
1,293 reads
Microsoft SQL Server Denali CTP 3 Product Guide
Microsoft has released a Product Guide for SQL Server Denali CTP3, which has datasheets, white papers, technical presentations, demonstrations, and...
2011-08-12
1,275 reads
Check Mount Points and Disk Free Space with PowerShell
Those who know me will know that this post is a little out of the ordinary… I am posting about...
2011-08-12
4,399 reads
SQL MCM Training – Day 4
Today Jonathan has presented on analyzing trace data, and Kimberly has spoken on troubleshooting
Plan Cache Issues and Index Consolidation. It's...
2011-08-12
548 reads
When was the Last Time You Removed an Index Because it was Never Used?
Indexes can be great for boosting the performance of a query, but if an index is never used, it can...
2011-08-11
1,161 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