Email Alerts
-
Master data services: A work in progress
This issue’s cover story explains what the SQL Server 2008 R2’s Master Data Services (MDS) feature can—and cannot— do. Also learn how to get the full value out of the SQL Server 2008 BI stack, and how to boost SQL Server performance with data collect... E-Zine
-
Selling a SQL Server 2008 R2 upgrade
When proposing an upgrade to SQL Server 2008 R2 to management, you need to focus more on ROI than its cool, new features. In the second volume of the SQL Server Insider e-zine, you’ll learn how to draft a presentation that will wow the higher ups and... E-Zine
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
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. Feature
-
Q&A;: Scaling out with Parallel Data Warehouse for SQL Server 2008 R2
With the official release of R2’s Parallel Data Warehouse edition coming soon, Microsoft’s Mark Kromer breaks down the management and architecture considerations to be aware of. SQL in Five
-
Quiz: BI in SQL Server 2008 R2
Are you a SQL Server 2008 R2 guru? Take the quiz to test your know-how on R2's new and improved BI capabilities. Quiz
-
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. IT Decisions
-
Frequently Asked Questions: SQL Server 2008 R2
Not sure what to make of R2? Here you’ll find answers to some of the most common questions involving the latest database server release from Microsoft. FAQ
-
Is self-service business intelligence the answer?
While Microsoft’s PowerPivot technology promises to empower users to make decisions based on their own analyses, self-service business intelligence has a dark side as well. Feature
-
Ten key changes with SQL Server 2008 R2
A lot's different in Microsoft's upcoming SQL Server release. Check out our list of the 10 most significant changes. Slideshow
-
SQL Server 2008 R2 key changes: Data-tier applications (DAC)
See why data-tier applications, a facet of Microsoft's new multi-server management features, made our list of the top changes for SQL Server 2008 R2. Slideshow
-
SQL Server 2008 R2 key changes: StreamInsight
Learn why the new StreamInsight component is on our list of top 10 changes in SQL Server 2008 R2. Slideshow
- See More: Essential Knowledge on Microsoft SQL Server 2008 R2
-
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. Q&A; | 06 Jun 2012
-
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. News | 18 Apr 2012
-
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. News | 11 Apr 2012
-
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. News | 14 Mar 2012
-
Microsoft StreamInsight charts course in unfamiliar waters
Microsoft StreamInsight, a complex event processing product, is a stab at a whole new space for the company, and not a bad one at that, experts say. News | 20 Oct 2011
-
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. News | 11 Nov 2010
-
SQL Server 2008 R2 Express ready for install
Microsoft has upped the maximum database size for SQL Server 2008 R2 Express in what amounts to a major upgrade over previous versions. News | 15 Sep 2010
-
Self-service BI tools could empower midmarket users
Midmarket organizations may look to SQL Server 2008 R2 and Microsoft PowerPivot for upcoming BI investments. IT DECISIONS | 17 Jun 2010
-
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. News | 05 May 2010
-
Microsoft, beta testers tout SQL Server 2008 R2 PowerPivot
The company’s new database release aims to free up information for non-DBAs while also enforcing compliance. News | 21 Apr 2010
- See More: News on Microsoft SQL Server 2008 R2
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
SQL Server 2008 R2 SP1 not earth-shaking, but useful
SQL Server 2008 R2 Service Pack 1 has a number of new features, including a query hint, new system objects and support for up to 15,000 partitions. Tip
-
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. Tip
-
Putting SQL Server catalog views to work
SQL Server catalog views are system views that provide an interface to a wide range of catalog metadata, including information about security objects, full-text search, database mirroring, partitions and more. Read on for an in-depth look at several ... Tip
-
Top seven things you don’t know about SQL Server 2008 R2
By now, everyone knows about PowerPivot and MDS. But while high-profile features like those have gotten most of the press, other changes to R2 have fallen under the radar. Tip
-
Sysprep utility speeds up SQL Server 2008 R2 deployments
A Windows staple for years, the Sysprep tool has finally made its way over to the SQL Server world with the release of R2. Tip
-
Reporting Services 2008 R2 eases SQL Server report building
It’s true, Microsoft has put out a number of new BI technologies for SQL Server 2008 R2, but changes to existing tools like Reporting Services may hold the most value initially. Tip
- See More: Tips on Microsoft SQL Server 2008 R2
-
application server
An application server is a server program in a computer in a distributed network that provides the business logic for an application program. Definition
-
Customers react to Microsoft SQL Server preview
Microsoft previewed some of the features of its next SQL Server release, code-named Denali, at the PASS Summit 2010. SearchSQLServer.com got reaction from attendees. Video
-
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. Q&A;
-
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. Tip
-
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. News
-
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. News
-
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. Tip
-
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. News
-
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. Tip
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
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. Tip
-
Microsoft StreamInsight charts course in unfamiliar waters
Microsoft StreamInsight, a complex event processing product, is a stab at a whole new space for the company, and not a bad one at that, experts say. News
- See More: All on Microsoft SQL Server 2008 R2
About Microsoft SQL Server 2008 R2
Two-years after releasing SQL Server 2008, Microsoft is following up with an R2 version of the database management system (DBMS). Available in early 2010, SQL Server 2008 R2 (Kilimanjaro) offers a variety of benefits, enhancements and new tools to simplify SQL Server management, administration and development. In addition to improved scalability and new consolidation tools, the SQL Server 2008 R2 upgrade also allows for better management of multiple instances and databases; includes changes to SQL Server Reporting Services (SSRS); and features the new business intelligence (BI) tool, Master Data Services, as well as the add-on, SQL Server PowerPivot (Project Gemini). These SQL Server 2008 R2 articles, tips and tutorials will advise you on the upgrade, migration and installation of Microsoft's SQL Server 2008 R2 database management system.