Microsoft Hosting Solutions Built to Your Needs

Sponsored Link
Rackspace is the expert when it comes to delivering hosting solutions. From building out Windows servers and highly complex configurations to managing and supporting network environments, mail solutions, storage, data backups and far more. We are here for you 24x7x365.


Network with Your SharePoint Peers – In-Person Trainings

Attend four sessions that directly support your department’s goals and priorities - and check out what’s on the horizon for SharePoint.


Query Temporal Data

Learn how to handle temporal data in SQL Server queries despite limited support.

SQL Server 2008: Which Edition’s Right for You? This article is only available to registered users.  Sign up now and get instant access!

How can you help your organization choose the edition of SQL Server 2008 it needs? Michael Otey takes a quick tour through the options that are available.

SQL Server Backup Best Practices

Reduce the stress of performing a system restore—follow these SQL Server best practices.

Demystifying SQL Server Virtualization This article is only available to registered users.  Sign up now and get instant access!

Michael Otey dispels some myths surrounding SQL Server virtualization, including the notion that all virtualization platforms are created equal. He explains the high-level differences between the hosted, hypervisor, and virtualized OS platforms.

Discover the Benefits of Filtered Indexes and Statistics

Learn how you can take advantage of SQL Server 2008’s filtered indexes and statistics feature to improve query performance and obtain detailed and accurate distribution statistics.

T-SQL Enhancements in SQL Server 2008, Part 2 This article is only available to registered users.  Sign up now and get instant access!

SQL Server 2008 powers up T-SQL with new features such as the GROUPING SETS operator and table-valued parameters.

Migrating to SQL Server 2008 This article is only available to registered users.  Sign up now and get instant access!

Now that Microsoft supports direct migration from SQL Server 2000 to SQL Server 2008, you must decide: Should I migrate from SQL Server 2000 to SQL Server 2005, or should I migrate directly to SQL Server 2008?

SQL Server 2008’s HierarchyID, Part 2

Use the new HIERARCHYID data type to move a subtree from one parent location in the hierarchy to another, and to convert a parent-child representation of the hierarchy to a representation that uses the HIERARCHYID data type.

T-SQL Enhancements in SQL Server 2008 This article is only available to registered users.  Sign up now and get instant access!

Tour SQL Server 2008’s extended T-SQL feature set and learn how the new statements DECLARE, MERGE, and INSERT can make a DBA’s job easier.

HierarchyID

Use SQL Server 2008’s new data type to maintain and query hierarchical data.

BlogsGo to the Blogs Index Page

In a Nutshell

Looking for a laugh? Don't miss this website!

Kevin points you to a funny and fun website that'll give any IT Pro a good laugh.

Comment on the blogRead this blog

SQL Server BI

The Meaning of the Microsoft MVP Award

Having recently been awarded my first Microsoft MVP award I quickly realized the award's true representation.

Comment on the blogRead this blog

In a Nutshell

SSIS Packages Need Love Too, er, Memory Too!

Kevin shares some tips on how to predetermine and then track memory usage by SSIS packages.

Comment on the blogRead this blog

Industry Bytes

Microsoft Announces Awards for BI Customers

Microsoft gave out BI awards to customers in four categories at the Business Intelligence Conference.

Comment on the blogRead this blog

SubscribeLearn More Here

SQL Server MagazineSubscribe to SQL Server Magazine

WhitepapersGo to the Whitepapers Index Page

Download Microsoft SQL Server whitepapers from top vendors and research firms. .

SQL Job Openings



Instant Poll

Are you virtualizing SQL Server?

  • Yes, with Microsoft's Hyper-V
  • Yes, with VMware's ESX Server
  • No, but we might in the future
  • No way, you can't virtualize SQL Server

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

Run the Group Policy Results Wizard and View the Output
Watch the video now!

featured ITTV video