Blog Archives

Automating Deployment of SQL Server Maintenance Plans

Introduction SQL Server maintenance plans provide automated backups of SQL Server databases. What if you want the same maintenance plan to be deployed to one or more additional servers? The deployment can be automated as explained here using SQL Server

Tagged with: , , , , ,
Posted in Development

Rebuilding Indexes on SQL Server

It is quite rare to need to rebuild the indexes on an SQL Server but it does happen. When it does, it is quite easy to rebuild an index using SQL Server Management Studio. Open up the node for the

Tagged with:
Posted in Development

SQL Server 2014 CTP1 Released

I hope you got plenty of use out of your SQL Server 2012 because SQL Server 2014 CTP1 has been released. You can dowload a trial here. http://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspx Performance is the first word mentioned in the improvements. Following that availability

Tagged with:
Posted in Development