Tag Archives: microsoft sql server
-
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 -
My SQL logins don’t work. Again.
Leave a commentJanuary 25, 2017 by Kenneth Fisher
My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one …
Continue reading -
Lead Blocker
16January 18, 2017 by Kenneth Fisher
Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and …
Continue reading -
What is COPY_ONLY?
4January 16, 2017 by Kenneth Fisher
You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up …
Continue reading -
Why won’t my SQL Logins work?
11January 12, 2017 by Kenneth Fisher
I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a …
Continue reading -
Connect suggestion to add included columns to sp_helpindex
1January 10, 2017 by Kenneth Fisher
I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the …
Continue reading -
sp_refreshsqlmodule_internal – The user does not have permission to perform this action.
Leave a commentDecember 28, 2016 by Kenneth Fisher
Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found …
Continue reading -
A semester’s worth of Backup and Recovery blogs – The TSQL Tuesday 85 Rollup
Leave a commentDecember 26, 2016 by Kenneth Fisher
I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery …
Continue reading
SQL Studies 