Shared databases or private databases?

Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of...

Shared databases or private databases?

Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of ram and a few hundred megabytes of hard disk...

Using Power Bi with my DBA Database

Every good DBA should have a DBA database. A place to store information about all of their instances and databases.
I...

A Quote from Spock

My mom gave me a book about Leonard Nimoy  recently and we talked later about the impact his life had...

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

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