T-SQL Tuesday #51: Is this a bet worth making?
On the second Tuesday of each month, the SQL Server universe all comes together to blog about a topic. Known...
2014-02-14 (first published: 2014-02-11)
1,803 reads
A Discussion of SQL Server-Related Topics
SQL Prompt – new features in version 6.x
I’ve been using SQL Prompt for years. In September 2013, version 6 was released (quickly followed by 6.1 in late...
2014-01-31 (first published: 2014-01-27)
3,071 reads
Assumptions and clusters – the double whammy
I was recently investigating an issue that stemmed from a database being in the recovery_pending state. A quick investigation through...
2014-01-20
824 reads
TSQL Tuesday #50 – Automation – Verifying the Backup Chain
I was recently just letting my mind wander. As it’s prone to do, all sorts of things just entered into...
2014-01-14
781 reads
Interview Questions – what to ask the company interviewing you
Previously, I posted a list of interview questions that I ask job candidates. This post is about the questions that...
2014-01-10 (first published: 2014-01-06)
4,140 reads
Are CHECKSUMs being performed with a Compressed Backup?
Now, why in the world would I be asking a question like this?
Well, in BOL (BACKUP) is this little blurb:
CHECKSUM
Specifies...
2014-01-06 (first published: 2013-12-30)
2,878 reads
T-SQL Tuesday #48 – My take on the cloud
So here it is, the second Tuesday of the month. This means that it is time for our favorite Tuesday...
2013-11-13
623 reads
The Failed Job
I was looking into a failed job on a SQL Server 2008R2 instance. My first step was to check the...
2013-11-15 (first published: 2013-11-07)
1,666 reads
Murder They Wrote
For those of you that know me, you know that I enjoy learning, and passing on what I have learned...
2013-11-06
784 reads
Retiring of the MCM Certifications, Part II
Image acquired from Twitter
In my recent blog post on “Retiring of the MCM Certifications”, there is a link to a...
2013-09-03
1,342 reads
Blogs
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Patch Tuesday – Where to get more information
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
Forums
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
any reason to avoid asking ssis to extract files from ftp
hi we have to replace talend which generally was used to move files. talend's...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers