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...

Small presenter tip: changing display mode automatically after presenter view

This morning Adam Machanic (blog | twitter) asked the following question on Twitter:
Anyone know if it's possible to configure PowerPoint 2013...

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...