Browsing All Posts filed under »SQL 2012«

CUBE and GROUPING

December 28, 2012

0

CUBE was introduced in SQL Server 2005. When you use the CUBE operator it generates a result set of every possible combination from your set of columns; much like a CUBE would be generated if you were using analysis services. the CUBE operator isn’t something I’ve had to use much so I’ll show you an example. […]

Testing tools for SQL development

August 22, 2012

2

I’ve recently put together an article on using SQL Test/tSQLt, which you can find here. However, I wanted to briefly talk about the alternatives as I see them. Before any commercial testing tools were around we could just use a combination of manual scripts that called procedures and used temporary tables to hold data. It […]

Test Driven Development in the world of SQL

August 22, 2012

7

Any software/web developer worth hiring would tell you that Test Driven Development is important. Although it takes time to do properly,  It can increase productivity as features tend to be developed with a clearer understanding of the problem and make changing business requirements much easier to implement. Importantly, your code quality will improve and there […]