Microsoft SQL Server 2008 R2

Microsoft SQL Server 2008 R2 News

November 11, 2010 11 Nov'10
Microsoft gives tour of new release of SQL Server

Microsoft gave PASS Summit 2010 attendees a walk-through of its Denali SQL Server release, demoing its AlwaysOn, FileTable and expanded SQL Server Integration Services features.
May 05, 2010 05 May'10
Microsoft changes virtualization licensing for SQL Server 2008 R2

The company has put the kibosh on unlimited virtualization rights with SQL Server 2008 R2 Enterprise Edition.

Bring yourself up to speed with our introductory content

Microsoft SQL Server

Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments Continue Reading
Quick start tips for using the new MSSQL-CLI SQL query tool

The new MSSQL-CLI command-line tool provides many enhancements over SQLCMD CLI that enable you to quickly write and run T-SQL queries across Linux, macOS and Windows. Continue Reading
Seven reasons to upgrade to SQL Server 2012

Support for early versions of SQL Server has ended. But rather than upgrade to SQL Server 2014, companies are turning to SQL Server 2012. Here is why. Continue Reading

Weigh the pros and cons of technologies, products and projects you are considering.

SQL Server 2012 features: Weighing the benefits, limitations

This guide explores the popular new features of SQL Server 2012 and offers tips for deciding if it's right for your organization. Continue Reading
Pros and cons of SQL Server 2012

Performance and support top the lists of pros for going to SQL Server 2012. But application compatibility and “the unknown” might keep you away for now. Continue Reading
Pros and cons of the DACPAC with SQL Server 2008 R2

Data-tier applications are among SQL Server 2008 R2’s most talked-about new features, though version-one limitations could minimize their impact in the short term. Continue Reading

Learn to apply best practices and optimize your operations.

4 strategies to beat the SQL Server 2008 support cutoff

The looming end of SQL Server 2008 extended support should spur database teams into action. Consider these four options to extend security updates or migrate your aging SQL Server systems. Continue Reading
Putting the data to work: How to create a chart in PowerPivot

Importing Microsoft SQL Server data into PowerPivot is the first step; now you’re ready to do some reporting. Get instructions on how to populate and refine charts in PowerPivot. Continue Reading
Evaluating the ROI of a SQL Server 2008 R2 upgrade

Cool new features may not impress management, but return on investment always will. Speak an executive’s language when making the hard pitch for a SQL Server 2008 R2 upgrade. Continue Reading

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

Speed up execution times in Microsoft SQL Azure

Compare the time cost of database calls to SQL Azure versus calls to a local server and get recommendations for improving the speed of database calls to SQL Azure. Continue Reading
Microsoft SQL Server 2012 pricing, licensing packed with changes

SQL Server 2012 pricing includes some significant adjustments, including a reduction in the number of editions and the change from processor- to core-based licensing. Continue Reading
Parallel Data Warehouse has speed, space, special requirements

Microsoft Parallel Data Warehouse is not like other software. The appliance for SQL Server 2008 R2 allows for mammoth workloads; it also has some specific data loading procedures. Continue Reading