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
610 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
553 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
733 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
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
568 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
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,095 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
609 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,736 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
456 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers