Why would you want to name a transaction?
Something that i keep seeing in documentation, in forum code and in real systems is transactions that have names
BEGIN TRANSACTION...
2015-12-04 (first published: 2015-12-01)
5,914 reads
Querying the Plan Cache
I love working with indexes, and I need to know what’s using them to work on them intelligently. Most of...
2015-12-08 (first published: 2015-12-01)
2,021 reads
The Discomfort Zone
Over the Thanksgiving holiday, I read a book entitled The Phoenix Project. This book has been in my Kindle library...
2015-12-04 (first published: 2015-12-01)
1,537 reads
Summon Blue Screens of Death (for testing purposes only, of course)
Today I had a need to manually trigger and sustain a Blue Screen of Death (BSOD) inside a Windows Server...
2015-11-30
845 reads
Monday Morning SQL Break – November 30, 2015
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2015-11-30
843 reads
You should always have an “I got hit by a bus” backup plan
You have an on call, you have a business continuity plan, you have a disaster recovery plan but what happens...
2015-12-07 (first published: 2015-11-30)
2,457 reads
Row-Level Security part 2 – Controlling Write Access
My previous post was focused on controlling read operations. With the latest enhancements to the row-level security, it is now possible...
2015-12-03 (first published: 2015-11-29)
2,837 reads
Columnstore Indexes – part 73 (“Big Delta-Stores with Nonclustered Columnstore”)
Continuation from the previous 72 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Since the very first version of SQL...
2015-11-28
985 reads
Python Command Line Calls
There was a time I worked in a company any we lived in the command line. This was in the...
2015-11-27
1,118 reads
Find duplicate indexes in SSDT
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...
Duplicate indexes, one of the most pointless things you can do to a table that...
2015-11-27
992 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers