Tag Archives: microsoft sql server
-
‘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 -
Can we get a license for DDL Triggers?
4December 14, 2015 by Kenneth Fisher
There are several types of triggers. Logon triggers – Fired when someone tries to connect to the instance. DML triggers …
Continue reading -
Using unique constraints
10December 10, 2015 by Kenneth Fisher
I ran into an interesting problem the other day. Given the title of the post, obviously a unique constraint was …
Continue reading -
Apathy – A quick path to the naughty list.
Leave a commentDecember 8, 2015 by Kenneth Fisher
It’s the Christmas season! And it’s T-SQL Tuesday! And Bradley Ball (b/t), SQL’s very own superhero (one of many really …
Continue reading -
DBA Myths: Database file extentions
10December 2, 2015 by Kenneth Fisher
Every now and again I hear or read that the only file extensions for a SQL Server database are mdf, …
Continue reading -
SSMS Setup
9November 16, 2015 by Kenneth Fisher
Every time I install a new version of SSMS I make a handful of changes to the default setup. For …
Continue reading -
Why are you still using datetime?
28November 10, 2015 by Kenneth Fisher
It’s almost Thanksgiving time again! Let’s see, what am I thankful for? T-SQL Tuesday! Someone else get’s to pick a …
Continue reading
SQL Studies 