We’re up to a staggering 54 syndicated blogs at SQLServerPedia from 57 bloggers! (We’ve got a couple of husband-and-wife blogging teams and a pair of friends sharing a blog.) Here’s the new guys this week:
Jason Brimhall (Blog – @SQLRnnr)
Jason works primarily with SQL 2000 and SQL 2005, performance tuning queries and then implementing SSIS solutions as the business requires. He’s also starting to delve into SSRS. He has supported clients hosting over 1 million users per day and has been responsible for turning a database that was a sore eye for the company into a talking point of high performance. Jason has been blogging since the start of 2010. Some of his recent blog posts include:
- Stepping Stone Certification – Jason’s advocating an independent certification between the MCITP (seen as too easy to pass) and the MCM (seen as too expensive & hard). I agree on the need, but I don’t think it’s practical for the community to take on. They’re talking about review boards, which instantly inflates the price tag by a *lot*. It’s nice to think volunteers will accomplish the review board part, but it’s not practical in the real world. Say you’ve got 1,000 people per year who want to go in front of the review board for 1 hour each, and you need 3 people on the review board. Now schedule it all, and throw in retakes. Riiight. I love watching this discussion though.
- What’s Taking Up Space? – Jason moved all the objects out of his primary filegroup, and then couldn’t understand what was still taking up space. I remember being in this exact situation myself, and I didn’t solve it anywhere NEAR as well as Jason did!
- Capturing IP Addresses of Logins – Ever want to find out who’s using a shared SQL authentication login?
Valentino Vranken (Blog)
Valentino Vranken is a Senior SQL Server Consultant working for Ordina, Belgium (Europe). When he started his career over ten years ago he was developing applications using C++ and SQL Server 7.0. Over the years he gathered experience using various programming languages to manipulate data in SQL Server databases. Nowadays his focus is more on Business Intelligence implementations, still using SQL Server. Valentino is a MCP with currently two MCTS certifications on SQL Server 2008. Besides writing articles and blogging, he’s active on forums and recently he has also become a core member of the Belgian SQL Server User Group. Some of his recent posts are:
- Importing Excel Data Using SSIS – Start-to-finish tutorial with plenty of screenshots. This will come in handy as users start to use PowerPivot and they tell you, “I’ve got this big old spreadsheet that I never update, but I use for lookup data. Can you bring it into the data warehouse?”
- Reading Excel Data with OPENROWSET() – if you just need to query the data short-term, here’s an easier way.
- Recursively Delete Folders in SSIS – holy moly, this is harder than it sounds.
These guys are putting out some great work, and I’m excited to start reading their stuff!
I’ll definitely be reading Vranken’s blog.Good Stuff.
Thanks Brent. It is also good to hear additional comments about the in-between certification. Agreed that a review board could get costly. We’re still trying to hammer some of those details out.
Welcome Jason and Valentino – good to have you on board.
Thank you David and Christian for welcoming me, and congrats to Jason as well for getting his blog syndicated here. And of course to Brent, now the world knows that I occasionally write something about SQL Server
Regards, Valentino.