I use a custom application to generate the SQLTeam newsletter each week. It pulls out the blog posts I’ve flagged during the week and some recent forum posts. This week I was in the process of making some updates to the software and so I used my shiny new…
It’s hard to believe I’ve been doing SQL Server consulting for nearly ten years now. All that time I’ve been part of a firm called ClearData Consulting. Over the summer we made the decision to disband the company. [http://www.scalesql.com/] My new firm is scaleSQL…
Bing just announced a visual search feature [http://www.bing.com/visualsearch]. I mostly clicked on it because I enjoy bright, shiny things. Wow! I just spent 30 minutes filtering NFL players in all sort of weird ways. I don’t know how that helps my fantasy team yet. But…
I’m presenting at the Kansas City SQL Server User’s Group [http://kansascity.sqlpass.org/] on Thursday, August 13th at Johnson County Community College. Check the monitors when you arrive for the room. We start at 6PM with 30 minutes of announcements and such. I’ll be starting at…
I put my name down for the Google Voice [http://www.google.com/voice] trial a few months back. I recently received my invitation and configured my account. The entire process was painless and it has some interesting benefits: * I’m in the process of starting a new business and…
Microsoft continues to release cumulative updates roughly every two months. These two came right on schedule. As always I’ve updated my build list in the SQL Server Version [http://www.sqlteam.com/article/sql-server-versions] article on SQLTeam.com.…
At PASS we’ve been interviewing our pre-conference and post-conference speakers [http://summit2009.sqlpass.org/Agenda/PrePostConferenceSessions.aspx] and publishing the interviews. The topics revolve around the speaker’s session and what they’re going to cover. For example, Brian Knight [http://summit2009.sqlpass.org/Agenda/PrePostConferenceSessions/KnightQA.aspx] discussed…
When I connect my laptop to Wi-Fi hotspots I’m usually pretty careful. I look at the name of what I’m connecting to and make sure it looks reasonable. I know it’s no guarantee but if there is only one wi-fi hotspot with the airport name there’s…
Until this weekend I hadn’t done much with Bing. I looked at the pretty pictures and tried a search now and then but that’s about it. I recently stumbled on Bing vs. Google [http://www.bing-vs-google.com/]. You can enter your search text and it will search both…
It’s pretty easy to determine the CPU and disk resources that a given query or stored procedure will use. It’s more difficult to determine the resources that were used to compile that query plan. You can start by looking at sys.dm_exec_cached_plans. It has a…