Blog Post

Monday Morning SQL Break – July 18, 2016


It’s Monday time for this week’s 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 on the Cortana Intelligence and ML Blog Team.  In this post, the team demonstrates how to operationalize Machine Learning models through Power BI.  It’s a great tutorial that will help you better integrate your analytics solutions, if you haven’t check it out.

Last Week’s Popular Posts

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

  1. 31 Days of SSIS – The Introduction (659)
  2. 31 Days of SSIS – Raw Files Are Awesome (1/31) (321)
  3. 31 Days of SSIS as a Book (303)
  4. Get Just The Tools: SSMS Download (159)
  5. 31 Days of SSIS – Using Breakpoints (2/31) (157)
  6. Security Questions: Removing Logins From Databases (145)
  7. Security Questions: What permissions are required to create temporary tables? (130)
  8. XQuery for the Non-Expert – Value (126)
  9. Looking to SQL Server 2014 High Availability In Standard Edition (108)
  10. Security Questions: Difference Between db_datawriter and db_ddladmin? (80)

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. Power BI and Azure ML – Better Together [53 clicks]
  2. FAQs: Microsoft Certification Exam Price Adjustment 2016 [23 clicks]
  3. SQL Interview Question: “How do you respond?” [18 clicks]
  4. Comparing two query plans [16 clicks]
  5. Announcing SQL Server Stretch Database service preview [13 clicks]
  6. Choosing the Right SQL Server Edition [13 clicks]
  7. Tackle WRITELOG Waits Using the Transaction Log and Extended Events [13 clicks]
  8. Performance Improvements in SQL Server Dashboards Management Pack [12 clicks]
  9. 3 Best Practice Steps for Implementing a Power BI Project [12 clicks]
  10. When is a bug a bug and when is it an incomplete feature [12 clicks]
  11. Handling inheritance with JSON [11 clicks]
  12. Overworked Americans Aren’t Taking The Vacation They’ve Earned [11 clicks]
  13. When are things equal in this world and when are they not. The mystery of NULLs [11 clicks]
  14. SQL 2016 – It Just Runs Faster: In-Memory Optimized Database Worker Pool [10 clicks]
  15. T-SQL Tuesday #79 – Creating R Code to run on SQL Server 2016 [10 clicks]
  16. Azure Database and Query Store support in ANTS Performance Profiler [10 clicks]
  17. SQL Prompt Prevents Stupidity [9 clicks]
  18. Microsoft Fixed My Biggest SQL Server Pet Peeve (Two Years Ago) [9 clicks]
  19. 9 Powerful Ways Ultra-Successful People Eliminate Self-Doubt [8 clicks]
  20. Half Baked Features [8 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: Server Role Tips (2013-07-11)
  2. Security Questions: Removing Logins From Databases (2013-07-12)
  3. Volunteering and Resume Building (2009-07-13)
  4. Security Questions: Difference Between db_datawriter and db_ddladmin? (2013-07-13)

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. Why Not to Trust Statistics | Math with Bad Drawings [66 clicks]
  2. 17 tips to save money, from a woman who lived on $14,000 a year [51 clicks]
  3. Why an Eagle Really Grabbed a Kid [27 clicks]
  4. Watch Super-Powerful Electromagnets Shrink Quarters [23 clicks]
  5. Password Sharing Is a Federal Crime, Appeals Court Rules [19 clicks]
  6. Build Your Own Mini NES With a Raspberry Pi and This 3D Printed Case [14 clicks]
  7. They Have To Be Monsters [11 clicks]
  8. Milk Producers Go Negative on Almond Milk [11 clicks]
  9. FBI Closes D.B. Cooper Investigation After 45 Years [10 clicks]
  10. Mall Suspends Security Robot After It Clobbered a Toddler [10 clicks]
  11. Pokémon Go Was Never Able To Read Your Email [Updated] [8 clicks]
  12. The World’s Strangest Currencies [8 clicks]
  13. This Map Shows the Average Income of the Top 1% by Location [8 clicks]
  14. US government plans to use drones to fire vaccine-laced M&Ms near endangered ferrets [6 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?

Original post (opens in new tab)