Man, the intertubez were lively this week – tons of great links to share!
SQL Server Links
SQLBatman’s Dear Vendor letters – sounds like SQLBatman has been having a rough week with a vendor. Read them in order for maximum laughs:
List of Business Intelligence and Data Warehouse people on Twitter – Shawn Rogers compiled it and shared it in Google Docs – great idea. I love that he included a list of vendors on Twitter that don’t spam, and I made the cut! Woohoo! Let the spam begin! I copied some of the obviously-SQL people into the SQL Server Twitter list on SQLServerPedia, but I’d bookmark Shawn’s list because he’s got good people on there for Teradata and other systems.
SQLTrace – Helps find performance bottlenecks in your SQL code. Takes an SQL batch as its first argument, sets up a trace filtered to include the current connection only, runs the batch, and summarises the trace information per statement in the batch. (I haven’t used this yet, but it sounds cool.)
BCP Basics – the SQL Server Bulk Copy utility is one of those tools I only have to use once or twice a year, and I never remember how it works. Michelle does a great job of summing up what you need to know without doing a copy/paste from Books Online.
MySQL 5.1 released with crashing bugs – this is written by the founder of MySQL, mind you. My favorite quote out of the article: “If you are using MySQL 5.1 just as a ‘better’ version of MySQL 5.0 and you don’t plan to use any of the new features in MySQL 5.1 then you are probably fine to try out MySQL 5.1.”
Jasson Massie talks about SQLServerPedia – he’s the T-SQL Code Library Editor, and he explains why he thinks it’ll succeed. He’ll be on our live webcast on Thursday.
Jimmy May’s series on partition alignment continues – with a cheat sheet on the math involved.
Monitoring backups with Microsoft MOM/SCOM – Tom LaRock shows how to use Microsoft Operations Manager to make sure all of your databases are backed up. Quest Spotlight does this out of the box, but not all of you are lucky enough to use that product, and I know a lot of you are forced to use MOM because it’s a corporate policy. If you’re one of those folks, talk to Tom because he can help you make MOM work the way DBAs want it to work.
PASS Switzerland site now live – Charley Hanania’s putting in a lot of time to get the Professional Association for SQL Server up and running in Switzerland.
People listen to the loudest noise – a comic from Indexed. I’d like to think I fall in group B:
Cloud and Virtualization Links
Amazon SimpleDB changes – was private beta, now “unlimited beta” – whatever – but the interesting thing for me is one of the upcoming features: “We are planning to release a SQL-like SELECT API as well as a Batch Put operation to streamline uploading of multiple items or attributes.” Yay! I’m all for competition because I want Microsoft SDS to have a select-style API as soon as possible.
The Junk Drawer
Real Advice Hurts – I adore this quote: “Somewhere, a sad, obese man in pristine ASICS scarfs cookie dough over an unopened _Runner’s World_, complaining that he needs more ‘tips.’”
Similicio.us – put in a web site, and it’ll find similar web sites. Useful, but the damn thing is down more often than it’s up.
The 24 Hours of LeMons by Autoblog – The 24 Hours at LeMans is a famous auto race featuring the best of the best, the toughest of the tough. This is not that race – it’s LeMons – not LeMans, LeMons, as in lemons. The goal is to take a really cheap car and get it to survive the race as long as possible. This year, Autoblog is entering, and this is the first part in their series of articles detailing their preparations.
[...] Brent Ozar – SQL Server & Cloud Links for the Week [...]