SQL Server

Creating a Custom SSDT Test Condition

I was teaching our new SSDT2019 class today and, while discussing SQL Server Unit Testing, I was asked why the default Row Count test condition only tested for equality (and...

Continue Reading
Top 5 Reasons to use VS Database Projects

There is a traditional resistance to using database projects – the production system is the reference point, and I have a backup, so what is the problem, right? Since the...

Continue Reading
Visual Studio Rangers publish guidance for Visual Studio 2010 Database projects

Today the Visual Studio ALM Rangers published more solid guidance. This time it was around a favorite topic of mine – Visual Studio database projects. This guidance focuses on 5...

Continue Reading
SQL Injection – the best way to avoid a speeding ticket!

For those cities or countries that take photographs of your license plate, then looks up who to send the speed ticket to.   Credit goes to the original hacker –...

Continue Reading
Generating INSERT statements to accompany your Database Projects

Microsoft has yet to provide us with some kind of utility to handle the importing, managing, versioning, and deploying of data along with our schema changes inside Visual Studio Team...

Continue Reading
DeployToDatabaseAddToServerExplorer

I’ve been doing a lot of work with the Database, er Development edition of VSTS 2008. Of course I’m running the GDR-R2 version which really changed the architecture of the...

Continue Reading
SQL Server Magazine’s Community Choice Awards – Nominations are open now

I wanted to make sure you were aware of the upcoming Community Choice Awards. Nominations opened last week and will close on August 10th. Here is the promotion that is...

Continue Reading
SQL Server 2008 Report Builder Available

Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 delivers an intuitive, Office-like report authoring environment enabling business and power users to leverage their experience with Microsoft Office 2007 products....

Continue Reading
Boise SQL Server User Group Presentation

Thanks to those who attended the second meeting of the Boise SQL Server User Group. We had a good turnout of around 30 people and I hope everyone enjoyed my...

Continue Reading
Kalen Delaney in Boise tonight!

Tonight is the maiden voyage of the Idaho SQL Server User Group and what a way to send it off - with Kalen talking about SQL Server 2005. Counting heads...

Continue Reading