Vote NOW in the 2009 Community Choice Awards!

Windows IT Pro and SQL Server Magazine are proud to announce that the 2009 Community Choice Awards are now open for final voting. Click the link above to begin voting for your favorite IT products and services. Voters also have a chance to win a $250 gift card and other prizes!

Live Seminar: WS08R2 Improves TCO in Your Data Center

Nov. 12 - Join Mel Beckman to learn how Windows Server 2008 R2 helps with your SQL deployments on Hyper-V and find out about a “cash for clunkers” server promotion that runs through the end of 2009.

Save 25% on the SQL Server Magazine Master CD!

The SQL Server Magazine Master CD is where content meets convenience.  Get the expertise from SQL Server Magazine loaded onto a CD for speed and portability.  Also includes web access!



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.

The Microsoft Release Tsunami

Mike Otey looks at the lengthy release line-up from Microsoft in 2009 and 2010 and considers the value of moving to SQL Server 2008 R2. Is a BI-focused release for you?

Using Nested Iterations and the OVER Clause for Running Aggregates

Until SQL Server supports the OVER clause, your best solutions for running aggregates are a set-based solution using subqueries or joins, for very small partition sizes, or a CLR data reader–based solution, for large partitions.

BlogsGo to the Blogs Index Page

Industry Bytes

SQL PASS Summit 2009: New SQL Server 2008 R2 Editions Announced

Announcements from keynote: Nov CTP. New editions: SQL Server 2008 R2 Datacenter and SQL Server 2008 R2 Parallel Data Warehouse

Comment on the blogRead this blog

Puzzled by T-SQL

Virtual Auxiliary Table of Numbers

Itzik provides code to generate a virtual auxiliary table of numbers efficiently.

4 CommentsRead this blog

SQL Server BI

In a Nutshell

SQL Sets

A new data collection tool from Mike Morris

Comment on the blogRead this blog

SubscribeLearn More Here

SQL Server MagazineSubscribe to SQL Server Magazine

SQL Job Openings



Instant Poll

Are you implementing Windows 7 in your environment?

  • Yes, I've already installed it.
  • Yes, I'm planning to install it within the next three months.
  • Yes, I'm planning to purchase a Windows 7 computer.
  • No, I'm sticking with Windows Vista.
  • No, I'm sticking with Windows XP.
  • No, I use a Mac.

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