The Raw Bloopers
A raw dump of stuff from Memorial Day 2010 until July 4, 2010
Since Community Server has trouble with this,...
2010-07-02
611 reads
Blog Posts
There will be no 'Free Lunch' -just great feelings of accomplishment
NEW: Project Criteria and Submission Here I was again awarded the ‘Most Valuable Professional’ (MVP) designation from Microsoft for my...
2010-07-02
554 reads
Using a UDF as a SARG. Make a hash of it!
I am somewhat uncomfortable blogging this, as I feel that it falls into “Polish a turd” category. Having said that,...
2010-07-02
749 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
439 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
325 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,106 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
625 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,753 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
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers