Time for T-SQL Tuesday #70!

Here is your invitation for T-SQL Tuesday #70, and the topic is: Strategies for managing an enterprise We define “enterprise” in...

How to Create Pareto Chart in Power BI

About 80% of the world’s population lives in about 13% of the countries. Okay, this statement is not as knee-jerking...

SQL 2016 CTP 2.3 has been released

A new monthly release of the SQL Server 2016 preview has been released: CTP 2.3.

You can find the download here (the...

CONTEXT_INFO and efficient mass update on a large table with a trigger

Let`s assume we have following task – make changes to the data in a large table that has consistency checker in...

Experiences of Submitting a PASS Session

[read this post on Mr. Fox SQL blog] The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to...

Experiences of Submitting a PASS Session

[read this post on Mr. Fox SQL blog]
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in...

The most dangerous command in sql

GUYS,
I was just surfing internet to read more about GAM and SGAM. Accidently I read an awesome article about the...

The most dangerous command in sql

GUYS,
I was just surfing internet to read more about GAM and SGAM. Accidently I read an awesome article about the...

Upgrading a SQL Azure Database to v12

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Populating My DBA Database for Power Bi with PowerShell – Server Info

Following my last post about using Power Bi with my DBA Database I have been asked if I would share...