SQL Server

SRS Double Hop Authentication

I was recently asked by a client to architect a data and reporting environment.  Part of the business requirements was separation of the production database server and the reporting services server.   Another part of the business requirements stated that the reports were to leverage a shared data source and Windows Authentication.  While none of the [...]

1 comment More…

SQLSaturday #57, Houston

Thumbnail image for SQLSaturday #57, Houston

As Cochair of the planning committee I am very pleased to announce that we are officially having a SQLSaturday in Houston. The event will be on January 29th, 2011 at the Bammel Church of Christ. Co Chairs Jonathan Gardner (Blog|Twitter) Malik Al-Amin (Blog|Twitter) Nancy Hidy Wilson (Twitter) Information We have created a Twitter account @SQLSatHou [...]

4 comments More…

Using Model to Change Default Database Settings

During a Twitter conversation today Malik Alamin (Twitter) asked about the Autogrow settings on his databases. The conversation naturally progressed to the question of how you change the default behavior and set all newly created databases to have user defined settings. Brent Ozar (Blog | Twitter) was able to point us in the right direction [...]

0 comments More…

What Features Visual Studio 2010 Offers DBAs and Database Devs

Thumbnail image for What Features Visual Studio 2010 Offers DBAs and Database Devs

I was recently reviewing some the change management and document control policies that governs our IT group. While I have been confirming to these change management policies I started to think back on how we make our developers work with code. We have deployed a Team Foundation Server 2010 and are using it for source [...]

0 comments More…

Using Joins instead of Sub Queries: a Case Study

During a recent upgrade from SQL 2000 to SQL 2005 some poorly written code was exposed on a custom web application. Users and developers started reporting that their applications were timing out. One of the queries I posted in the Execution Plan Challenge. Another exposed query involved a sub query.

5 comments More…

User and Schema Association after Restore on DR Computer

I was faced with a situation I have yet to encounter as a DBA. I don’t know why I have yet to find this but I will write about it anyway. I have been working on a side by side upgrade/migration project going from SQL Server 2000 to SQL Server 2005. I have the two boxes configured but in the upgrade we are also going to have to correct some ‘error’ in security. It is because of this fact that I just can’t migrate the master database and get all of my user associations back working together.

0 comments More…