Conversation History: The Continuing Case Against GUIDs
We had a cooperative relational database design exercise at the office last week as part of our regular department "Lunch...
2013-03-08
1,241 reads
SQL Server : Understanding the IAM Page
In my earlier post, we have discussed about Data,GAM,SGAMand PFS pages. In this post, let us try to understand about...
2013-03-07
7,866 reads
Profisee Master Data Maestro
I have been using Microsoft’s Master Data Services (MDS) on a daily basis for the last 8 months. I also...
2013-03-07
3,138 reads
Index Analysis March Update
In yesterdays duplicate index blog post, I mentioned that there would be an update to the index analysis stored procedure...
2013-03-07
724 reads
Twitter Talk Theatre, Episode 1: “RAID is good enough!”
But We’ve Never Had a Disaster Before!
This week, some of my Twitter followers were kind enough to chime in on...
2013-03-07
704 reads
Off to the Richmond User Group, a Red Gate Experiment and SQL Saturday #187
This weekend is SQL Saturday #187 in Richmond, VA. Today’s a travel day for me, as I head out early...
2013-03-07
813 reads
Building My Next Workstation–Part 4
Reading about the motherboard choices took a while. Because I had already decided on a CPU, the Intel I7 I...
2013-03-07
786 reads
SQL Saturday Kosovo #225
I’m so exciting to announce that the SQL Saturday Kosovo is going to be held on May 18, 2013 and...
2013-03-07
1,109 reads
SQL Server – TSql to find Records matching certain criteria in all the tables of a DB.
Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are...
2013-03-07
2,001 reads
Speaking at SQL Saturday Detroit on March 16
Ahhh – Motor City. What a fun place to start my 2013 SQL Saturday rounds! Detroit, here I come! You all...
2013-03-07
614 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