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 blog

Industry Bytes

PowerPivot for Excel Download Now Available

Check out PowerPivot for Excel and PowerPivot for SharePoint today.

Comment on the blogRead this blog

Industry 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 blog

In 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 blog

SubscribeLearn More Here

SQL Server MagazineSubscribe to SQL Server Magazine

SQL Job Openings



Instant Poll

Are you using any type of database change management system in your organization?

  • Yes, we've had one in place for more than a year.
  • Yes, we've implemented one within the last year.
  • No, but we plan to implement one in 2010.
  • No, but we'd like to implement one within the next two years.
  • No, we have no need for one.

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

Featured ITTV Video

Using Windows SideShow On A Mobile Device
Watch the video now!
ITTV Featured Video


 

ADS BY GOOGLE