I would typically use Management Studio to rename columns or tables in SQL Server. Afterall, it is an easy thing to do to open up the GUI make your changes and then save them back to the SQL Server. Have you ever been in a situation where you wanted to make a number of such changes and then later on you needed to repeat those changes on another system? I was in such a … [Read more...] about How to Rename a SQL Server Column or Table Using T-SQL
Implementing a Simple SQL Server Backup Script
I've used this simple SQL Server backup script a number of times to backup sql server to a file or network drive. It's ideal if you are running SQL Server Express for example which does not come equipped with maintenance plans. This script can be used in conjunction with SQLCMD to backup SQL Server from the command line. So let's take a look at this. What we want to … [Read more...] about Implementing a Simple SQL Server Backup Script
Using DBCC SQLPERF
There are a number of uses for the DBCC SQLPERF command. I touched upon one of them in my last post on how you can use the command to obtain information about transaction log growth. This handy little DBCC command has been around for a while now. So lets look at the others ways you use it.... Viewing wait statistics data Clearing wait statistics data Clearing … [Read more...] about Using DBCC SQLPERF
Monitoring SQL Server Transaction Log Growth Using DBCC SQLPERF(logspace)
For this article, I am using DBCC SQLPERF(logspace) to get size information about the transaction logs. I hope you will find this post useful in helping to monitor the growth of your transaction logs. The idea here is to capture and store the growth information at set intervals. This can provide a way to report on how much the logs are growing by and when. Reports are then de … [Read more...] about Monitoring SQL Server Transaction Log Growth Using DBCC SQLPERF(logspace)
An Introduction to SQL Server Backup
Before I get into this post on SQL Server backup, I must make something really clear without sounding like I am stating the obvious. :| Having a fully tested backup and restore plan in place for your SQL Server databases is one of, if not, THE most important job that you have to ensure you get right as a DBA. Getting it wrong could mean huge financial costs to your … [Read more...] about An Introduction to SQL Server Backup