How to manage SQL Server security with SQL Source Control

One of the most common issue you can find when source controlling the database is about the security. How to manage...

Happy Independence Day - Jai Hind

Wishing you a very

Happy Independence Day

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

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