Solving a slow running query issue with UNION

That’s right! I will solve a performance issue by adding a UNION into the query. Interested? Read on!
I recently encountered...

T-SQL Tuesday #63: How do you manage security

This month’s T-SQL Tuesday is hosted by Kenneth Fisher (blog | twitter) and its subject is about security.
Security is one of...

Author of the Year at MSSQLTips.com

I have the pleasure and privilege to announce that I was awarded with the “Author of the Year” award at...

The mysterious permission issue

As you might have realized, this is not the title of an Agatha Christie book, but rather about some nasty...

Better late than never…

Just like last year, I’m a bit late with the obligatory “how was last year and what is this year...

Overview of Published Articles – 2014Q4

Here is an overview of the articles I published in the last quarter of 2014.
INTENSE SCHOOL
MCSE Prep: Overview of T-SQL Windowing...

Formatting Durations in SSAS: Caveat

I recently published an article on MSSQLTips.com titled Format Durations in SQL Server Analysis Services. For those who haven’t read...

Nominated for the 2014 Tribal Awards

Just like last year, SQLServerCentral.com and Simple Talk are hosting the Tribal Awards. In their words:
The Tribal Awards, co-hosted by Simple-Talk and...

PASS BI VC recording is available now

The recording of the webinar I did for the PASS BI virtual chapter is live!

(Quick reminder: it was the same...

Beware the defaults! (in windowing functions) – The Movie!

I was recently contacted by the fine gents of Webucator, an online training services provider. In order to promote their...