SQL Server Magazine October 2000
| |
|
Options |
Security
Microsoft introduced changes in security implemention in SQL Server 7.0. Confusion about the changes led many administrators to leave their security implementation plans unchanged or to leave holes through which unauthorized users can get to the data. In this issue, Morris Lewis demonstrates how you can build a security plan for SQL Server 7.0 or 2000 that's manageable, flexible, and verifiably secure.
|
|
• Subscribe
• Renew
• Master CD
• Change Mailing Address
• Customer Service
• Back Issues
• Article Reprints
• Group Discounts
|
|
[Focus]
Build a security plan for SQL Server 2000 or SQL Server 7.0 that is manageable, flexible, and verifiably secure.
By Morris Lewis
[Features]
In a follow-up to his June 2000 article "Relational to Dimensional," the author shows you how to extend a dimensional data mart with preaggregated dimensions and a user-friendly interface.
By Bob Pfeiff
Do you need to create partitioned views that don't meet the requirements for updates? This article, the last in a three-part series about distributed partitioned views, shows you how to create INSTEAD OF triggers to modify the views.
By Kalen Delaney , et al.
Use the DataLink utility to create an OLE DB management tool that rivals the ODBC Administrator.
By Michael Otey
[Lab Reports]
You can use SQL Compare to find differences in databases rather than scanning code line by line.
By Rodney Landrum
[SQL Server Savvy]
Learn how to implement hierarchical relationships in SQL Server, how to optimize cursor performance, how and when to use the DBCC CONCURRENCYVIOLATION command, and more.
By Brian Moran
[Editorial]
All's fair in love, war, and benchmarks--including challenging TPC-C results. But we all benefit when players concentrate more on database technology and less on corporate intrigue.
By Michael Otey
[Reader to Reader]
Readers share their tips for ordering by SQL views, storing SQL Server 7.0 server registrations on a centralized system, and logging third-party applications' transactions.
By Various Authors
[SQL Server Q&A]
Richard Waymire answers questions about running SQL Server on a Win98 machine, setting dateformat, changing compatibility levels, and more.
By Richard Waymire
[SQL Seven]
Here's a quick overview of the seven different types of hardware RAID implementations.
By Michael Otey
[SQL Server/Office Integration]
Learn how to publish your SQL Server datasheets with FrontPage 2000.
By Rick Dobson
[Inside SQL Server]
Learn the ins and outs of the datatime data type.
By Kalen Delaney
[Web Dev]
Check out this Visual Basic COM component for breaking large XML files and streams into manageable chunks for processing.
By Ken Spencer
[Mastering Analysis]
SQL Server 2000 Analysis Services has powerful named sets that can help you get more out of your OLAP reports.
By Russ Whitney
[Solutions by Design]
Learn how to safely and successfully break the design rules of database normalization.
By Michelle A. Poolet
[T-SQL Black Belt]
Itzik Ben-Gan presents two solutions--one that readers contributed--for situations in which the @@identity function doesn't reflect the correct identity value.
By Itzik Ben-Gan
[News Analysis]
Microsoft will include SQL Server 2000 in the release of Small Business Server (SBS).
By Paul Thurrott
SQL Server 2000's new scores comply with the Transaction Processing Performance Council (TPC) requirements that disqualified the company's previous record-setting score.
By Paul Thurrott
|
