Tag Archives: microsoft sql server
-
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 -
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 -
What are the system databases?
4May 21, 2018 by Kenneth Fisher
I get to help with technical interviews every now and again, and one of the questions we always ask is …
Continue reading -
The trials and tribulations of REVERTing from impersonation
1May 16, 2018 by Kenneth Fisher
Impersonation is a highly useful tool in your toolbox. With the EXECUTE AS clause you can allow your stored procedure …
Continue reading -
Each session should be able to have its own temp table, but there can be problems.
1May 10, 2018 by Kenneth Fisher
You should be able to create a #temp in every session. That’s the idea, right? It’s one of the things …
Continue reading -
SQL Homework – May 2018 – Create a database
2May 2, 2018 by Kenneth Fisher
I’ve really got to make a plan here at some point. So far I’ve been just putting down things as …
Continue reading -
SQL and Azure Maze
Leave a commentApril 30, 2018 by Kenneth Fisher
Something fun for the end of the month. Here are a handful of mazes for you to enjoy. I found …
Continue reading
