0 to Speaker
Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I...
2015-03-23
699 reads
Kenneth Fisher
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,228 reads
Who’s using that database?
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,450 reads
There are #temp tables and then there are ##temp tables.
Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly...
2015-03-16
669 reads
Using Solutions in SSMS
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,232 reads
I want to blog but …
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
665 reads
Tales of a DBA fed up with NOLOCK. Part 2
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,508 reads
SQL Judo’s Monthly Challenge – March 2014 – Powershell something
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
801 reads
Tales of a DBA fed up with NOLOCK. Part 1
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,762 reads
Using sp_DBPermissions and sp_SrvPermissions v6.0
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,291 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers