Something for the Weekend – SQL Server Links 11/02/11

SQL Server Links

• Importance of network latency when using database mirroring – The results are in and Paul Randal provides his analysis. I’ve got to say the discussions did make me do a double take on my Mirrored environments and I suggest you do the same.
• Free Poster! Guide to SQL Server Isolation Levels – Artistic flair from Kendra Little.
• Are we Borg? – Getting all Philosophical and Trekie it’s Tobor Karaszi.
• SQL University – Security Week – Another lesson from Thomas Larock with this weeks SQL University subject, Security.
• What does high wait in SOS_SCHEDULER_YIELD mean? – The Replication Team blog looks in more detail at whether a high value for this Wait Type is actually something to be concerned with.
• Replicating data loaded with BCP or Bulk Insert – Some good tips here for managing your replicated traffic appropriately when importing data at the Publisher via BCP or BULK INSERT, courtesy of those clever chaps from the Microsoft SQL Server Replication Support Team.
• Pinal Dave: Blogger, MVP and now Interviewee – A brilliant insight here into one of the communities biggest characters, with this interview hosted by Michael J Swart.
• Maintaining Your Sanity While Managing Large Environments – Good advice on such matters is actually tough to come by so make sure you make the most of it. Great stuff from Jonathan Kehayias.
• Windows Azure Use Case: New Development – This week it’s another Case for Buck Woody, no not the criminal trial sort, a Use Case. Yet even more reasons why you should be using SQL Azure.
• Opportunity Cost versus Real Cost – Do you know the difference? Joe Webb discusses this very important distinction and why it matters to the Data Professional.
• SQL Server service does not start | An error occurred during encryption – This week yet even more real world support cases from Pradeep Adiga, does nothing just work in this guys shop :-) Pradeep was also recently awarded the Microsoft Community Contributor Award. Nicely done sir!
• Data Durability – Discussing this issue across a number of database technologies it’s Jeremiah Peschka.
• How Should I Present? – I know I’ve been asking myself this very same question of late. If you’re thinking about speaking/presenting then you’ll want to read this excellent post, from Mike Walsh.
• Why can’t I open SQL Server Management Studio – Oh well, I’ll be heading off for the day then. What? You mean there is a fix for this. Saving the day it’s the CSS SQL Server Engineers to the rescue.
• SQL Server RBS Performance with SharePoint Server 2010 – A new White Paper is available from those clever folks in the SQL Server CAT. Not only do they get to play with the best toys but they’re nice enough to write about it to!