Monthly Archives: May 2016
-
I hate saying no
2May 31, 2016 by Kenneth Fisher
I really do. There is a joke that DBAs say no to everything and there is some truth to that. …
Continue reading -
Connecting to Azure SQL Database
2May 25, 2016 by Kenneth Fisher
Recently I created my first Azure SQL Database. But now I need to connect to it. You can connect using …
Continue reading -
Master_Views: master_objects, master_tables, etc
1May 23, 2016 by Kenneth Fisher
There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of …
Continue reading -
Re-Evaluating Best Practices
7May 18, 2016 by Kenneth Fisher
I was reading a blog post from my friend Randolph West (b/t) on Best Practices and a thought struck me. …
Continue reading -
RAID your backups
6May 16, 2016 by Kenneth Fisher
Let’s start with a very brief definition of some RAID levels. RAID 0 : Stripe your data across multiple disks. …
Continue reading -
Comparing the contents of two tables
16May 12, 2016 by Kenneth Fisher
I’ve been working on tuning a query for the last week and I’ve had to make several changes to the …
Continue reading -
Getting your Cloud on
3May 10, 2016 by Kenneth Fisher
One of the things I like best about joining in on Adam Machanic’s (b/t) TSQL Tuesday blog party is that …
Continue reading -
Grant Deny Revoke
3May 4, 2016 by Kenneth Fisher
It always amazes me how often these three commands get confused. Heck it amazes me how long I confused them. …
Continue reading -
Remove files from a filegroup
Leave a commentMay 2, 2016 by Kenneth Fisher
You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve …
Continue reading
SQL Studies 