In a security bulletin which it dispatched to the subscribers of its Security mailing list, Microsoft acknowledged a problem with its remote procedure call (RPC) implementation that affects services running on Windows NT 4.0, Windows 2000, SQL Server 7.0, SQL Server 2000, Exchange 5.5 and Exchange 2
Tag: sql server
Microsoft® SQL Server™ 2000 Reference Library
Author David Iseminger, Series Editor – MICROSOFT SQL SERVER 2000 REFERENCE LIBRARY provides the ideal set of reference materials for SQL Server—direct from Microsoft SQL Server 2000 Books Online. This well-conceived, intelligently indexed six-volume set sensibly organizes and condenses the vast sea
Using Len() in a Select Statement
From SQL Team – Maya writes "My select statement returns a resultset with one field, 'ResultText'. I would like to get a length of that field. Is there a way in SQL to do it like in Visual Basic ?" Yes Maya, there are two ways of doing this.
Microsoft SQL Server 2000 as a "Dimensionally Friendly System"
By Joy Mundy – This paper maps features and functionality of the Microsoft® SQL Server™ 2000 Data Warehousing Framework to the twenty characteristics of a "dimensionally friendly system" identified by Ralph Kimball.
Inside Microsoft® SQL Server™ 2000
Author Kalen Delaney – Master the inner workings of today’s premier relational database management system with this official guide to the SQL Server™ 2000 engine. Written by a renowned columnist in partnership with the product development team, this is the must-read book for anyone who needs to unde
How to write secure SQL Server–based applications
Chip Andrews – Designing secure applications is more about good planning than anything else. So before you begin that new project, think it over carefully. With application-level intrusions becoming increasingly common, you need to keep attackers from exploiting your code and circumventing your expe
SQL Server 2000 Black Book
Book by Patrick Dalton, Paul Whitehead – A guide for intermediate to advanced database administrators and programmers, offering a behind-the-scences look at SQL Server 2000. The CD-ROM contains examples, source code, and other helpful material for use with the text. DLC: 166MHz+ processor, Microsoft
Building and Managing Highly Available SQL Server Applications
By Scott Mauvais – Building highly available applications requires three ingredients: technology, people, and process. Let's review what I mean by these terms.
Analyze Disk Utilization
By Russ Whitney – Most users who know about analysis applications recognize the power and value of analysis but don't realize the breadth of situations to which analysis applications are applicable. Probably 80 percent of OLAP product demonstrations use sales data. The sample database that SQL S
SQL Server 2000 Undocumented Stored Procedures
by Alexander Chigrik – In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 2000.