SQL Server Magazine September 2003
[Focus]
Any event that causes data loss or system downtime can be a disaster for your company. But with careful planning, you can minimize a disaster’s effects. Help your system survive by using these disaster-prevention best practices.
By Kalen Delaney
When disaster strikes only a subset of data, take the easiest route to recovery. Why undertake a full database restoration if faster recovery options are available?
By Kimberly L. Tripp
[SQL Server Savvy]
Do you regularly get an annoying error message from Enterprise Manager when you try to view database information through the Task Pad view?
By Brian Moran
Would you like to know how to hide Data Transformation Services (DTS) packages from a certain set of Enterprise Manager users?
By Brian Moran
How to write an OSQL script that passes your desired variables.
By Brian Moran
Learn how to prevent certain users from creating new Data Transformation Services (DTS) packages on your server.
By Brian Moran
Learn how to verify that your client machine has a TCP/IP sockets Net-Library connection to the database.
By Brian Moran
[Editorial]
SQL Server, far more than any other enterprise-level database, is installed and run under less-than-optimal conditions. Building truly reliable systems requires good planning and adherence to best practices.
By Michael Otey
[SQL Seven]
These connection-string examples illustrate the seven most common connection scenarios.
By Michael Otey
[Inside SQL Server]
Some additions to the sysprocesses table and a new function in Service Pack 3 make SQL Server troubleshooting even easier.
By Kalen Delaney
[Mastering Analysis]
OLAP cubes are notorious for having lots of empty (or null) cells. Including these empty cells in your result sets can bog down your analysis applications. But you can use these tricks to eliminate empties.
By Russ Whitney
[Solutions by Design]
Typically, DBAs use database partitioning to improve performance or enforce security on large databases. However, in this case study, a company used partitioning to improve performance on its small database with great success.
By Michelle A. Poolet
[T-SQL Black Belt]
Resourceful readers share their set-based solutions to August’s relational-division puzzle—and get great results!
By Itzik Ben-Gan
[Exploring XML]
ADO.NET's DataSet gives you the performance benefits of client-side technology for storing and accessing large amounts of XML data in SQL Server.
By Rich Rollman
[Letters]
Readers write in about how Reporting Services will bring integrated OLAP and transactional reporting functionality within the reach of any business and about using Analysis Services actions to link external information to a cube.
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Carolyn Mader
|
