New & Notable
Microsoft SQL Server 2008 R2 News
November 11, 2010
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
The company has put the kibosh on unlimited virtualization rights with SQL Server 2008 R2 Enterprise Edition.
Microsoft SQL Server 2008 R2 Get Started
Bring yourself up to speed with our introductory content
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
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
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
Evaluate Microsoft SQL Server 2008 R2 Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
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
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
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
Manage Microsoft SQL Server 2008 R2
Learn to apply best practices and optimize your operations.
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
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
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
Problem Solve Microsoft SQL Server 2008 R2 Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
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
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
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