SQL Server

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…

Running Visual Studio 2010 Generated Deployment Scripts in SSMS

Thumbnail image for Running Visual Studio 2010 Generated Deployment Scripts in SSMS

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

5 comments More…

Warnings, Warnings Everywhere: Database References in Visual Studio 2010

Visual Studio small logo

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

4 comments More…

Database Deployment with Visual Studio 2010

vs_thumb

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

13 comments More…

SQLSaturday #35 Recap

Thumbnail image for SQLSaturday #35 Recap

This weekend I was in Dallas, TX with Nancy Wilson (@nancyhidywilson) and Malik Al-Amin (@Malik_Alamin) form the Houston Area SQL Server Users Group volunteering at SQLSaturday 35. It gave us a unique perspective and taught us some very valuable lessons for when we put on SQLSaturday in Houston. I wanted to give a big thanks [...]

22 comments More…

Houston Area SQL Server User Group Meeting

This is a reminder that we will have Kevin Kline (Blog | Twitter) with us discussing Top 10 Mistakes on SQL Server. I would encourage everyone in the area to come out if they can. Detailed meeting information below: When: Tuesday, April 13, 2010 – 11:30am-1:00pm Where: Microsoft Houston Office 2000 W. Sam Houston Pkwy. [...]

0 comments More…