May 20 2010
I will be presenting on two topics at SQL Saturday #27 in Portland, OR this weekend: Backup and Disaster Recovery for N00Bs and Indexing Dynamic Management Views. It’s going to be exhausting, but fun: out of Detroit at 8pm EDT – Into Portland around 11pm PDT (that’s 2 AM “real” time folks if you don’t [...]
May 17 2010
I alluded to taking the time to chart out a recent conversation that took place between myself and Jeremiah Peschka (blog|twitter). Before you proceed I want to stress that we were both sober. It highlights though just how prone people in our profession are towards the shiny side of life. The distractions abound for those [...]
May 17 2010
SQL Sentry is sponsoring the first SQLCruise, a 4-day training event aboard the Carnival Imagination for the amazing low price of $295.00 + cost of the cruise. Official contest details and rules are available here. Details about SQLCruise, the itinerary, class schedule, trainers, and events are available at SQLCruise.com. You can also follow SQLCruise on [...]
May 14 2010
Paul Randal recently streaked through the the family picnic and tossed-down a hornet’s nest on the dessert table by starting a meme on which five things Microsoft should drop from their SQL Server product. I came to this party late – and uninvited – but I’m going to go ahead and drop my junk in [...]
May 11 2010
I love seeing good documentation in code. I really love seeing honest documentation in code. Seeing comments that basically show the developer has given up, hacked together a poor workaround to get a tasked accomplished at the cost of performance for every customer… full of Awesome. This is slightly redacted code from a stored procedure [...]
May 10 2010
#11 – Memory Settings Unless you have been working with SQL Server for a while, you may not go into the Server Properties or Facets and tweak much of anything after a successfull install. After all, there are a great deal of things out there and it can be really confusing. Let’s keep it really [...]
May 6 2010
Paul Randal identified an issue in the SQL Server Missing Index DMVs (pre-SQL 2008R2) wherein they will, under the right wrong circumstances, recommend indexes that do already exist. This means that either missing is a subjective term or there is a bug in SQL Server 2005 and 2008. With the right people involved a great idea [...]
May 3 2010
That’s right. We’re on a boat and Autotune is forbidden. So is Auto_Growth. But SQLCruise? What is SQLCruise? Is it a SQL Saturday afterparty? Is it a Tweet-up at sea? Is it a new training event unlike anything else that you’ve ever heard of? Kind of, sort of, and oh yes indeed! SQL Saturday [...]
