Successfully Managing Upwards and Getting Your Boss on Your Side Part 1
Edwin M Sarmiento is a Filipino Microsoft Data Pla...
2019-05-23
Career Growth
2019-05-22
The Other Jobs
This week Steve is asking what jobs you might choose if you had the chance, as well as those you enjoyed, or perhaps dreaded.
2019-05-17
259 reads
Just What IS it That You Do?
This is a question that I get asked all the time. It’s fair enough, really. The most common assumption for people outside the field seems to be that that...
2019-05-06
How can we close the tech skills gap?
One of the most profound challenges faced by technology companies today is talent. According to the latest Harvey Nash survey, 65% of CIOs believe that a shortage of tech skills is affecting their ability to respond to change.
2019-05-03
The Space Between
Andy Leonard on finding the time to keep up with learning and avoiding time sinks.
2019-05-02
The Database Giveth and Taketh Away
A database error at Southwest Airlines confused some customers and was embarrassing. Steve worries that we might want to be more careful in the future about making database mistakes.
2019-04-25
298 reads
How the Company-Startup Thing Worked Out For Me, Year 7
It’s time for my annual update on the wild ride. If you want to catch up, check out past posts in the Brent Ozar Unlimited tag. This post covers...
2019-04-09
You're not really that good at SQL Server
Steve reminds some people that there are reasons to continue to improve your skills.
2019-04-08
1,798 reads
2017-06-16
2,523 reads
Blogs
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...
What is KTLO? Keep The Lights On vs Project Work in Agile
By Rohit Garg
🔍 Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT...
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...
Import/Export SSMS Settings issue
I have tried a number of times to export and then import my SSMS...
FQDN - SQL cannot connect when the server name has backslash
Hi I need to connect to a SQL server via FQDN - that is...
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