Book Review: T-SQL Window Functions by Itzik Ben-Gan

5 years ago

A couple of years back Itzik Ben-Gan (the T-SQL guru) wrote the book Microsoft SQL Server 2012 High-Performance T-SQL Using…

T-SQL Tuesday #121: Gifts received for this year

5 years ago

It's T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the subject is looking back at the…

Refresh Power BI Dataset using Logic Apps

5 years ago

A recent blog on the Power BI website announced the availability of a preview component in Microsoft Flow, which allows…

Cool Stuff in Snowflake – Part 10: RATIO_TO_REPORT

5 years ago

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll…

Restarting SQL Server after adding a new SQL login

5 years ago

At a project, we asked if we could get a SQL Server login/user so we could make a connection from…

Speaking Engagements End 2019

5 years ago

Currently I have two conferences in the pipeline. The first is our local DataMinds Connect, the biggest Microsoft data platform…

What’s in the pipeline for Power BI?

5 years ago

If you're interested in Power BI (or the Power platform in general), you might be interested in checking out the…

The Azure-SSIS IR Startup Time

5 years ago

UPDATE: here's an official blog post going in more technical detail on how they achieved the improvements in startup time…

Cool Stuff in Snowflake – Part 9: ILIKE

5 years ago

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll…

SQL Server Development Best Practices – Webinar

6 years ago

I'm delighted to announce I'll be giving a webinar for MSSQLTips.com about SQL Server Development Best Practices. Aka writing T-SQL…