Big Numbers
What had me reflecting on numbers was an article in the Financial Times (Conduit of Contention if you can find...
2011-07-29
1,504 reads
Thank you PASS Community
This has been a great week for me. I had a lot of new faces come out for the Columbus...
2011-07-29
1,521 reads
Modified Insert Unknown Row to Dimension Table
A little over a year ago Patrick LeBlanc wrote a blog post about inserting an unknown row into a dimension. ...
2011-07-29
2,917 reads
Roundup for Un-SQL Friday #005: Bad Interviews
It’s time for the Un-SQL Friday #005 roundup!
From managers…
First up, The Lone DBA admits that he wasn’t always (ahem) one of us…he’s got...
2011-07-29
1,777 reads
Re-blog – July 22-July 28
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-29
1,516 reads
Calling SCOM in C#
Written by David Postlethwaite
I’m sure there are many out there using System Centre Operations Manager (or SCOM for short)...
2011-07-29
3,967 reads
Marking FK Constraints NOT FOR REPLICATION
When administering Merge Replication, sometimes we need to mark foreign
key constraints NOT FOR REPLICATION. In some cases, we might...
2011-07-29
7,756 reads
Build a schedule for SQL Saturday
A new feature has been added to SQL Saturday. Now when you register for an event you can build your...
2011-07-29
1,438 reads
Activity Monitor and Profiler
Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head blocker in a blocking chain. That script can...
2011-07-28
14 reads
Activity Monitor and Profiler
Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head...
2011-07-28
2,001 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