Tutorial of MS SQL Extended Events in 7 T-SQL Steps

Hi, today I would like to show you how you can use Extended Events Sessions on SQL Server 2008 or above. Extended Event Sessions are future of monitoring of the Continue ReadingTutorial of MS SQL Extended Events in 7 T-SQL Steps

Simple Service Bus Training

Hi, today I prepared my first screencast training on YouTube about the Simple Service Bus I made. It took me a lot of effort and it is just a start. Continue ReadingSimple Service Bus Training

SQL Ninja uses ORDER BY with CASE

Hi, today I want to show you simple technique which can be used when you need parameterised ORDER BY cause in T-SQL. Sometimes you may want to have elegant query. Continue ReadingSQL Ninja uses ORDER BY with CASE

SQL Queries Tuning by Brent Ozard

Hi, today I want to share with you training that I get from one colleague today. This is available at Watch Brent Tune Queries [Video] I have to said that Continue ReadingSQL Queries Tuning by Brent Ozard

SQL Ninja gets Products from Group Tree CTE

Hi, today I want to show you comparison of 2 possible techniques fro get data about all Products mapped to the Product Groups tree. I wrote as usual one T-SQL Continue ReadingSQL Ninja gets Products from Group Tree CTE

SQL Ninja replace for Cursor with CTE

Hi, today I want to share with you results on nice experiment and its code. I like C#, but currently most of my work attention is focused on T-SQL code. Continue ReadingSQL Ninja replace for Cursor with CTE

TSQLTester for SQL Ninja with Mocking

Hi, I am using very often TSQLTester from the moment it was created. And it saved me a lot of time with my performance challenges. Of course my favorite advantage Continue ReadingTSQLTester for SQL Ninja with Mocking

TSQLTester for SQL Ninja

Hi, today I would like to share with you idea of testing tool for T-SQL developers who want to not only replace stored procedures with fasters stored procedures but also Continue ReadingTSQLTester for SQL Ninja