One of the most important responsibilities of a database administrator is to make sure that all the databases are backed up across environments managed by them. In my earlier article titled Importance of Database Backups and Recovery Plan I discussed the importance of a good database backup and recovery plan for all the user and system databases. In this article we will take a look at the steps which a database administrator needs to follow to backup and restore an analysis services database.

SQL Server 2008 R2 Service Pack 1 Customer Technology Preview Available

by Press Release

MSDN Communities

SQL Server 2008 R2

You can help test the first service pack for SQL Server 2008 R2 and ensure the highest quality possible for its release.

Happy Easter 2011

by Steve Jones

SQLServerCentral.com

Editorial

It's Good Friday and the Easter holiday weekend with a number of countries having a bank holiday. Steve Jones is on vacation and providing us with a blooper reel for today.

ShowPlan Operator of the Week - Split, Sort, Collapse

by Additional Articles

SimpleTalk

Execution Plans

'Split, Sort & Collapse' is, happily, not a description of the intrepid Fabiano Amorim after his epic series of articles about the ShowPlan operators. With renewed stamina, Fabiano continues his mission to describe all the major operators by explaining the Trivial Plan and the power of unique indices.

Saying Thank You

by Steve Jones

SQLServerCentral.com

Editorial

After a bad experience traveling, Steve Jones stops to recognize that despite a possible computer bug, he still recognizes that the programmers building web sites aren't making mistakes on purpose and deserve a thank you for their work.

SQL Server Webinar Series #9: Streamlining SharePoint Recovery

by Press Release

SQLServerCentral.com

Metalogix Selective Restore Manager streamlines the process of finding and recovering individual documents and lists directly from a SharePoint content database backup file without the need for a recovery farm. When used in conjunction with Red Gate’s SQL Virtual Restore, Selective Restore Manager can recover documents and lists without physically restoring the backup file—saving time and much needed disk space. Together, Metalogix Selective Restore Manager and Red Gate SQL Virtual Restore open up new possibilities for your SharePoint backup and recovery strategy. Apr 21, 2011, 11am EST.

When does a Tumbling Window Start in StreamInsight

by Additional Articles

sqlis.com

StreamInsight

Whilst getting some courseware ready I was playing around writing some code and I decided to very simply show when a window starts and ends based on you asking for a TumblingWindow of n time units in StreamInsight. I thought this was going to be a two second thing but what I found was something I haven’t yet found documented anywhere until now.

The Mentoring Experiment

by Steve Jones

SQLServerCentral.com

Editorial

Have you ever wanted a mentor? Do you think that your career would benefit from having one? Steve Jones talks about a new experiment that he is putting in place with Andy Warren that looks to build a mentoring framework.

Database Normalization Webcast

by Press Release

SQLServerCentral.com

Join Normalization nut Thomas LeBlanc for a review of a standard operating procedure used among DBAs at an employer. See the changes he made after joining the BI group at this employer. The session will go through naming conventions, check list for creating a table, formatting in stored procedures, and more. A brief preview of the SQLRally talk 3rd Normal Form: That’s Crazy Talk!!! Will be given about Lookup tables. Thur, Apr 21, 2011, 12:00pm EST.