Microsoft SQL Server 2008 R2

New & Notable

Download this free guide

Free Guide: DBMS Features Overview for 3 New Popular Options

IT expert Michael Otey, explores 5 trends for SQL Server environments, what to expect in SQL Server 2019 and why it might be time to update SQL Server skills. Also, compare the key features of Google Cloud Spanner and Oracle Database 19c.

Corporate E-mail Address:
You forgot to provide an Email Address.
This email address doesn’t appear to be valid.
This email address is already registered. Please login.
You have exceeded the maximum character limit.
Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Microsoft SQL Server 2008 R2 News

March 07, 2014 07 Mar'14
SQL Server 2012 SP2 due out later this year, and other SQL Server news

Following a request from some SQL Server MVPs, Microsoft has announced that SQL Server 2012 SP2 will come out sometime later this year.
June 06, 2012 06 Jun'12
Ahead of TechEd, Microsoft speaks on SQL Server 2012, Amazon RDS

Mark Kromer gives tips on what he thinks will be the best sessions at Microsoft TechEd 2012, and also comments on SQL Server in the cloud and a recent Amazon announcement.
April 18, 2012 18 Apr'12
Microsoft’s SQL Server 2012 has muscle, but database battle is fierce

One of the strongest versions Microsoft has put out in years, SQL Server 2012 first needs to accomplish a monumental task -- overcome database inertia, industry watchers say.
April 11, 2012 11 Apr'12
Big data a big deal for SQL Server 2012, users say

SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users.

Microsoft SQL Server 2008 R2 Get Started

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

Evaluate Microsoft SQL Server 2008 R2 Vendors & Products

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
SQL Server 2012 ‘virtually’ out, Microsoft talks features, licensing

With SQL Server 2012 released in a “virtual launch” this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are. Continue Reading

Manage Microsoft SQL Server 2008 R2

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
Catching up with Master Data Management products

SQL Server 2008 R2 hosts the Master Data Services feature, which can help businesses standardize sets of data. Microsoft didn’t quite let MDS gestate long enough, though, and it lacks a few crucial qualities. 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.

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
SQL Server stored procedures supercharged in recent, upcoming versions

Microsoft is forever tinkering with SQL Server stored procedures to give queries more thrust. Find out what’s new in SQL Server 2008, 2008 R2 and the next-generation 2012 release. Continue Reading