Database Maintenance - Category Archive
The following is a list of all entries from the Database Maintenance category.
Free eBook on SQL Server Maintenance Plans Now Available
Books,Database Administration,Database Maintenance | January 14, 2010 | 11:30 amMy new eBook, Brad’ Sure Guide to SQL Server Maintenance Plans is now available as a free, 269 page PDF eBook. The book is designed for part-time or novice DBAs who want to learn how to properly create Maintenance Plans using the tools that come with SQL Server Management Studio (SSMS) in SQL Server 2005/2008. ...read more
How to Use SQL Backup Inside a Maintenance Plan
Database Administration,Database Maintenance | January 13, 2010 | 2:00 amWhen you create a SQL Server Maintenance Plan using the Maintenance Plan Wizard or the Maintenance Plan Designer, the SQL Server native backup command is used to perform full, differential, and transaction log backups. But what if you want to use backup compression to reduce the size of your backups and the amount of time ...read more
Ola Hallengren Updates Free Database Maintenance Scripts to Support SQLBackup 6.3
Database Maintenance,Free Stuff | November 26, 2009 | 10:31 amOla Hallengren has recently updated his popular free SQL Server database maintenance scripts to support the newest point release of SQLBackup 6.3. For those of you who are not familiar with Ola’s database maintenance scripts, they are designed to help you backup, optimize indexes, and perform integrity checks on all your databases. These are highly ...read more
PASS’s SQL Server Standard Latest Edition Available
Database Maintenance,PASS | November 13, 2009 | 11:09 amAlthough it’s buried on the SQLPASS website, the newest edition of the SQL Server Standard is now available here in the PDF format. The goal is to publish two articles a month on the website. The first article is from Thomas LaRock (aka SQLRockstar), and it is called “The Trouble With Triggers.” The editor of ...read more
Free T-SQL Database Maintenance Scripts
Database Administration,Database Maintenance,Free Stuff,Performance Tuning | October 13, 2009 | 5:36 pmI often get questions in e-mails, or at user group meetings, for advice on writing T-SQL database maintenance scripts. There seem to be a lot of DBAs who need more flexibility than what the Database Maintenance Wizard offers to perform database maintenance, which means they must user either T-SQL or PowerShell scripts in order to ...read more
Free SQL Server Dashboard
Database Administration,Database Maintenance,Free Stuff | September 23, 2009 | 9:01 amGreg Larsen, a SQL Server DBA, and the owner of the website SQLServerExamples.com, has released a free plug-in for SSMS called the SQL Server DBA Dashboard. The useful tool produces a multitude of reports to help both DBAs and Developers in their quest to see inside of SQL Server, and how it is performing.
Help Design a New SQL Server Monitoring Tool
Database Administration,Database Maintenance,DBA Career,Performance Tuning | September 3, 2009 | 9:25 amIn an experiment in SQL Server community involvement, the members of Red Gate Software’s software development usability team have created a new website called www.thefutureofmonitoring.com. This team, among other teams at Red Gate Software, are working Version 2 of its popular SQL Response software. The goal of the new website is to get your input ...read more
Policy-Based Management
Database Maintenance | August 8, 2009 | 3:20 amIf SQL Servers are treated as ‘islands’, each with their own subtly different configurations, managing multiple instances of them can be a frustrating experience for the DBA. SQL Server 2008’s policy-based management aims to help us enforce policies for SQL Server instances throughout an organization. In this article, I look at what policy-based management is, ...read more
Twitter
Linked In