Smart and Cost-Effective Hosting Solution

Rackspace hosted severs are designed to be as business friendly as they are earth friendly. Do your part for the environment without the sacrifice. We make is easy for our customers to choose a green configuration or customize one that works for your business needs.


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.

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

SQL Server Data Services is the database version of Microsoft’s Software Plus Services strategy--and it could prove helpful for data storage and access. Here are five things to know about SQL Server Data Services.

The Logical Puzzle

Get the solution to May’s puzzle “A Cat, a String, and the Earth,” and prepare your mind for June’s puzzle.

Use T-SQL to Solve the Classic Eight Queens Puzzle

Hone both your logic and programming skills by using T-SQL to solve this logic puzzle.

What Readers Want SQL Server to Include This article is only available to registered users.  Sign up now and get instant access!

Take a look at which features our readers believe should be in the next version of SQL Server.

SQL Server 2000 Code for Temporal Histograms This article is only available to registered users.  Sign up now and get instant access!

If you're running SQL Server 2000, use the code linked to this document in place of Listing 3 and Listing 4 in "Temporal Histograms," May 2008, InstantDoc ID 98360.

SQL Server 2005 Client Network Libraries This article is only available to registered users.  Sign up now and get instant access!

Client network libraries are vital in SQL Server, enabling the communications link between client applications and the SQL Server system. This list will help you get acquainted with SQL Server 2005’s client network libraries.

BlogsGo to the Blogs Index Page

Industry Bytes

Finding and Optimizing Poor-Performing SQL Code

Embarcadero's DB Optimizer helps you find and diagnose performance problems caused by SQL code.

Comment on the blogRead this blog

In a Nutshell

Blogging - Quantity versus Quality

Kevin wonders what you like better in a blogger - quantity of content or quality?

2 CommentsRead this blog

SQL Server BI

Value-Add: Data Warehousing & Analysis Services Cube Storage Estimates

Learn how to provide your valued clients with accurate storage estimates for both data warehouses as well as Analysis Services cubes.

Comment on the blogRead this blog

Industry Bytes

Embarcadero Completes Acquisition of CodeGear

Roughly two months after it announced that it would acquire CodeGear from Borland, database tools developer Embarcadero Technologies issued a news release on July 1st announcing that it has completed the acqusition.

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. .

Instant Poll

What role do you play within your organization?

  • I'm a SQL Server DBA
  • I'm a SQL Server developer
  • I'm a business intelligence analyst
  • I'm an IT pro who also manages our SQL Server instances
  • I'm a SQL Server and Oracle administrator

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