DBA

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…

Running Visual Studio 2010 Generated Deployment Scripts in SSMS

Thumbnail image for Running Visual Studio 2010 Generated Deployment Scripts in SSMS by Jonathan July 8, 2010

Previously we discussed how to use the Database Deployment feature in Visual Studio 2010. There are two options to deploy a database project. The first is to have Visual Studio deploy the scripts automatically. The second is to have Visual Studio build a deployment script that can be run via SQL Server Management Studio or [...]

View Comments Read More…

Warnings, Warnings Everywhere: Database References in Visual Studio 2010

Visual Studio small logo by Jonathan June 11, 2010

In previous articles we discussed how database professionals could use the features in Visual Studio 2010. During the video I demonstrated with a test project. Since then I have been working to migrate my DBA database project into Visual Studio 2010. From the beginning I ran into issues. This was a very discouraging start to [...]

View Comments Read More…

Database Deployment with Visual Studio 2010

vs_thumb by Jonathan May 27, 2010

I have been exploring some of the features of Visual Studio 2010 that are useful to DBAs and Database Developers. Today’s topic is Database Deployment. Software developers have been using the deployment tools in Visual Studio for some time, however, the addition of database deployment gives database professionals the ability to systematically deploy their projects [...]

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…

MS Project Server and Backup Best Practices

by Jonathan January 15, 2010

Microsoft’s Project is a very standard project management tool that most Project Managers are all to familiar with. While Project is a great application it was limited to local information. Microsoft’s Project Server extends Project’s capabilities and allows the sharing of resources and information across an Enterprise. Project Server 2007 is built around the SharePoint [...]

View Comments Read More…