Wow – I’m an Author!

I'm very proud to have contributed a chapter to Tribal SQL, which is now available for purchase at Amazon and finer bookstores everywhere. This is the first book I've had any part in writing, something I never thought I would do. I always hated English and literature classes in school - if it wasn't math, hard science, or architectural history, I wanted no part of it. I credit the SQL community and blogging for slowly getting me excited about the written word. Getting this book from idea to print was not a sprint but a marathon. While I'm sure there was plenty going on behind…
Read More

Speaking at MADPASS This Week

Tomorrow I am making the trek up to Madison to speak at MADPASS! I had a great time there last year and am looking forward to heading back. I'll be giving my talk on SQL Server's data compression feature entitled "The Skinny on Data Compression." I'll be explaining how data compression works and sharing some of the things I've learned about when and where to deploy data compression that I've accumulated over the past 2 years of using it. Greg Kramer will also be presenting tips and tricks regarding DAX that both Excel and SQL professionals should find useful. WHERE: 2310 Crossroads Drive, Madison, WI…
Read More

Moving A Database to New Storage With No Downtime

It's once again the second Tuesday of the month, meaning it's T-SQL Tuesday! This month's topic comes to us from Jen McCown (blog | @JenniferMcCown). Jen is asking us to share our knowledge about filegroups, and it just so happens that I have a story about migrating to new storage that involved a large number of file and filegroup operations. The Problem At work we have been very fortunate to get a new SAN, and I was charged with moving data from the old SAN to the new one. This data falls under 2 main groups: large numbers of small…
Read More

Bigger Databases Aren’t Always Better

I'm fortunate to be able to work with some rather large SQL Server instances on a daily basis, including databases over 25TB in size. Due to their bulk, "VLDBs" (Very Large Databases) present some challenges for DBAs: following best practices for small transactional systems might not be feasible on a VLDB. Regular maintenance processes such as backups and integrity checks take longer when there's more data to scan. You also really need to think twice before doing something like adding an index to a 2TB table! I've learned a ton about working with VLDBs in the time I've been at…
Read More

SQL Saturday Returns To Chicago A Fourth Time!

Where can you find deep dish pizza, questionable politics, amazing architecture and a great SQL Saturday all in one stop? Sweet Home Chicago! The organizing committee in the windy city has been hard at work, and SQL Saturday #211: Chicago 2013 is open for registration. This year the event will be taking place on Saturday April 13, 2013. DeVry University's Addison Campus is once again graciously allowing us to use their awesome facility. We're all looking forward to a great day of free SQL Server training, networking, and #SQLFamily in Chicagoland. Please join us! As in past years, the event…
Read More