SQL Homework – December 2019 – The default trace and the system health session.

• by Kenneth Fisher

• SQLStudies

I know this is the holiday season for many of us (which ones depend on your religion and nationality of ... Continue reading

2019-12-17 (first published: 2019-12-02)

424 reads

Bad Idea Cowboy Hat: BEGIN TRANSACTION; GO 1000;

• by Kenneth Fisher

• SQLStudies

One of my favorite presentations is Revenge the SQL by Rob Volk (blog|twitter). It’s a demonstration of a lot of ... Continue reading

2019-12-12 (first published: 2019-11-27)

1,103 reads

Session Evaluations from “SQL Server Security from the Ground Up”

• by Kenneth Fisher

• SQLStudies

I was recently given the opportunity to speak at Pass Summit. As always (this is the second time) this was ... Continue reading

2019-12-12

5 reads

Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.

• by Kenneth Fisher

• SQLStudies

I love this error. Primarily because it demonstrates two very important things. Errors matter. Make sure when you ask someone ... Continue reading

2019-12-11 (first published: 2019-12-05)

520 reads

#PowershellBasics: Working with arrays

• by Kenneth Fisher

• SQLStudies

I mentioned arrays in a previous post so I figured I should talk about what they are and how to ... Continue reading

2019-12-06 (first published: 2019-11-25)

413 reads

DBA Myths: Is an identity column always unique, in order, and without gaps?

• by Kenneth Fisher

• SQLStudies

Identity columns are all over the place. Probably 80-90% of the tables I see have them and they are almost ... Continue reading

2019-11-29 (first published: 2019-11-20)

1,059 reads

The curious case of CHAR(0)

• by Kenneth Fisher

• SQLStudies

Over the years I’ve seen quite a few strange things with SQL Server. This one may not have been the ... Continue reading

2019-11-25 (first published: 2019-11-14)

1,103 reads

What the ???? T-SQL Tuesday #120

• by Kenneth Fisher

• SQLStudies

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

2019-11-21 (first published: 2019-11-12)

438 reads

DBA Myths: The system sessions are the ones with a session_id 50 or less

• by Kenneth Fisher

• SQLStudies

Anecdotally any session_id that’s 50 or less is going to be a system session and anything over 50 will be ... Continue reading

2019-11-18

28 reads

Pass Summit 2019 Keynote Day 2

• by Kenneth Fisher

• SQLStudies

I’m blogging they Keynote! One of my bucket list things has always to live blog a keynote at Pass Summit ... Continue reading

2019-11-07

89 reads