-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Archives: December 2015

Do you check for TRUSTWORTHY databases as part of your security audits?

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

7 comments, 2,097 reads

Posted in SQLStudies on 30 December 2015

What does that N in nvarchar really mean?

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

9 comments, 1,825 reads

Posted in SQLStudies on 28 December 2015

‘Twas 4:45 Friday

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

0 comments, 373 reads

Posted in SQLStudies on 23 December 2015

What is the current database context?

Every now and again it can be very helpful to know what the current database context is when you are writing T-SQL code. It’s actually pretty simple. Use DB_Name() and/or DB_ID().

You can use them without a parameter to return the name or id of the current database context. Read more

3 comments, 450 reads

Posted in SQLStudies on 21 December 2015

Scripting out multiple scripts from the Object Explorer Details window.

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

5 comments, 385 reads

Posted in SQLStudies on 16 December 2015

Can we get a license for DDL Triggers?

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

1 comments, 1,524 reads

Posted in SQLStudies on 14 December 2015

Using unique constraints

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

10 comments, 1,414 reads

Posted in SQLStudies on 10 December 2015

Apathy – A quick path to the naughty list.

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 but he’s the only one I know who dresses the part)

has decided to combine the two. With this month’s subject Naughty or Nice he’d like… Read more

0 comments, 354 reads

Posted in SQLStudies on 8 December 2015

DBA Myths: Database file extentions

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

9 comments, 2,160 reads

Posted in SQLStudies on 2 December 2015