I’m normally not one to advocate the use of the Database Engine Tuning Advisor (DETA), a tool available inside of Microsoft SQL Server. (To be fair, I’m not a fan of the SQL Tuning Advisor from Oracle, either.) But I recently came across a little nugget of information that I wanted to share with you regarding [...]
SQLServerPedia Wiki
Is Your DBA Lying To You?
“Signs point to yes.” – Magic 8-Ball prophecy
You have probably heard this line at one point, the one that says “the best DBAs are the ones you never see or hear?” I used to think that was a result of some sketchy personal hygiene choices and later on understood it to mean that if everything [...]
#Meme15 – Why The Twitter?
It’s the middle of the month and that means it is time for another #Meme15 assignment, the brainchild of Jason Strate (blog | @stratesql).
This month we are going to talk about Twitter. Specifically with regards to the following two questions:
Why should average Jane or Joe professional consider using Twitter? – and-
What benefit have you seen in your [...]
How To Improve Database Performance Without Changing Code
I hear it all the time. It’s a familiar refrain. Most of the time it is innocent enough, and understandable. But there are times when hearing those words are like hearing the screech of fingernails on a chalkboard:
“We can’t change the code.”
There you are, listening to someone complain to you about the database server, and [...]
SQL Someday Video
Here is the video from the SQL Inspire event last Fall in NYC. I hope you enjoy the talk, it took me a lifetime to create. You can read more about SQL Someday over at the Someday page. I plan on adding to that page over time.
Review of DBA Survivor by Mike Fal
Saw this review today and wanted to share it with everyone here:
http://www.mikefal.net/2012/01/03/dba-survivor-learning-how-to-rock-out-with-databases/
I’m touched that Mike would take the time to write such a wonderful (and unsolicited) review of “that little book” I wrote almost two years ago now. I’d like for you to read his entire review, but I am going to share his last [...]