Author Archives: Kenneth Fisher
-
DBA Myths: Can a differential backup get bigger than the full backup?
4February 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 -
Using Cloud Academy
Leave a commentFebruary 6, 2019 by Kenneth Fisher
The other day I talked about using Microsoft Learn. Well, honestly, Cloud Academy is the learning tool I’ve been using …
Continue reading -
SQL Homework – February 2019 – Instance configurations
4February 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
5January 30, 2019 by Kenneth Fisher
Note: I am perfectly aware of my ability as an artist so let the ribbing begin 🙂
-
Disabling Indexes
1January 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?
1January 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 -
Read-only tables
4January 21, 2019 by Kenneth Fisher
Sometimes you need a table that is read only. You don’t want anyone to be able to write to it …
Continue reading -
Controlling the firewall for an Azure SQL DB via T-SQL
2January 16, 2019 by Kenneth Fisher
The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I …
Continue reading -
SQL Bits 2019: The Great Data Heist
Leave a commentJanuary 14, 2019 by Kenneth Fisher
SQL Bits is almost here! It’s February 27th to March 2nd. SQL Bits is one of the most popular SQL …
Continue reading
