Category Archives: Microsoft SQL Server
-
Simply Debugging
3March 7, 2018 by Kenneth Fisher
Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it …
Continue reading -
SQL Homework – March 2018 – Recovery Objectives
Leave a commentMarch 5, 2018 by Kenneth Fisher
My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases …
Continue reading -
A day in the life of a Sr DBA/Dev
Leave a commentFebruary 28, 2018 by Kenneth Fisher
If you are a Sr DBA or developer you have probably had some variation of this conversation at multiple points …
Continue reading -
Double hop error when using SQLCMD
2February 26, 2018 by Kenneth Fisher
tl;dr; SQLCMD v2014 and up has special requirements for Kerberos. One of the problems with linked servers (no rude noises …
Continue reading -
Windowing without a partition by or an order by
2February 21, 2018 by Kenneth Fisher
If you’ve never worked with windowing functions they look something like this: The other day someone mentioned that you could …
Continue reading -
The default filegroup, and why you should care.
2February 19, 2018 by Kenneth Fisher
You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index …
Continue reading -
Synonyms, how and why.
6February 15, 2018 by Kenneth Fisher
Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even …
Continue reading -
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
Leave a commentFebruary 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
