Monthly Archives: January 2019
-
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 -
Read-only tables
5January 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 -
#SQLCareer 4/4 January 2nd 2019
Leave a commentJanuary 10, 2019 by Kenneth Fisher
Last July (yes, it’s taken me 5+ months to finally finish this) Steve Jones (b/t) suggested that it might be …
Continue reading -
Automation starts by doing something once, very very carefully: T-SQL Tuesday #110
5January 8, 2019 by Kenneth Fisher
After a while the intros for my T-SQL Tuesday posts get a little boring. So without any further ado, it’s …
Continue reading -
SQL Homework – January 2019 – Baselines
Leave a commentJanuary 2, 2019 by Kenneth Fisher
Happy New Year! Every year for New Years we all make a big deal of coming up with New Years …
Continue reading