Day 25 Optimization

Locking is depends upon Isolation level and Storage Engine. MySQL uses table level locking (instead of page, row, or column...

dbachecks – Improved Descriptions

With the latest release of dbachecks we have added a new check for testing that foreign keys and constraints are...

Fix For Using Azure Active Directory and DacFX

Update:
Refer to this post instead
Hello!
One of the things I feel strongly about is that a build/release pipeline needs to be as complete as possible - that is all configuration...

Is your SQL Server environment ready for GDPR? Part 1

Unless you have been living under a rock lately, you have not heard about GDPR. This has been hot topic...

Techorama 2018 Session Materials

Techorama 2018 is over, sadly enough. It was a great conference: lots of awesome speakers and sessions and very nicely...

When Good Query Plans Go Bad

Today's story starts again with a page escalation:

--
We are seeing very high CPU usage on DistServer01.  Could you please take...

Back to basics: What is a HEAP table?

Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more...

Convert a Positive Number To a Negative In SQL With a Spot of Bitwise Logic

Now this is something that I’ve seen asked a few times and it’s always a question that gets a fair...

Cosmos DB for the Data Professional

Cosmos DB is one of the fastest growing Azure services in 2018. As its popularity grows, data professionals are faced...

Day 24 Replication Setup

Today we will discuss how setup a replication: Master – Slave Replication: Requirement: 2 (Linux) System (MasterServer and SlaveServer) MySQL Installed...