The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Overwhelmed by all the properties for controlling elements of your reports? Delve into lesser-known properties of BIDS to refresh and paginate onscreen reports, produce multicolumn reports, and design reports for online viewing, with little effort.
By Michelle A. Poolet
By
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 Kevin Kline
Use the four main interfaces provided by this free tool to see how SQL Server stores data.
By Lavon Peters
SSDs have been used in the military and aerospace industries for years—but are they suitable for your enterprise?
By John Green
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 Tom Carpenter
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 Michael Otey
Use this HP product as a virtualization server? No, but as a Web server the 1U 64-bit HP ProLiant 160 is perfect.
By Bill McEvoy
Thanks to the GROUP BY clause, you can write SELECT queries that produce detailed reports.
By Jeff James
Jeff James discusses the recent acquisition of MySQL AB by Sun Micrososystems.
By Pinalkumar Dave
Discover the difference between Windows Authentication Mode and Mixed Mode, and learn the names and uses of installed system databases.
Check out new and improved SQL Server–related products from Fujitsu, NetPro, Confio, and Secerno.
Find out how to map control numbers to a fact table and associate them with each line item.
By Tyler Chessman
CLR UDTs aren't intended to turn SQL Server into a full-blown object-oriented database. Learn about the proper place of CLR UDTs and methods for overcoming common objections to using them.
By Itzik Ben-Gan
Hone both your logic and programming skills by using T-SQL to solve this logic puzzle.
Get the solution to May’s puzzle “A Cat, a String, and the Earth,” and prepare your mind for June’s puzzle.
By Andrew Kelly
Obtain performance metrics by using SQL Server 2005’s built-in sys.dm_exec_plan_attributes DMV.
By Stacia Misner
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.
Take a look at which features our readers believe should be in the next version of SQL Server.
See how the VarBinaryComp UDT takes advantage of new support for large types to store,compress, and decompress up to 2GB of binary data.
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.
advertisement