Blog Post

Monday Morning SQL Break – July 11, 2016


It’s Monday and time for this week’s blog and twitter round-up for last week.  I spent the weekend with family and a bit of tried out Pokemon Go with the kids, so nothing too interesting to share going into this weekend.  That said, if you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this blog.

Most Popular Article Shared

Last weeks most popular link is an article by Paul Randal (Blog | @paulrandal) on wait types and latch classes.  This is a great new resource that you have to check out.  If you care why SQL Server is waiting for this reason or that, this new resource can help identify those reasons and cut down on the research time into issues.

Last Week’s Popular Posts

The most popular posts on this blog in the week are:

  1. 31 Days of SSIS – The Introduction (581)
  2. 31 Days of SSIS – Raw Files Are Awesome (1/31) (288)
  3. 31 Days of SSIS as a Book (255)
  4. Get Just The Tools: SSMS Download (142)
  5. Security Questions: Removing Logins From Databases (124)
  6. 31 Days of SSIS – Using Breakpoints (2/31) (122)
  7. XQuery for the Non-Expert – Value (116)
  8. Security Questions: What permissions are required to create temporary tables? (99)
  9. Security Questions: Difference Between db_datawriter and db_ddladmin? (84)
  10. Looking to SQL Server 2014 High Availability In Standard Edition (82)

Last Week’s Top 20 “Reading” Links

Along with the most popular link, here are the top twenty items relating to SQL Server, technology and careers that were shared last week. If you missed them throughout the week, here’s the opportunity to get caught up on some items that other’s read after I linked them out.

  1. Announcing the comprehensive SQL Server Wait Types and Latch Classes Library [45 clicks]
  2. Email Microsoft CEO Satya Nadella sent the troops announcing a significant executive reorg [44 clicks]
  3. Eight Different Ways to Clear the SQL Server Plan Cache [27 clicks]
  4. 3 Tricks with STATISTICS IO and STATISTICS TIME in SQL Server [23 clicks]
  5. [Updated]: Light weight SQL Server procedure auditing without using SQL Server auditing version [20 clicks]
  6. Announcing SQL Server Management Studio – July 2016 Release [20 clicks]
  7. SAIIK: PaaS vs IaaS – Navigating the Decision Tree: Azure SQL DB vs SQL Server in a VM [19 clicks]
  8. Increased nonclustered index key size with SQL Server 2016 [12 clicks]
  9. Video: How to Become a Consultant or Contractor [11 clicks]
  10. Enable business insights for everyone with SQL Server 2016: Part 2 [11 clicks]
  11. Your Most Important Meeting of the Day [11 clicks]
  12. Precedence Goes to Query Store or Plan Guide? [10 clicks]
  13. New memory grant query hint MIN_GRANT_PERCENT came to rescue [10 clicks]
  14. SQL Server Diagnostic Information Queries for July 2016 [9 clicks]
  15. Reconciling set-based operations with row-by-row iterative processing [8 clicks]
  16. Announcement: Backup(n.) vs Back Up(v.) [8 clicks]
  17. SQL Server Query Store: Default Settings [8 clicks]
  18. You Can’t Force Query Plans If They Use TVPs With PKs [8 clicks]
  19. You can upgrade from any version 2005+ to any other version [7 clicks]
  20. The 5 Times Your Leadership Is Guaranteed to Fail [7 clicks]

Last Week’s Posts From Previous Years

Sometimes the most useful content on a blog wasn’t written in the past week, it’s often other articles shared in the past that resonate with readers. Check out the following links that I published in past years over the past week:

  1. Lost in Translation – Deprecated System Tables – syscomments (2012-07-04)
  2. Lost in Translation – Deprecated System Tables – sysconfigures (2012-07-05)
  3. Lost in Translation – Deprecated System Tables – sysconstraints (2012-07-06)
  4. What Happened to My Fabulous Beverage! (2009-07-07)
  5. Using SSMS to Script Out Data (2009-07-07)
  6. Lost in Translation – Deprecated System Tables – syscurconfigs (2012-07-07)
  7. 5 Common Mistakes with Tempdb (2009-07-08)
  8. Lost in Translation – Deprecated System Tables – sysdatabases (2012-07-08)
  9. Security Questions: Logins Not In Use (2013-07-09)
  10. Security Questions: Prioritizing Security (2013-07-09)
  11. Index Size and Usage (2008-07-10)
  12. Security Questions: Logins, Credentials, and Proxies (2013-07-10)
  13. Security Questions: Server Role Tips (2013-07-11)

Other Items Shared

Of course, no week would be complete without a few off-topic links. These have nothing to do with technology or your career, but they are interesting and worth a second look.

  1. Watch What Happens When You Fill A Giant Balloon With Liquid Nitrogen [35 clicks]
  2. California Town Fixes Crooked Curb, Breaks Geologists’ Hearts [18 clicks]
  3. These Are the 5 Best TED Talks Ever, According to the Guy Who Runs TED [15 clicks]
  4. Kissing Your Dog Isn’t Just Gross, It Can Potentially Make You Very Sick [14 clicks]
  5. The Biggest Obstacle To Mars Colonization May Be Obsolete Humans [12 clicks]
  6. Turning air into stone [10 clicks]
  7. For the First Time Ever, Scientists Show That Eating Pasta Makes Women Skinny [9 clicks]
  8. 7 Ways to be a Dealer in Hope [6 clicks]
  9. Microsoft is adding a wheelchair option for its Xbox avatars [5 clicks]
  10. Of bears and biases: scientific judgment and the fate of Yellowstone’s grizzlies [4 clicks]
  11. How a Messy Kitchen Might Ruin Your Diet [3 clicks]
  12. World’s Largest Storage Battery Will Power Los Angeles [3 clicks]

Got something you think I should read and share, leave a comment below. Also, if you want to see all of the links that were tweeted out last week?