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.


Learn How to Maximize SharePoint - In-Person Training – 8 Cities

Attend this SharePoint event to for best practices and tips regarding infrastructure, design, redundancy, site administration, and ECM. Register today to take advantage of Early Bird special pricing for only $99 – Extended Until September 15th!


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.

SQL Server Compact Edition FAQs This article is only available to registered users.  Sign up now and get instant access!

SQL Server Compact Edition 3.5 is Microsoft’s smallest full relational database—check out these FAQs to learn more.

The Logical Puzzle

Get the solution to June’s puzzle, “Josephus Problem.”

Virtualizing SQL Server with VMware or Hyper-V This article is only available to registered users.  Sign up now and get instant access!

Tests of server virtualization products VMware ESX Server 3.5 and Windows Server 2008 Hyper-V, plus SQL Server running four virtual machines (VMs) indicate that SQL Server running in a VM is ready to handle production workloads.

BlogsGo to the Blogs Index Page

In a Nutshell

Puzzled by T-SQL

T-SQL Sorting Challenge

Itzik provides a T-SQL challenge involving sorting separated lists of values.

2 CommentsRead this blog

Puzzled by T-SQL

SQL Server 2008 RTM MERGE Bug and Fix

Itzik describes a bug involving the MERGE statement in SQL Server 2008 RTM, and provides a pointer to the bug fix.

Comment on the blogRead this blog

In a Nutshell

SQL Server Memory Tracking with Windows Task Manager

Kevin describes a possible problem scenario when monitoring SQL Server memory using Windows Task Manager.

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

What type of SQL Server news do you look for on the Internet?

  • Microsoft SQL Server product news
  • Third-party SQL Server product news
  • Industry analysts' take on the SQL Server market
  • News about SQL Server executive changes at Microsoft
  • News about SQL Server's competitors

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