I recently worked on a project for my employer, Insource Technology, to develop a corporate blog. As the project progressed we ran into an interesting problem. An author would upload a .docx file to the site without an issue. When the file was downloaded it would not download as a .docx file but as a [...]

{ 0 comments }

SQLSaturday #57, Houston

Post image for SQLSaturday #57, Houston

by Jonathan on 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 [...]

{ 2 comments }

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…

SQLSaturday #35 Recap

Thumbnail image for SQLSaturday #35 Recap by Jonathan May 25, 2010

This weekend I was in Dallas, TX with Nancy Wilson (Twitter) and Malik Al-Amin (Twitter) 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 [...]

View Comments Read More…