Category Archives: Microsoft SQL Server
-
SQL Homework – March 2019 – Reconfigure tempdb
Leave a commentMarch 4, 2019 by Kenneth Fisher
You’ve heard of tempdb right? It’s one of the system databases. All of the system databases are important but poor …
Continue reading -
Using the Microsoft Authenticator app to log into Azure
Leave a commentFebruary 25, 2019 by Kenneth Fisher
So I was trying to work on a blog post about the new truncation error this morning and realized I …
Continue reading -
Why do I (they) own that database?
2February 20, 2019 by Kenneth Fisher
Ever looked at the list of databases and wonder why you own one of them? Or why some other user …
Continue reading -
Error in SSMS: Attempted to read or write protected memory.
2February 18, 2019 by Kenneth Fisher
There are a lot of reasons to write a blog post. One of my favorites is when I’ve been asked …
Continue reading -
DBA Myths: Can a differential backup get bigger than the full backup?
7February 14, 2019 by Kenneth Fisher
The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one …
Continue reading -
What is your why?: T-SQL Tuesday #111
Leave a commentFebruary 12, 2019 by Kenneth Fisher
This month Andy Leonard (b/t) wants to know why we do what we do. Funnily enough, this is something I …
Continue reading -
SQL Homework – February 2019 – Instance configurations
5February 4, 2019 by Kenneth Fisher
This homework series really has two purposes. It’s a primer for beginners. These are tasks I think most if not …
Continue reading -
See SQL Run
6January 30, 2019 by Kenneth Fisher
Note: I am perfectly aware of my ability as an artist so let the ribbing begin 🙂
-
Disabling Indexes
3January 28, 2019 by Kenneth Fisher
Indexes are probably the number one tool we have to improve performance. That said, there are times when we want …
Continue reading -
What’s a differential backup?
2January 23, 2019 by Kenneth Fisher
Of the different basic types of backups (full, differential and log) I find the differential the most interesting, and frequently …
Continue reading
SQL Studies 