Cumulative Update – 12 for SQL Server 2008 R2 Service Pack 1 Is Now Available !
The 12th cumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the...
2013-04-17
979 reads
Featured on ITCentralStation this week
WOW! This week I was featured on the ITCentralStation.com home page as their Reviewer of the Week with my review of...
2013-04-17
591 reads
Necromancing the Chicken
First off, I’m sorry this space has been dead for so long. I’m sure I’ve dropped off many an RSS...
2013-04-16
869 reads
Geoflow Preview for Excel 2013
Last week at the PASS Business Analytics Conference in Chicago, Microsoft disclosed a public preview of GeoFlow for Excel (download). GeoFlow” is...
2013-04-16
885 reads
A Rickety Stairway to SQL Server Data Mining, Part 10.4: Data Mining Dimensions vs. Drastic Dynamic DMX
by Steve Bolton
Anyone who’s gotten this far in this series of amateur self-tutorials on SQL Server Data Mining (SSDM)...
2013-05-02 (first published: 2013-04-16)
3,019 reads
SQL Server : Index at a glance
In the last ten posts, we have discussed in details about the SQL server index and its storage structure. In...
2013-04-16
1,246 reads
Connecting to SSIS 2008 Without Local Admin
The default install of SSIS only allows users with local admin rights on the server to connect. This can be...
2013-04-16
62 reads
The Bucket List – Item #1 is (finally) finished
We all have a bucket list – that list of things that we want to accomplish before one, well, kicks the...
2013-04-16
749 reads
MCM Road Less Traveled
I began this post back in October of 2012 after learning that I had passed the SQL Server 2008 MCM Knowledge exam. I had set it aside in hopes...
2013-04-16
15 reads
MCM Road Less Traveled
I began this post back in October of 2012 after learning that I had passed the SQL Server 2008 MCM...
2013-04-16
961 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