SQL, Analysis Services & related stories.

SQL 2000 to SQL 2005 migration: temporary tables reuse issue.

During the same project the next issue was found: temporary table reuse. Here is an example on “how...

Date: 04/28/2007

SQL 2000 to 2005 migration: execution plan change issue.

Last week I was engaged on SQL 2000 to SQL 2005 migration project, and we had identified some issues...

Date: 04/28/2007

How to avoid 1000 rows limitation when querying active directory (AD) from SQL 2005 with using custom code.

As all of you know it is possible to query active directory from SQL Server with using ADSI provider...

Date: 03/22/2007

Switching context with using EXECUTE AS ... not always switch it in fact as you wish.

In this demo i will try to explain why SET TRUSTWORTHY ON on some databases may make the sysadmin...

Date: 03/01/2007

Workaround for “Unable to set Default Schema for a group”.

Let assume you are using Windows Authentication with SQL Server 2005, you've added a new server...

Date: 01/27/2007

SQL Server 2005: building security model based on DDL triggers.

Last month I’m working with a client to create something like non-standard security model. He asked...

Date: 01/14/2007

db_securityadmin is very powerfull and … dangerous.

Few days ago I worked for one client. He uses the following business model: - dbo usually...

Date: 01/14/2007

ALTER DATABASE ... ALTER COLLATION (FORCED).

As all of you know Microsoft has made a small problem for all SQL DBA and developers. If you have a...

Date: 12/02/2006