Archives: April 2011
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…
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
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
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
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
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
DBCC TRACEON(661); GO
I then stated inserting records… Read more
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
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
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
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