Docker 101, Adaptive Joins, and more (Database Weekly 2020-09-05)

 Database Weekly for September 5, 2020 Problems displaying this newsletter? [View online](. [Database Weekly]( The Complete Weekly Roundup of SQL Server News Hand-picked content to sharpen your professional edge Editorial  Mentoring Over the years when I changed careers and then advanced in IT, many people helped me learn or provided opportunities. Some of these people gave specific in-person help, like my brothers who taught me programming logic and database normalization before I ever thought about working in technology. Others assisted from a distance when I read their books and articles or watched their presentations. I’m not sure if these people can be called my mentors, but I am sure I wouldn’t be where I am today without them. I count Steve Jones as a long-time mentor because he was the person who helped develop me as a writer 15 years ago. He was also kind enough to sit with me to discuss my career options one year at PASS Summit, and I’m sure he was quite busy that week, so I’m grateful that he took the time. We’ve never had any kind of formal mentorship set up, but I know I can always count on him for advice. (We work together now at Redgate!) A consulting company I worked for a few years ago set up mentoring sessions between senior and junior consultants. I ended up with three or four juniors who wanted me to mentor them. If I remember correctly, many of the sessions would be cancelled due to customer work, so I’m not sure how effective they were. Today, I get many informal requests asking for help with just about anything related to the data platform. Many are requests for good books on a particular data platform topic. It's frequently on an area I know nothing about, and only or or two books might exist on the topic as well. I also often get asked for help with queries. This usually ends up with me writing a query instead of actually teaching anything. It's also possibly not correct because most people don’t take the time to provide enough sample data nor all the business rules. Most problems are not straightforward. My advice is to be sure to provide a script with the create table and insert statements as well as making sure that the data is representative, not just one edge case. In fact, it is probably better to post your one-off questions like this on a forum or #sqlhelp. That way, more people who have some time to spare will see your questions. Right now, I have what I’ll call official mentoring relationships set up with three people. I’ve given each individual some recommendations, and there are specific goals in mind. So far, my mentees are enthusiastic and following up with me on their own. It is up to them to do the work. The outcome is not my problem; however, I will assist the best I can and am rooting for them. Being a mentor is a great way to pay it forward. For those of you who have found mentors, remember that they are giving you a precious give – their time. Kathi Kellenberger [Join the debate, and respond to the editorial on the forums](  [Redgate University]( The Weekly News All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. Vendors/3rd Party Products [When SQL Server Performance Goes Bad: Rogue Indexes]( Phil Factor explains how SQL Monitor helps focus performance tuning efforts on the tables and queries where 'rogue indexes' might be a significant problem, and then how to identify both 'missing' indexes that might be beneficial to the overall workload, and those that are unused or duplicated, and so are doing more harm than good. .NET Related Articles [Build a REST API in .NET Core]( A REST API can hide the complexity behind large scale solutions using simple verbs like POST, PUT, or PATCH. In this article, Camilo Reyes explains how to create a REST API in .NET Core. AI/Machine Learning/Cognitive Services [Google offers to help others with the tricky ethics of AI]( Services to include spotting racial bias, developi... [Information Measurement with SQL Server, Part 6.1: Information Gain and Tree Structures]( By Steve Bolton …………Like many of my other series of amateur mistutorials, the section of my blog devoted to the broad topic of Information Measurement is ultimately meant to... The... [Why Build a Hybrid Data Lake for Analytics and AI]( Click to learn more about author Haoyuan Li. The present global crisis has bolstered cries for cost-cutting across organizations. Data lakes spanning from on-premises environments to a public cloud... Administration [Restoring the SQL Server Master Database]( The master database contains records of the structure/configuration for both the current instance and all other databases... [Troubleshoot a SQL Server performance issue like a pro – Part 1]( Once you have worked on enough SQL Server performance issues, you start to develop an approach and lean on the same tools... [dbachecks meets ImportExcel]( I got a message from a friend on Twitter last night asking ‘Is there an easy way to get dbachecks backup info into an Excel spreadsheet?’... [Change Azure SQL Database Service Level Objectives in SSMS]( Sometimes as a DBA, I am lazy and want the ability to execute all of my tasks in one place... [Storage 101: The Future of Storage]( Robert Sheldon wraps up his series on storage by discussing the latest storage innovation and ideas. [Restoring the SQL Server Master Database]( Total: 1 Average: 5 INTRODUCTION The master database contains records of the structure/configuration for both the current instance and all other databases. When you run sp_configure, you are writing... [Failing SQL Agent Jobs – Part 1]( SQL Server Agent Jobs are one of the core features of SQL Server. Agent Jobs perform many actions, from maintenance tasks (server and database), data movement flows, replication, log... The... [Redgate SQL Prompt]( Big Data [How to Leverage Big Data for Business Intelligence]( Click to learn more about author Errin O’Connor. If you have heard about Moore’s law, then you know that in the span of two years, the computer’s capacity increases... Computing in the Cloud (Azure, Google, AWS) [Microsoft Azure Announces Project Bicep, an ARM DSL]( Managing Azure Resource Manager (ARM) templates can be challenging. The Microsoft Azure team is aware of the challenges and has released a very early-alpha-v0.1 version of a new effort named... [Podcast recording – Mixed Extents 01 – Cloud vs. On-Prem]( I’m thrilled to have been part of the second Eig... Conferences, Classes, Events, and Webinars [Monitoring is Key to Database DevOps Success]( Through automated database monitoring, organizations are not only catching deployment issues faster, they are also resolving them quicker by empowering seamless integration between development and database management teams. [Fully Left-shifted Deployments with Version Control and Automatic Cloning]( Discover the future of DevOps! Join Microsoft MVP Kendra Little to see Redgate's recent innovations in action and give you a picture of where Database DevOps is going, and why. DMO/SMO/Powershell [dbatools.io = command-line SQL Server Management Studio: Let me see]( dbatools commands used: Get-DbaDatabase Get-DbaDbF... Database Design, Theory and Development [The final word on storage for DATETIME2]( Two years ago I wrote a post that got a lot of traction in the comments at the time. Last month there was renewed interest because one of the... DevOps and Continuous Delivery (CI/CD) [Database Development with GitHub]( How can you use GitHub to do team-based database development? This article proposes a process that splits development work into task-based GitHub branches, incorporates daily database builds and integration... [The top 7 benefits of DevOps for CEOs]( Updated August 2020 If you were asked what the benefits of DevOps are, you could probably name two or three straight away. Maybe four or five. But – and... [DevOps for Data Science – Continuous Delivery]( In this series on DevOps for Data Science, I’ve explained the concept of a DevOps “Maturity Model” – a list of things you can do, in order, that will... ETL/SSIS/Azure Data Factory/Biml [Creating Your First Azure Data Factory]( Azure Data Factory has grown in both popularity an... HA/DR/Always On/Clustering [Configuring AlwaysOn Availability Groups on SQL Server]( Total: 1 Average: 5INTRODUCTION This document describes the steps and additional information necessary to configure AlwaysOn Availability Groups for HA and DR on MS SQL Server. AlwaysOn Availability Groups... Performance Tuning SQL Server [Adaptive Joins in SQL Server]( SQL Server 2017 (compatibility 140) brought us many Intelligent Query Processing (IQP), formally known as Adaptive Query Processing, features that improve performance on workloads straight out of the box... The... [Starting SQL: Things Query Plans Can’t Tell You]( Hidey-Hole When you’re looking at the execution plan for a query that someone is griping about, one thing to keep in mind is that it’s just part of the picture.... [Starting SQL: Compensating For Lock Waits]( No, Lock Locks are necessary, I’m told. There’s this whole “ACID” thing that makes databases work. It’s generally a good idea for people who into correct answers. But blocking is one... PowerPivot/PowerQuery/PowerBI [New Power BI Migration Documentation]( I’m really pleased to announce that new Power BI Migration documentation that I authored is published on the [Power BI in Excel updates and more… (Roundup | Aug 31, 2020)]( Thanks for watching this week's Power BI news roun... Professional Development [Lessons learned from being self-employed, 2 years in]( Two years ago I quit my job and started working for myself. After two years, I think most people would look at it as a big success, I’m now... Security News and Issues [We Didn't Encrypt Your Password, We Hashed It. Here's What That Means:]( You've possibly just found out you're in a data breach. The organisation involved may have contacted you and advised your password... T-SQL [Columnstore Query Patterns]( Ed Pollack walks us through some query patterns wh... [Please stop using this UPSERT anti-pattern]( There is a very common anti-pattern you should avoid, involving updating a row if it exists and inserting it if it doesn't. See how to avoid race conditions and... [Weighted Randomization In T-SQL]( When I am not working on or writing about SQL, I am posting theme park pictures on Twitter of DisneyWorld (@DisneyPicADay) and Dollywood (@DollywoodP). The fun part of it... [All triggers have to be able to handle multiple row operations.]( Quick post today. Recently I was helping a co-worker write a trigger. Basically there is a table of servers that’s ... Continue reading The post All triggers have to be... [Who Dropped Your Table? – SQL in Sixty Seconds #112]( Who Dropped My Table? - I was recently asked this ... [SQL Homework – September 2020 – More DML Triggers]( Triggers. Still blech. In June I asked you to play with DML triggers. Well, one more time. First of all ... Continue reading The post SQL Homework – September 2020... Virtualization and Containers/Kubernetes [Windows containers & SQL Server – Part 3 – Error Logs]( So far this series has covered: installing Docker for Windows... [Docker 101 and How do containers work?]( Everyone is using containers and talking about containers. Except those for whom it hasn't "clicked." Obvious to some and unendingly frustrating to others, containers are changing how we build...  [RSS Feed]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -