SQL
Get flash to fully experience Pearltrees
Get Index Fragmentation Percentage for all Tables in SQL Server Database - Code Samples & Tutorials
Here is a useful script I've been able to put together from multiple posts online that gets the estimated index fragmentation for all tables in your database where the fragmentation percentage is greater than the where clause. Here's the SQL: select object_name(itable.object_id) as tablename, itable.name as IndexName,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.
Index Defrag Script, v4.1 « SQL Fool
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 AllenRankings | SQLRockstar
Here is the latest update for the blogger rankings. I promoted Ted Krueger ( blog | @onpnt ) to model and moved Brad McGehee ( blog | @bradmcgehee ) down to msdb. I also promoted Michael Swart ( blog | @mjswart ) and Karen López ( blog | @datachick ) up to msdb.
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!
Free Training Videos and Tutorials
Overview One of your last lines of defense for just about any system is to have a backup in place in case there is a need to recover some or all of your data. This is also true for SQL Server. In this tutorial we will discuss selecting the correct recovery models what backup options are available how to create backups using T-SQL commands and SQL Server Management Studio If you are new to SQL Server you should review each of these topics, so you are aware of the available options and what steps you will need to take in order to recover your data if ever there is the need. You can either use the outline on the left or click on the arrows to the right or below to scroll through each of these topics.
SQL Server Backup Options and Commands tutorial and example
Selecting the SQL Server database recovery model to ensure proper backups
Problem One 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.