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.
2001-09-13
1,358 reads
Professional SQL Server 2000 XML - Find out if this book from Wrox is as interesting as it sounds.
2001-09-12
3,740 reads
2001-09-11
3,013 reads
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)
2001-09-11
1,661 reads
Left over from the Y2K fiasco, but a good corporate memo that might still be useful as an alternative to XP.
2001-09-10
2,082 reads
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.
2001-09-10
9,702 reads
Learn the key basics of writing quality Transact-SQL code.
2001-09-07
6,666 reads
Do OLAP tools shortchange users with time-varying data? This article by Seth Grimes looks at some of the problems with OLAP tools.
2001-09-06
1,614 reads
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.
2001-09-05
1,422 reads
2001-09-04
3,059 reads
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers