Resources

Articles
Click here to see all of the articles Allan has written for SQL Server Magazine.

 

Books Written, Reviewed, or Contributed To (Newest to Oldest)

 

Recommended Reading

  • Microsoft SQL Server 2008 Internals (Microsoft Press, 2009) – Written by Kalen Delaney, et al. Great reference book. It can be found in a paperback print edition or Kindle book.
  • Professional SQL Server 2008 Internals and Troubleshooting (Wrox, 2010) – Excellent book by a bunch of SQL Server folks including SQL luminaries Brent Ozar, Cindy Gross, and Jonathan Kehayias (and more). It can be found in a paperback print edition or Kindle book.

 

Presentation Decks

 

Scripts

 

SQL Server Links

  • Brent Ozar PLF – This is the home base of Brent Ozar, Jeremiah Peschka, Kendra Little, and Tim Ford.
  • Confio – Confio makes tools for SQL Server, and is home to SQL Server MVP Tom LeRock.
  • Data Education – SQL Server MVP Adam Machanic’s training company offering courses in the Boston, MA area from many of the top SQL experts in the world.
  • Idera – Idera makes tools for SQL Server.
  • Inside SQL Server- This is Kalen Delaney’s page for her Inside SQL Server books, and it contains a lot of good information as well as errata for the books.
  • SolidQ – Allan sometimes does work with the folks over at SolidQ.
  • Quest – Quest makes tools for SQL Server and is home to SQL Server MVP extrodinaire Kevin Kline.
  • Redgate – Redgate makes tools for SQL Server, and is home to such SQL Server MVPs as Steve Jones and Grant Fritchey.
  • SQLPeople – SQL Server MVP Andy Leonard‘s new community focused page for SQL Server.
  • SQL Sentry – SQL Sentry makes tools for SQL Server, including the ever-useful Plan Explorer. SQL Server MVP Aaron Bertrand works for SQL Sentry.
  • SQL Skills – This is the home base of Kimberly Tripp, Paul Randal, Jonathan Kehayias, and Joe Sack.

 

Webcasts (Newest to Oldest)

 

Whitepapers Written or Contributed To (Newest to Oldest)

SQLHA Experts Tip #6

Allan Hirt
Partner
Follow:
LinkedIn Twitter

Benchmark/baseline performance from the start and continue to do it throughout a solution’s lifecycle. Usage (such as the number of users, which adds load) will change over time and you should be able to understand what “normal” looks like to anticipate problems as well as keep track of usage for future capacity planning.