Roundup from Simple Talk and Beyond – March 14 2014

Simple-Talk Updates

…in which we give a short review of the latest articles on Simple-Talk in the past fortnight, dig up some old favourites, and mention some of our favourite articles and blogs from around the InterWebs.

This week on Simple-Talk we published the first article by a new author, Joshua Feierman on ‘Applying The Scientific Method to SQL Server Performance Tuning’. It is an interesting topic because it really applies to any type of bug-hunting, and he approaches it with freshness and clarity. SQL Server people may find what he says self-evident, but many of the less experienced DBAs and developers tend to struggle with finding successful strategies for dealing with performance problems, and so will find his ideas useful. Whatever your experience, Josh’s article should be a handy resource to point colleagues towards.

Jaap Wesselius, one of our most popular authors, has returned with an interesting advocacy of Private Cloud, ‘Private Cloud, What Is It and Why Do You Need I?” It should be a godsend to larger enterprises because it takes the pressure off the inevitable inertia in the provision of IT resources. Large companies currently find it very difficult to react quickly to the needs of rapid development. It also simplifies the internal accounting process. Most of all, the concerns about the security of the public cloud simply won’t go away. Is the technology for Private Cloud now mature enough for corporate IT? Jaap thinks so.

Laerte Junior’s series on PowerShell continues to develop, and now that he’s moved beyond the basics, his enthusiasm glows out of the page. He just loves the power that scripting can give for a working DBA. Laerte is a SQL Server DBA, but his MVP is for PowerShell. Even if you’re not specifying and gathering performance counters, it is a good example of using the Cmdlet provided for the task and using it as intended. Don’t fight it: It is so much faster to do things the PowerShell way.

The presentations that Paul Randal and Kimberly L. Tripp give about SQL Server are always packed. Their blogs get more hits in a year than the population of several countries. They are a great team and it is just that ‘R’ came before ‘T’ in the alphabet that we chose Paul first to be Geek of the Week. Find out that he’s not really Scottish, he’s learning Chinese, he once worked for DEC, why he likes the #sqlHelp hashtag, and how he still has nerves before a presentation.

Joe Celko has a point about Dates. He’s not arguing that people should stop using the rather odd TSQL way of handling dates and times: he’s just wishing that SQL Server would allow developers to use the SQL Standard way of doing so. So Joe has attitude? We like writers who have a zeal and engagement with the topics they write about, and that is why Joe’s many books and articles are so easy to read.

Warwick Rudd returns on the topic of AlwaysOn Availability Groups. This time, he starts with an amazing story involving a script that was developed to load over 300 databases to a single Availability Group. Unsurprisingly, the subsequent execution brought the server so comprehensively to its knees that it was impossible even to log in normally. Yes, it is time to work out what is realistic and what isn’t by reading ‘AlwaysOn Availability Groups – What Not to do when Adding Databases

This week, Phil Factor has been busy updating a couple of articles quietly. The SQL Server Security Cribsheet and SQL Server Security Workbench were originally written in the far off days (February 2007) before SQL Server 2005 was widely used. Schemas were Owners then, and the changeover confused a lot of database developers. So at the time, it seemed wrong to base the article entirely on the new permissions hierarchy. He and Robyn always meant to update them but somehow never got around to it, until the recent wet weather drove Phil into the warm and dry to do the work.

From Around the Web

On SQLServerCentral, there was ‘SFTP, encrypt or compress data files in SSIS using custom components’ , SaaS and Multi-tenancy Models by Sean Woehrle, Using the Statistical Program R for Running Statistics by Tomaz Kastrun and SQL Server 2012 AlwaysOn Groups and FCIs Part 2 by Perry Whittle.

Our favourite articles in other sites include How to read and interpret the SQL Server log from Remus Rusanu: ‘Stop Tuning with Wait Stats Percentages’ from Brent Ozar, and ‘Retiring greybeards force firms to retrain Java, .NET bods as mainframe sysadmins‘ by Gavin Clarke