-
Why you shouldn’t use SELECT *
2March 28, 2016 by Kenneth Fisher
I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?) …
Continue reading -
I’m presenting for the Pass Security Virtual Chapter!
1March 23, 2016 by Kenneth Fisher
Tomorrow (3/24/2016) at noon CT I’ll be presenting my SQL Server Security Basics session for the Pass Security Virtual Chapter. …
Continue reading -
TOP 1 killed my performance; Rob Farley helped me resurrect it.
15March 21, 2016 by Kenneth Fisher
tl;dr; There is no short version of this. It’s LONG. It’s interesting but you might want to skip it if …
Continue reading -
What permissions do I need?
Leave a commentMarch 16, 2016 by Kenneth Fisher
Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it …
Continue reading -
Pulling data from a non-clustered index
2March 14, 2016 by Kenneth Fisher
This is one of those things that I found very interesting but figured I’d probably never really use. Of course …
Continue reading -
You don’t need to be a sysadmin
29March 10, 2016 by Kenneth Fisher
Hey, I need sysadmin access to ServerA. Ok. Why do you need sysadmin? Well I need to be able to …
Continue reading -
Ever wonder what that goofy query in the header means?
5March 8, 2016 by Kenneth Fisher
It’s T-SQL Tuesday time again (Number 76!) and this month we are hosted by Bob Pusateri (b/t) who has invited …
Continue reading -
How do I grant someone the ability to create a stored procedure?
2March 2, 2016 by Kenneth Fisher
The question of How to grant the ability to create/alter stored procedures and views came up today on dba.stackexchange.com. It’s …
Continue reading -
Blogger questions: How often should I blog?
10February 29, 2016 by Kenneth Fisher
What with the #sqlnewblogger effort we’ve been seeing a lot of new bloggers (and some old ones starting up again) …
Continue reading -
Powershell script to create multiple SQL Server Connections
2February 24, 2016 by Kenneth Fisher
As with most of these types of things, I had a need. I want to show how using sys.dm_exec_[requests/sessions/connections] is …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 