Go Green Without Sacrificing Server Performance

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


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!


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.

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.

BlogsGo to the Blogs Index Page

SQL Server BI

The Importance of Planning in BI

Business Intelligence projects are prone to the same bad, ad-hoc implementation practices as found in software development. Take the time to plan accordingly.

Comment on the blogRead this blog

Industry Bytes

Prevent Privileged Users from Accessing Sensitive Data

Data security is once again in the spotlight in the SQL Server community because of the recent SQL injection attacks and data thefts. See what Guardium's products can offer you in the way of database activity monitoring.

Comment on the blogRead this blog

Industry Bytes

Microsoft Announces SQL Server 2008 RTM

Microsoft announced today that SQL Server 2008 has been released to manufacturing. The RTM of SQL Server 2008 comes almost six months after the launch of the product on February 27, along with Visual Studio 2008 and Windows Server 2008.

Comment on the blogRead this blog

In a Nutshell

Which Version of SQL Server Am I Running?

Ever wonder what versions 8.00.2039 is? Kevin points you to resources that tell you what version any given number means.

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

How would you rate your SQL Server expertise?

  • Novice
  • Novice to intermediate
  • Intermediate to advanced
  • Expert

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