T-SQL refactoring
Keeping your SQL objects’ naming rules during furious development is hard. New levels of information are added continuously, entities are...
2011-07-28
2,745 reads
How to move Cluster MSDTC Drive
I recently had the need to move the MSDTC for a cluster to a new SAN drive. It’s a quite simple...
2011-07-28
2,869 reads
When Did That Restore Finish?
I saw this question come across Twitter under the #sqlhelp tag one day and was wondering myself. Someone suggested the...
2011-07-28
7,601 reads
Do You Work for #1?
Someone recently asked me if I would work for a company if I didn’t believe in their products or services...
2011-07-28
653 reads
Bad Admins: Non-Production Servers
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-28
2,187 reads
Lookup functions in SSRS 2008 R2 - II
Introduction
In my last post on Lookup functions related to SSRS 2008 R2, I had explained Lookup(). It is used to...
2011-07-27
8,560 reads
SQL Server does not script indexes by default
Here is a got-ya that happened to me. In SQL Server I want to generate a script of all the...
2011-07-27
9,110 reads
Preparing for #sqlsat81
SQL Saturday 81 is coming up this weekend in Birmingham AL. This will be my 5th SQL Saturday to speak...
2011-07-27
591 reads
SQLSaturday #85 Orlando: Pragmatic Works BI Pre-Con!
I’m very proud to announce that Pragmatic Works will be presenting a Business Intelligence Workshop pre-con for SQLSaturday #85 in...
2011-07-27
693 reads
Exceptional DBA of the Year 2011 - Please vote for Jeff Moden
Every year Redgate has a competition to find the most
exceptional DBA of the year. This year too they are conducting....
2011-07-27
1,620 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