Latest Headlines

Microsoft SQL Server 2012 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing environment or for those learning about databases or SQL Server for the first time who need a platform they can install on a personal computer to create a learning environment.

Read the full story: Installing SQL Server 2012 Express Edition

Many database users begin their adventure in the world of databases by creating a Microsoft Access database that meets the basic requirements of their organizations. Often, this is a dramatic improvement from an unwieldy collection of spreadsheets, text files or other documents that the organization previously used to manage information. However, eventually the business may outgrow that Access database and need to make the move to a more advanced database product.

Read the full story: Migrating to SQL Server with the Access Upsizing Wizard

Is your Access database growing too large or unwieldy? Perhaps you need to allow more robust multiuser access to the database? Converting your Access database to Microsoft SQL Server might be the solution you’re trying to find. Fortunately, Microsoft provides an Upsizing Wizard in Access that makes it easy to convert your database. In this tutorial, we walk through the process of converting your database.

Read the full tutorial: Converting a Database from Access to SQL Server

Is your Access database growing too large or unwieldy? Perhaps you need to allow more robust multiuser access to the database? Converting your Access database to Microsoft SQL Server might be the solution you’re trying to find. Fortunately, Microsoft provides an Upsizing Wizard in Access that makes it easy to convert your database. In this tutorial, we walk through the process of converting your database.

Read the full tutorial: Converting a Database from Access to SQL Server

Foreign key constraints allow you to create relationships between data elements stored in multiple database tables. In addition to facilitating cross-table database queries (called JOINs), these relationships also ensure that the referential integrity of the database is preserved when information is added, removed or modified.

Read the full story: Foreign Keys in SQL Server

Looking for more information on the license structure or features of SQL Server 2012? Check out these two stories:

Read more:

• SQL Server 2012 Editions, Licensing and Pricing
• Top Five New Features in SQL Server 2012

SQL Profiler is a diagnostic tool included with Microsoft SQL Server 2012. It allows you to create SQL traces that track the specific actions performed against a SQL Server databases. SQL traces provide valuable information for troubleshooting database issues and tuning database engine performance. For example, administrators might use a trace to identify a bottleneck in a query and develop optimizations that might improve database performance.

Read the full article: Creating Database Traces with SQL Server 2012