Category Archives: Microsoft SQL Server
-
Moving a table using BCP and native format
8March 21, 2018 by Kenneth Fisher
You need to move a table from one instance to another with the following requirements: The instances are on separate …
Continue reading -
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
1March 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
4February 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.
8February 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
SQL Studies 