I wrote a post recently about setting the DAC port for an SQL instance.
I now do this as a matter of course on all of my SQL instance as I manage most of them remotly.
However, from time to time I discover instances that have had… Read more
I had a situation today where I needed to ensure that the dedicated Administrator connection (DAC) ran on a specific port.
The main reason that I wanted it on a specific port was so I could use the connection remotely (if needed) and because the connection was on… Read more
I’ve noted a few instances lately of cases where VARCHAR(MAX) columns have been used unnecessarily, when a small value (for a VARCHAR) would have been fine.
Apart from the storage implications of a VARCHAR(MAX) column there is also the issue that in SQL SERVER 2008, having a column of… Read more
I was checking out some of our configuration options today using sys.configurations and I started to wonder how many people actually use this table, or whether most people simply use the more common system stored procedure sp_configure.
As sys.configurations is simply a table, we can use an ORDER BY… Read more
I think it’s a safe bet that everybody here has issued a DROP DATABASE statement and knows what to expect.
Well, today I was experimenting with a development database. The script I was using employed simply reusable code to drop and re-create the database – or so I though. Read more
I’m probably not the only one that has noticed that as the volume of data gets bigger in out databases, the time taken to preform maintenance increases.
This seems to be a simple fact of life for the DBA. But as our maintenance time increases, we need to be… Read more
Back in February, I was lucky enough to attend a week of training on SQL internals from the people at SQLskills in Dallas, Texas.
I felt that I learned that much there and enjoyed myself so much that the journey back across the Pacific from New Zealand for the… Read more
I recently ran into a nice feature that I had never encountered before.
Sometimes, when developing or administrating an unfamiliar table we will simply do a “SELECT *” so that we can quickly see the column names.
This is pretty much fine when the table is small.
However in… Read more
Here’s my input into this months Meme Monday – there are no dumb questions.
It seems (at least to me), that – occasionally – no matter how hard you try to ask an intelligent question about SQL SERVER on some of the forums – that somebody will interpret… Read more
I’m a big fan of maintaining and updating your technical skills, but sometimes its difficult to measure your ability at a task, especially if you don’t use that particular piece of a technology in your day job.
One good way of measuring these skills is to sit certifications and… Read more
I recently received a brand new windows 7 virtual machine for my every day work use and one of the first things that I did was install SQL SERVER 2008 developer edition on it.
As I’d expect, this was a pretty straight forward task and before long I had… Read more
The recommended way to access SQL SERVER metadata is through the catalog views.
The compatibility views basically… Read more
There’s a lot of mixed opinions around about certifications.
Are they worth while, do they mean anything, do employers value them and the like.
I’m personally in the “certifications are definatly” worth while camp. For a few reasons,
- Certifications test my knowledge to a certain standard and give me…
Running object creation scripts into other environments is a big part of most DBA’s work – especially when a new system is being built in an agile manner. Stored procedures get created and altered all the time.
Very often I used to see code like this
IF EXISTS (…
Apparently “Meme Monday” was started by Thomas Larock (Blog | Twitter) , as a way for getting people writing. I haven’t been tagged or anything, I just thought that I’d gate crash the party. It was also Tuesday (here in New Zealand), when I seen this weeks… Read more
Both the lazy writer process and a checkpoint both push in-memory pages out to disk, however that’s where the similarity ends.
The reason that I’m blogging about that is because I can completely understand how people can confuse these two events – however they are totally different. This post… Read more
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