Indexes are best utilized in WHERE, not JOIN
A pervasive oversight in database indexing by newer database users is relying solely on indexes used for joining tables together...
2010-07-01
3,750 reads
Electricity Conservation and Solar PV Power
Since I got my grid-tied solar PV system on my roof turned on almost two weeks ago, I have gotten...
2010-07-01
3,105 reads
SQL Server MVP - Are you kidding me?
I received an email today stating that I had been selected as a Microsoft SQL Server MVP for 2010. This is my...
2010-07-01
733 reads
Why I Use Social Media
Yesterday was a scary time for the Kelley family. Our youngest, our five year-old daughter, suddenly had a rash everywhere....
2010-07-01
598 reads
MVP Congratulations
It usually slips my mind that there are award dates for the Microsoft MVP program outside my own. I’m on...
2010-07-01
570 reads
July Question: Tell us your story of how you happened to become a DBA.
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-07-01
458 reads
How to Provide Great Feedback
As a DBA you will encounter processes, code and design decisions within your environment that require change for the better....
2010-07-01
622 reads
PASS Spring Event in Orlando
It’s official! There will be a PASS Conference in the late April or early May in Orlando. Andy Warren (@sqlandy)...
2010-07-01
336 reads
Congrats to all MVPs (New and Renewed)
Today twitter is buzzing with news about MVPs being confirmed. Some new and some old getting renewed. I am sure...
2010-07-01
570 reads
Delegating
I think all managers are told they must delegate to succeed and/or survive. Seems obvious, a manager can’t do it...
2010-07-01
323 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers