Last Wednesday I delivered a webinar for Confio titled “Database Design: Size DOES Matter”. I had a piece of code at the end that evaluated defined datatypes to the current data values in those columns. The idea being that if a column is defined as BIGINT but contains values that are best defined as a … Read more
The recording of my recent webinar for Confio has been made available and you can go here to register to watch (registration required, but it is FREE). Here is the abstract: “Great database performance starts with great database design. During the design process it is important to select your SQL Server datatypes wisely. Failure to do … Read more
Great database performance starts with great database design. I have yet to meet someone to argue with that statement. I have, however, met many a database that has a less than optimal design. Sometimes this is due to the evolution of the database; it was built for one purpose and it is now being used … Read more
You have more options than just the DBA. I’ve put a few into this sheet that you can print out and hang in your cubicle, or on bulletin boards in the office, or on telephone poles…and I already took one for myself. You can have the rest. Enjoy!
The fifth and final episode for Be The Next Microsoft Employee went live today and I could not wait to watch. The first four weeks we got a lot of insight into the candidates and into Microsoft. We learned which of the candidates had stronger technical skills and which ones had stronger communication skills. We … Read more
You’re transaction log files are a mess. You don’t think so, but it’s true. Too many times I have seen transaction logs treated without care; they are placed on the same disk drives as the data files or they are placed on drives not optimized for write activity. I have even seen admins who fail … Read more
