How to setup CMS
If you need to setup a Central Management Server or just want to check it out, then here is how...
2011-08-09
974 reads
All about Execution Plans
Coming to the PASS Summit in October this year? Excellent!
I say excellent, because Grant (blog|twitter) and I are presenting a...
2011-08-09
780 reads
FK Hierarchy v 2.1
Last month I published an update to my Foreign Key Hierarchy script. Today, I am providing a new update for that script. A friend (Rémi Grégoire) helped out with...
2011-08-09
18 reads
FK Hierarchy v 2.1
Last month I published an update to my Foreign Key Hierarchy script. Today, I am providing a new update for...
2011-08-09
681 reads
PASS Update #61
Just a few quick updates.
First, on the SQLSaturday site we’ll be shortly rolling out an updated logo and layout for...
2011-08-09
630 reads
Server Side Paging with new OFFSET feature in SQL Server Denali
Ever since I was a web developer back in the days, server side paging has been an issues. Back then...
2011-08-09
1,727 reads
SQL MCM Training – Day 1
Today was my first day of SQL MCM training here in Bellevue. We started at 08:30am
and now (05:30pm) Kimberly is...
2011-08-09
1,710 reads
Excel Services in SharePoint 2010 Webinar
Tomorrow I will be presenting a webinar at 11 AM eastern time for the Pragmatic Works Training on the T’s. ...
2011-08-08
907 reads
Replication Agent Failure
I recently spent several days investigating a replication failure. Finding the answer specific to my problem was difficult, so I...
2011-08-08
8,020 reads
S3OLV August Meeting II
I recently published a post about the upcoming meeting for S3OLV. This post is to serve as an update to the post. It is quite important that a more...
2011-08-08
11 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