Support for Network Database Files
By default, network database files are not supported with Microsoft SQL Server. Here's a workaround.
Microsoft SQL Server OLAP Services Cell-Level Security
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.
Review: Professional SQL Server 2000 XML
Professional SQL Server 2000 XML - Find out if this book from Wrox is as interesting as it sounds.
Connection Pooling with Microsoft SQL Server 2000 Analysis Services
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)
An Alternative to Windows NT
Left over from the Y2K fiasco, but a good corporate memo that might still be useful as an alternative to XP.
Death of the Production DBA
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.
SQL Server Database Coding Conventions and Best Practices
Learn the key basics of writing quality Transact-SQL code.
Measure for Measure
Do OLAP tools shortchange users with time-varying data? This article by Seth Grimes looks at some of the problems with OLAP tools.
What is OLAP?
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.
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Website Stability 2025/12/05
All week we've had issues with the site being up and down. There's been...
403 Forbidden
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Question of the Day
Fabric Mirroring
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers