SQL Server Magazine

Upgrading to Hyper-V RTM

Generate a Clickthrough Report using Visual Studio ReportViewer

See how you can set up a clickthrough report without using SQL Server Reporting Services (SSRS).

HierarchyID

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

HierarchyID

Nifty Ways to Use FOR XML PATH Concatenation

No temporary tables or table variables are needed to perform FOR XML PATH concatenation, so the resulting query is not only fast but also high performing.

T-SQL 101, Lesson 5

Understand the differences between inner, outer, and cross joins before you use them in your queries.

The Logical Puzzle

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

TechEd 2008: Double the Pleasure or Double the Hassle?

This week, Brian Moran talks about TechEd 2008, and what SQL Server-focused attendees thought of TechEd being split into two separate weeks.

Guest VM Audio Support under Hyper-V

Guest VM Audio Support under Hyper-V

What You Might Have Missed at TechEd 2008

Take a look at some of the SQL Server-related news our editors wrote about while they were at TechEd 2008.

Adventures with Big Data: How to Import 16 Billion Rows into a Single Table

If you have a lot of data to import into or export out of a SQL Server table, here are some tips that can save you a lot of time and aggravation.

Security Logging with Service Broker

Create the message types, contracts, queues, and services for an event-logging solution, and use some simple ASP code to call a SQL Server stored procedure that places information in a security logging queue for automated processing.

SQL Server Data Services

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.

SQL Server Data Services

T-SQL 101, Lesson 4

Thanks to the GROUP BY clause, you can write SELECT queries that produce detailed reports.

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.

Hyper-V Synthetic Devices

Learn about Hyper-V's synthetic and emulated devices

Are You a Developer or an IT Pro?

This year, Microsoft has decided to split TechEd into a developer week and an IT pro week. Kalen looks at how DBAs are deciding which week to attend.