Category Archives: Microsoft SQL Server
-
Temporary stored procedures
Leave a commentAugust 7, 2019 by Kenneth Fisher
tl;dr; Temporary stored procedures are excellent for testing pieces of code that are going to go into (or come from) …
Continue reading -
SQL Homework – August 2019 – Getting the data out
Leave a commentAugust 5, 2019 by Kenneth Fisher
Everything else aside two of the most important tasks of a database are to get data in, and get data …
Continue reading -
Header Query Crossword
Leave a commentJuly 31, 2019 by Kenneth Fisher
I did an interesting form of crossword recently and since I haven’t done one in a while I figured this …
Continue reading -
Optional vs Required parameters in Stored Procedures
13July 29, 2019 by Kenneth Fisher
If you are executing a stored procedure with a bunch of parameters it can be a bit of a pain …
Continue reading -
Custom error messages
1July 24, 2019 by Kenneth Fisher
I’m sure lots of you have used the function RAISERROR to handle an error caused by your code. The problem …
Continue reading -
Current database vs database locks
2July 22, 2019 by Kenneth Fisher
I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is …
Continue reading -
Is it just me or does msdb feel a lot like a user database?
Leave a commentJuly 17, 2019 by Kenneth Fisher
When you think of system databases, tables, etc there are a number of things you might think of. Necessary to …
Continue reading -
Short circuiting an AND
4July 15, 2019 by Kenneth Fisher
The other day I did a post on how an OR short circuits. It was a somewhat unusual type of …
Continue reading -
SQL Homework – July 2019 – Table Size
Leave a commentJuly 1, 2019 by Kenneth Fisher
In general this homework series is meant to give you ideas of things to play with that most if not …
Continue reading -
Introducing sp_AzSQLDBPermissions (Beta)
9June 27, 2019 by Kenneth Fisher
I’ve written a version of my permissions scripts for Azure SQL Database. It’s still in Beta but I’m confident enough …
Continue reading
SQL Studies 