If you're considering moving your on-premises SQL Server databases to the Microsoft Azure cloud, you need to decide which of the different cloud options works best for you. You might not realize it to ...

msdb: used by SQL Agent, backups/restores, Service Broker, mail, alerts etc Details of how to move undamaged and damaged system databases (other than the master database) are given with step-by-step ...

While SQL Server 2008 was little more than a service-pack level upgrade, the 2012 version of Microsoft’s database has a boatload of new features and delivers solid performance improvements.

Here's a detailed look at the January 2012 issue of SQL Server Pro magazine (January 2013), the online subscription-based monthly magazine that has news and articles from across the SQL Server world.

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...