Archives: July 2010
I also want to thank Andy for taking the time to provide this service to the community.
My nomination application made it through the committee. I got an email yesterday telling me that I needed to schedule an interview, and a list of available slots.
I picked next Friday, August 6th, at 10am PST for my slot and it’s scheduled. It’s a phone interview, according to the… Read more
For the past couple years we’ve had a few different documents that covered how to run a SQLSaturday, but as you all know building and maintaining documentation is hard, and we just didn’t have a good process for capturing new lessons and folding them in. A couple months back… Read more
This is just a quick note to say that I’ll be in South Florida this weekend presenting at SQLSaturday #40. This weekend and the following week are particularly awesome for a few reasons:
- My birthday is Friday!
- Look at this lineup, it’s PACKED with #awesomesauce
Or “Monitoring plan cache usage”
For people interested in the details of how SQL is using and reusing execution plans, there are some useful events in profiler for watching this in detail, under the Stored procedure group:
Additionally there’s the SQL:StmtRecompile event… Read more
Every so often on the on-line forums, the question of : Which is better Count(*) or Count(1) ? will occur. So can it categorically be proved than one is better than the other ?
What we need to do is populate a table and use both count(*) and count(1) and… Read more
One of the best things to come out with Powershell V2 is remoting and asynchronous calls. Between the two of these, you can basically send commands simultaneously to a number of SQL Server instances. BUT… and there always seems to be one of those, there is a lot of work… Read more
I realized over the weekend that I hadn’t booked a hotel for my SQL Saturday #28 trip to Baton Rouge. This was one I can’t miss since I’m doing 2 sessions and the keynote. I remembered today, and called the Cook Hotel, a beautiful place on the LSU campus where… Read more
I finally get to head down to Miramar to speak at SQLSaturday #40 – South Florida. I really wanted to go last year, but I was in New England at the time, so I couldn’t make it. So this weekend, July 30-31, I’ll be making the drive down to attend… Read more
I’ve been asked that at a few of my Modern Resume presentations if I do all the things that I mention, and to what extent. My answer is that I do and I don’t. I’ve done them all at some point in my career,…
Have you heard the sound of silence? Yep, that’s been my blog.
It’s been weeks since I’ve posted anything on here, and to both of my loyal readers I offer my apologies. It’s been a bit of a wild summer already… I sold my house, moved my large family into… Read more
Ran across Pillbox in Government Computing News (GCN), a web app that lets you identify what a pill is based on shape, color, imprint, and more. They have an HTML version and a Flex version, the latter definitely more user friendly (more graphics), but both are useful. The article about… Read more
I just found out today that I will be one of the speakers at SQL Saturday #51 in Nashville, Tennessee on Saturday, August 21, 2010. My presentation will be:
DMV Emergency Room!
If you have ever been responsible for a mission critical database, you have probably been faced with a…
While I have always known that the Windows operating system Power Plan options affect a server’s performance, I had not realized how much until SQL Server MVP Glenn Berry (Blog | Twitter) suggested I try out my new Dell T610 test servers under the three available power savings… Read more
Recently one of my clients would like to see their Revenue figures represented some of the time as a positive (+VE) value and some time as a negative (-VE) value. They would like to have the ability to select between the two at run time in the Analyses Services Cube.… Read more
Presenting to the West Michigan SQL Server User Group / SQL PASS Chapter
I will be presentitng to the West Michigan SQL Server User Group/SQL PASS Chapter tomorrow at 6:45 PM Eastern Time / 3:45 PM Pacific Time. Topic will be Advanced Tuning: Unconventional Solutions to Everyday Problems. You're welcome… Read more
2 comments, 511 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 26 July 2010
The 6th Annual Jacksonville Code Camp is coming up fast. There are tons of great presenters slated to be here giving free training and demonstrations on the latest and greatest products out there. Below are some of the details about the event, what my presentation will be on and… Read more
In cycling each team is made up of nine riders. Each rider on a team can have a different specialization. A careful balance of skill sets on a team can determine if a team will stand triumphant on a champion’s podium at the end of the day or simply fade… Read more
Chapter 3 of the Defensive Database Programming Book by Alex Kuznetsov teaches us about how to “survive” changes to database objects. Alex brings to light how simple changes to the underlying schema could be damaging to performance and accuracy of the code that touches the objects to be changed.
Three… Read more
Maybe I need a better name for it, but I’m describing the pain that happens when you’re getting ready for vacation and returning from one. I bet most of you have gone through it, and it’s easy to get to the point where going on vacation seems like more trouble… Read more