Database Maintenance - Category Archive
The following is a list of all entries from the Database Maintenance category.
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 polished ...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 the ...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
DBA Career, Database Administration, Database Maintenance, 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 on ...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
Management Studio Improvements in SQL Server 2008
Database Administration, Database Maintenance | | 3:17 amSQL Server Management Studio in SQL Server 2005 has faced some tough criticism from DBAs over the years. Microsoft has tried hard to make up for the troubles of the past, bringing a multitude of improvements in SSMS 2008 that I go through in this article. Read more…
Twitter
Linked In