The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
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.
By Russ Whitney
The September puzzle presents a virtual cube called Trained Cube.
By Brian Moran
You can use DBCC CONCURRENCYVIOLATION to check whether users of SQL Server Personal Edition or SQL Server Desktop Edition are reaching the threshold of concurrent batches.
By Michelle A. Poolet
Learn how to safely and successfully break the design rules of database normalization.
By Rick Dobson
Learn how to publish your SQL Server datasheets with FrontPage 2000.
By Paul Thurrott
Microsoft will include SQL Server 2000 in the release of Small Business Server (SBS).
By Michael Otey
This example illustrates how to assign the ConnectionString property of an ADO connection object by using a .udl file.
You can manually modify the Windows Registry to add a new Data Link option to Windows Explorer's File, New menu.
List the beer products that have at least 100 unique customers.
By Kalen Delaney
Learn the ins and outs of the datatime data type.
Download this Data Definition Language (DDL) script to create the SQLmag database that Michelle A. Poolet uses in her October Solutions by Design article.
Here's a quick overview of the seven different types of hardware RAID implementations.
By
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.
SQL Server 2000's new scores comply with the Transaction Processing Performance Council (TPC) requirements that disqualified the company's previous record-setting score.
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 Morris Lewis
Build a security plan for SQL Server 2000 or SQL Server 7.0 that is manageable, flexible, and verifiably secure.
By Ken Spencer
Check out this Visual Basic COM component for breaking large XML files and streams into manageable chunks for processing.
By Bob Pfeiff
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.
Use the DataLink utility to create an OLE DB management tool that rivals the ODBC Administrator.
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 Itzik Ben-Gan
Itzik Ben-Gan presents two solutions--one that readers contributed--for situations in which the @@identity function doesn't reflect the correct identity value.
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 Rodney Landrum
You can use SQL Compare to find differences in databases rather than scanning code line by line.
By Richard Waymire
Richard Waymire answers questions about running SQL Server on a Win98 machine, setting dateformat, changing compatibility levels, and more.
SQL Server 2000 Analysis Services has powerful named sets that can help you get more out of your OLAP reports.
advertisement