Category: sql server

Connect the Nots

Today I learned that you can’t adjust the font size in SQL Server Management Studio’s Object Explorer pane. Nor registered servers, nor properties. This has been noted, and closed as “Maybe someday we’ll get to it, maybe”. This rather sucks, as the trend seems to be making more and more things zoomable and adjustable and all that. […]

“Thing IS NOT NULL” isn’t the same as “Thing != NULL”

I’ve talked about NULLs before. (Ref: Here’s a bit on ISNULL(), and here’s one about understanding NULL at a basic level.)  And yet, it’s worthwhile to bring these things up from time to time. “[Thing] != NULL” is nonsense. It won’t work the way you want it to work, because NULL literally means “unknown”. Nothing in the […]

Sean’s session, “Monster Text Manipulation: Regular Expressions for the DBA” #SQLBits

Update: Thank you, SQLBits, for rescheduling Sean’s session! In addition to the recording/code link for this class (below), you can find recording/code for Stored Procedure Solutions here, and for Powershell Cmdlets for DBAs here. We had an awful schedule mix up here at SQLBits. If, as a result, you missed out on Sean’s Regular Expressions for the DBA […]