SQL Server

SQLSaturday #57, Houston

Thumbnail image for SQLSaturday #57, Houston by Jonathan July 23, 2010

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 [...]

View Comments Read More…

Using Model to Change Default Database Settings

by Jonathan April 12, 2010

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 [...]

View Comments Read More…

What Features Visual Studio 2010 Offers DBAs and Database Devs

Thumbnail image for What Features Visual Studio 2010 Offers DBAs and Database Devs by Jonathan April 8, 2010

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 [...]

View Comments Read More…

Using Joins instead of Sub Queries: a Case Study

by Jonathan December 10, 2009

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.

View Comments Read More…

User and Schema Association after Restore on DR Computer

by Jonathan October 27, 2009

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.

View Comments Read More…

Links of the Week (9/25/2009)

by Jonathan September 25, 2009

SQL SQL WHERE Clause Optimization – Query optimization can make or break an application.  Understanding how a WHERE clause can affect a query is very important.  This article helps shed light on that. Creating Dynamic Output in SSIS – SQL Integration Services is one of SQL Servers most powerful features.  This article will demonstrate how [...]

View Comments Read More…