It used to be that finding and using a sample SQL database was quite simple. In fact, the venerable Pubs database used to be installed as part of the SQL Server installation process. Fast forward to ...

SQL Server Management Studio can help take the guesswork out of creating connection strings for PowerShell applications.

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 ...

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.

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.

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 ...