LessThanDot Site Logo

LessThanDot

A decade of helpful technical content

This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.

Continuous Delivery Project – Incorporating the Unit Tests

The purpose of the integration build is to bring potential issues to the surface as quickly as possible. Unit tests run quickly and adding them to the continuous integration build helps flush out defects as close to the beginning of the process as possible. Generally build engines will support unit test framework by directly integrating with them or by providing an ability to execute the test framework and import their results.

Read More...

SQL Advent 2011 Day 19: Filtered Indexes

In my Are you ready for SQL Server 2012 or are you still partying like it is 1999? post, I wrote about how you should start using SQL Server 2005 and SQL Server 2008 functionality now in order to prepare for SQL Server 2012. I still see tons of code that is written in the pre 2005 style and people still keep using those functions, procs and statements even though SQL Server 2005 and 2008 have much better functionality.

Read More...

SQL Advent 2011 Day 18: Table-valued Parameters

In my Are you ready for SQL Server 2012 or are you still partying like it is 1999? post, I wrote about how you should start using SQL Server 2005 and SQL Server 2008 functionality now in order to prepare for SQL Server 2012. I still see tons of code that is written in the pre 2005 style and people still keep using those functions, procs and statements even though SQL Server 2005 and 2008 have much better functionality.

Read More...

SQL Advent 2011 Day 17: varchar(max)

In my Are you ready for SQL Server 2012 or are you still partying like it is 1999? post, I wrote about how you should start using SQL Server 2005 and SQL Server 2008 functionality now in order to prepare for SQL Server 2012. I still see tons of code that is written in the pre 2005 style and people still keep using those functions, procs and statements even though SQL Server 2005 and 2008 have much better functionality.

Read More...

SQL Advent 2011 Day 16: CROSS APPLY and OUTER APPLY

In my Are you ready for SQL Server 2012 or are you still partying like it is 1999? post, I wrote about how you should start using SQL Server 2005 and SQL Server 2008 functionality now in order to prepare for SQL Server 2012. I still see tons of code that is written in the pre 2005 style and people still keep using those functions, procs and statements even though SQL Server 2005 and 2008 have much better functionality.

Read More...

LessThanDot Bloggers Weekly 12/11

This week was an active week for the bloggers on LessThanDot. Here is a recap on everyone’s contributions. Week 12⁄11 – 12⁄15 Saturday started with Denis Gobo continuing an excellent series titled, “SQL Advent 2011”. This week’s daily blogs for Denis’s series were SQL Advent 2011 Day 15: Joins FULL OUTER JOIN scares me a little when it comes to really big tables and SSIS 😉 There are a lot of blogs out there describing JOINs but this one and the examples provided are a great, brief and to the point on how each JOIN is used and the resulting output.

Read More...

On Being A Consultant: Lessons Learned, Month One

In November, I took a big leap: I went from being a full-time DBA for a Fortune 500 company to being a technical database consultant at a small (but amazing) marketing consulting firm. It’s been an adventure so far. I knew that being a consultant would be different than being a full-time employee. I knew my schedule would change, the pace of work would change, the level of work would change, and I’d learn a lot.

Read More...

Continuous Delivery Project – Making MVCMusicStore Testable

It can be challenging to add unit testing to a project that was built without planning to incorporate it. The ASP.Net MVC Music Store tutorial was not built with unit testing in mind, but today we’re going to walk through the addition of Controller unit tests, focusing on a controller that directly references Entity Framework objects and implicitly interacts with ASP.Net Membership objects and Request data from the current HttpContext.

Read More...

SQL Advent 2011 Day 15: Joins

In my Are you ready for SQL Server 2012 or are you still partying like it is 1999? post, I wrote about how you should start using SQL Server 2005 and SQL Server 2008 functionality now in order to prepare for SQL Server 2012. I still see tons of code that is written in the pre 2005 style and people still keep using those functions, procs and statements even though SQL Server 2005 and 2008 have much better functionality.

Read More...

#meme15: I'm A Blogger. Why?

It’s time for a new meme! My good friend Jason Strate (twitter | blog) wants us to blog on the 15th-ish of each month. The first topic is: Blogging. Why did I start blogging? Why do I keep doing it? Why I Started Blogging It was 2009. I realized there was a SQL community. I was reading blogs, lurking on forums, attending a user group, and tweeting. I was also asking a lot of questions.

Read More...