SQL Server

Houston User Group Casino Night

Thumbnail image for Houston User Group Casino Night

The Houston SharePoint User group reached out to other area user groups this year and asked if we would like to participate in a joint user group event around Christmas time. We, of course, thought this was a fantastic idea. What is better than having community get together? Having multiple communities get together for a [...]

0 comments More…

SQL Saturday #97, Austin Wrap Up

Last weekend I presented Adventures in Project Management at SQL Saturday #97, Austin.  This was the first time I gave this presentation and it went really well.  The talk was well attended and seemed to be well received.  I think the fact that no one threw any fruit at me means they liked it.  You [...]

0 comments More…

Speaking at SQL Saturday #97

Thumbnail image for Speaking at SQL Saturday #97

I have been selected to speak at SQL Saturday #97 in Austin, TX on October 1st. I will be presenting a bonus topic, Adventures in Project Management. I am very much looking forward to presenting is Austin. Reviewing the lineup, it will be an event not to be missed. Some of my favorite people will [...]

1 comment More…

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…

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…

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…