Why not NOLOCK?
Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at...
2015-03-18
1,217 reads
Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at...
2015-03-18
1,217 reads
A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else...
2015-03-17 (first published: 2015-03-09)
7,445 reads
Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly...
2015-03-16
660 reads
There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions,...
2015-03-11
1,223 reads
I don’t know how to get started.
Pretty simple. There are a number of free blogging sites out there. Personally I...
2015-03-04
659 reads
Feb 16, 2015
Dear Diary,
A few weeks back I introduced HAL002 to a database managed by some annoying devs. They were...
2015-03-04 (first published: 2015-02-23)
7,493 reads
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...
2015-03-02
795 reads
Nov 12, 2014
Dear Diary,
They asked for help again. Every now and again everything slows down and they see a lot...
2015-02-26 (first published: 2015-02-16)
8,756 reads
It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting....
2015-02-25
1,287 reads
So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it...
2015-02-19 (first published: 2015-02-10)
7,217 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