2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:
The concert hall at the Sydney...

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:
The concert hall at the Sydney...

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:
The Louvre Museum has 8.5 million...

Enforcing T-SQL quality with SSDT Analysis Extensions

What? Simply put, it is possible to include checks in the SSDT (Sql Server Data Tools) build process - you come up with a set of rules or start...

Enforcing T-SQL quality with SSDT Analysis Extensions

What? Simply put, it is possible to include checks in the SSDT (Sql Server Data Tools) build process - you come...

Enforcing T-SQL quality with SSDT Analysis Extensions

What? Simply put, it is possible to include checks in the SSDT (Sql Server Data Tools) build process - you come...

Speaking Stats

I was updating my speaking schedule and CV, trying to get an idea of what might be planned for 2015....

T-SQL – How to Find Number of Words in a Given String

TSQL: To find number of words in a given string
Download the codehttps://gallery.technet.microsoft.com/T-SQL-How-to-Find-Number-533b6b39
DECLARE @DemoTable Table
(Col varchar(500));

INSERT INTO @DemoTable (Col)VALUES ('JOHN...

T-SQL COALESCE Example

T-SQL COALESCE
SQL Server T-SQL coalesce simplifies the use of a case statement to find the first non-null value of your...

“Pretty Plans vs. Performance” or “Grant Gets Pwned”

If you get an execution plan that looks like this:

I wouldn’t blame you for immediately thinking about query tuning. Especially...