Thursday Morning SQL Break – June 15, 2015

unicorn pirateIt’s Thursday 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 article Thomas LaRock (Blog | @SQLRockstar).  As the title suggests, it’s a list of 42 things not to say to DBAs.  My favorite part is that he has 42 items in this list.

Last Week’s Popular Posts

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

  1. 31 Days of SSIS – The Introduction (622)
  2. Get Just The Tools: SSMS Download (559)
  3. 31 Days of SSIS – Raw Files Are Awesome (1/31) (336)
  4. 31 Days of SSIS as a Book (325)
  5. The Side Effect of NOLOCK (180)
  6. Looking to SQL Server 2014 High Availability In Standard Edition (178)
  7. Security Questions: Difference Between db_datawriter and db_ddladmin? (154)
  8. Security Questions: Grant Permissions to All Stored Procedures (142)
  9. XQuery for the Non-Expert – Value (139)
  10. Determining Filegroup for a Table (127)

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. 42 Things You Should Never, Ever Say To a DBA [20 clicks]
  2. Old, forgotten, lonely? SQL Server 2016 will sling you into Azure [18 clicks]
  3. Configuring a Multi-Subnet Test Environment for SQL Server [18 clicks]
  4. Analyzing I/O Performance for SQL Server [13 clicks]
  5. More online operations available now – or soon [13 clicks]
  6. Weight doesn’t ALWAYS have to be AlwaysOn [13 clicks]
  7. General Database Server Build and Deployment Instructions [12 clicks]
  8. Rebuild Partitioned Clustered Columnstore Indexes [11 clicks]
  9. 10 Tips for the Minimalist DBA [11 clicks]
  10. Plan Caching and Recompilation in SQL Server 2012 [11 clicks]
  11. What is LegiTest? [10 clicks]
  12. How to rename a column when CDC is enabled [9 clicks]
  13. DB_Owner Querying for Database Options [9 clicks]
  14. PAL Update and More with Clint Huffman [9 clicks]
  15. Do Foreign Keys Matter for Insert Speed [9 clicks]
  16. SQL Server Integration with Windows Azure Storage [8 clicks]
  17. Database Point In Time Recovery vs. Storage Point In Time Recovery [8 clicks]
  18. SQL Server Data Warehousing in Windows Azure Virtual Machines [7 clicks]
  19. NEW WHITEPAPER: Using Power BI in a Hybrid Environment [7 clicks]
  20. Refactoring Mistakes Are Why We Write Tests [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. Reporting Services and Internet Explorer 9 (2011-06-08)
  2. SQL Server 2008 Release Candidate 0 (2008-06-09)
  3. Looking to SQL Server 2014 High Availability In Standard Edition (2013-06-10)
  4. Transfer Logins Between SQL Server 2005 Instances (2008-06-11)
  5. Oct 21 – IT Care – Painting by Numbers, Update Your SQL Skills with New Paintbrushes (2009-06-11)
  6. T-SQL Tuesday – Evil Plan Operators – #TSQL2sDay (2013-06-11)
  7. June ITCare Event – Solving Business Pains with SQL Server Integration Services (2009-06-12)
  8. Security Questions: SQL Agent Permissions (2013-06-12)
  9. Security Questions: Migrate Logins Between Servers (2013-06-13)
  10. The Side Effect of NOLOCK (video) (2013-06-13)

Other Items Shared

Of course, no week would be complete without a few off-topic links (or link in this case). These have nothing to do with technology or your career, but they are interesting and worth a second look.

  1. Man’s tweets about being ‘trapped’ in Taco Bell drive-thru go viral [21 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?