-
Nada to Speaker: Demystifying and Diminishing Dynamic SQL Difficulties
Leave a commentAugust 20, 2018 by Kenneth Fisher
Last Thursday I spoke at NTSSUG (North Texas SQL Server User Group). This is my local group (only 1.5 hours …
Continue reading -
What are my permissions?
Leave a commentAugust 16, 2018 by Kenneth Fisher
Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z …
Continue reading -
Complicated linked servers and a bunch of head-desks: T-SQL Tuesday #104
Leave a commentAugust 14, 2018 by Kenneth Fisher
Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started …
Continue reading -
Putting Object Explorer etc on the right side of SSMS rather than the left.
Leave a commentAugust 8, 2018 by Kenneth Fisher
A while back I was given the advice Move your tabs (Object Explorer etc) to the right side of SSMS. …
Continue reading -
T-SQL Formatters
3August 6, 2018 by Kenneth Fisher
The other day I was given a truly horribly formatted piece of SQL. Something a bit like this only worse, …
Continue reading -
SQL Homework – August 2018 – Set up database mail
Leave a commentAugust 1, 2018 by Kenneth Fisher
This month’s homework is pretty simple to say, not necessarily easy to do. Set up database mail. Why database mail? …
Continue reading -
#SQLCareer 2/4 July 25th 2018
Leave a commentJuly 30, 2018 by Kenneth Fisher
Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the …
Continue reading -
#SQLCareer 1/4 July 19th 2018
1July 25, 2018 by Kenneth Fisher
Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the …
Continue reading -
Processes can dramatically improve your work until they don’t.
Leave a commentJuly 23, 2018 by Kenneth Fisher
As always with something like this, I like to start with a definition so we are all starting in the …
Continue reading -
RESTORE VERIFYONLY what does WITH LOADHISTORY do?
2July 18, 2018 by Kenneth Fisher
Recently someone mentioned the LOADHISTORY option of RESTORE. It’s not horribly hard to find in BOL but it wasn’t the …
Continue reading
SQL Studies
Live, Learn, Share
