SQLStudies

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-05

10 reads

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-02

91 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-11-27

431 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)

303 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)

981 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

25 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)

999 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)

407 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

82 reads

Volunteers

• by Kenneth Fisher

• SQLStudies

This week is the PASS Summit and it has me thinking about all of the amazing work done in our ... Continue reading

2019-11-06

5 reads