Archives: December 2015
I ran a twitter poll the other day Do you check for databases with trustworthy turned on when you do security audits?
I wasn’t surprised (although a little disappointed) that out of the 9 people the answered only one person was, and of the rest 5 didn’t even know what… Read more
In any study of Data Types in SQL Server you are going to have to look at the various string data types. One important component is the difference between nChar vs Char and nVarChar vs VarChar. Most people reading this are probably thinking “Well that’s ridiculously easy.” If you are… Read more
I couldn’t think of anything really fun to post for Christmas Eve-Eve and I’ve been busy buying and wrapping presents so here is my Christmas post from last year. Enjoy :)
‘Twas 4:45 Friday, and all through the office
not a creature was stirring, not even the bosses.
The code… Read more
You can use them without a parameter to return the name or id of the current database context. Read more
A few weeks ago I was reading a blog post by Andrea Allred (b/t) and was just amazed by what I was reading. I’ve never been a big fan of the Object Explorer Details window. It didn’t seem to really add anything. But Andrea pointed out… Read more
There are several types of triggers.
- Logon triggers – Fired when someone tries to connect to the instance.
- DML triggers – Fired after a DML statement. INSERT, UPDATE and DELETE statements.
- DDL triggers – Fired after a DDL statement. For example CREATE, ALTER, DROP, GRANT, DENY, and REVOKE.
All… Read more
I ran into an interesting problem the other day. Given the title of the post, obviously a unique constraint was involved, although I want to point out that the problem was not caused by the constraint in and of itself. It did get me thinking about this particular kind of… Read more
has decided to combine the two. With this month’s subject Naughty or Nice he’d like… Read more
Every now and again I hear or read that the only file extensions for a SQL Server database are mdf, ndf and ldf. Not true I’m afraid. And I truly wish it was. The file extensions can be whatever you want, or even nothing at all.
Note: Here are the… Read more