Only Left Joining based on Subsequent Inner Join
How do you left join to a table ONLY if it inner joins to another?
Elecom Huge Trackball
In one of my first fulltime jobs, I started experiencing shoulder and neck pain, and after talking to some medical people and older IT people, I realised that the cause was my mouse. The crappy little mice that come free with your computer are an ergonomic disaster. There’s plenty of research that goes in to […]
My Favourite, yet most Pointless, SQL Datatype
This month, for T-SQL Tuesday, Brent Ozar has asked us to write about our favourite data types. There is a list of data types over in the docs, and most of them have a use. Numbers and dates as I’ve already mentioned, strings obviously need to go in (either as extended ASCII or Unicode), and […]
Recording of Adding Parameter info to sp_BlitzWho – Part 3
After a bug report from my previous work on sp_BlitzWho, I’m finally fixing it properly. Check out the clip below on YouTube, or if you want to see the original work, check out part 1 and part 2.
Recording of Fixing bug in sp_DatabaseRestore from SQL Server First Responder Kit
I found a bug in the sp_DatabaseRestore code in the First Responder kit, so I decided to fix it and while I did I found another bug. Watch along on the recording.
Recording of Adding Parameter info to sp_BlitzWho – Part 2
I did some more work on sp_BlitzWho recently. Check out the clip on YouTube below. If you missed part 1, you can find it here.
Recording of Adding Parameter info to sp_BlitzWho – Part 1
I did some work on sp_BlitzWho recently. Check out the clip on YouTube. Part 2 will hopefully come soon:
When are different Strings equal?
When working on the First Responder Kit recently, I needed to compare two strings and came across a bit of an oddity on how SQL compares strings. Let’s check it out. First, put the following stored proc in to your database: Pretty simple, we’re going to take 2 strings in, compare them together. If they’re […]
Recording of Fixing bug when changing Database Owner in sp_DatabaseRestore
I did some work on sp_DatabaseRestore recently. Check out the clip on YouTube:
TSQL-Tuesday – Automate Your Stress Away
Elizabeth Noble is hosting this months TSQL-Tuesday, and she asks a great question: How do you automate stress away from your life? I love automation, not because automation is cool in itself (although it is) but I love it because of all the side benefits it gives you. It means I stuff up less often […]