The aim of the new Database Recovery Advisor in SQL Server 2012 is to simplify the task of piecing together a recovery sequence from multiple backup files, comprising full, differential, and log backups. In this article, I'll demonstrate how the tool makes it easier to plan for, and perform, a point in time recovery from a series of backups, in order to recover data that may have been lost due to an application bug, or user error.

File Watcher Task

by Additional Articles

sqlis.com

Integration Services (SSIS)

The task will detect changes to existing files as well as new files, both actions will cause the file to be found when available. A file is available when the task can open it exclusively. This is important for files that take a long time to be written, such as large files, or those that are just written slowly or delivered via a slow network link.

One Single View

by Steve Jones

SQLServerCentral.com

Editorial

This editorial was originally published on Oct 9, 2007. It is being re-run as Steve is traveling. When I worked at JD Edwards, one of the goals of our business intelligence system was to house a single view of the truth. I recently saw a blog post by Andrew Fryer that does a good job of explaining what this actually is.

SQL Triggers in a Security Context

by Derek Colley

SQLServerCentral.com

SQL Server

This article will show you how to use user-defined triggers to supplement your security policies, preventing unauthorised data manipulation and blocking unfriendly logins.

Do you work with data to support organizational decisions?

by Additional Articles

Redgate

Are you a database or BI expert supporting decisions in your company with reports or models using Microsoft tools? We want to hear how you do this and what you think of the trend towards 'self-service' analysis for business users. Share your experiences in a short survey.

The PoSh DBA - The Attributes of Advanced Functions

by Additional Articles

SimpleTalk

PowerShell

Once you pass that point of just hurriedly writing PowerShell scripts for immediate use and start to write PowerShell functions for reuse, then you'll want a robust set of parameters that allow functions to work just like cmdlets.

Is it time to move from SQL Azure to Amazon RDS SQL Server?

by Peter Marriott

SQLServerCentral.com

Azure

Amazon RDS SQL Server is the new kid on the block. Is it better than SQL Azure?

Why It's Good To Be Wrong

by Hakim Ali

SQLServerCentral.com

Editorial

Today we have a guest editorial from Hakim Ali. Being wrong is not as bad as you may think.

SQL Server Report Server 2008 R2 Execution Log Reports

by Additional Articles

MSSQLTips.com

SQL Server 2008 R2

As you design and deploy more and more reports to your Report Server, how do you review which reports are being run, how often, and how long the reports take to render?

SQL Server Central Webinar Series #20: Using SQL Storage Compress in the Real World

by Press Release

SQLServerCentral.com

Join us on July 10 at 4:00pm GMT/11:00am EDT for an in-depth look at SQL Storage Compress and learn how you can shrink the storage needs for your databases.

SQL Server 2012 Database Recovery Advisor: Simplified Point in Time Recovery

File Watcher Task

One Single View

SQL Triggers in a Security Context

Do you work with data to support organizational decisions?

The PoSh DBA - The Attributes of Advanced Functions

Is it time to move from SQL Azure to Amazon RDS SQL Server?

Why It's Good To Be Wrong

SQL Server Report Server 2008 R2 Execution Log Reports

SQL Server Central Webinar Series #20: Using SQL Storage Compress in the Real World

Blogs

Monday Monitor Tips: Virtual Machine Usage and Cost

Advice I Like: Respect

Blue Sky Programming – The Optimism Trap

Forums

SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About

SQL Server Still Wins

DBCC CHECKDB Limits I

Question of the Day

DBCC CHECKDB Limits I