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...
Author: Igor Kovalenko 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...
Author: Igor Kovalenko 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...
Author: Igor Kovalenko 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...
Author: Igor Kovalenko 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...
Author: Igor Kovalenko 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...
Author: Igor Kovalenko 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...
Author: Igor Kovalenko 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...
Author: Igor Kovalenko Date: 12/02/2006