-
Scripting out multiple scripts from the Object Explorer Details window.
5December 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?
Leave a commentDecember 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
7December 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 -
You should always have an “I got hit by a bus” backup plan
8November 30, 2015 by Kenneth Fisher
You have an on call, you have a business continuity plan, you have a disaster recovery plan but what happens …
Continue reading -
Women in technology
Leave a commentNovember 25, 2015 by Kenneth Fisher
Earlier this week a friend of mine (Lynn Swayze (Hall) (b/t)) posted this great article on women in technology. It’s …
Continue reading -
Using multiple log files
5November 23, 2015 by Kenneth Fisher
The transaction log is made up of one or more files that are used sequentially. So in other words if …
Continue reading -
Naught to Speaker pt 3
6November 18, 2015 by Kenneth Fisher
Becoming a speaker is one heck of a journey. Early this year I submitted a session to speak at Pass …
Continue reading -
SSMS Setup
5November 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
SQL Studies
Live, Learn, Share
