Learning Isn’t Easy, But It’s Vital (2020-08-29)

 Database Weekly for August 29, 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  Learning Isn’t Easy, But It’s Vital In between other work, for the last four weeks or so, I’ve been trying to learn AWS DevOps Pipelines. Let me tell you, they are not simple. At least, I still haven’t quite figured them out. However, I’m going to keep on trying until I figure it out. I’m doing this for a few reasons, and I think they may apply to all of us. First, and I’m not even going to mince words on this, I’m doing it so I’m more valuable to my organization. If I know more and can do more, I’m a good person for the organization to keep around. I’m also worth more in terms of cash. Simply put, a more knowledgeable employee is a more valuable employee. However, I’ve got an affliction called the “Helper Gene.” It means I’m always trying to help others. In this case, if I can figure out how to get AWS Pipelines working, maybe I can translate that learning for others. If I’m having a hard time with learning something, it could be that what I’m learning is beyond me. However, it’s also an indicator that others are probably having a hard time as well. That makes for clear opportunities in helping others. Finally, let’s face it, if you want to stay a technologist, and you’re more than 3-5 years away from retirement, you need to up your skills. You’ll have to learn the next version of whatever data platform you’re on. You must learn, and implement, automation. Technology and the technology landscape is constantly shifting. A lot of our built-up knowledge will serve us extremely well in this changing landscape. Unfortunately, it won’t be enough as things continue to change. So, best to be learning new things. It’s a muscle. Exercise it. Grant Fritchey [Join the debate, and respond to the editorial on the forums](  [Redgate SQL Prompt]( 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: Implicit Conversions]( When you're developing a database, the pressure is on to get something that works, using an efficient algorithm. When you are getting close to a release candidate, however, there are some programming habits that must be removed from the code, because they can cause unexpected performance problems. In this article, you'll learn how to detect and remove one such problem: reliance on implicit datatype conversions in your queries. We'll use a combination of plan cache queries, extended events, and SQL Monitor. [Introduction to Analyzing Waits using SQL Monitor]( Phil Factor sets out with the modest aim of giving you enough of an introduction to waits to better understand the wait information you get from a SQL Server monitoring tool like SQL Monitor, and the rather overwhelming amount of information available in the underlying DMVs and Extended Events. [Using Filters to Fine-tune Redgate Database Deployments]( Filters are used by Redgate's SQL Compare, SQL Source Control, DLM Dashboard, and SQL Change Automation. A typical use for a filter is to work on just one schema within a database or just a limited set of tables and routines. You would also want to use a filter to exclude certain object, such as database users, from comparisons. Phil Factor explains how they work, and how to create, edit and then use them within the various Redgate tools. Administration [Understanding SQL Server Recovery Models]( The database recovery model controls how a SQL Ser... [3 Ways to Run DBCC CHECKDB Faster]( In my last post, I talked about how you can get 43... [Who is your Fail-Safe Agent??]( Did you know it is possible for SQL Server Agent t... [Move TempDB for Performance – SQL in Sixty Seconds #107]( we figured out that they had slow overall performa... [SQL Server System Databases – Basic Concepts]( Total: 1 Average: 5Introduction The SQL Server design implies a one-to-many mapping between the database engine (instance) and the databases hosted on the instance. It means that you can... [Extended Events: Filter on Stored Procedure Name]( I just received a question about Extended Events: What about filtering on the stored procedure name. You know I love writing and talking about Extended Events. The answer is,... The... Azure SQL Database [Azure SQL Database – Read Only Endpoints]( One of the main benefits of configuring active geo-replication for Azure SQL Database is leveraging the read-only endpoint, a good technique to split away read only activity from OLTP... The... [Adding an Azure Active Directory User to Azure SQL Database with Automation]( My teammate Meagan (b|t) messaged me in Teams yesterday afternoon to say “Joey, the client created a new database using your automated process, and my ETL user (which is... [Redgate SQL Prompt]( Big Data [The Problem with Big Data: It’s Getting Bigger]( Click to learn more about author Bernard Brode. Ta... Career Growth and Certifications [As a DBA, am I a gatekeeper?]( TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and ... Continue reading The post As a DBA, am I... [Going all-in on remote work: The technical and cultural changes]( The new way of work requires a new way of managing, whether you like it or not. [DBA in training: Preparing for interviews]( Getting that first job as a DBA is not easy for most of us. In this article, Pamela Mooney explains what to expect when interviewing and how to prepare.… The... [Azure DP-900 (Data Fundamental) Certification perpetration]( Nothing Is hard when you decide to do it, from two weeks I earned my Certification of Azure Data Engineer and today I passed Exam DP-900 and I got... The... Computing in the Cloud (Azure, Google, AWS) [GCP Refresher – Intro, Free account with 300$ credit, Service Model, Cheat Sheet & Billing]( [MSSQLFUN & Decode ITeS becomes a family of 17... [What Does Billing Look Like When Changing to an Azure CSP]( Billing in Microsoft Azure is a strange beast to g... Conferences, Classes, Events, and Webinars [The future of DevOps]( Join Microsoft MVP Kendra Little to discover how you can fully left-shift your deployments with version control and automatic cloning using Redgate's latest innovations. [Debating #PASSSummit Pre Cons for Monday]( I’ll be speaking at the PASS Summit in 2020, and I have some things to prepare for that. I get a conference admission for the event and access for... The... [New Pluralsight Course – Kubernetes Package Administration with Helm]( My first course Kubernetes Package Administration with Helm has been published on Pluralsight and is now available! Check out the course overview here This course is aimed at anyone... The... [Updated Fundamentals of Database Administration Class: Just $39]( You’re a systems administrator or developer who’s been stuck in charge of the SQL Server. You have a couple of production SQL Servers, no high availability or disaster recovery,... DMO/SMO/Powershell [dbatools.io = command-line SQL Server Management Studio: AlwaysOn Availability Groups]( This post is part of the series showing practical usage examples. [How to Use Parameters in PowerShell Part II]( PowerShell is a basic skill any administrator working in Windows or Azure should know. After writing his first article about PowerShell parameters, Greg Moore realized that there is even more to talk about. This article covers using pipelined parameters and more. Data Privacy, Compliance, and GDPR [Why CDOs Need a Bigger Budget Now for Data Governance]( Click to learn more about author Amar Kanagaraj. T... [Microsoft Improves Data Protection in Azure Files]( Several new Azure Files features went into public preview earlier this year to help organizations move file shares to the cloud with confidence. The post Microsoft Improves Data Protection in... DevOps and Continuous Delivery (CI/CD) [Ramping Up on Database DevOps: A Sample Get-Started Reading List]( Ready to learn more about how to evolve software development for databases? Here's a sample list of resources to get you going. The post Ramping Up on Database DevOps: A... [The Two Ways Containers Will Revolutionize Database DevOps]( Containers have already transformed the way application development works, but adoption has been slower for databases. Finally, the revolution is beginning. In this post, Kendra Little shares the two ways in which containers will dramatically change the way teams develop and deploy database changes. ETL/SSIS/Azure Data Factory/Biml [How to Skip SSIS Package Validation]( A new feature in version 3.9 of the Visual Studio 2019 SSIS extension is “skip package validation.” I’ve tested the functionality and it works well. Here’s how you set... Hardware [Lenovo IdeaPad Slim 7: First True Showcase of AMD’s Mobile Promise]( eWEEK PRODUCT REVIEW: For those working from home-... Microsoft News [TPM 2.0 and Secure Boot Become Mandatory for Windows Server Hardware in 2021]( Most x64 bit server hardware shipping today has TPM 2.0 and Secure Boot, but the features are often turned off by default. The post TPM 2.0 and Secure Boot Become... Oracle [Prepping an Oracle Database for a Cloud Migration]( There’s so much I need to get written down these days, but there’s only so many hours in a day Tags:  azure, Lift and Shift, oracle, Oracle on Azure Del.icio.us ... Performance Tuning SQL Server [Starting SQL: Compensating For Memory Waits]( Scrabble Words You spend most of your life waiting. Sometimes it’s not bad. Even a long wait can be okay if you only have to do it once. Once I waited... [Starting SQL: Some Waits Relate]( Going For Distance There are waits, and then there are waits. If you know, you know, you know? If you don’t know, here’s the deal: there are some waits that are gonna... [Starting SQL: Waits And Measures]( Done Started Something If you talk to anyone who bills by the hour for SQL Server, one of the first things they’ll ask you is what your wait stats are. It’s... PowerPivot/PowerQuery/PowerBI [Dynamic titles with multiple slicers or filters in Power BI]( We've talked about dynamic titles in Power BI befo... [Displaying Routes On A Map In Power BI]( In last week’s post I described the new Power Query M functions for working with Well Known Text objects, and in a post a few weeks ago I showed... [Create a trial tenant to explore Power BI Administration]( Want to explore or test Power BI administration se... Product Reviews and Articles [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... [Exchanging Schemas with SQL Compare Snapshots]( Recently I was working with a customer and they asked if they could somehow package up their schema without the data and send this to a colleague. Absolutely, and... The... Product Upgrades and Releases [Announcing a second Local Zone in Los Angeles]( In December 2019, Jeff Barr published this post announcing the launch of a new Local Zone in Los Angeles, California. A Local Zone extends existing AWS regions closer to... [Integration Services Extension v3.9 is Available]( Integration Services Extension v3.9 is now available for Visual Studio 2019. I tested the skip-package-validation feature and I like it! Interesting (to me) is skipping deployment to Azure-SSIS for... R Language [Time Series Modelling: R & SAS]( Como integrar modelos hierárquicos de séries tem... SQL [Heaps in SQL Server: Part 3 Nonclustered Indexes]( Uwe Ricken continues his series on heaps. This time he demonstrates a common scenario where the query against a heap is faster than a clustered index. SQL Server Security and Auditing [Complete Guide To “SQL Server Security & Architecture and Internals”]( [MSSQLFUN & Decode ITeS becomes a family of 1700 individuals across the globe. Please join us onFacebook & YouTube.] Refer our Complete Guide To “SQL Server Security & Architecture and Internals”... The... Security News and Issues [How a $1 million plot to hack Tesla failed]( Hacking isn’t all 1s and 0s—more often than yo... T-SQL [Recursively Querying Row Groups]( Recursively Querying Related Rows Recursive querie... [Dirty Read with NOLOCK – SQL in Sixty Seconds #110]( Recently I noticed that my client has been using t... [Solve Puzzle about Data type – SQL in Sixty Seconds #108]( A very interesting puzzle, where you see the data ... [When SQL Server Performance Goes Bad: Implicit Conversions]( When you're developing a database, the pressure is on to get something that works, using an efficient algorithm. When you are getting close to a release candidate, however, there...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -