Author Archives: Kenneth Fisher
-
Using VALUES to construct an in-line table.
Leave a commentMay 22, 2019 by Kenneth Fisher
This has come up a few times recently, I find it rather fascinating and I can never seem to remember …
Continue reading -
Bad Idea Cowboy Hat: Using a foreign key to prevent updates
Leave a commentMay 20, 2019 by Kenneth Fisher
When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series (yes I asked) I decided that …
Continue reading -
Security Learning Pathway at PASS Summit.
Leave a commentMay 17, 2019 by Kenneth Fisher
This year PASS is trying something new at PASS Summit. There are going to be Learning Pathways. A learning pathway …
Continue reading -
How was it done back in the day? T-SQL Tuesday #114
2May 14, 2019 by Kenneth Fisher
It’s TSQL Tuesday and Matthew McGiffen (b/t) is our host with a subject near and dear to my heart. Puzzles! …
Continue reading -
Why am I getting an NT AUTHORITY\ANONYMOUS error when creating or altering a stored procedure?
1May 8, 2019 by Kenneth Fisher
If you have to deal with linked servers then you probably have or will run into the following error: Login …
Continue reading -
db_owner in msdb == sysadmin
1May 6, 2019 by Kenneth Fisher
This doesn’t require much in the way discussion. This isn’t exactly a huge issue since I don’t think granting db_owner …
Continue reading -
SQL Homework – May 2019 – SQLCMD and the DAC
5May 1, 2019 by Kenneth Fisher
Yes, it’s that time again. Time to do your homework. This month your homework is to set up the DAC …
Continue reading -
What do you get with a Free account in #Azure?
Leave a commentApril 29, 2019 by Kenneth Fisher
The first thing I want to do is say thank you to Michael Crump (b/t). He tweeted out this: What …
Continue reading -
Yes, pulling just the data you need is really important.
Leave a commentApril 24, 2019 by Kenneth Fisher
I was asked the other day why a customer was having performance issues on a table. A simple SELECT that …
Continue reading -
Shrinking a large database with limited outage windows
10April 22, 2019 by Kenneth Fisher
Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where …
Continue reading
