The way we train AI is fundamentally flawed (2020-11-21 DBW)

 Database Weekly for November 21, 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  The Wide Impact of PASS I’m writing this a week after the end of the first Virtual PASS Summit. For those who don’t know, let me share a couple of things. First, the PASS organization itself is in a bit of financial trouble at this writing. Second, I’m on the PASS Board, so I’m tasked with helping to keep the ship afloat. As such, I’ve been thinking about the organization quite a lot recently. Let me share a few thoughts. I believe that we, the community of data professionals, benefit from this organization. Now, you may never have been to a Summit, a SQLSaturday, a local user group, one of the many live Microsoft events that PASS puts on, or any of the myriad online and virtual events that PASS organizes and presents. I’m saddened that this is true, but it may well be. This could be because of the cost of Summit or just because there hasn’t been a SQLSaturday near you or you never saw the virtual events being offered. Not to mention the fact, you may just be busy keeping your head above water at work. Despite this, you too have likely benefited from the PASS organization. Now how can I say that? PASS started over twenty years ago. It started as just Summit. It didn’t do anything else. However, over time, it grew. Through that growth, quite a few people engaged with the organization, myself included. Many of those people started volunteering with the organization. They started user groups. Maybe they organized SQLSaturdays. They started presenting training and learning sessions because of PASS. These people started mentoring others, using principals they picked up from the organization. Some of them wrote books or recorded videos. Turn and ask one of the big name data pros where they got their start or how they grew into being a big name data professional, many will point to PASS. So, while you may not have been to a single PASS event, if you’ve read one of my books, blog posts or articles, you’re benefitting from the fact that PASS helped me shape my career into what I have today. I know that if the organization goes away, you sure won’t. The community of data professionals will continue. People run their own events all the time. We follow one another on social media. Blogs, videos, articles, books, all of that will continue. However, we will have lost a central, organizing body for the community. A prime channel of sharing a message as important as “Connect, Share, Learn” will be gone. Organizations will put together their own conferences, virtual or otherwise. But a global, independent gathering place will be lost. The community will absolutely continue, but it will be less. Fingers crossed, we keep it going. Grant Fritchey [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 [Database Build Blockers: Four-part Object References]( Cross-server references keep cropping up as a problem for development and build. Phil Factor demonstrates how using linked server 'aliases' can get around these issues, even if the individual databases use four-part references within the code rather than synonyms. [Sharing SQL Code Snippets with Coworkers, The World and Yourself]( Louis Davidson explains how he manages and shares several different sources of SQL Prompt code snippets, in a single Snippet library, using Dropbox and source control. [Database Updates: Rolling Back and Fixing Forward]( Phil Factor's take on the best ways to reverse or accelerate your way out of the problems caused by a failed database update. [Get involved in the 2021 State of Database DevOps survey]( We’re inviting you to take part in the 2021 State of Database DevOps survey! Now in its 5th year, the leading research on Database DevOps will also explore how DevOps strategies have contributed to the resilience of the database during the pandemic. Complete the survey to get exclusive access to the final report and the chance to win a $500 Amazon gift card. AI/Machine Learning/Cognitive Services [Enhancing your Natural Language Processing: Intro to Conversational AI]( Conversational AI can offer a way to provide that ... [How role-playing a dragon can teach an AI to manipulate and persuade]( An AI that completes quests in a text-based adventure game by talking to the characters has learned not only how to do things, but how to get others to... [The way we train AI is fundamentally flawed]( It’s no secret that machine-learning models tuned and tweaked to near-perfect performance in the lab often fail in real settings. This is typically put down to a mismatch between... Administration [How do I tell what compression level my tables/indexes are?]( It’s been a while since I worked with compressio... Azure CosmosDB [How to track Azure Cosmos DB Re-Indexing Progress](     Indexes let your queries run faster. When you need to adjust your indexing policies, database engines re-indexes your data respecting to your changes. In Cosmos DB, when... Azure SQL Database [[Video] Azure SQL Database – Failing Over (Failover Groups)]( Quick video showing you how to failover your Azure SQL Database between your primary and secondary location. The post [Video] Azure SQL Database – Failing Over (Failover Groups) appeared first... Azure Synapse (SQL Data Warehouse and Data Lake) [Folders in Azure Synapse Analytics]( Wolfgang Strasser checks out a small but helpful addition to Azure Synapse Analytics: Good morning, day, afternoon or night – wherever and whenever you read…Continue readingFolders in Azure Synapse... Career Growth and Certifications [What It Takes To Write Two Blog Posts]( This week, I published two blog posts: How Bad Sta... [Setting yourself up for online streaming success, PASS Virtual Summit style]( Last week I presented on three separate occasions during what is considered the biggest Microsoft Data Platform conference of the year, the PASS Summit: Full-day pre-conference session Speaker Idol... The... Community Interests and PASS [Ten Ideas to Improve Online Tech Conferences]( Virtual conferences can be a lot more awesome. Her... [Thoughts on the 2020 PASS Virtual Summit as an Attendee]( Last week was the first PASS Virtual Summit. This ... [PASS Summit 2020 – My experience]( This was the first year in 16 years for me that th... [What the future of PASS needs – and how I can help]( At the recent PASS Virtual Summit I and the other ... [Virtual PASS Summit 2020 Wrap Up]( Whether you caught a single session, took a pre-co... Computing in the Cloud (Azure, Google, AWS) [Azure Stack and Azure Arc for data services]( For those companies that can’t yet move to the c... [Multi-Region Replication Now Enabled for AWS Managed Microsoft Active Directory]( Our customers build applications that need to serv... [Saving money with Log Analytics]( Azure Monitor and Log Analytics are a very importa... [The Secret to Saving on Cloud Costs]( Have you ever cringed when you received your month... Conferences, Classes, Events, and Webinars [Speaking at DPS 2020]( I was lucky enough to attend the Data Platform Sum... [Announcing EightKB 2021]( The first EightKB back in July was a real blast. F... [EightKB is back!]( We’re back! The first EightKB back in July was a real blast. Five expert speakers delivered mind-melting content to over 1000 attendees! We were honestly blown away by how... [Upcoming Events: SQL Saturday Montreal]( Key Details What: SQL Saturday Montreal.Where: Internet Montreal.When: Saturday, November 21st.Admission is free. Register on the SQL Saturday website. What I’m Presenting 3:00 PM — 04:00 PM EST — Data Virtualization... [Join us for this year’s final Redgate Summit]( With 2020 coming to a close, it's time to look at the new year ahead. Join our final 2020 summit this December 10th, to discover how to implement a generative culture for successful IT teams and how database DevOps will drive growth and ROI in a remote world. Register to tune in live or watch the recordings. [Improve Data Efficiency with Database DevOps Solutions]( Join SQLServerCentral Editor, Steve Jones for this Microsoft Azure hosted webinar to learn how to rapidly implement a database DevOps solution with Azure and Redgate tools. You'll discover how database DevOps solutions can help your organization protect business-critical data and improve the efficiency and quality of your software delivery. DMO/SMO/Powershell [Using PowerShell to restore Missing Windows Installer cache items]( This seems oddly specific, but someone or somethin... Data Mining / Data Analysis [Do digital contact tracing apps work? Here’s what you need to know.]( In the early days of the covid-19 pandemic, several competing projects launched around a deceptively simple concept: your phone could alert you if you’d crossed paths with someone who... Data Privacy, Compliance, and GDPR [What do identity thieves covet the most?]( Recently nine pharmacists from across the count... Data Science [Data Science and Social Visibility: An Emerging Tech Revolution for 2020]( Click to learn more about author Pratip Biswas. Co... Data Visualisation [what is a waterfall?]( This month, we build on our “explain the change” challenge, as we bring you another article from our back-to-basics series called what is…?, where we break down some common... Database Design, Theory and Development [Normal Forms]( To prevent data change anomalies, a database shoul... DevOps and Continuous Delivery (CI/CD) [Database DevOps Considerations for SQL Server Availability Groups]( One question which comes up periodically from our ... [Challenges to Implementing Database DevOps: Minimum Team Size]( The next question in this series of blog posts I want to tackle is: What’s the smallest recommended size of development team that can reasonably set up and manage... [Challenges to Implementing Database DevOps: What If I Get It Wrong?]( Another great question that I think I can try to answer: I always gets bogged down in the details and worry about doing it wrong and making a mess... [Three ways that taking the State of Database DevOps Survey helps the community]( Redgate has recently opened the 2021 State of Data... [The Learning Curve for DevOps]( If you’re attempting to implement automation in ... [Challenges to Implementing Database DevOps: Dealing With Hotfixes]( I recently took part in a panel discussion at the PASS Virtual Summit 2020 entitled: Challenges to Implementing Database DevOps. The interaction with the attendees was stupendous. We received... [Git in action]( Dino Esposito continues his series on git. In this article, he explains how to initialize a repository, track files, and revert to a specific revision. ETL/SSIS/Azure Data Factory/Biml [What Is ETLT? Merging the Best of ETL and ELT Into a Single ETLT Data Integration Strategy]( In this article, learn more about ETLT and see an overview of ETL and ELT, advantages and use cases, and more. Hardware [HP EliteBook 845 G7 Laptop: A Wolf in Sexy Sheep’s Clothing]( eWEEK LAPTOP ANALYSIS: HP builds PCs for personas,... [The Corsair Gaming K100 RGB Keyboard Review: Optical-Mechanical Masterpiece]( In today's review, we are taking a look at the suc... [Mac mini and Apple Silicon M1 review: Not so crazy after all]( The M1 is amazingly fast. More importantly, it's a... [Intel’s New NUC Laptop Kit: Whitebook Tiger Lake For All]( The Next Unit of Computing branding, known as NUC ... Oracle [SQL Developer – A great tool and better ways to use it]( SQL Developer is a popular free tool for working w... Performance Tuning SQL Server [When You’re Troubleshooting Blocking, Look at Query #2, Too.]( Wanna attend all my live classes for two full year... [Filter]( Introduction The Filter operator is used to remove... [Why You Shouldn’t Ignore Filter Operators In Query Plans Part 2]( If You Remember Part 1 We looked at a couple exam... [How Scalar User-Defined Functions Slow Down Queries]( When your query has a scalar user-defined function in it, SQL Server may not parallelize it and may hide the work that it’s doing in your execution plan. To... [One Thing The “New” Cardinality Estimator Does Better]( Or “Default”, If That’s Your Kink Look, I’m not saying there’s only one thing that the “Default” cardinality estimator does better than the “Legacy” cardinality estimator. All I’m saying is... PowerPivot/PowerQuery/PowerBI [Using Images from a Database in Power BI]( We've looked at images from sources like OneDrive ... [Power BI: Sometimes you just need guidance]( Just starting with Power BI? Maybe you've been usi... [Reading Bioinformatics and Genomics Files in Power BI]( For many users in the finance, insurance, retail, ... [Which Columns are Not Used in my Power BI Data Model?]( Level: Intermediate. One of the commercial services I offer is to complete a health check of Power BI deployments. I look at everything including the data model, the DAX,... [Using Images from a Database in Power BI]( We've looked at images from sources like OneDrive ... Product Reviews and Articles [Book Review: Making Work Visible]( I was recommended Making Work Visible by a develop... [Database Deployments and Rocky Rollback Horrors: Where Does the New Data Go?]( Phil Factor describes the problem of preserving data that is left 'in limbo' when you need to revert the database to a previous version that has no way of... [Maintaining a Database Build Script with SQL Compare]( Phil Factor explores a lesser-known capability of SQL Compare, which is to help you maintain a 'traditional', well-documented, single file build script, for creating the current version of the... Product Upgrades and Releases [AWS Network Firewall – New Managed Firewall Service in VPC]( Our customers want to have a high availability, scalable firewall service to protect their virtual networks in the cloud. Security is the number one priority of AWS, which has... Python [How to import two modules with same function name in Python]( Are you interested in guest posting? Publish at DataScience+ via your RStudio editor. Category Introduction Tags Import Data Python Tips & Tricks Let me create a module with two functions and Add Multiply I call... R Language [Little useless-useful R functions – Same function names from different packages or namespaces]( This little useless-useful R function is not that useless after-all. Many of the R programmers have had some issues with namespaces in R environment and lost some time debugging, that turned out to be due to variable name or function name. [AzureTableStor: R interface to Azure table storage service]( by Hong Ooi I’m pleased to announce that the Azu... [Little useless-useful R functions – Same function names from different packages or namespaces]( This little useless-useful R function is not that useless after-all. Many of the R programmers have had some issues with namespaces in R environment and lost some time debugging,... Replication [SQL Server Replication]( I can remember several years ago every time someon... Reporting Services [Always Encrypted Data Displayed in SSRS with a gMSA]( Let’s take a look at how to display Always Encrypted Data in SSRS with a gMSA (Group Managed Service Account). We are mixing some technologies […] The post Always Encrypted... The... SQL [DBA in training: Backups, SLAs, and restore strategies]( There are a handful of options when backing up SQL Server databases. A DBA must understand the differences and come up with a plan that protects the organisation’s data. In this article, Pamela Mooney explains service level agreements, recovery models, and some strategies to ensure that the data can be restored quickly. Security News and Issues [Why Companies Should Outsource Cybersecurity During COVID and Beyond]( eWEEK DATA POINTS: Most organizations are not cybe... T-SQL [How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective]( Total: 1 Average: 5We often see poorly written com... [Mastering the Use of Stoplists With SQL Server Full-Text Search (FTS)]( Total: 1 Average: 5 Creating and managing stoplists serves as one of the main components responsible for improving the Full-Text Search performance alongside reducing the size of the index.... [Using CASE Expressions in SQL Server]( Total: 1 Average: 5 Introduction CASE Expressions in SQL Server are used for the column values substitution to present the result sets in a particular fashion or simple queries.... Testing Software [Synthetic Data Generation. Part 4: Tools]( Total: 1 Average: 5 In the previous part of the se... The Lighter Side [The second-largest radio telescope in the world is shutting down]( The US National Science Foundation has just announced it is going to begin decommissioning the famous Arecibo Observatory, the 1,000-foot-wide, 900-ton radio telescope located in Puerto Rico. It’s a... [Rocket Lab has successfully recovered a booster for the first time]( New Zealand company Rocket Lab has hit a key milestone with the successful launch and recovery of its flagship Electron rocket. The mission, the firm’s 16th so far, included... [Pfizer wants authorization to start distributing its vaccine by Christmas]( Pfizer will apply for emergency permission to distribute its covid-19 vaccine in the US and is ready to start shipping the shots within “hours” of getting a government green... [DHL is deploying electric class 8 trucks in Los Angeles]( The trucks, built by BYD, will haul cargo to and from its hub at LAX airport.  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -