Log Buffer #190, A Carnival of the Vanities for DBAs
May 28, 2010 / By Vanessa Simmons
Chen Shapira was eager to share news early this week, sending along her favorite picks on Tuesday.
Prof. Neil Gunther doesn’t like the way commercial load testing software distributes think times.
Miladin Modrakovic wants to add columns to a table and initialize them with values. When the table is huge, updates can take too long. No worries! Datapump will save the day!
Chris Presley contributed a few good SQL Server archive articles:
One which talks about data compression commands in SQL 2008 and 2008 R2. And another which highlights a difference in SQL Business Development Studio (SQL BIDS) between SQL 2008 and 2008 R2 for anyone that uses SQL Integration Services (SSIS).
For MySQL, Vadim posts FlashCache: tpcc workload – the last in a series on FlashCache testing when the cache is placed on Intel SSD card.
Ronald Branford notes in MySQL Best Practices: User Security – that it is critical that to not use the default MySQL installation security because it’s insecure.
Lastly we wrap up with a few more were archives added by Alex Fatkulin that didn’t get out last week.
Until next week.