The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Customize your report delivery to let users flexibly change data views and get the information they need in the format they can use best.
By Michael Otey
Is it better to integrate binary large object (BLOB) data within the database or store it in the file system? Each method has its pros and cons.
By
Microsoft’s Richard Waymire gives a method for moving server registration information between client machines.
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.
Microsoft’s Richard Waymire helps a reader locate an instance of SQL Server 2005 Express.
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.
Microsoft’s Patrick Conlan explains a design philosophy in SQL Server 2005.
By Craig Utley
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 David Chernicoff
Is a NAS device the answer to your SQL Server storage needs? We help you decide.
By Blake Eno
Check out new and improved SQL Server–related products.
By Michelle A. Poolet
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 John Green
Check out the MiraLink 400, a remote data-mirroring appliance that looks like a SCSI drive to the server.
By Itzik Ben-Gan
Explore cursor and set-based solutions to this classic T-SQL programming problem and pick up some query optimizer tips along the way.
SQL Server 2005 clearly delineates the features of the different editions. Customers need to choose wisely for their needs.
By Kalen Delaney
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.
Our editors share insights from their conversations with ProClarity, Red Gate Software, Panorama Software, and Guardium.
By Rodney Landrum
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 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 Bill McEvoy
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.
advertisement