-
Session Evaluations from “SQL Server Security from the Ground Up”
Leave a commentDecember 12, 2019 by Kenneth Fisher
I was recently given the opportunity to speak at Pass Summit. As always (this is the second time) this was …
Continue reading -
A gift. T-SQL Tuesday #121
1December 10, 2019 by Kenneth Fisher
My good friend Malathi Mahadevan (blog|twitter) is hosting T-SQL Tuesday this month and wants us to talk about Gifts received …
Continue reading -
Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.
7December 5, 2019 by Kenneth Fisher
I love this error. Primarily because it demonstrates two very important things. Errors matter. Make sure when you ask someone …
Continue reading -
SQL Homework – December 2019 – The default trace and the system health session.
Leave a commentDecember 2, 2019 by Kenneth Fisher
I know this is the holiday season for many of us (which ones depend on your religion and nationality of …
Continue reading -
Bad Idea Cowboy Hat: BEGIN TRANSACTION; GO 1000;
Leave a commentNovember 27, 2019 by Kenneth Fisher
One of my favorite presentations is Revenge the SQL by Rob Volk (blog|twitter). It’s a demonstration of a lot of …
Continue reading -
#PowershellBasics: Working with arrays
2November 25, 2019 by Kenneth Fisher
I mentioned arrays in a previous post so I figured I should talk about what they are and how to …
Continue reading -
DBA Myths: Is an identity column always unique, in order, and without gaps?
6November 20, 2019 by Kenneth Fisher
Identity columns are all over the place. Probably 80-90% of the tables I see have them and they are almost …
Continue reading -
DBA Myths: The system sessions are the ones with a session_id 50 or less
Leave a commentNovember 18, 2019 by Kenneth Fisher
Anecdotally any session_id that’s 50 or less is going to be a system session and anything over 50 will be …
Continue reading -
The curious case of CHAR(0)
10November 14, 2019 by Kenneth Fisher
Over the years I’ve seen quite a few strange things with SQL Server. This one may not have been the …
Continue reading -
What the ???? T-SQL Tuesday #120
11November 12, 2019 by Kenneth Fisher
Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and all. Wayne Sheffield (blog|twitter) is our …
Continue reading