{"id":2144,"date":"2014-01-19T12:47:39","date_gmt":"2014-01-19T12:47:39","guid":{"rendered":"http:\/\/ruirib.net\/blog\/?p=2144"},"modified":"2014-01-19T16:12:32","modified_gmt":"2014-01-19T16:12:32","slug":"my-links-of-the-week-january-19-2014","status":"publish","type":"post","link":"https:\/\/ruirib.net\/index.php\/2014\/01\/my-links-of-the-week-january-19-2014\/","title":{"rendered":"My links of the week &#8211; January 19, 2014"},"content":{"rendered":"<style type=\"text\/css\"><\/style><p>Here are my choice of links for the past week.<\/p>\r\n<ul>\r\n<li>SQL Server:\r\n<ul>\r\n<li class=\"betterSpacedBullets\">Gail Shaw&#8217;s <a href=\"https:\/\/www.simple-talk.com\/sql\/performance\/sql-server-deadlocks-by-example\/\">SQL Server Deadlocks by Example<\/a>\u00a0provides a good overview of deadlocks in SQL Server, with advice on how to detect and avoid them.<\/li>\r\n<li class=\"betterSpacedBullets\">Thomas Kejser&#8217;s <a href=\"http:\/.kejser.org\/2014\/01\/12\/clustered-indexes-vs-heaps\/\">Clustered Indexes vs. Heaps<\/a>\u00a0analyses common table usage scenarios to determine whether using clustered indexes is a good option.<\/li>\r\n<li class=\"betterSpacedBullets\">Keeping with the clustered index subject, Marcus Winand&#8217;s\u00a0<a href=\"http:\/\/use-the-index-luke.com\/2014-01\/unreasonable-defaults-primary-key-clustering-key\">Unreasonable Defaults: Primary Key as Clustering Key<\/a>\u00a0provides a detailed analysis of what a clustered index is and how it affects other existing table indexes, leading to the (implied) question of whether setting a primary key as a clustered index is a good option at all.<\/li>\r\n<li class=\"betterSpacedBullets\">Juergen Thomas&#8217;s <a href=\"http:\/s.msdn.com\/b\/saponsqlserver\/archive\/2014\/01\/16\/new-functionality-in-sql-server-2014-part-2-new-cardinality-estimation.aspx\">New functionality in SQL Server 2014 \u2013 Part 2 \u2013 New Cardinality Estimation<\/a>\u00a0explains the role of cardinality estimation in query execution, addresses the changes in cardinalily estimation in SQL Server 2014 and provides some examples of how the changes affect query execution. An excellent read.<\/li>\r\n<li class=\"betterSpacedBullets\">Paul White&#8217;s <a href=\"http:\/\/www.sqlperformance.com\/2014\/01\/sql-plan\/cardinality-estimation-for-multiple-predicates\">Cardinality Estimation for Multiple Predicates<\/a>\u00a0also addresses the subject of cardinality estimation, but covers the use of multiple predicates in a query. The article shows how the default behavior can be avoided through the use of trace flags. It also addresses the changes in cardinality estimation and the use of related trace flags in SQL Server 2014.<\/li>\r\n<li class=\"betterSpacedBullets\">Thomas LaRock&#8217;s <a href=\"http:\/\/thomaslarock.com\/2014\/01\/restore-the-master-database-in-sql-server-2012\/\">How to: restore the master database in SQL Server 2012<\/a>\u00a0shows how the master database can be restored in a SQL Server 2012 instance.<\/li>\r\n<li class=\"betterSpacedBullets\">Tim Wieman&#8217;s <a href=\"http:\/s.msdn.com\/b\/sqlcat\/archive\/2014\/01\/16\/scaling-out-sql-server-disks-and-data-files-on-windows-azure-virtual-machines-a-real-world-example.aspx\">Scaling-out SQL Server disks and data files on Windows Azure Virtual Machines\u2026a real-world example<\/a>\u00a0provides an example of scaling out disks and data files (in this case for TempDB) on an Azure VM. The article includes many useful reference links.<\/li>\r\n<li class=\"betterSpacedBullets\">Hugo Kornelis&#8217;s <a href=\"https:\/\/www.simple-talk.com\/sql\/t-sql-programming\/generating-test-data-in-tsql\/\">Generating Test Data in TSQL<\/a>\u00a0addresses test data generation, in a situation where the data needs to follow a distribution and columns are not independent.<\/li>\r\n<li class=\"betterSpacedBullets\">Brent Ozar&#8217;s\u00a0<a href=\"http:\/\/www.brentozar.com\/archive\/2014\/01\/how-to-query-the-stackexchange-databases\/\">How to Query the StackExchange Databases<\/a>\u00a0shows how the Stack Exchange databases can be accessed and queried, both through a browser or actually downloading the data to a local instance of SQL Server. If you ever need real data for query tuning, the article shows a way to get it.<\/li>\r\n<li class=\"betterSpacedBullets\">Glen Berry&#8217;s <a href=\"http:\/\/www.sqlskills.coms\/glenn\/sql-server-diagnostic-information-queries-for-january-2014\/\">SQL Server Diagnostic Information Queries for January 2014<\/a>\u00a0includes the latest version of the author&#8217;s diagnostic information queries.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Web Design and Development:\r\n<ul>\r\n<li class=\"betterSpacedBullets\">Jon Galloway&#8217;s <a href=\"http:\/\/weblogs.asp.net\/jgalloway\/archive\/2014\/01\/17\/asp-net-a-last-look-back-at-2013-looking-ahead-to-2014.aspx\">ASP.NET &#8211; A last look back at 2013, looking ahead to 2014<\/a>\u00a0is a good overview of what happened with ASP.NET during 2013 and what to expect in 2014, with links to many resources relevant for those who work with ASP.NET.<\/li>\r\n<li class=\"betterSpacedBullets\">Shawn Wildermuth&#8217;s <a href=\"http:\/\/wildermuth.com\/2014\/1\/17\/Why_Should_You_Care_About_NodeJS\">Why Should You Care About NodeJS?<\/a>\u00a0explains what .NET developers can learn from NodeJS and why they should have \u00a0a look at it and consider using it in some projects.<\/li>\r\n<li class=\"betterSpacedBullets\">Steve Hansen&#8217;s <a href=\"http:\/\/sdt.bz\/content\/article.aspx?ArticleID=67571&amp;page=1\">HTML5: Myths and misconceptions<\/a>\u00a0provides a bit of history on HTML 5 and tries to debunk some of the rising myths about what it is and what it offers.<\/li>\r\n<li class=\"betterSpacedBullets\">Jonathan Cutrell&#8217;s <a href=\"http:\/\/webdesign.tutsplus.com\/articles\/industry-trends\/web-design-2014-what-to-watch-out-for\/\">Web Design 2014: What to Watch Out For<\/a>\u00a0makes some predictions on what to expect on the field of web design, for 2014.<\/li>\r\n<li class=\"betterSpacedBullets\">Pete Hodgson&#8217;s <a href=\"http:\/\/programming.oreilly.com\/2014\/01\/keeping-jquery-in-check.html\">Keeping jQuery in Check<\/a>\u00a0proposes a segregated DOM to avoid the pitfalls of what the author describes as &#8216;jQuery soup&#8217;, an indiscriminate intermingling of $ references, AJax calls, application logic and business rules.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Big Data \/ BI:\r\n<ul>\r\n<li class=\"betterSpacedBullets\">Josh Polsky and Yaniv Mor&#8217;s <a href=\"http:\/\/www.bigdata-startups.com\/etl-relevant\/\">ETL \u2013 Is it Still Relevant?<\/a>\u00a0states that ETL is still very much relevant in big data scenarios and explains why.\u00a0<\/li>\r\n<li class=\"betterSpacedBullets\">Merv Adrian&#8217;s\u00a0<a href=\"http:\/s.gartner.com\/merv-adrian\/2014\/01\/13\/aaa-is-not-enough-security-in-the-big-data-era\/\">AAA is Not Enough Security in the Big Data Era<\/a>\u00a0argues for the need of anonymization or deidentification in an era, where big data will be increasingly used for medical, commercial and security reasons.<\/li>\r\n<li class=\"betterSpacedBullets\">Alexei Khalyako&#8217;s <a href=\"http:\/\/alexeikh.wordpress.com\/2014\/01\/14\/expanding-hdp-hadoop-file-system-to-azure-blob-storage\/\">Expanding HDP Hadoop file system to Azure Blob Storage<\/a>\u00a0shows how to take advantage of the cheap cost and scalability of Azure Blob Storage, expanding available storage beyond the 16TB available in a HD Insight cluster.<\/li>\r\n<li class=\"betterSpacedBullets\">Rob Kerr&#8217;s <a href=\"http:\/\/msbiacademy.com\/?p=6291\">Submitting C# MapReduce jobs on Windows Azure HDInsight<\/a>\u00a0is a video showing how to create and execute C# MapReduce jobs on Azure&#8217;s HDInsight.\u00a0<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>That&#8217;s it for this week. Thanks for reading.<\/p>","protected":false},"excerpt":{"rendered":"Here are my choice of links for the past week. SQL Server: Gail Shaw&#8217;s SQL Server Deadlocks by Example\u00a0provides a good overview of deadlocks in SQL Server, with advice on how to detect and avoid them. Thomas Kejser&#8217;s Clustered Indexes vs. Heaps\u00a0analyses common table usage scenarios to determine whether using clustered indexes is a good&#8230;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73,16,2,77],"tags":[210,212,61,258,209,207,206,211,153,213,208,157,253],"class_list":["post-2144","post","type-post","status-publish","format-standard","hentry","category-links-of-the-week","category-software","category-sql-server","category-web-development","tag-asp-net","tag-azure-blob-storage","tag-azure-sql-vm","tag-big-data","tag-cardinality-estimation","tag-clustered-index","tag-deadlocks","tag-etl","tag-hd-insight","tag-map-reduce","tag-master-database","tag-node-js","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/posts\/2144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/comments?post=2144"}],"version-history":[{"count":21,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/posts\/2144\/revisions"}],"predecessor-version":[{"id":2335,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/posts\/2144\/revisions\/2335"}],"wp:attachment":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/media?parent=2144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/categories?post=2144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/tags?post=2144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}