Training and tips to get certified with Microsoft (Part 1)

In the last weeks, while I was preparing for one of the certification exams, I got a lot of questions from collegues, asking questions such as How do you...

Are your indexes being thwarted by mismatched datatypes?

In this series I explore scenarios that hurt SQL Server performance and show you how to avoid them. Pulled from my collection of "things I didn't know I was...

Connect to Microsoft Azure Subscription using Windows PowerShell – Part 1

Hello friends, in this blog we will learn how we can connect to Azure Subscription using PowerShell. As you know...

Manually updating Statistics

Even though SQL Server automatically updates statistics in the background for you, you may find there are times when you...

Power BI Custom Visuals Class (Module 60 – Drilldown Player)

In this module you will learn how to use the Drilldown Player Custom Visual.  The Drilldown Player acts like a...

RegEx in SQL Server for replacing text

In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in SQL Server using regex, and now I’m showing how...

RegEx in SQL Server for replacing text

In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in...

RegEx in SQL Server for replacing text

In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in SQL Server using regex, and now I’m showing how...

SQL Cruise: Alaska 2017

We’re weeks away from another SQL Cruise. If you’ve never heard of this before, follow the link to read more....

SQL Server Express v SQL Server Developer Edition

SQL Server Express v  SQL Server Developer Edition

Over the weekend I received the following in an email from Ali Ahmad...