|
|
|
Get Your Own Blog
If you would like to blog on SQLServerCentral.com then send an email to
webmaster@sqlservercentral.com.
Contact the author
All Blogs
Feeds
Archives
for this blog
Security is a very important part of every DBA’s role. If you are not clued up on security best practices or don’t secure your SQL Servers, you should be concerned as it could end up costing you your job!
I have worked in organisations where the painstaking task of managing… Read more
Today's post is a follow on from one earlier this month Database uplevel Restores. I got round to testing restoring a SQL Server 2000 backup to a SQL Server 2008 R2 server and it worked! Details Below;
-- Restore command RESTORE DATABASE [SQL2000Test] FROM DISK = 'D:\SQL2000TestBackup.bak' Read more
I had a problem just before the festive period where one of our production SQL Servers was randomly grinding to a halt, queries which usually returned in milliseconds where running for minutes. It took 4 days of performance monitoring / troubleshooting and some help from the SQL Community (when I… Read more
Today’s post is a quick one as I am a bit under the cosh.
There are many ways to move database files, detach and attach, backup and restore, alter database. But what can you do if the files you want to move belong to a database being used in replication? … Read more
I've been using 4 alerts for corruption now for about 2 years for Errors 823, 824, 825 and 9100. Basically I would create an operator via SSMS, the four alerts via T-SQL then manually add the operator to the response through SSMS. Now given that I only did this during the… Read more
I have, in the past had the need to rename a server, either because the server has been named incorrectly or because it has been created as a clone from an image. There is a documented process which I have used in the past to rename SQL Server once the… Read more
Today I've been reading Paul Randal's collection of Blogs from a series called A SQL Server DBA myth a day. If you haven't yet read it I recommend it there are a couple of misconceptions in there that I have fallen foul of in the past. You can…Read more
I read a blog post this morning on SQLServerCentral by Tim Radney about SQL Server Error Logs. Tim talks about increasing the number of error logs in SQL Server. One thing that came to mind to take this one step further and is just as simple to do is to… Read more
I came across an issue on a server this morning where a drive had run out of free space. Now given I still haven't got a full list of servers which I should be managing I'm not going to kick myself over this.
The issue came to light by the fact the previous DBA had set-up an email…Read more
Today I'm in the process of installing some physical servers. To put this into perspective due to the companies I have worked for over the last few years adopting virtualisation I haven't installed Windows Server let alone commission a physical server from sysprep up.
Imagine then being asked to connect from my…Read more
Right I've been itching to post another Blog and actually contribute something this time. This isn't something I've learned but something I've taught many times in the past.
It can't be just me but I get asked a lot about the formatting of dates especially for reports.
This is something that is almost always…Read more
So here it is then, my first ever Blog post!
I'm not cheating here as I am not officially starting to post the 365 things I learn about SQL Server until 1st January 2012!
Last week I started a new job and am now a Database Administrator for Experian QAS.…Read more
Newer posts
|
Subscribe to this blog
