This article describes how SQL Server 7.0 (Service Pack 1) OLAP Services takes advantage of the user and group structure in Microsoft Windows NT to offer cell-level security, and describes several ways to tailor permissions to data across the enterprise.
Professional SQL Server 2000 XML - Find out if this book from Wrox is as interesting as it sounds.
This white paper describes how to use the connection pooling objects included with the Microsoft XML for Analysis Provider to develop scalable client and Web applications for Microsoft SQL Server 2000 Analysis Services. (11 printed pages)
Left over from the Y2K fiasco, but a good corporate memo that might still be useful as an alternative to XP.
If you see a priest outside your cubical, beware! He could be trying to read you your last rites. If he hasn't showed up yet, don't worry, he'll be over shortly because the production DBA is dead or will be shortly.
Learn the key basics of writing quality Transact-SQL code.
Do OLAP tools shortchange users with time-varying data? This article by Seth Grimes looks at some of the problems with OLAP tools.
An interesting question and one that The OLAP Report attempts to answer. This article is an analysis of what the increasingly misused OLAP term is supposed to mean.
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
By Steve Jones
A few years ago SQL Prompt added a command palette to let you search...
All, In attempts thinking that I am smarter than your average bear, I attempted...
CREATE DATABASE dbsubjects; CREATE TABLE tblstudent( ID INTEGER PRIMARY KEY, TheName Varchar (100), TheAddress...
We have about 20 SQL Servers. We use Net backup or Native backup for...
Ask SSC