SQL Server Magazine September 2006
[Focus]
Reporting Services gives you an inexpensive way to deliver Analysis Services data to business users. Here’s how you can provide greater flexibility in your reports so users can easily change the ways they view BI data.
By Craig Utley
[Features]
Use the new VARBINARY(MAX) data type with T-SQL or ADO.NET 2.0 to easily import BLOB data into and retrieve it from a SQL Server 2005 database.
By Michael Otey
Here's how to build a lottery prediction Analysis Services project and become disgustingly wealthy. In the process, you'll get a powerful BI education.
By Rodney Landrum
[Editorial]
SQL Server 2005 clearly delineates the features of the different editions. Customers need to choose wisely for their needs.
By Michael Otey
[Reader to Reader]
By combining the schema views of sys.tables and sys.dm_db_index_usage_stats in SQL Server 2005, you can find out which tables users access the most.
By Readers
The ScrapeText function accepts an HTML string as input and returns a plain text string by simply skipping over any text contained within the tags < and > tags.
By Bill McEvoy
[Inside SQL Server]
SQL Server lets you store large amounts of data by using LOB columns or by using the MAX specifier to define a variable-length column.
By Kalen Delaney
[Solutions by Design]
Naming conventions, regulatory compliance, primary keys are some of the topics in this month's Solutions by Design column. Read about these data modeling concepts and join the discussions at SQL Server Magazine's Database Design forum.
By Michelle A. Poolet
[T-SQL Black Belt]
Explore cursor and set-based solutions to this classic T-SQL programming problem and pick up some query optimizer tips along the way.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server–related products.
By Blake Eno
[SELECT TOP(X)]
Converting Oracle databases to SQL Server has always been a manual process fraught with pitfalls—but not anymore, thanks to SQL Server Migration Assistant. Here are four features of this tool that will pave the way to a successful conversion.
By Michael Otey
[Ask Microsoft]
Microsoft’s Patrick Conlan explains a design philosophy in SQL Server 2005.
By Microsoft's SQL Server Development Team
Microsoft’s Richard Waymire helps a reader locate an instance of SQL Server 2005 Express.
By Microsoft's SQL Server Development Team
Microsoft’s Richard Waymire gives a method for moving server registration information between client machines.
By Microsoft's SQL Server Development Team
[Vendor Briefs]
Our editors share insights from their conversations with ProClarity, Red Gate Software, Panorama Software, and Guardium.
By Editors
[Review]
Check out the MiraLink 400, a remote data-mirroring appliance that looks like a SCSI drive to the server.
By John Green
[Buyer's Guide]
Is a NAS device the answer to your SQL Server storage needs? We help you decide.
By David Chernicoff
|
