YOUR CHANNEL IS LOADING
  • 1

    Provisioning

  • 2

    Trusting Systems

  • 3

    Understanding HA

  • 4

    How do you solve T-SQL problems?

  • 5

    Morphing Microsoft

The Voice of the DBA The Gambler

MEVIOtoday

Mar 13, 2013 The Gambler

In April of this year, the SQL Intersection conference is coming to Las Vegas. I'm speaking, along with Grant Fritchey and many others. It's a fun event, in a city with a huge variety of things to do in the evenings after a full day of SQL Server sessions. I tend to look for networking chances to meet and catch up with people at night, though there have been a few times a comedy show has enticed me away from my hotel. I like Las Vegas, though I'm not a gambler. Despite the fact that most people think of visitors looking for their chance to sit at a table with dice or cards, there are many of us that go for other activities.

I was at in a session recently and heard a speaker recommend that the audience run DBCC checks regularly. That's good advice, and it's what I recommend in my sessions as well. A person in the audience raised their hand and politely disagreed, saying that they almost never run DBCC CHECKDB. This person found it to be a waste of resources since they'd never encountered corruption in their career, and hadn't known anyone in over a decade that had experienced on a SQL Server system. This person asked the speaker how many times the speaker had seen corruption (five was the answer) and then said across thousands of days of backups, it just wasn't worth the resources to run DBCC CHECDB.

 

Read the rest of "The Gambler" at SQLServerCentral.