-
DB_NAME() vs ORIGINAL_DB_NAME()
1March 15, 2018 by Kenneth Fisher
I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular …
Continue reading -
A look back from the future. – TSQL Tuesday #100
3March 13, 2018 by Kenneth Fisher
The date is July 14th, 2026 and it’s TSQL Tuesday #200. We are still using SQL Server, and in fact …
Continue reading -
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