Category Archives: Microsoft SQL Server
-
My backup script (where, how, how big, etc.)
5November 26, 2018 by Kenneth Fisher
A while back I wrote about how to find where your backups are. And I’ve also written about I use …
Continue reading -
Dealing with multiple AD accounts
8November 19, 2018 by Kenneth Fisher
To help promote the seperation of duties one of the things my company has done is to divide our permissions …
Continue reading -
Parameterized dynamic SQL is parameterized.
3November 15, 2018 by Kenneth Fisher
Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic …
Continue reading -
T-shaped knowledge and learning about the cloud: T-SQL Tuesday #108
5November 13, 2018 by Kenneth Fisher
Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a …
Continue reading -
SQL Homework – November 2018 – Constraints
2November 5, 2018 by Kenneth Fisher
You’ve created tables before but how about constraints? Constraints allow a finer level of control over what data is allowed …
Continue reading -
How do I look at my error log if SQL won’t open?
1October 22, 2018 by Kenneth Fisher
Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you …
Continue reading -
What is the Object Explorer Details tab good for?
1October 17, 2018 by Kenneth Fisher
For a long time there I would see the Object Explorer Details tab show up when I opened SSMS (SQL …
Continue reading -
Highlighting sp_spaceused
1October 15, 2018 by Kenneth Fisher
I’ve been using sp_spaceused a lot recently so I thought I would bring it up again. Basically it’s a quick …
Continue reading -
Which is faster? IN (list) or IN (SELECT FROM Temp)
8October 11, 2018 by Kenneth Fisher
If you’ve done much with IN (list) then you’ve realized that it basically translates out to You’ve probably also realized …
Continue reading -
Letting the business bully you: T-SQL Tuesday #107
1October 9, 2018 by Kenneth Fisher
Before I start anything I want go give a disclaimer. I absolutely believe that the business should be involved in …
Continue reading
SQL Studies 