I've been chosen to speak at SQL Saturday Guatemala
I'm thrilled to announce that one of my proposals has been chosen to be presented in Guatemala's SQL Saturday that will be held on February 3rd at the Francisco...
2018-01-20
2 reads
SQLDbaInternals
I've been chosen to speak at SQL Saturday Guatemala
I'm thrilled to announce that one of my proposals has been chosen to be presented in Guatemala's SQL Saturday that...
2018-01-19
125 reads
Configure Always on AG with SQL 2017
One of the new features that we have with SQL 2017 is that you no longer need a Windows cluster to enable the AlwaysOn feature with SQL server (remember...
2017-12-04
37 reads
Configure Always on AG with SQL 2017
One of the new features that we have with SQL 2017 is that you no longer need a Windows cluster...
2017-12-04
24,844 reads
Create users in Azure AD
In this post I'll show you how to create new users in your Azure Active Directory so you can use them as service accounts or to grant other users...
2017-11-27
11 reads
Create users in Azure AD
In this post I'll show you how to create new users in your Azure Active Directory so you can use...
2017-11-27
132 reads
Configure an Azure AD Domain Services
Problem: I was working on getting a demo on how to setup Always On with SQL Server 2017 without the need of creating a windows cluster, I had my...
2017-11-20
74 reads
Configure an Azure AD Domain Services
Problem: I was working on getting a demo on how to setup Always On with SQL Server 2017 without the...
2017-11-20
157 reads
Contained Databases setup
Last weekI wrote about what is a contained database, the benefits and challenges, today as promised I'll show you how to setup one, how to configure a user and...
2017-11-08
4 reads
Contained Databases setup
Last weekI wrote about what is a contained database, the benefits and challenges, today as promised I'll show you how...
2017-11-08
234 reads
Blogs
TSQL Tuesday #188 Growing community
I am responding late to a T-SQL Tuesday invite from John Sterrett. John’s call...
Time to Revive our YouTube Channel
It’s been forgotten about and neglected for few years but I’ve decided to dust...
Microsoft MVP 2025: Continuing the Data Platform Journey
I am honored to announce that I have been renewed as a Microsoft MVP...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Navigating Multi Platform Realities in My Database Life
Comments posted to this topic are about the item Navigating Multi Platform Realities in...
Import/Export SSMS Settings issue
I have tried a number of times to export and then import my SSMS...
Question of the Day
Query Plan Regressions --
For the Question of the day, I am going to go deep, but try to be more clear, as I feel like I didn't give enough info last time, leading folks to guess the wrong answer... :) For today's question: You’re troubleshooting a performance issue on a critical stored procedure. You notice that a previously efficient query now performs a full table scan instead of an index seek. Upon investigating, you find that an NVARCHAR parameter is being compared to a VARCHAR column in the WHERE clause. What is the most likely cause of the query plan regression?
See possible answers