Taking Time Off
I’m trying to better manage my workload. When I owned this site, I struggled to find time off, and typically...
2010-07-02
350 reads
Winner of the June SQL Aloha Contest
This month’s question of the month was:
What is your best advice for boosting index performance?
As usual, selecting the winning entry...
2010-07-02
438 reads
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
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
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...
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