Announcing the Winners of Our 2009 Editors' Best and Community Choice Awards!
SQL Server Magazine's 2009 Editors' Best and Community Choice awards recognize the products in your industry that our editors, contributors, and readers believe are worthy of the highest recognition. The Editor's Best awards highlight those products that have most impressed our staff over the past year, and the Community Choice awards brought you fully into the process this year: For the first time, we completely opened up the nomination and voting processes to the guys and gals in the trenches. So dive in to our results, check out all our winners, and let us know what you think!
Is SQL Server 2008 R2 For You?
Some things to consider in making a decision to upgrade to SQL Server 2008 R2
Calculating Concurrent Sessions, Part 2
Itzik presents a set-based solution with linear complexity that performs better than the previous solutions. He also discusses a set-based solution that will outperform all other solutions once SQL Server supports it.
The Inevitable Virtualization of SQL Server
Improvements in performance and scalability in ESX Server and Hyper-V are making SQL Server a viable candidate for virtualization.
Calculating Concurrent Sessions, Part 1
Itzik discusses a set-based and a cursor-based solution to a T-SQL concurrent sessions querying problem, as well as the performance and scaling ramifications of both solutions.
Getting Started with BI
Despite the fact that SQL Server’s BI capabilities have been around for more than 10 years many SQL Pros don't use them. So what’s so hard about BI? I think you can sum it up with the three Ts: terminology, technology, and tools.
Date and Time Support in SQL Server 2008
Four new date- and time-related data types in SQL Server 2008 address the limitations of previous versions’ DATETIME and SMALLDATETIME data types.
7 Facts About SQL Azure
Get the basics on SQL Azure, formerly SQL Data Services, Microsoft’s SQL Server-based database cloud offering.
T-SQL Classic Date Functions
These 7 essential T-SQL functions work with SQL Server’s classic datetime data type and can help you in myriad ways.
SQL Server 2008 R2: 5 Cool New Features
Support for 256 logical processors, a new Master Data Services feature, and BI-oriented Project Gemini are some of the SQL Server 2008 R2 features in our top five list.
Minimally Logged Inserts
Learn which insert methods can benefit from minimal logging, to improve your statements' performance.
BlogsGo to the Blogs Index Page
SQL Server BI
Microsoft PowerPivot Resources
Derek shares a wealth of valuable Microsoft PowerPivot resources to help kick-start your evaluations of the upcoming self-service BI platform.
Comment on the blogRead this blogIndustry Bytes
PowerPivot for Excel Download Now Available
Check out PowerPivot for Excel and PowerPivot for SharePoint today.
Comment on the blogRead this blogIndustry Bytes
Quest Software Introduces Foglight for SQL Server at PASS
Foglight for SQL Server and the most recent version of Spotlight for SQL Server help you quickly find and fix performance problems with enhanced business intelligence and remote monitoring capabilities.
Comment on the blogRead this blogIn a Nutshell
More Good Tools to Check Out
Kevin points you to an update on Ola Hallengren's popular scripts, plus some new tools.
Comment on the blogRead this blogSubscribeLearn More Here
![]() |
December 2009Best Products of 2009 Subscribe Renew Current Issue Archive Monthly Online Pass & Digital issue Master CD |
WhitepapersGo to the Whitepapers Index Page
Download Microsoft SQL Server whitepapers from top vendors and research firms. .
SQL Job Openings
Instant Poll
Are you using any type of database change management system in your organization?
DownloadsGo to the Downloads Index Page
13 Things You Need to Know About SQL Server 2005
Learn what's in SQL Server 2005 and what's out.The Argent Guardian easily beats out MOM in all our tests
OS: Microsoft Windows 200x and UNIX Company: Argent ®
More Downloads Here




