SQL Aliasing – Why You Need It
Quick word on Aliasing. In the past few months I have come across a SQL issue that occurs in many different configurations, across various physical locations, and amongst several engineers. Since it was so prevalent I thought it might be helpful to talk about aliasing SQL instances. When you install a SQL instance, no matter…
Read more…
SQL Server Maintenance for the Full-Stack Engineer
Don’t Panic Labs is an office filled with full-stack developers. We cover all aspects of software — from JavaScript in a browser, to core business rules in C#, to performant queries and table structures in SQL Server. Full-stack developers have a vast knowledge of all technologies required to create a working system, but do not…
Read more…
Looking Back and Looking Ahead
As we were looking back over the blog’s 2012 stats, I was struck (and humbled, honestly) at how many visitors we’ve received and the attention certain posts had garnered. Our five most popular posts in 2012 were: Ganz’s ClickOnce Publish and Deploy from Team Foundation Server 2010 Santi’s Developing Reports for SQL Server Reporting Services…
Read more…
“Transforming” App.Config Files in a TFS Build
Do you develop using your production or staging SQL server? If so, please don’t. If not, great! How do you keep track of which Web.Config is pushed to your server? VS2010 has an improved Web Deploy process that allows you to use config transforms to adjust your Web.Config files based on the build configuration. Scott…
Read more…