Thomas LeBlanc is a Data Warehouse Architect in Baton Rouge, and uses his 25 years in IT to help develop OLTP systems with normalized databases for high-performing T-SQL systems and end-to-end dimensional data marts using SSIS, SSAS, 3rd party apps, and Excel. His SQL Server certifications include MCSA 12, MCITP 08 BI and DBA, MCITP 2005 DBA, and MCDBA 2000. As a PASS volunteer, he is currently the Excel BI VC chair and past chair of Data Arch VC and VC Mentor. Local work includes the Baton Rouge SQL Server User Group and assisting with four SQLSaturdays. Bing TheSmilingDBA for more information about Thomas.
Where applications are evolved by gradually molding them to a growing understanding of the business domain, this presents great challenges to database development. If databases are designed too loosely, and initial errors are allowed to fester, the results become harder and harder to refactor until eventually they constitute a database time bomb. Thomas LeBlanc describes how to avoid a few basic, but very common, database time bombs. … Read more