Blog Post

Monday Morning SQL Break – June 20, 2016


It’s Monday time for this week’s weekly blog and twitter round-up for last week. 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 Kendra Little (Blog | @Kendra_Little) on scripting out all of the indexes from your database.  This can be quite useful, especially if you don’t have your database in source code control.  Check out the post and take a look at Kendra’s script.

Last Week’s Popular Posts

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

  1. 31 Days of SSIS – The Introduction (653)
  2. 31 Days of SSIS – Raw Files Are Awesome (1/31) (318)
  3. 31 Days of SSIS as a Book (269)
  4. Get Just The Tools: SSMS Download (190)
  5. 31 Days of SSIS – Generating Row Numbers (23/31) (134)
  6. Security Questions: What permissions are required to create temporary tables? (122)
  7. XQuery for the Non-Expert – Value (119)
  8. Determining Filegroup for a Table (109)
  9. Security Questions: Removing Logins From Databases (98)
  10. 31 Days of SSIS – Using Breakpoints (2/31) (86)

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. How to Script Out Indexes from SQL Server [24 clicks]
  2. Announcing SQL Server 2014 SP2 [24 clicks]
  3. HOW TO: Restore the Master Database in SQL Server 2016 [21 clicks]
  4. SQL 2016–Install MSVC Patch Required [19 clicks]
  5. Changing the sa Password with SQLCMD [18 clicks]
  6. PCI Compliance and SQL 2005 don’t mix anymore [17 clicks]
  7. In-database Advanced Analytics with R in SQL Server 2016 [12 clicks]
  8. Do You Even Blog Bro? (Stats, Execution Plans, Indexes, and crazyness) [11 clicks]
  9. SQL Server 2016 outperforms other RDBMS for Data Warehouse [11 clicks]
  10. Why We Revised the Anti-Harassment Policy and What that Means [10 clicks]
  11. Azure ML Now Compliant with HIPAA, ISO 27001, ISO 27018 and EU Model Clauses [9 clicks]
  12. JSON support in SQL Server – Details, tips and tricks [9 clicks]
  13. A Basic Recursive CTE and a Money Lesson [9 clicks]
  14. Another Hidden Parallelism Killer: Scalar UDFs In Check Constraints [8 clicks]
  15. Live Query Statistics Don’t Replace Actual Execution Plans [7 clicks]
  16. Columnstore Index: Overview and Value Proposition [7 clicks]
  17. Do You Teach Azure Data Platform? [7 clicks]
  18. Query Store, Forced Plans, and New Plans [7 clicks]
  19. How to find blocked process [7 clicks]
  20. 3 Ways to Take Microsoft Official Courses [6 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. Security Questions: Migrate Logins Between Servers (2013-06-13)
  2. The Side Effect of NOLOCK (video) (2013-06-13)
  3. Index Those Foreign Keys (2010-06-18)
  4. The Side Effect of NOLOCK (2012-06-18)
  5. CLR_AUTO_EVENT Wait Stat (2008-06-19)

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. 21 Small Ways to Make Life Simpler [13 clicks]
  2. Microsoft to acquire LinkedIn for $26.2 billion [9 clicks]
  3. Microsoft’s new Xbox One S revealed in leaked images [9 clicks]
  4. A Scientist’s Dream Fulfilled: Harnessing The Immune System To Fight Cancer [8 clicks]
  5. After ‘The Biggest Loser,’ Their Bodies Fought to Regain Weight [8 clicks]
  6. We Finally Know What Causes Volcanic Lightning [6 clicks]
  7. Microsoft’s new Xbox finally ditches the annoying power brick [6 clicks]
  8. Your beliefs are wrong. Are you willing to change? [6 clicks]
  9. Petra, Jordan: Huge monument found ‘hiding in plain sight’ [5 clicks]
  10. New Map Shows the Dark Side of Artificial Light at Night [5 clicks]
  11. Now Is the Best Time to See Electric-Blue Clouds at Night [4 clicks]
  12. The 9 Best Tips On Writing From Ernest Hemingway [4 clicks]
  13. Perfect Backpack for Lazy People Ensures You’ll Always Have a Place to Sit [3 clicks]
  14. When Will China’s “Heavenly Palace” Space Lab Fall Back to Earth? [3 clicks]
  15. How To Be Better Than The Biggest Losers and Create a Lasting Change [3 clicks]
  16. Coral Reefs Doing Better Than Expected in Many Areas [2 clicks]

Upcoming PASS Cloud Virtual Chapter Meetings

As co-leader of the PASS Cloud Virtual Chapter, and an advocate of cloud technologies, check out these upcoming presentations:

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?