During the same project the next issue was found: temporary table reuse. Here is an example on “how to reproduce”: USE tempdb GO CREATE PROCEDURE dbo.usp_step_one AS BEGIN CREATE TABLE #temp (ID INT NOT NULL, NUM INT) ALTER TABLE...

Last week I was engaged on SQL 2000 to SQL 2005 migration project, and we had identified some issues related to significant changes in execution plans. Before migration we tested the application with using Upgrade Advisor (test passed without any caution...

As all of you know it is possible to query active directory from SQL Server with using ADSI provider as linked server. This solution works fine until you will have a lot of users in active directory. According to best practice guide windows system engineers...

In this demo i will try to explain why SET TRUSTWORTHY ON on some databases may make the sysadmin job unsafe. In previous posts i explained how db owner (or any developer) can try to implemet simplest luring attack against server sysadmin. According to...

Let assume you are using Windows Authentication with SQL Server 2005, you've added a new server account for domain group and would like to give it a default schema. The properties window is the same for users and groups but the default schema field is...

Last month I’m working with a client to create something like non-standard security model. He asked for the following features: - server–level management only for sa (server admin). - database–level management for dbo (one or more dbo per database...

Few days ago I worked for one client. He uses the following business model: - dbo usually responsible for high level database design and maintenance; - all database users organized in additional security groups for security purposes; - dedicated...

As all of you know Microsoft has made a small problem for all SQL DBA and developers. If you have a database with any of SQL_xxxxx collations (for more details please have a look at the TERTIARY_WEIGHTS() function here ), you will defenetily have a significant...