Sunday, September 27, 2015

Unit testing in SQL Server, taking a first look a tSQLt

›
This is the third post in my Unit Testing series, today we are looking at what tSQLt, in the next post we will take a look at how to install...
Wednesday, September 23, 2015

Unit testing in SQL Server..what are unit tests

›
This is a continuation from yesterday's post  Unit testing in SQl Server... why?  Today we will look at what unit tests actually ar...

Unit testing in SQl Server... why?

›
I have been using tSQLt to do unit testing within SQL Server for the last 2 years. I already did a presentation twice at work and decided to...
Friday, September 18, 2015

Whenever you use the designer in SSMS, click on the Generate Change Script icon to verify what it will do

›
SQL Server Management Studio is pretty good tool to manage and develop against SQL Server instances. You have to be aware of some things t...
Thursday, September 10, 2015

Review of SQL Performance Explained by Markus Winand

›
SQL Performance Explained is a database book written by Markus Winand, the book is a little less than 200 pages. The book covers Oracle, ...
Wednesday, September 09, 2015

Dealing with temporary tables and named constraints

›
The other day one of our recently changed stored procedures in the development environment started to fail with a message like the followi...
Tuesday, September 08, 2015

Defaults with parameters in SQL Server stored procedures gotcha

›
I was talking with someone today and this person told me that the stored procedure doesn't work as expected Here is what the simplif...
Monday, September 07, 2015

It is ten years ago that I wrote my first blogpost

›
This month ten years ago I wrote my first blogpost, that post is  Split a comma delimited string fast! Looking at that post, it makes me cr...
Sunday, September 06, 2015

Links to a handful of posts I created today

›
I got rid of my squarespace site and decided to repost the handful of SQL Server related posts here.  Some of this content might be useful s...

Questions for SQL Server MVPs

›
Since I decided I did not want to be awarded again as a SQL Server MVP,  I wanted to ask some fellow MVPs a couple of questions about the M...

My last day as a SQL Server MVP

›
My last day as a SQL Server MVP Nine months ago I decided that I did not want to be a SQL Server MVP anymore. I just want to write a co...

Awesome SSMS shortcuts that will save you tons of time

›
How many times have you written a join with a bunch of tables and you wanted to quickly see what was in a table. You would either find th...

Pass Summit 2014 pre-conference day 2

›
I went to the SQL Server PASS Summit 2014 in Seattle, this is just my recap of my first day. My first day was day 2 of the pre-conference. ...