{"id":2334,"date":"2014-01-26T11:00:41","date_gmt":"2014-01-26T11:00:41","guid":{"rendered":"http:\/\/ruirib.net\/blog\/?p=2334"},"modified":"2014-01-27T07:44:31","modified_gmt":"2014-01-27T07:44:31","slug":"my-links-of-the-week-january-26-2014","status":"publish","type":"post","link":"https:\/\/ruirib.net\/index.php\/2014\/01\/my-links-of-the-week-january-26-2014\/","title":{"rendered":"My links of the week &#8211; January 26, 2014"},"content":{"rendered":"<style type=\"text\/css\"><\/style><p>Here are the links for the past week.<\/p>\r\n<ul>\r\n<li>SQL Server:\r\n<ul>\r\n<li class=\"betterSpacedBullets\">Jes Schultz Borland&#8217;s <a href=\"http:\/\/www.brentozar.com\/archive\/2014\/01\/improving-the-performance-of-backups\/\">Improving the Performance of Backups<\/a>\u00a0suggests a few ways to improve the performance of backup operations. The comments also suggest further reading with additional great advice.<\/li>\r\n<li class=\"betterSpacedBullets\">Hugo Kornelis&#8217;s <a href=\"http:\/\/sqlblog.coms\/hugo_kornelis\/archive\/2014\/01\/19\/parameterization-and-filtered-indexes-part-1.aspx\">Parameterization and filtered indexes (part 1)<\/a> and <a href=\"http:\/\/sqlblog.coms\/hugo_kornelis\/archive\/2014\/01\/19\/parameterization-and-filtered-indexes-part-2.aspx\">Parameterization and filtered indexes (part 2)<\/a>\u00a0address the issue of possible interference from filtered indexes in SQL Server&#8217;s ability to perform query parameterization and concludes that, when using filtered indexes, setting the database to use simple parameterization may be a preferable solution to forced parameterization. A good read.<\/li>\r\n<li class=\"betterSpacedBullets\">Grant Fritchey&#8217;s <a href=\"http:\/\/www.scarydba.com\/2014\/01\/20\/time-for-a-quick-rant\/\">Time for a Quick Rant<\/a>\u00a0is an interesting rant about what appears a rather common decision on not performing database backups when &#8220;the database is too big to be backed up&#8221;. The comments also offer some good advice on how to address backups in situations where the database is really big.<\/li>\r\n<li class=\"betterSpacedBullets\">Robert L. Soldier&#8217;s <a href=\"http:\/\/www.sqlsoldier.com\/wp\/sqlserver\/schemaonlybackupsandrestores\">Schema-only Backups and Restores<\/a>\u00a0shows how a backup and restore of a database schema can be done using a DACPAC.<\/li>\r\n<li class=\"betterSpacedBullets\">Klaus Aschenbrenner&#8217;s <a href=\"http:\/\/www.sqlpassion.at\/archive\/2014\/01\/21\/myths-and-misconceptions-about-transaction-isolation-levels\/\">Myths and Misconceptions about Transaction Isolation Levels<\/a>\u00a0provides some insightful advice on transaction isolation levels and how the expected SQL Server behavior regarding isolation levels may be changed, in certain circumstances, by SQL Server.<\/li>\r\n<li class=\"betterSpacedBullets\">Arshad Ali&#8217;s <a href=\"http:\/\/www.databasejournal.com\/features\/mssql\/getting-starting-with-change-data-capture-cdc-in-sql-server-part-1.html\">Getting Starting with Change Data Capture (CDC) in SQL Server \u2013 Part 1<\/a>\u00a0explains what Change Data Capture (CDC) is and how it can be used to capture data changes in a tracked table.<\/li>\r\n<li class=\"betterSpacedBullets\">Dinesh Asanka&#8217;s <a href=\"http:\/\/www.sql-server-performance.com\/2014\/default-database-best-practices\/\">Default Database Issues and Best Practices<\/a>\u00a0suggests the master database is not the best option for default database and suggests a better alternative.<\/li>\r\n<li class=\"betterSpacedBullets\">Jason Strate&#8217;s\u00a0<a href=\"http:\/\/www.jasonstrate.com\/2014\/01\/webcast-follow-up-the-flavors-of-non-clustered-indexes\/\">Webcast follow-up: the flavors of non-clustered indexes<\/a>\u00a0is a very interesting webcast on non-clustered indexes.<\/li>\r\n<li class=\"betterSpacedBullets\">Daniel Farina&#8217;s\u00a0<a href=\"http:\/\/www.mssqltips.com\/sqlservertip\/3120\/whats-new-in-sql-server-2014-is-it-worth-the-upgrade\/\">What&#8217;s new in SQL Server 2014? Is it worth the upgrade?<\/a>\u00a0covers some of the most relevant new features in SQL Server 2014.<\/li>\r\n<li class=\"betterSpacedBullets\">Brent Ozar&#8217;s\u00a0<a href=\"http:\/\/www.brentozar.com\/archive\/2014\/01\/sp_blitz-v32-emailing-serializable-locking-simultaneous-agent-jobs-and-more\/\">sp_Blitz\u2122 v32: Emailing, Serializable Locking, Simultaneous Agent Jobs, and More<\/a>\u00a0presents the changes in the latest version of the famous sp_Blitz health check stored procedure.<\/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\">K. Scott Allen&#8217;s <a href=\"http:\/\/odetocode.coms\/scott\/archive\/2014\/01\/21\/angularjs-training.aspx\">AngularJS Fundamentals<\/a> provides a very useful set of links on Angular JS.<\/li>\r\n<li class=\"betterSpacedBullets\">Jon Galloway&#8217;s Looking at <a href=\"http:\/\/weblogs.asp.net\/jgalloway\/archive\/2014\/01\/21\/looking-at-asp-net-mvc-5-1-and-web-api-2-1-part-1-overview-and-enums.aspx\">ASP.NET MVC 5.1 and Web API 2.1 &#8211; Part 1 &#8211; Overview and Enums<\/a> and <a href=\"http:\/\/weblogs.asp.net\/jgalloway\/archive\/2014\/01\/24\/looking-at-asp-net-mvc-5-1-and-web-api-2-1-part-2-attribute-routing-with-custom-constraints.aspx\">Looking at ASP.NET MVC 5.1 and Web API 2.1 &#8211; Part 2 &#8211; Attribute Routing with Custom Constraints<\/a>\u00a0present some of the new features in the recent release of ASP.NET MVC 5.1 and Web API 2.1.<\/li>\r\n<li class=\"betterSpacedBullets\">Addy Osmani&#8217;s <a href=\"http:\/\/addyosmani.com\/largescalejavascript\/\">Patterns For Large-Scale JavaScript Application Architecture<\/a>\u00a0presents an interesting set of patterns for large-scale Javascript application architecture.<\/li>\r\n<li class=\"betterSpacedBullets\">Krasimir Tsonev&#8217;s <a href=\"http:\/\/flippinawesome.org\/2014\/01\/20\/dependency-injection-in-javascript\/\">Dependency Injection in JavaScript<\/a>\u00a0shows how dependency injection can be achieved in JavaScript.<\/li>\r\n<li class=\"betterSpacedBullets\">Sara Vieira&#8217;s\u00a0<a href=\"http:\/\/www.webdesignerdepot.com\/2014\/01\/how-to-kickstart-your-html\/\">How to Kickstart your HTML<\/a>\u00a0presents HTML Kickstart, a framework, characterized by its simplicity,that can be used to obtain quick front-end prototypes.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>Cloud computing:\r\n<ul>\r\n<li class=\"betterSpacedBullets\">Troy Hunt&#8217;s <a href=\"http:\/\/www.troyhunt.com\/2014\/01\/with-great-azure-vm-comes-great.html\">With great Azure VM comes great responsibility (which is why you really want an Azure Web Site)<\/a>\u00a0compare&#8217;s running a web site in an Azure VM vs. an Azure Web Site and explains the advantages of going with the latter.<\/li>\r\n<li class=\"betterSpacedBullets\">Scott Hanselman&#8217;s<a href=\"http:\/\/www.hanselman.com\/IntroducingWindowsAzureWebJobs.aspx\"> Introducing Windows Azure WebJobs<\/a>\u00a0presents Azure WebJobs, a new feature of Azure WebSites, that allows the execution of regular background jobs and batches.<\/li>\r\n<li class=\"betterSpacedBullets\">Keith Mayer&#8217;s <a href=\"http:\/s.technet.com\/b\/heyscriptingguy\/archive\/2014\/01\/24\/create-backups-of-virtual-machines-in-windows-azure-by-using-powershell.aspx\">Create Backups of Virtual Machines in Windows Azure by using PowerShell<\/a>\u00a0shows how Azure VMs can be backed up using Powershell.<\/li>\r\n<li class=\"betterSpacedBullets\">Brian Farnhill&#8217;s <a href=\"http:\/s.msdn.com\/b\/brian_farnhill\/archive\/2014\/01\/22\/managing-windows-azure-vms-through-powershell.aspx\">Managing Windows Azure VMs through PowerShell<\/a>\u00a0shows how Powershell can be used to perform multiple operations on Windows Azure VMs.<\/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 the links for the past week. SQL Server: Jes Schultz Borland&#8217;s Improving the Performance of Backups\u00a0suggests a few ways to improve the performance of backup operations. The comments also suggest further reading with additional great advice. Hugo Kornelis&#8217;s Parameterization and filtered indexes (part 1) and Parameterization and filtered indexes (part 2)\u00a0address the issue&#8230;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,73,2,77],"tags":[158,219,222,223,214,216,215,221,220,93,217,181,224,173,218,253],"class_list":["post-2334","post","type-post","status-publish","format-standard","hentry","category-cloud-computing","category-links-of-the-week","category-sql-server","category-web-development","tag-angular-js","tag-asp-net-mvc-5-1","tag-azure-vm","tag-azure-web-site","tag-backup","tag-change-data-capture","tag-dacpac","tag-html","tag-html-kickstart","tag-javascript","tag-non-clustered-index","tag-parameter-sniffing","tag-powershell","tag-query-parameterization","tag-sp_blitz","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/posts\/2334","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=2334"}],"version-history":[{"count":20,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/posts\/2334\/revisions"}],"predecessor-version":[{"id":2587,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/posts\/2334\/revisions\/2587"}],"wp:attachment":[{"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/media?parent=2334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/categories?post=2334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ruirib.net\/index.php\/wp-json\/wp\/v2\/tags?post=2334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}