Category Archive: SQL Server

Aug 21 2016

Learning SQL Server Data Tools (SSDT)

If you want to learn the SQL Server Data Tools (SSDT) I definitely recommend watching the Pluralsight course Visual Studio Data Tools for Developers. It is a 3 hours long course from Deborah Kurata that provides a great introduction to it. SSDT is a collection of tools for developers that helps you to work with SQL Server inside …

Continue reading »

Permanent link to this article: https://www.productivecsharp.com/2016/08/learning-sql-server-data-tools-ssdt/

May 24 2016

Do you want to kill SQL Server performance? Use correlated subqueries.

Today I learnt an important lesson: you should never ever use correlated subqueries in SQL Server. If you want to kill performance, that is a very good way to do it. This is a portion of the query I was working on (in bold my changes). The simple addition of this correlated sub-query made the executing …

Continue reading »

Permanent link to this article: https://www.productivecsharp.com/2016/05/killing-sql-server-performance/

Jul 25 2014

Database Unit Testing and Learning TSQL

Did you know that you can write database unit tests for SQL Server? There is a framework called tSQLt that helps you to do it. There is also a tool from Red Gate Software called SQL Test that provide a nice UI on top of it, integrated in SQL Server Management Studio. What about using …

Continue reading »

Permanent link to this article: https://www.productivecsharp.com/2014/07/database-unit-testing-and-learning-tsql/

Jun 02 2014

Stored Procedure to Calculate Expressions

I was reading the section Character Functions in the Chapter 2 of the book Querying Microsoft SQL Server 2012 and pretty soon I get bored of trying individually the various functions on strings available in T-SQL. Then, I challenged myself to write a stored procedure (this is my first one) to evaluate an arithmetic expression with …

Continue reading »

Permanent link to this article: https://www.productivecsharp.com/2014/06/stored-procedure-to-calculate-expressions/

May 28 2014

Preparing for Querying Microsoft SQL Server 2012

Few months ago I joined Red Gate Software and I am having a lot of fun so far. We have a great team in SQL Compare and we are working hard to add support for SQL Server 2014. I think that learning more about SQL Server is very important because a lot of Red Gate …

Continue reading »

Permanent link to this article: https://www.productivecsharp.com/2014/05/preparing-for-querying-microsoft-sql-server-2012/