Blog Post

Monday Morning SQL Break – August 1, 2016


It’s Monday and 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 a blog post from Steve Jones (blog | @) on R Services and a white paper written by Joe Sack.  While the meat of the content is the white paper reference, Steve does talk a bit about what we need to see more of when it comes to R.  Check out both, the white paper can help get you going and Steve’s post provides ideas on sharing your knowledge.

Last Week’s Popular Posts

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

  1. 31 Days of SSIS – The Introduction (759)
  2. 31 Days of SSIS – Raw Files Are Awesome (1/31) (347)
  3. 31 Days of SSIS as a Book (287)
  4. Get Just The Tools: SSMS Download (227)
  5. XQuery for the Non-Expert – Value (120)
  6. Security Questions: Removing Logins From Databases (119)
  7. 31 Days of SSIS – Using Breakpoints (2/31) (110)
  8. 31 Days of SSIS – Generating Row Numbers (23/31) (109)
  9. Determining Filegroup for a Table (80)
  10. Security Questions: Difference Between db_datawriter and db_ddladmin? (76)

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. Why Use R Services? [24 clicks]
  2. Certification Update – SQL 2016 [21 clicks]
  3. Slimmer SQL Saturdays [18 clicks]
  4. MapR, Microsoft make announcements at Hadoop and Red Hat summits [16 clicks]
  5. SQL PowerShell: July 2016 update [13 clicks]
  6. How is performance impacted by having too many NUMA nodes? [13 clicks]
  7. Stretch Database in SQL Server 2016 RTM [12 clicks]
  8. PASS Summit 2016 I’m Speaking [12 clicks]
  9. Will Query Store Work in a Read Only Database? [12 clicks]
  10. Summit Speakers Announced [10 clicks]
  11. What Happens to Pages in the Buffer Pool when your Availablity Group Fails Over? [10 clicks]
  12. Learn Index Tuning at the PASS Summit in 2016! [9 clicks]
  13. Increased Memory Size for In-Memory OLTP in SQL Server 2016 [9 clicks]
  14. Fail Over, Fail Again, Fail Better – Preparing for Disaster Recovery (Dear SQL DBA) [9 clicks]
  15. Getting the Previous Row Value before SQL Server 2012 [9 clicks]
  16. SQL Server 2016 Upgrade Testing with the New Cardinality Estimator: Context Matters [8 clicks]
  17. Help, my company won’t pay for training! [8 clicks]
  18. Everything?!? You Need to Know About Beta Registration [8 clicks]
  19. Setting CE TraceFlags on a query-by-query (or session) basis [7 clicks]
  20. LAST_VALUE–The Basics of Framing [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. Security Questions: Recommended Security Book (2013-07-27)
  2. Gotta Stop Violating Foreign Keys (2009-07-29)
  3. Finding Number of Reports Executed By Folder (2009-07-30)
  4. Analyzing Report Execution Time (2009-07-31)

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. Credit card companies are blowing it with chip payments [15 clicks]
  2. WONDER WOMAN – Official Comic-Con Trailer (2017) Gal Gadot DC Superhero Movie [14 clicks]
  3. Why Did Busloads Of Asian Tourists Suddenly Arrive In This English Village? [14 clicks]
  4. What Really Divides American Politics: 2 Different Ideas of Freedom [13 clicks]
  5. Elon Musk to Open His Tesla Gigafactory Years Ahead of Schedule [11 clicks]
  6. These 9 Slides Put the New Tesla Gigafactory in Perspective [10 clicks]
  7. DOCTOR STRANGE Trailer from SDCC Is a Big Leap from the MCU Look | Nerdist [10 clicks]
  8. Microsoft Surpasses 1 Million Course Enrollments on edX Platform [9 clicks]
  9. Science Says 92 Percent of People Don’t Achieve Their Goals. Here’s How the Other 8 Percent Do [8 clicks]
  10. Blair Witch Is Back To Scare The Bejesus Out Of You [8 clicks]
  11. Another Democratic Party committee has been hacked [8 clicks]
  12. JACK REACHER: NEVER GO BACK Official Trailer (2016) Tom Cruise Movie [7 clicks]
  13. SUICIDE SQUAD – Official Comic-Con Trailer (2016) DC Superhero Movie HD [7 clicks]
  14. The problem with complaining about the system [7 clicks]
  15. Marvel decides not to split Avengers: Infinity War into two movies [7 clicks]
  16. Larry the Lobster Rescued From Restaurant, Dies Getting Shipped to Aquarium [7 clicks]
  17. Tower of Terror to get superhero makeover at Disney California Adventure Park [6 clicks]
  18. Guardians of the Galaxy Vol. 2 [6 clicks]
  19. KONG: SKULL ISLAND – Official Comic-Con Trailer (2017) Tom Hiddleston Monster Movie [6 clicks]
  20. Tesla Gigafactory launch event tonight will be streamed online [6 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?