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

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

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

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...