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...
2012-01-05
3,365 reads
Colleen M. Morrow
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...
2012-01-02 (first published: 2011-12-26)
2,301 reads
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...
2011-12-29
2,081 reads
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...
2011-12-22
810 reads
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...
2011-12-19
1,217 reads
#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...
2011-12-15
620 reads
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,...
2011-12-08
1,751 reads
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. ...
2011-12-06
1,254 reads
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...
2011-12-05
728 reads
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...
2011-12-01
1,147 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers