Sharing your Knowledge, SQL Server updates, and more (DBW 2023-02-24)

Database Weekly for February 25, 2023 Problems displaying this newsletter? [View online](. [Database Weekly]( The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com Hand-picked content to sharpen your professional edge Editorial  Consider Sharing Your Knowledge At User Groups and Conferences The first time I spoke in front of a group of people over 20 years ago about a programming topic, I was scared to death. I could barely sleep the night before, obsessing about the material and practicing it repeatedly. When I finally did sleep, it felt like minutes before I awoke, and it was several hours before I needed to even think about getting up. After I finally got to the venue, setting up and watching people come into the room to hear me speak was sort of terrifying. Would the room fill up? Would there be one or two people, both who fell asleep and hit their heads on the chair in front of them, then leave? Throughout the presentation, I watched the people who attended 's micro-expressions, wondering what they were thinking. I rather expect that is why many people have avoided speaking: Fear. It was not my original idea over 20 years ago, either. My boss told me, "we don't have money to pay for conferences, but we can cover travel. Try speaking at conferences." So I applied to speak about ERwin data modeler at CA World. Long story short, I was accepted, and there I stood in front of 30 or so people thinking, "if I survive, this will be the last time I do this." My mind did not change when it was over, but somewhere in the back of my head, I realized... this was a good experience despite the heart palpitations! I ask myself every time I do a presentation, "why am I doing this?" but the answer is always there right in front of me. You probably think that the answer is that "I want to teach others all the things I know." I do like sharing knowledge, but that is only a little less than half of what motivates me. The real motivation is learning new stuff. While that may sound self-centered, it is, and it isn't. To do a presentation on a topic, you need to seek out a breadth of knowledge that goes past your basic experiences. So you must read and make sure that what you have done at your day job actually makes sense. (This can can be quite an eye opener!) Then you need to find a way to present the material that makes sense. This means doing the presentation out loud to myself to make sure the words sound right. Prepping the first time helps you learn, but what about the second or third time you present the same topic? As time passes, the industry changes. Even my beloved relational database design topic has evolved in the past 20 years. Keeping up with all the changes in the industry is a crucial value of regularly doing presentations. A good presentation typically tells the best way to do what your topic is covering, no matter what you have to do in the reality of your day job. Learning as you prepare to give the presentation is incredible, but once you start talking, you will often learn from the attendees. Consider the following levels of people who will attend your sessions. - Newbies. You can't learn from someone new to your topic, can you? You certainly can. Questions people ask who are new to your topic help you realize things you don't explain well enough. People who are hungry to learn from you often ask great questions. Sometimes you have to think, "why didn't I think of that?". - Experts. Why would an expert in the topic you are presenting come to your session? To learn something new. I go to sessions all the time and know 99% of what is being offered. But that 1% is worth it. Experts may teach you a thing or two you didn't realize with questions or discussion after your session. Still, there are very few people who know everything about a topic. - Every level in between. Most people who go to sessions are not unfamiliar with the topic going in. They have experience and ideas from their own years of experience that they may share when you ask for questions and comments. The more people who go into accumulating knowledge about your craft, the better. The discussions you may have during and after presentations can really let you realize that some of the things you are staunchly against don't matter. In a presentation, someone asked why my suggestion is to not prefix tables with TBL_. We discussed it and others in the group agreed with me that it is redundant. But others disagreed and felt it was good documentation. In the end consistency and correctness matter more than anything. If you have that feeling that you have nothing to share, you are without a doubt, very wrong. If it scares you to death to get up in front of a large crowd, you are not alone. A lot of those people who present are scared every time they do it. Heck, one of the greatest performers alive still has some stage fright even though he is over 70 and has played for hundreds of thousands of people over the years. [Paul McCartney almost quit performing because he had stage fright](. So consider giving it a try at a conference or your local user group. It isn't easy, but it is very much worth it. Louis Davidson (@drsql) [Join the debate, and respond to the editorial on the forums](  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 [How to Improve the Quality of Database Releases using Clones]( This article explains how we can use the ephemeral, containerized databases delivered by Redgate Clone to increase database code quality and therefore the stability, reliability, and performance of the databases we release. [3 Key Areas to Drive Digital Transformation]( In this article, I want to look at three key areas that need to be considered to make digital transformation occur.As a Response to Current Changes, In Preparation for Future changes and To Enhance the Human Experience. [Azure Machine Learning Introduction: Part 1 Overview and prep work]( The five-part series is designed to jump-start any IT professional’s journey in the fascinating world of Data Science with Azure Machine Learning (Azure ML). Readers don’t need prior knowledge of Data Science, Machine Learning, Statistics, or Azure to begin this adventure. AI/Machine Learning/Cognitive Services [How OpenAI is trying to make ChatGPT safer and less biased]( From Technology Review Feed - Tech Review Top Stories This story originally appeared in The Algorithm, our weekly newsletter on AI. To get stories like this in your inbox first, sign up here. Have you been threatened by an... Community Interests [How to ask for programming help]( Over the past 25 years, I have answered a lot of p... [Entering the software economy]( From Technology Review Feed - Tech Review Top Stories Many companies looking to enter the software economy, the ecosystem of companies that create or are enabled by software, do so through acquisitions, often by targeting startups. Evaluating the... Conferences, Classes, Events, and Webinars [Join Redgate at SQL Bits, March 15-18]( From castles and dragons to sword fights and spells, this year’s SQL Bits will have it all. Make sure you don’t miss out on our great sessions, from Code Errors to Reliable Releases, to adding some PostgreSQL skills to your repertoire. Get 10% off registering with 10REDGATE. ETL/SSIS/Azure Data Factory/Biml [Metadata-driven pipelines in Azure Data Factory | Part 4 - Analytical Processing]( From SQLServerCentral Blogs (2023-Feb-20) The previous posts covered the following areas of Metadata-driven pipelines in Azure Data Factory:Part 1 - Data CopyPart 2 - Feed ConfigurationPart 3 - Column MetadataThese 3 areas suggested that it is... The... Hardware [A Minor Bandwidth Upgrade]( From SQLBlog.org I recently added a switch and an adapter to take much better advantage of AT&T's 5-gig service. Performance Tuning SQL Server [Lesson Learned #333: RESOURCE_SEMAPHORE Wait Type]( From Azure Database Support Blog Today, we got a service request that our customer ... [SQL Server 2022: Measuring Extended Events Performance Impacts]( From Jonathan Kehayias Have you ever wondered if Extended Events is affec... PowerPivot/PowerQuery/PowerBI [How to get a CLOCK in your Power BI Report]( From Guy in a Cube We had a question about how to get a clock in Powe... [From Frustration to Optimization: A Journey through Power BI Data Model Design]( From Data – Marc Discussions with clients regarding the performance... [Power BI Migration Tools: What They Can And Can’t Do]( From Chris Webb's BI Blog Beware of Power BI migration tools that do things ... SQL [Checking the Microsoft Container Registry for new SQL Server images]( From SQLServerCentral Blogs A while back I wrote a post on how to retrieve the... SQL Server News [February 2023 : Many updates for SQL Server]( From SQLBlog.org A good round of updates for most modern-ish versio... Security News and Issues [How your brain data could be used against you]( From Technology Review Feed - Tech Review Top Stories This article is from The Checkup, MIT Technology R... [Despite Breach, LastPass Demonstrates the Power of Password Management]( From Dark Reading: Dark Reading News Analysis What's scarier than keeping all of your passwords in one place and having that place raided by hackers? Maybe reusing insecure passwords. T-SQL and Query Languages [SQL Calendar Table - Use a Table and View to Simplify Generation]( From MSSQL Tips This article provides T-SQL code to generate SQL calendar tables and to auto-create HTML code for formatted tables that could be used in web applications. [SQL STUFF vs SQL REPLACE vs SQL WRITE in SQL Server]( From MSSQL Tips Learn about the similarities and differences of ST... [Fun With KQL – Let]( From Arcane Code Fun With KQL - Let [SQL Cheat Sheet for Newbies]( From SQLShack In this SQL cheat sheet, we’ll look at sample SQL queries that can help you learn basic T-SQL queries as quickly as possible. Introduction Transact-SQL (T-SQL) is an extension... Testing Software [How to Install the AdventureWorks Sample Database in Azure SQL Database]( From MSSQL Tips Learn how to configure Azure SQL Database and setu...  [RSS Feed]([Twitter]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -