Monthly Archives: January 2017
-
Azure quick start
1January 30, 2017 by Kenneth Fisher
In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well …
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 -
Creating a connect entry.
4January 23, 2017 by Kenneth Fisher
I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of …
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 -
A detailed view into your Azure resources
Leave a commentJanuary 5, 2017 by Kenneth Fisher
I’ve been studying Azure recently and came across a really interesting Azure site. resources.azure.com To give you an idea why …
Continue reading
SQL Studies 