T-SQL Tuesday #99 – Door #1

This months T-SQL Tuesday is hosted by Aaron Bertrand and the topic is Dealer’s Choice. Aaron gives us the choice...

T-SQL Tuesday #99 - Dealer's Choice / sqlibrium

This month’s T-SQL Tuesday from Aaron Bertrand gives us a choice:
Life beyond the technical in a search for what Drew with the Burdensome Name calls #sqlibrium Your own T-SQL...

Migrating MySQL Databases

A little out of my area, but I need to move the tsqltuesday.com database to a new service. The company...

Kronothon2.0 – Accept the challenge

Kronothon2.0 – The only difference between Success and Failure is one’s attitude.
Register here to win cash prizes up to 5 Lakhs...

Automating Database Deployment: Part 1 Introduction to RoundhousE

Database Deployment in DevOps One of the many obstacles to database development and DevOps is how to deploy databases consistently and how to automate the process. Database deployments have...

How I Used Pragmatic Works Training to Pass the Power BI 70-778 Certification

Recently I took and passed the Microsoft certification exam 70-778 for Power BI called Analyzing and Visualizing Data with Microsoft...

SQL# Version 4.1 is released!!

Version 4.1 of SQL# has just been released!

New functionality available only in Full version
Sys_LockResourceReturns the name of the specified Lock...

The SQLUndercover Inspector is now available!

The SQLUndercover Inspector is now available on GitHub, a quick run down of what it does can be found here:...

Power BI with different Network Visualizations

(2018-Feb-10) A few days ago Microsoft provided another update for its desktop version of the Power BI data analytical tool...

Migrating to Azure DBaaS – A Client’s Steps Taken to the Cloud – Part 1

Hello everybody!
I have been working with one of my favorite clients lately on migrating their SQL databases to a DBaaS...