Tag Archives: microsoft sql server
-
The identity column, the insert and the linked server.
4June 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 -
What are the system databases?
5May 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 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 -
What is a DBA?
Leave a commentApril 25, 2018 by Kenneth Fisher
If you’ve worked in the data industry for more than few minutes then you’ve probably heard the phrase The DBA …
Continue reading -
Command shell steps in SQL Agent jobs only process a single command.
1April 23, 2018 by Kenneth Fisher
I was working on a SQL Agent job recently that required a series of command shell commands. And it would …
Continue reading -
Exploring system tables, views, SPs etc
Leave a commentApril 18, 2018 by Kenneth Fisher
I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have …
Continue reading
SQL Studies 