Msg 7395: Unable to start a nested transaction

Happy new year, SQL peeps! I hope everyone had a wonderful holiday. Last week was very quiet at work, but...

SQL Server A to Z – YEAR

SELECT 'Happy '+ DATENAME(dw, GETDATE())Welcome to the penultimate installment of SQL Server A to Z (it’s not often I get to...

SQL Server A to Z – CPU-Z

How fitting that I should close out the A to Z series while I close out the year.  We’ve finally...

A SQL Server Christmas Card

Merry Christmas everyone!
DECLARE @hohoho char(100)
DECLARE @bells smallint
DECLARE @tiers smallint
DECLARE @maxtiers smallint

SELECT @hohoho = ' ', @tiers = 1, @bells = 1, @maxtiers = 6
PRINT @hohoho

WHILE @tiers...

Pitching Pebbles – Using Certificates to Grant Privileges

If you fill the jar with pebbles first, you'll never have room for the big rocks.
I’m sure you’ve heard the...

#meme15 – Why Do You Blog?

Jason Strate (blog|@StrateSQL) is starting a new blog meme: #meme15.  The overall topic of #meme15 will be social networking, obviously...

SQL Server A to Z – XML

I can’t believe it’s already December.  This year has just flown by.  The rush of holiday events has already started,...

T-SQL Tuesday #025 – Tips and Tricks

This month’s T-SQL Tuesday is being hosted by Allen White (blog | @SQLRunr ).  The topic:  Share your T-SQL tips and tricks. ...

Get Involved – This Week In PASS

We’re all busy people.  We have jobs, families, and responsibilities out the wazoo.  Little Timmy needs to be picked up...

SQL Server 2012 – Bug in sys.fn_xe_file_target_read_file?

So I finally managed to get my hands on a VM with Windows 2008 R2 SP1 so I could install...