Brent Ozar Unlimited® Weekly Links, February 9th Edition

We're in Denver this week teaching a class. We're definitely not smoking pot and skiing. Honest. Is this email not displaying correctly? View it in your browser. Jeremiah's Links Trace Flag Side Effects A list of trace flags, side effects, and sources for more reading. SQL Server and SSDs Bob Dorr's notes about SQL Server and SSDs. Sample Version Control Workflows Version control is important. Make sure you know which version control method is right for you. Brent's Links You're My Favorite Reader Horoscopes sound relevant because of The Forer Effect. Sys.dm_exec_requests Bug Some numbers roll past their datatype limits and go negative. Visualize the Speed of Light By riding along with a photon as it leaves the sun. Kendra's Links The Case of the Growing Transaction Log Maria found that after applying a service pack, her transaction logs kept growing and growing. Read the story of how she tracked down the the cause of the issue. Name Your Contraints I wholeheartedly agree with Kenneth -- never use the default constraint names in production code, it can create a hassle if you build a copy from source and need to do a schema diff. Doing Median the Hard Way SQL Server 2012 makes this easier, Rob helps you out if you don't have that luxury. Kendra explains Dropping an Offline Database in SQL Server Brent asks How Many Databases Can I Put on One SQL Server? Kendra on The Hard Truth About Patching SQL Server Availability Groups (Hotfixes, Cumulative Updates, and Service Packs) Join Kendra on Failing over an Asynchronous Mirror in SQL Server (video)   Free Every Tuesday - Office Hours with Brent Ozar Unlimited® April 17, Boston - Developer's Guide to SQL Server Performance - 1 day, $99 May 4-8, Chicago - Advanced Querying and Indexing - 5 days, $3,995 May 11-14, Chicago - SQL Server Performance Troubleshooting - 4 days, $3,195   Follow on Twitter Forward to a Friend Subscribe to Our Feed  follow on Twitter | subscribe to our feed | forward to a friend  Copyright © 2015 Brent Ozar Unlimited��, All rights reserved. We're sending you this because you signed up for the BrentOzar.com Community. If you no longer want these community recaps, please unsubscribe. We're all about staying at Inbox Zero too. Our mailing address is: Brent Ozar Unlimited�� 9450 SW Gemini Dr ECM #45779 Beaverton, OR 97008 Add us to your address book  unsubscribe from this list | update subscription preferences