SQL Server Magazine June 2008
[Focus]
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.
By Stacia Misner
[Features]
Back up your SQL Server databases regularly to prevent lost data in the event of a disaster.
By Michelle A. Poolet
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.
By Tom Carpenter
Discover the difference between Windows Authentication Mode and Mixed Mode, and learn the names and uses of installed system databases.
By Pinalkumar Dave
Thanks to the GROUP BY clause, you can write SELECT queries that produce detailed reports.
By Bill McEvoy
See how the VarBinaryComp UDT takes advantage of new support for large types to store,compress, and decompress up to 2GB of binary data.
By Tyler Chessman
[Editorial]
Take a look at which features our readers believe should be in the next version of SQL Server.
By Michael Otey
[Reader to Reader]
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.
By Readers
[Solutions by Design]
Find out how to map control numbers to a fact table and associate them with each line item.
By Michelle A. Poolet
[T-SQL Black Belt]
Hone both your logic and programming skills by using T-SQL to solve this logic puzzle.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server–related products from Fujitsu, NetPro, Confio, and Secerno.
By Jeff James
[SELECT TOP(X)]
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.
By Michael Otey
[Tool Time with Kevin Kline]
Use the four main interfaces provided by this free tool to see how SQL Server stores data.
By Kevin Kline
[Review]
Use this HP product as a virtualization server? No, but as a Web server the 1U 64-bit HP ProLiant 160 is perfect.
By Michael Otey
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.
By John Green
[Market Watch]
SSDs have been used in the military and aerospace industries for years—but are they suitable for your enterprise?
By Lavon Peters
[PTO for the Rest of Us]
Obtain performance metrics by using SQL Server 2005’s built-in sys.dm_exec_plan_attributes DMV.
By Andrew Kelly
[Industry Bytes]
Jeff James discusses the recent acquisition of MySQL AB by Sun Micrososystems.
By Jeff James
|
