Monthly Archives: April 2018
-
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 -
I’ve gotten a transaction log full error but when I look it’s not full??
2April 16, 2018 by Kenneth Fisher
Every now and again I’ll get an error telling me a transaction log is full. This can be for any …
Continue reading -
Deleting a lot of data
5April 12, 2018 by Kenneth Fisher
I recently had the task of deleting a bit over a billion rows from a table. Now I could have …
Continue reading -
Exploring permissions with sp_DBPermissions and sp_SrvPermissions : TSQL Tuesday 101
1April 10, 2018 by Kenneth Fisher
Our host for T-SQL Tuesday this month is Jens Vestergaard (b/t) and he has asked about our favorite SSMS tool. …
Continue reading -
SSMS’s Dark Theme
5April 4, 2018 by Kenneth Fisher
There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the …
Continue reading -
SQL Homework – April 2018 – Indexes
Leave a commentApril 2, 2018 by Kenneth Fisher
This month we are going to look at a topic near and dear to both database developers and database administrators …
Continue reading