---

[Focus]

---

Use Properties to Improve Report Presentation
Push the envelope on report design by using BIDS properties to refresh and paginate onscreen reports, keep data regions together on a page, and produce multicolumn reports.
 — Stacia Misner

---

[Features]

---

Backup and Restore Fundamentals
Back up your SQL Server databases regularly to prevent lost data in the event of a disaster.
 — Michelle A. Poolet


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.
 — Tom Carpenter


Sharpen Your Basic SQL Server Skills
Discover the difference between Windows Authentication Mode and Mixed Mode, and learn the names and uses of installed system databases.
 — Pinalkumar Dave


T-SQL 101, Lesson 4
Thanks to the GROUP BY clause, you can write SELECT queries that produce detailed reports.
 — Bill McEvoy


Using Large CLR UDTs in SQL Server 2008
See how the VarBinaryComp UDT takes advantage of new support for large types to store,compress, and decompress up to 2GB of binary data.
 — Tyler Chessman

---

[Editorial]

---

What Readers Want SQL Server to Include
Take a look at which features our readers believe should be in the next version of SQL Server.
 — Michael Otey

---

[Reader to Reader]

---

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

---

[Solutions by Design]

---

Data Warehousing: Degenerate Dimensions
Find out how to map control numbers to a fact table and associate them with each line item.
 — Michelle A. Poolet

---

[T-SQL Black Belt]

---

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.
 — Itzik Ben-Gan

---

[New Products]

---

New Products
Check out new and improved SQL Server–related products from Fujitsu, NetPro, Confio, and Secerno.
 — Jeff James

---

[SELECT TOP(X)]

---

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.
 — Michael Otey

---

[Tool Time with Kevin Kline]

---

SQL Server Internals Viewer
Use the four main interfaces provided by this free tool to see how SQL Server stores data.
 — Kevin Kline

---

[Review]

---

HP ProLiant DL 160
Use this HP product as a virtualization server? No, but as a Web server the 1U 64-bit HP ProLiant 160 is perfect.
 — Michael Otey

SteelEye LifeKeeper Protection Suite for SQL Server
Need high availability and clustering for SQL Server? If you don't mind the lack of granular data rewind capabilities, check out SteelEye's suite.
 — John Green

---

[Market Watch]

---

Solid State Storage For SQL Server
SSDs have been used in the military and aerospace industries for years—but are they suitable for your enterprise?
 — Lavon Peters

---

[PTO for the Rest of Us]

---

Who's Hogging My Server?
Obtain performance metrics by using SQL Server 2005’s built-in sys.dm_exec_plan_attributes DMV.
 — Andrew Kelly

---

[Industry Bytes]

---

Sun Acquires MySQL AB: Now What?
Jeff James discusses the recent acquisition of MySQL AB by Sun Micrososystems.
 — Jeff James