Louis has been in the IT industry for over 20 years as a corporate database developer and data architect. Currently he is the Data Architect for CBN in Virginia Beach. Louis has been a Microsoft MVP since 2004, and is an active volunteer for the PASS locally and globally. He is the author of a series of SQL Server Database Design books, most recently Pro SQL Server Relational Database Design and Implementation.
SQL Server Indexes need to be effective. It is wrong to have too few or too many. The ones you create must ensure that the workload reads the data quickly with a minimum of I/O. As well as a sound knowledge of the way that relational databases work, it helps to be familiar with the Dynamic Management Objects that are there to assist with your indexing strategy.… Read more
Before you can tackle any performance issues with a working database, you need to know which queries to work on first: The ones that are taking the most time in total, and which are the most expensive in terms of cache, CPU and disk. Although SQL Server Management Studio can help, it isn't long before you need an armoury of DMVs to provide you the statistics to find the culprits. … Read more
This is the book that will de-mystify the process of using Dynamic Management Views to collect the information you need to troubleshoot SQL Server problems. It will highlight the core techniques and "patterns" that you need to master, and will provide a core set of scripts that you can use and adapt for your own requirements.… Read more
OK Simple-Talkers I have a interesting situation driving be nuttier than squirrel poo. I have the following 2 steps in a scheduled SQL job I use to backup logs. If for some reason a log file does not exist it will throw the error 22049. I trap for it and want it to proceed with the … Read more
Here it is, the last day of PASS 2007 and I find myself in a melancholy that comes with the last day of summer camps from many years past. We are all far past the stage of being exhausted, yet not ready to seek out the family come to collect me and take that long … Read more
Here it is day two and I am finally starting to get adjusted to the time difference. Wimp. Sure, I thought I had it bad. Two entire time zones between my native Michigan and Denver. I always lose touch with just how global PASS is. I was attending Peter Ward’s fantastic spotlight session on Engineering for the … Read more
Volunteer meetings, PASS business, PASS SIG Quizbowl, Welcome Reception, SQL Server Central Party and the subsequent after party and after-after party, General Session and four breakout sessions and man is my brain tired! It’s all just a part of being at PASS and being involved in PASS. Sure it is a great deal of work, but … Read more