background preloader

SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization

SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization

Index Defrag Script, v4.1 « SQL Fool It’s been quite some time since my last index defrag script update. A big part of the reason for that is because I wanted to implement many of the suggestions I’ve received, but I just haven’t had the time. I still have those changes planned, but I’m not sure quite when I’ll get to it. Rather than continue to wait for a major release, I’m releasing a small update to my defrag that will take care of the most common complaints I receive. Change Log: Bug fix for databases containing spaces or special charactersSupport for case-sensitive databasesRe-executable CREATE script (for those who want to re-run the whole script)Comma-delimited list of databases is now supported for the @database parameter Feature List: Defrag a single database, a list of databases, or all databases (@database)Time Limitations: stop defragging after the specified amount of time has elapsed (@timeLimit). I often receive the same questions about this script, so allow me to answer them here:

SQL Server Book Reviews for DBAs There’s a ton of SQL Server books out there to help get you started on the road to becoming a database administrator. I’m going to start at the start of your career, and go forward. My Favorite Non-SQL Server Books These books aren’t specific to DBAs, but are things I’ve found really helpful in my career: Getting Things Done Getting Things Done by David Allen Do you get nervous at the thought of opening your email in-box because there’s so much piled up, and you don’t know where to begin? David Allen’s book Getting Things Done has been the answer for me and for a few of the folks I work with. I showed my current manager into the GTD philosophy, and he caught on right away. You can buy the paperback on Amazon, and there’s also a Kindle version. Time Management for Systems Administrators by Thomas Limoncelli If you’re not quite ready for the GTD strategy, check out this lighter version of the philosophy that’s tailored specifically for IT workers. The Whuffie Factor by Tara Hunt

Free Training Videos and Tutorials We speak at SQL Server user groups and live events, and we record presentations and post them here whenever possible. Every Tuesday at 11:30AM Central, we run a free webcast covering SQL Server, virtualization, storage, and more. If you can attend live and ask questions, that’s great! You can register for our upcoming webcasts, and add a recurring calendar reminder so you can make it each week. Want to automatically get new videos and set up easy viewing on your tablet or phone? Pop some popcorn and turn down the lights…. SQL Server Performance Tuning Tutorials SQL on SSDs: Hot and Crazy Love – Brent Ozar talks about the attractions and perils of super fast storageDevelopers, Performance, and the SQL Server Transaction Log – Kendra Little talks about how application patterns impact performance of the transaction logDBA Darwin Awards: Index Edition - Brent Ozar shows you common mis-steps people make with indexes. Professional Development Videos SQL Server DBA Tutorial Videos

Selecting the SQL Server database recovery model to ensure proper backups ProblemOne of the first things that should be done when managing SQL Server is to setup an appropriate backup plan in order to minimize any data loss in the event of a failure. Along with setting up a backup plan there are certain database configurations that need to be setup to ensure you are able to backup databases correctly. In this tip we will look at the different recovery models that SQL Server offers and how to choose a recovery model for your database. SolutionFor SQL Server 2000 and 2005, Microsoft offers three different recovery models for your databases. The three recovery models are: SimpleThe simple recovery model does what it implies, it gives you a simple backup that can be used to replace your entire database in the event of a failure or if you have the need to restore your database to another server. Type of backups you can run: Complete backups Differential backups File and/or Filegroup backups Partial backups Copy-Only backups Data is critical and data can not be lost.

Related: