Blocking and deadlocking on purpose
Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling...
2015-07-07 (first published: 2015-07-01)
2,516 reads
Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling...
2015-07-07 (first published: 2015-07-01)
2,516 reads
A few months ago I wrote a post about the fact that I had actually submitted a session to PASS...
2015-07-03 (first published: 2015-06-29)
1,701 reads
Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you...
2015-06-30 (first published: 2015-06-24)
2,065 reads
TLDR; Search for and modify the sqlfile.sql file.
During a recent T-SQL Tuesday Boris Hristov (b/t) taught me about SET NOEXEC...
2015-06-23 (first published: 2015-06-11)
3,102 reads
I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know...
2015-06-22
825 reads
Recently Adam Machanic (b/t) was telling me about an interesting effect of the top operator. When I asked for an...
2015-06-17
649 reads
It’s the second Tuesday of the month and that means T-SQL Tuesday time! T-SQL Tuesday is a blog party started...
2015-06-15 (first published: 2015-06-09)
2,303 reads
Renaming a database isn’t something you do frequently but it does have bit of a gotcha. First of all let’s...
2015-06-15
603 reads
A question came up at work the other day, mostly as a mind game, but you never know it might...
2015-06-08 (first published: 2015-05-28)
1,837 reads
Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone...
2015-06-03
1,665 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Comments posted to this topic are about the item One more reason to use...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers