Among many new features, Microsoft's new database management system is well-suited for applications that require uptime and portability. With the recent release of SQL Server 2012, Microsoft is ...

Contained Databases - SQL Server has long struggled with portability of databases. While it has always been easy to move data and data structures, other objects, like logins, related SQL Agent jobs ...

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.

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

Relational SQL databases, which have been around since the 1980s, historically ran on mainframes or single servers—that’s all we had. If you wanted the database to handle more data and run faster, you ...

SQL Server is primarily built around a row-based table structure that connects related data elements in different tables to one another, avoiding the need to redundantly store data in multiple places ...

The latest SQL Server comes packed with support for Linux, automatic tuning and other enhancements that will enhance and simplify the use of the database platform. Today at the Microsoft Ignite ...

How effective are free and open source data bases? For answers, we reviewed 6:: Microsoft SQL Server Express, PostgreSQL, Oracle's MySQL, MariaDB, Apache Derby and Firebird SQL. Free or open source ...