How to use Excel and tSQL to help you Generate Code

Introduction It’s amazing to me the reactions I get when I show people seemingly simple tricks on how to automate or generate code and/or script generation. Whenever I see a pattern, that means ...

TSQL: Passing objects to stored procedures via XML

Introduction This is a subject I have heard about repeatedly, but I never bothered looking into it until recently. I was told that writing hard coded insert and update statements is bad practice. To w...

How to Kill all Processes for a Specific Database

Usually you would just use the Activity Monitor like shown below… The mundane repetition of right click each process and selecting Kill Process becomes annoying after the n_th process.  ...

How to get Filename and File Extension from a Column with tSQL

I have written this query like 100 times, but this time I am going to document it so I don’t lose it again. This query specifically assumes that you have a single column that contains a file nam...

Straight to the Point: Query for Database and Table Sizes

I love how I have to search too much to find simple information, one liners, it is just like in College where my college course book would be about 100,000,000,000 pages long and really it says absolu...

Selecting Random Date Between a Date Range with tSQL

I had a very interesting experience recently trying to figure out how to select a random date between a date range using tSQL, it was a lot of trial and error, but ultimately this is what I came up wi...

UPDATE SELECT FROM JOIN

This is something that I don’t do often, but it pops up every now and again. I always forget how to do it, so I have to look it up each time. Here is an example: [crayon-5f92b4bb033ad694096185/]...