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!

Getting the Most from BI in a Tough Economy

July 23, 2009: eLearning series with Derek Comingore and Barry Ralston. Keep Your Company on Top of the Game!

Why Not Consider Consolidating SQL Server Data Warehouses?

Typically consolidation of SQL focuses on application-based databases that support OLTP workloads. Think about taking a new approach – consolidating data warehouses. Read this white paper today!



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

In a Nutshell

In a Nutshell

Puzzled by T-SQL

Logic Puzzle – Dice Substitute

Itzik provides a logic puzzle involving finding a substitute for dice.

10 CommentsRead this blog

SQL Server BI

Getting the most from BI in a Tough Economy

Join me on July 23rd and learn how to quickly deliver actionable information to your company's leaders.

Comment on the blogRead this blog

SubscribeLearn More Here

SQL Server MagazineSubscribe to SQL Server Magazine

SQL Job Openings



Instant Poll

Are you planning to upgrade to SQL Server 2008 R2?

  • Yes, I'm excited about the new BI features
  • Yes, I'm ready to upgrade from SQL Server 2005
  • Yes, I'm ready to upgrade from SQL Server 2000
  • No, I'm not interested in the new BI features
  • No, I'm not planning to upgrade from SQL Server 2005 any time soon
  • No, I'm not planning to upgrade from SQL Server 2000 any time soon
  • No, but I plan to upgrade to SQL Server 2008 in the future.
  • What's the difference between SQL Server 2008 R2 and SQL Server 2008?

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