Category Archives: SQLServerPedia Syndication
-
Using Solutions in SSMS
3March 11, 2015 by Kenneth Fisher
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, …
Continue reading -
Who’s using that database?
Leave a commentMarch 9, 2015 by Kenneth Fisher
A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else …
Continue reading -
I want to blog but …
Leave a commentMarch 4, 2015 by Kenneth Fisher
I don’t know how to get started. Pretty simple. There are a number of free blogging sites out there. Personally …
Continue reading -
SQL Judo’s Monthly Challenge – March 2014 – Powershell something
Leave a commentMarch 2, 2015 by Kenneth Fisher
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
Continue reading -
Tales of a DBA fed up with NOLOCK. Part 2
6February 23, 2015 by Kenneth Fisher
Feb 16, 2015 Dear Diary, A few weeks back I introduced HAL002 to a database managed by some annoying devs. …
Continue reading -
Test your UPDATEs and DELETEs before you run them
14February 18, 2015 by Kenneth Fisher
This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you …
Continue reading -
Tales of a DBA fed up with NOLOCK. Part 1
35February 16, 2015 by Kenneth Fisher
Nov 12, 2014 Dear Diary, They asked for help again. Every now and again everything slows down and they see …
Continue reading -
TSQL Tuesday #63 – How do you manage security: Rollup
1February 12, 2015 by Kenneth Fisher
When I decided on security as my topic for February’s T-SQL Tuesday blog party my thought was that security was …
Continue reading
