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

One Week to Music City Tech

Next week is Music City Tech, a three day conference consisting of Coding, Agile, and Data tracks, takes place in...

Power BI and Data Security – Audit Logs, Powershell, Power BI and @AngryAnalytics

The following has been reposted with permission from Steve Howard a.k.a. @AngryAnalytics. I have made some formatting changes but the...

Query Predicates

Sometimes people speak “SQL” and expect you know all the terminology. In recent a conversation about query plans I was...

Tips for Securing SQL Server Database from All Sort of Risks

Securing SQL Server Database is a challenging task as there are number of external and internal risks or parameters affecting the Server and its databases. In this section, we...