Category Archives: Microsoft SQL Server
-
Hobbies, stress relief, and meeting management: T-SQL Tuesday #99
2February 13, 2018 by Kenneth Fisher
It’s T-SQL Tuesday again! And in fact it’s the 99th one! Given that T-SQL Tuesday runs once a month that …
Continue reading -
Backups of backups or How long is my backup really available?
1February 7, 2018 by Kenneth Fisher
I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important, …
Continue reading -
SQL Homework – February 2018 – Work with security
1February 5, 2018 by Kenneth Fisher
This month let’s create some security! Create logins: GUI 5 pts/Script 5 pts Create a SQL login and a Windows …
Continue reading -
How To: Install SQL Server on an Azure VM
3January 29, 2018 by Kenneth Fisher
Last month I demonstrated creating an Azure VM with SQL installed using one of the default templates. While this is …
Continue reading -
Help it takes forever to open the SQL Server Log!
Leave a commentJanuary 24, 2018 by Kenneth Fisher
Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the …
Continue reading -
What’s dbo?
6January 22, 2018 by Kenneth Fisher
Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems …
Continue reading -
How to read a technical blog
4January 17, 2018 by Kenneth Fisher
There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If …
Continue reading -
Fun with sp_rename
Leave a commentJanuary 11, 2018 by Kenneth Fisher
Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in …
Continue reading -
A Solution for Squirrely SQL Server Security: TSQL Tuesday #98
Leave a commentJanuary 9, 2018 by Kenneth Fisher
It’s the first T-SQL Tuesday of the year! Arun Sirpal (b/t) is our host this month. Thanks, Arun! The subject …
Continue reading
SQL Studies 