As a DBA you always followed a practice to back up your database (or take a snapshot of your database) before making any changes so that you can revert to your old database state if something goes wrong. Also to setup a development or test environment you use a backup of your database and restore it in the respective environment. If you are moving to SQL Azure, what would you do in these cases as backup / restore and database snapshots are not supported as of now?

Calling SQL Server With A BlackBerry Phone

by R Glen Cooper

SQLServerCentral.com

BlackBerry

An interesting tutorial for linking SQL Server to a Blackberry device and viewing images.

Stairway to SQL Server Reporting Services

by Site Owners

SQLServerCentral.com

Reporting Services (SSRS)

A series from MVP Jessica Moss designed to help you understand Reporting Services and begin building reports.

You Should Know

by Steve Jones

SQLServerCentral.com

Editorial

Are there things you should know? It seems that we quite often find that others in our profession don't understand the simple things we assume they do. Steve Jones talks about one item in particular: staging servers.

Five DMV Queries That Will Make You a Superhero in 2011!

by GlennBerry

SQLServerCentral.com

Blogs

Way back in January, 2008, I wrote a blog post called “Five DMV Queries That Will Make You A Superhero!”...

SEQUENCE in SQL Server 2011

by Additional Articles

SQL Server Performance

SQL Server 2011

SEQUENCE is a core new feature of SQL Server 2011 (Denali). It is a more performant, flexible alternative to the INDENTITY attribute. This article introduces sequence and demonstrates how to use it and its performance advantage.

Life Without Keyboards

by Steve Jones

SQLServerCentral.com

Editorial

The way we input data is changing with the advent of the iPad and tablets. Is that good or bad for the acquisition of data? Steve Jones has a few thoughts today.

SQL DISTINCT on Multiple Columns

by Sarvesh Singh

SQLServerCentral.com

DISTINCT

Learn the basic usage of DISTINCT in this article.

PASS Summit Location

by Grant Fritchey

SQLServerCentral.com

Blogs

Andy Warren has posted another one of his excellent summaries of what’s going on at the PASS Board. Andy, thanks...

Re-generating SQL Server Logins

by Additional Articles

Database Journal

Security

SQL Server stores all login information on security catalog system tables. By querying the system tables, SQL statements can be re-generated to recover logins, including password, default schema/database, server/database role assignments, and object level permissions. A comprehensive permission report can also be produced by combining information from the system metadata.

SQL Azure - Creating backups and copies of your databases

Calling SQL Server With A BlackBerry Phone

Stairway to SQL Server Reporting Services

You Should Know

Five DMV Queries That Will Make You a Superhero in 2011!

SEQUENCE in SQL Server 2011

Life Without Keyboards

SQL DISTINCT on Multiple Columns

PASS Summit Location

Re-generating SQL Server Logins

Blogs

Optimizing Redshift Performance by Configuring WLM Queues

PowerShell Strikes Back: Return of the Loop

Breaking Rules in Rome

Forums

BCA KCU GAJAH MADA No.Telpon 087781685647

Merge Replication failing with Error converting data type nvarchar to numeric

Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit

Question of the Day

Distance Metric Algorithms