-
To the page and back again
1January 18, 2016 by Kenneth Fisher
To the page It’s not one of those things you have to do frequently but every now and again you …
Continue reading -
What is RESULT SETS?
12January 14, 2016 by Kenneth Fisher
I was reading some code the other day and it included the statement RESULT SETS. I’d never seen it before …
Continue reading -
MSDTC Requirements for SSIS Transactions
4January 6, 2016 by Kenneth Fisher
MSDTC is frequently required when using transactions within SSIS. And not just when you are connecting to two SQL Server …
Continue reading -
2015 a year in review
7January 4, 2016 by Kenneth Fisher
It’s a new year, so time to look back at the previous year, and forward to the next. I’ll tell …
Continue reading -
Do you check for TRUSTWORTHY databases as part of your security audits?
7December 30, 2015 by Kenneth Fisher
I ran a twitter poll the other day Do you check for databases with trustworthy turned on when you do …
Continue reading -
What does that N in nvarchar really mean?
9December 28, 2015 by Kenneth Fisher
In any study of Data Types in SQL Server you are going to have to look at the various string …
Continue reading -
‘Twas 4:45 Friday
Leave a commentDecember 23, 2015 by Kenneth Fisher
I couldn’t think of anything really fun to post for Christmas Eve-Eve and I’ve been busy buying and wrapping presents …
Continue reading -
What is the current database context?
3December 21, 2015 by Kenneth Fisher
Every now and again it can be very helpful to know what the current database context is when you are …
Continue reading -
Scripting out multiple scripts from the Object Explorer Details window.
6December 16, 2015 by Kenneth Fisher
A few weeks ago I was reading a blog post by Andrea Allred (b/t) and was just amazed by what …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 