Monday Morning SQL Break – June 1, 2015

unicorn pirateIt’s Monday and 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 blog post from Jen Underwood (Blog | @idigdata).  In it, she covers all of the great changes that are coming to the BI stack on SQL Server 2016.  I’m pretty keen on seeing what the changes to SSRS will look like, will we finally have a way to template the format of reports?  If you are interested in BI, you should check out Jen

Last Week’s Popular Posts

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

  1. 31 Days of SSIS – The Introduction (670)
  2. Get Just The Tools: SSMS Download (502)
  3. 31 Days of SSIS – Raw Files Are Awesome (1/31) (387)
  4. 31 Days of SSIS as a Book (284)
  5. The Side Effect of NOLOCK (255)
  6. Looking to SQL Server 2014 High Availability In Standard Edition (182)
  7. Security Questions: Difference Between db_datawriter and db_ddladmin? (152)
  8. Security Questions: Grant Permissions to All Stored Procedures (133)
  9. 31 Days of SSIS – Using Breakpoints (2/31) (128)
  10. XQuery for the Non-Expert – Value (116)

Last Week’s Top 10 “Reading” Links

Along with the most popular link, here are the top ten 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. Microsoft Breathes Life back into SQL Server BI On-Prem [163 clicks]
  2. SQL Server 2016 : In-Memory OLTP Enhancements [19 clicks]
  3. Is Performance Better With LEFT JOIN or RIGHT JOIN? [16 clicks]
  4. 8 Tips For Faster SQL Server Performance [16 clicks]
  5. Know Your Monitoring Scripts [16 clicks]
  6. Should I use Backup Compression or NTFS Compression for Backups? [14 clicks]
  7. A Scientific Guide to Saying “No”: How to Avoid Temptation and Distraction [12 clicks]
  8. Staging Data: Locking Danger with ALTER SCHEMA TRANSFER [12 clicks]
  9. 7 timeless lessons of programming “graybeards” [12 clicks]
  10. Improving Partition Maintenance with Incremental Statistics [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. Where’s StrateSQL? (2011-05-25)
  2. Free Hyper-V Training (2009-05-26)
  3. Doing Something About Auto Generated Names (2010-05-26)
  4. Security Questions: Difference between sysadmin and CONTROL SERVER Permission (2013-05-27)
  5. And Here You Thought It Just RTM’d (2010-05-28)
  6. Security Questions: Authentication Performance (2013-05-28)
  7. DBADiagnostics – My DBA Database (2009-05-29)
  8. Security Questions: Accessing SQL Server Securables (2013-05-29)
  9. Security Questions: TRUNCATE TABLE Permissions (2013-05-30)
  10. Thoughts About The Nail (2013-05-31)
  11. Does A Job Really Fail If Nobody Knows About It? (2009-06-01)
  12. But It Wasn’t My Job To Do The Backups!? (2009-06-01)

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. “Single Ladies” Set To The “DuckTales” Theme Song Is The Best Thing On The Internet Right Now [46 clicks]
  2. Everyone Failed To Ride This Bicycle. The Reason Behind Is Mind-Boggling [28 clicks]
  3. FIFA Frantically Announces 2015 Summer World Cup In United States [26 clicks]
  4. 6 Arrested Following Attack On Pedal Pub [26 clicks]
  5. Watch Out! This Boobytrapped Text Message Will Turn Off Your iPhone [23 clicks]
  6. A reminder that your Instagram photos aren’t really yours: Someone else can sell them for $90,000 [23 clicks]
  7. Microsoft announces Cortana for iOS and Android [15 clicks]
  8. British Novelist to American Grads: There”s Nothing Virtuous about Being Offended [15 clicks]
  9. ‘Microsoft Lottery’ doesn’t exist, Redmond warns [15 clicks]
  10. KUNG FURY Official Movie [7 clicks]
  11. “Avengers: Age of Ultron” and the Risks of Artificial Intelligence [7 clicks]
  12. Top FIFA officials arrested for corruption, to be extradited to US [4 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?