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
2,768 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,281 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,064 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
785 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,198 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
608 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,724 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,230 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
719 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,118 reads
Blogs
Using ThinOptics to Read Data
By Steve Jones
As I’ve aged, I find myself struggling to read many things in my life....
PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...
Set-Based vs Row-Based Database Code
By Kevin3NF
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...
Forums
The Fake Speakers
Comments posted to this topic are about the item The Fake Speakers
Stairway to Database DevOps Level 3: Managing Code as a Team in Git
Comments posted to this topic are about the item Stairway to Database DevOps Level...
Reduction of installation time of sql server 2008 R2 Express
The installation of SQL Server 2008 R2 Express on a virtual machine takes around...
Ask SSC