Happy Independence Day - Jai Hind

Wishingyoua very

HappyIndependenceDay

" We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific...

Refreshing Excel Power Query & Pivot Tables with SSIS and Task Factory

With SSIS 2014 and earlier there is currently not native way to refresh an Excel workbook which include Power Query...

Catch up with T-SQL Tuesday

T-SQL Tuesday is a monthly blog party where we get an invitation the first week of the month to write...

015 – Brian Davis - WaterOx Consulting

Brian Davis In WOxPod!, episode # 015 – “Brian Davis” we have...
The post 015 – Brian Davis appeared first on WaterOx Consulting.

SQL Script to find all the triggers defined on a database or on a single table

Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:-SELECT       tbl.name as [Table Name] ...

SQL Script to find all the triggers defined on a database or on a single table

Sometime we need to find all the triggers defined on the database. So in this case, we can use the...

We Don’t Trust This Data

“Learning to trust is one of life’s most difficult tasks.” –  Isaac Watts
As data professionals, there are times when our jobs...

Hekaton Part 4: Simple Performance comparison - In Memory vs Disk table

Continuing on the Hekaton Series, this post will attempt a very basic performance comparison of In Memory and disk based...

PASS Board Update: July 2015

I was actually travelling for most of July and some of that was on holiday with the family, the real...

SSMS 2016 CTP 2.2 Setup Failure 0x81f40001

I built a brand new virtual machine running Windows 2012 R2 and SQL Server 2016 CTP 2.2 (the June edition). ...