Microsoft SQL Server Conference & Expo

April 12-14, 2010 - Bellagio, Las vegas. Make plans to attend sessions on SQL Server 2008 R2, Analysis Services, BI, virtualization, New reporting Services, and much more! Register today to get the scoop from Microsoft on SQL Server "Madison".

VirtualizationPro 2010 Summit & Expo

March 16-19,2010 - Bellagio, Las Vegas. This conference-with a focus on Microsoft Hyper-V and VMware solutions-will feature independent industry experts as well as speakers from Microsoft and VMware. Join us to learn everything you need to deploy, configure, secure, optimize, and manage virtualization technology.

Learn How Virtualizing Your Backup Solution Is The Best Solution for Your SMB!

Explore why you need data de-duplication, how virtualization is an essential component in an SMB backup solution, and we'll also look at how to select a backup solution that is cost-effective, flexible, and scalable enough to provide the SMB IT professional with a competitive business asset.


Handling the Tree Path Request

Learn why the intuitive queries that address a common tree path request are optimized inefficiently, and discover alternative solutions with improved performance.

Iron and Cloud

Microsoft’s Dave Campbell explains how SQL Azure combines the features of traditional iron with the cloud to enable rapid provisioning and quick surges for data. Data gathered on a surge may be one day be provided by datasets in the “Dallas” program.

SQL Server 2008 R2 Editions

SQL Server 2008 R2 comes in some new flavors, from the Parallel Computing Edition on down to the three SQL Server Express editions.

The Need for Managed Self-Service BI

Can the PowerPivot for Excel 2010 feature for SQL Server 2008 R2 bring harmony to business and IT teams within the organization?

Properties of Relations on Sets

The author discusses a fundamental topic in mathematical set theory to determine the properties of a relation represented by a table called R on a set represented by a table called V.

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.

BlogsGo to the Blogs Index Page

Industry Bytes

SharePoint Teams Up at the Olympics

Share Dan's world as he helps connect NBC, its viewers, and the Winter Olympics with a suave little product called SharePoint.

Comment on the blogRead this blog

SQL Server BI

PowerPivot Alpha Geek Challenge #2

The PowerPivot Team wants to see what you're made of! Win a $250 Microsoft Store shopping spree and a chance for a free trip to 2010 Microsoft BI Conference!

Comment on the blogRead this blog

Puzzled by T-SQL

Multi-Row Variable Assignment and ORDER BY

Itzik discusses why you cannot trust techniques that perform multi-row variable assignment with an ORDER BY clause.

2 CommentsRead this blog

SQL Server BI

SQL Server PowerPivot: My Thoughts

Derek provides his thoughts on SQL Server PowerPivot and why the product is a game changer

Comment on the blogRead this blog

SubscribeLearn More Here

SQL Server MagazineSubscribe to SQL Server Magazine

SQL Job Openings



Instant Poll

How likely are you to view a product demo?

  • Very likely--I prefer to see a demo before I buy a product
  • Very likely--I like to see which products are on the market and how they work before I choose one
  • Pretty likely--If I have time, I prefer to see a demo of a product before I buy it
  • Not likely--I don't like to watch product demos
  • Not likely--I don't have time to watch product demos
  • It depends on how much time I have

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