Category Archives: Microsoft SQL Server
-
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 -
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 -
Certificates, Proxies and Jobs! Oh My!
3April 27, 2016 by Kenneth Fisher
Oh Noes! I have a job that requires me to run an SSIS package, cmdshell script, etc. And I need …
Continue reading -
Get your SQL Server MCSA without taking the BI exam.
2April 25, 2016 by Kenneth Fisher
I’m a big fan of certifications as a training exercise. However not everyone has the same interests. With the new …
Continue reading -
Why my primary test environment is case sensitive.
1April 20, 2016 by Kenneth Fisher
Me: I think I’m going create a new playground instance. Myself: Make sure you use a case sensitive (CS) collation …
Continue reading -
How do I rename a column?
2April 18, 2016 by Kenneth Fisher
Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to …
Continue reading
SQL Studies 