Best of Tech Ed 2009 Winners Announced!

Editors from Windows IT Pro and SQL Server Magazine announced the winners of the Best of Tech Ed 2009 Awards at Tech Ed 2009 in Los Angeles earlier this week. Click the link above to see the list of winners and a finalist video compilation. Congratulations to all the winners and finalists!

SQL Server Unleashed, free virtual event

Unleash SQL Server's Full Potential to Maximize ROI. Join us on September 15, 2009. Sessions will be led by SQL Server expert, consultant, and author Michael K. Campbell.

Register for SQL Connections and receive SQL Server 2008 Standard Edition with 1 CAL

Join us November 9-12, 2009, as SQL Server Connections returns to the Mandalay Bay Casino and Resort in Las Vegas, NV. Early bird rate until August 15th - save $100!



8 SQL Server 2008 Downloads

From SQL Server 2008 SP1 to SQL Server Express to SQL Server 2008 Upgrade Advisor, our 8 favorite downloads should find a place in your SQL Server toolbox.

The New Oracle Threat

Oracle recently announced a surprising acquisition of Sun Microsystems. Unlike the aborted IBM-Sun merger, this one makes a lot of sense. Oracle is a technology leader, and Sun will strengthen Oracle in a number of fundamental ways.

Best of TechEd 2009 Award Winners

The Best of TechEd Awards recognize the most innovative products and services offered by Microsoft partners that exhibited at TechEd 2009, held in June 2009 at the Los Angeles Convention center. Here are our winners!

CLR-Based Solution for Running Aggregates

If performance is your main goal, you should use the set-based solution only with very small partition sizes; otherwise, you should use the CLR-based solution.

Quality Coding vs. Quick Coding

Set-Based vs. Cursor-Based Solutions for Running Aggregates

Although set-based solutions to running aggregations have many advantages over cursor-based solutions, cursor-based solutions can provide better performance in certain cases, such as when dealing with very large partitions.

Using SQL Server 2008's FILESTREAM Data Type

The FILESTREAM data type in SQL Server 2008 is a valuable way to access data--here's a quick primer.

Get Ready for SQL Server 2008 SP1

In the Community Technology Preview (CTP) for SQL Server 2008 SP1 you’ll find a couple of important changes in the way that service packs are applied and used as well as some important new functionality for SQL Server 2008.

SQL Server Management Studio Keyboard Shortcuts

Put these SSMS keyboard shortcuts by your computer and quickly connect to, navigate through, and manage in SSMS.

Data Access Options in VS 2008 and the .NET Framework 3.5

New data-access options in VS 2008 and the .Net Framework 3.5 SP1 include LINQ to DataSet, ADO.Net Data Services, and SQL Server Data Services.

BlogsGo to the Blogs Index Page

Industry Bytes

NovaView 6.0 Can Connect to Any Data Source

Panorama Software's NovaView 6.0 includes a new Flash Analytics client, Relational Data Connector, and NovaView SharedViews.

Comment on the blogRead this blog

Industry Bytes

Backup Solution Aims to Help DBAs Turned Accidental SharePoint Admins

A SharePoint backup and recovery solution that might leave you more time for your other duties, like being a DBA.

Comment on the blogRead this blog

Puzzled by T-SQL

Solutions to Logic Puzzle - Dice Substitute

Itzik covers solutions to last week’s logic puzzle – Dice Substitute.

1 CommentRead this blog

In a Nutshell

SubscribeLearn More Here

SQL Server MagazineSubscribe to SQL Server Magazine

SQL Job Openings



Instant Poll

Are you ready to move SQL Server to the cloud?

  • Yes, I've already moved SQL Server to the cloud.
  • Yes, I plan to move SQL Server to the cloud in the next six months.
  • Yes, I plan to move SQL Server to the cloud in the next year.
  • No, I'm not interested in moving SQL Server to the cloud.
  • No, I don't think the cloud is secure enough yet.
  • SQL Server can be moved to the cloud?
  • I'm waiting to see what the upcoming Microsoft releases offer.

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

Hyper-V Networking
by John Savill
Watch the video now!
ITTV Featured Video


 

ADS BY GOOGLE