What with so much awesome SQL Server and technology content being published each week, you can have a real tough time keeping up with it all. So if you’re like me and you have a bit of extra surfing time at the weekend, then you might like to use that time to catch up on all the weeks goodies.
So without further ado here is my weekly roundup of the action for you to get stuck into.
SQL Server Links
Understanding the VAS Reservation (aka MemToLeave) in SQL Server – Jonathan has put together a fantastic and detailed discussion of VAS (Virtual Address Space) reserveration in SQL Server. Grab a coffee before you get started though ;-) there’s a lot to get your head round here.
Renaming Your MS SQL 2008 Database – Thomas La Rock tells of his early days as a SQL Server padowan and how he tackled this problem we’ve all had to work on at some point.
How to Create a Server-Side Trace with SQL Profiler – Jorge Segarra provides this excellent walkthrough.
5 Common Mistakes with Tempdb – Short, simple and good points to be aware of. Courtesy of Strate SQL.
Clone Database – This is very cool! You can take a meta data copy of your database and use it as a clone to generate estimated execution plans without the overhead of all the table data. For example, you can use this technique to see how your database query plans will be effected by new server hardware setup.
Top 10 SQL Server Connect Items by votes – Michael Swart blogs on his findings researching popular SQL Server Connect items.
So You Want To Learn Business Intelligence – Aaron Alton posts the second installment of his adventures into the world of Business Intelligence with SQL Server.
Misc Techie Stuff
Scaling up vs. Scaling out – Jasson Massie gives his take on Jeff Atwood’s recent blog post of the same topic.
Death of the IT Professional? – The British Computer Society (BCS) published an e-article speculating on the future of the IT professional. Thought provoking stuff.
My Random Pick of the Week
TechCrunch dubs Linux a ‘big ol’ bag of drivers -Brilliant humourus discussion about the recent google announcement to provide an operating system for netbooks.
Have a great weekend.