Finding SQL Server Installs with Powershell, Again
But the SQL Listener isn’t started!
Yep, I heard you loud and clear. There is more than one way to find...
2013-04-15
918 reads
Wesley Brown
- Interests: Collecting old computers
- Skills: I talk a lot.
Parsing Glenn Berry’s Diagnostic Information Queries With PowerShell
Do It In Bulk
I usually don’t run queries on just one server. Most of the time I need to get...
2013-04-12
1,256 reads
Finding SQL Server Installs Using Powershell
Old Dog, New Tricks
I’ve been writing tools for SQL Server for a lot of years. Some of these tools were...
2013-02-27
2,374 reads
New Toy: The Brydge iPad Keyboard – Updated
Finally a REAL keyboard for my iPad!
I can’t tell you how long I’ve wanted a real keyboard that my iPad...
2012-11-28
1,275 reads
Quick Tip: SSIS and SAP BW Round 2
Again, frustration.
After almost breaking my arm patting myself on the back getting past my last SAP BW issue I found that...
2012-11-19
1,178 reads
Quick Tip: SSIS and SAP BW
Frustration.
If you have ever had to work with Integration Services and data sources other than the Microsoft variety you know how frustrating...
2012-11-15
3,816 reads
Solid State Storage: Enterprise State Of Affairs
Here In A Flash!
Its been a crazy last few years in the flash storage space. Things really started taking off...
2012-11-07 (first published: 2012-11-05)
2,726 reads
SSIS and Oracle All Your Non-options
Why do some things have to be so hard?
I have been asking myself that question for the better part of...
2012-11-01 (first published: 2012-10-30)
3,457 reads
The Fundamentals of Storage Systems – Shared Consolidated Storage Systems
Shared Consolidated Storage Systems – A Brief History
Hey, “Shared Consolidated Storage Systems” did you just make that up? Why yes, yes...
2012-10-30 (first published: 2012-10-26)
2,485 reads
One Great Day And Mixed Feelings
If it happens two times then you know the first time wasn’t a fluke.
Today was my anniversary date for the SQL Server...
2012-10-02
1,005 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...
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