-
Strings vs Identifiers
3June 20, 2018 by Kenneth Fisher
A common mistake, and one I make frequently myself is to use a string in place of an identifier, or …
Continue reading -
Misleading errors: “Server is configured for Windows authentication only.” But it’s not!
1June 18, 2018 by Kenneth Fisher
In general, the errors SQL gives are highly useful. Of course every now and again you get one that’s just …
Continue reading -
The identity column, the insert and the linked server.
1June 14, 2018 by Kenneth Fisher
tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted …
Continue reading -
Moving to Azure: A change in processes – TSQL Tuesday 103
3June 12, 2018 by Kenneth Fisher
For this month’s t-sql Tuesday our host Bjoern Peters (b/t) wants us to describe our experiences with Azure SQL Database …
Continue reading -
What queries are getting blocked?
Leave a commentJune 6, 2018 by Kenneth Fisher
Monday Grant Fritchey (b/t) put up a great post EXTENDED EVENTS, THE SYSTEM_HEALTH SESSION, AND WAITS that talks about how …
Continue reading -
SQL Homework – June 2018 – Alter a database
Leave a commentJune 4, 2018 by Kenneth Fisher
Here we are again. The beginning of another month. At the beginning of each month I put out a SQL …
Continue reading -
Updated query to view data in the error log
1May 31, 2018 by Kenneth Fisher
This is one of my favorite scripts. It pulls all of the data from the error log and dumps it …
Continue reading -
An interview with Brent Ozar
3May 30, 2018 by Kenneth Fisher
I was talking about interviews (although not the job kind) with a friend and it reminded me of the time …
Continue reading -
Interview questions: What’s the first thing you would do if a user reports slowness.
8May 28, 2018 by Kenneth Fisher
We’ve been doing a fair amount of interviewing recently and one of our big questions is What do you do …
Continue reading
SQL Studies
Live, Learn, Share
