Monthly Archives: November 2020
-
How do I tell what compression level my tables/indexes are?
1November 17, 2020 by Kenneth Fisher
It’s been a while since I worked with compression and the other day I needed to check which of my …
Continue reading -
A quick and dirty scan of a list of instances using a dynamic linked server.
5November 12, 2020 by Kenneth Fisher
Note: This is not exactly a dyanmic linked server. It just gets dropped and recreated in a loop. I recently …
Continue reading -
I get by with a little help from my friends : T-SQL Tuesday #132
Leave a commentNovember 10, 2020 by Kenneth Fisher
Taiob Ali (blog|twitter) is our host for TSQL Tuesday this month and he’d like us to talk about how our …
Continue reading -
Adding a user to an Azure SQL DB
1November 5, 2020 by Kenneth Fisher
Creating a user is simple right? Yes and no. First of all, at least in SSMS it appears you don’t …
Continue reading -
SQL Homework – November 2020 – Help!
Leave a commentNovember 3, 2020 by Kenneth Fisher
If you ask any senior IT person What is the most important tool you have? there is a decent chance that …
Continue reading