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

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

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

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.

HealthySQL – A Review

How well do you know the health of your SQL Servers and databases? Ever wonder about the current health or...

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

Connecting, Saving, Discarding, Branching, and Merging in the Big Apple

We’ve got another DLM workshop on Database Source Control taking place in New York City on August 27. It’s in...

Getting and storing a high precision datetime

Earlier today I was working on a project where I was recording some time stamps. In order to get as...