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

Archives: April 2011

DBA relationships – The data custodian


As DBA’s, we all know how to manage security, some are more advanced that others but ensuring that the right people have the right access to the right information is an extremely large part of our jobs – at least it is for me any way.

I’m pretty sure…

Read more

0 comments, 2,224 reads

Posted in measure twice, cut once. on 28 April 2011

Connection strings and application name


There are many things that developers and DBA’s can do to help their relationships run smoothly, most of them are relatively simply things – as this tip is today.

DBA’s often have to track down problems – often performance related – and they tend to use profiler for… Read more

0 comments, 9,612 reads

Posted in measure twice, cut once. on 27 April 2011

The developer / DBA relationship.


A large part of my job involves liaising with developers. I spent the first 8 years of my IT career working as a developer before moving into database administration in 2008. Consequently,  I find this relationship to be one of the easier aspects of my job to manage  -… Read more

9 comments, 2,606 reads

Posted in measure twice, cut once. on 27 April 2011

A small facet of information


I’ve blogged about facets before, but I just thought that I’d mention them again, as they came in quite handy today.

I was looking to change the default backup directory of my SQL instance.

Usually, I’d just change the value by editing the registry, either manually or with a… Read more

1 comments, 495 reads

Posted in measure twice, cut once. on 24 April 2011

PowerShell Tip – Custom windows for different tasks.


There seems to be a lot of articles around at the moment concerning the use of PowerShell.

I think this is great and I’m currently attempting to write a Powershell script for all of the activities that I perform daily on my databases.

However, anybody who has more than… Read more

1 comments, 724 reads

Posted in measure twice, cut once. on 22 April 2011

DBCC TraceOn – some processes are global.


I was recently doing some testing as I thought that I’d experiment with the ghost clean up process.

I found that I needed to enable Trace Flag 661 to disable this process.
So off I went and ran the following code


I then stated inserting records… Read more

2 comments, 2,621 reads

Posted in measure twice, cut once. on 13 April 2011

So, what’s this heap thing?


I’ve been asked a few times lately to explain what a heap is.

I’m quite happy to do this, but I generally inquire of the person who posed the question, what exactly they think a heap is.

It’s at this point that I seem to mostly get one of… Read more

10 comments, 2,387 reads

Posted in measure twice, cut once. on 10 April 2011

This appears to be a system procedure..but it isn’t!


Recently, I was browsing through my database server when suddenly under the “System Stored Procedures” folder of the master database I seen a stored procedure that I knew had been written at my workplace. I knew this stored procedure never shipped with SQL SERVER 2008 and had not been… Read more

3 comments, 1,986 reads

Posted in measure twice, cut once. on 5 April 2011

View system object definitions


You’ve probably all noticed that when you right click on a user database object in SSMS object explorer that you get a context menu. One of the options in that context menu gives us the ability to script the object out.

However, try the same thing on an object… Read more

0 comments, 607 reads

Posted in measure twice, cut once. on 3 April 2011

If you fire that trigger, make sure you have the correct ID


I think it would be a fair bet to say that we’ve all used the @@IDENTITY function. It returns the last identity value that was generated by the statement – that’s what books online says.

Note that that statement says absolutely nothing about scope.

Generally, the scope will not… Read more

0 comments, 555 reads

Posted in measure twice, cut once. on 2 April 2011