-
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 -
Blogging and when to keep your big mouth shut
1May 14, 2018 by Kenneth Fisher
I’ve been blogging for a while now. I’ve thought about blogging quite a bit. I’ve even done quite a few …
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 -
Why I blog: TSQL Tuesday #102
2May 8, 2018 by Kenneth Fisher
It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given …
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 -
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
Live, Learn, Share
