Monthly Archives: February 2017
-
Queries with optional parameters
20February 27, 2017 by Kenneth Fisher
These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or …
Continue reading -
What’s in my backup file?
Leave a commentFebruary 22, 2017 by Kenneth Fisher
Restoring a backup file is pretty easy right? Ok, but what if more than one database backup is stored in …
Continue reading -
Penny wise, pound stupid
Leave a commentFebruary 20, 2017 by Kenneth Fisher
Growing up my mother used this phrase quite a bit. Penny wise, pound stupid. (In case you didn’t know the …
Continue reading -
Deadlock on ALTER DATABASE
5February 16, 2017 by Kenneth Fisher
I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you …
Continue reading -
Server level database permissions
4February 14, 2017 by Kenneth Fisher
Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a …
Continue reading -
Deadlock priority
5February 8, 2017 by Kenneth Fisher
Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who …
Continue reading -
SQL Connectivity issues: A guided walk through
Leave a commentFebruary 6, 2017 by Kenneth Fisher
The SQL Tiger Team (t) has recently put out a guided walkthrough for SQL Connectivity issues. Announcement Walk Through If …
Continue reading -
Changing what SSMS opens on startup
Leave a commentFebruary 1, 2017 by Kenneth Fisher
When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and …
Continue reading