Monday Morning SQL Break – May 4, 2015

unicorn pirateIt’s Monday time for this week’s weekly blog and twitter round-up for last week. If you don’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 from Geekwire.  It’s an interesting story about a missing table.  According to some “internal sources”, someone deleted a table.  Honestly, THIS is why DBAs talk about security.  THIS is why managers talk about change management.  There are a lot of folks over at Starbucks that probably never thought this could happen to them.  High availability isn’t just about having the database online, it also needs to provide a level of solution that prevents or, at least, mitigates these types of problems.

Last Week’s Popular Posts

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

  1. 31 Days of SSIS – The Introduction (652)
  2. Get Just The Tools: SSMS Download (604)
  3. 31 Days of SSIS as a Book (426)
  4. 31 Days of SSIS – Raw Files Are Awesome (1/31) (325)
  5. The Side Effect of NOLOCK (156)
  6. Security Questions: Grant Permissions to All Stored Procedures (141)
  7. Security Questions: Difference Between db_datawriter and db_ddladmin? (139)
  8. Determining Filegroup for a Table (137)
  9. 31 Days of SSIS – Generating Row Numbers (23/31) (133)
  10. XQuery for the Non-Expert – Value (118)

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. Starbucks back in business: Internal report blames deleted database table, indicates outage was global [25 clicks]
  2. Backupify CEO Tells Recent Grads To Stop Complaining About Work-Life Balance [22 clicks]
  3. All of the arguments Dr. Oz made against his critics were wrong [16 clicks]
  4. Altering a column to add NOT NULL [14 clicks]
  5. The Very First Concern with SQL Virtualization: Licensing [12 clicks]
  6. Angoss Enables Companies to Perform In-Database Analytics on Microsoft Analytics Platform System [10 clicks]
  7. Internals of the Seven SQL Server Sorts – Part 1 [8 clicks]
  8. IaaS Just Got Easier. Again [5 clicks]
  9. Amazon Web Services Vs Microsoft Azure: The Real Difference [5 clicks]
  10. Chip Shot: Intel® Xeon® E5 v3 Server Processors Power New Microsoft Azure G-series [4 clicks]
  11. Premium Storage: High-Performance Storage for Azure Virtual Machine Workloads [3 clicks]
  12. Troubleshooting Azure Connectivity: Ports and Endpoints [2 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. Find Query Plans That May Utilize Parallelism (2009-04-27)
  2. Analyze This – Analyze Your Indexes – Part 5 (2009-04-28)
  3. Analyze This – Analyze Your Indexes – Part 6 (2009-04-28)
  4. Changing A Performance Counter Log Format (2010-05-02)
  5. Searching for Plans (2010-05-03)
  6. Snapshots of Index Contention (2009-05-04)
  7. Can You Dig It? – Determining Index Plan Usage (2012-05-04)

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, follow me on twitter (@StrateSQL).