A Whole Lot of Professional Development Going On

Database Weekly for September 23, 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  Gentlest of Reminders, Don't Stop Learning I was on the road for just over two weeks. I was able to travel around to a few places and present some sessions. But, better than that, thanks to [SQL Konferenz]( I was able to go to a couple of sessions and learn some stuff. I'm lucky/cursed in my position at Redgate. We have a bunch of software, and a bunch of developers. For some reason, they seem to do quite a lot of work, expanding, enhancing and changing all those tools. And I have to learn it all. It's never ending. On top of that, I'm trying to pick up PostgreSQL (and you can [read about]( my struggles). Not to mention, I'm absolutely not letting my existing skill set in SQL Server atrophy, so I'm trying to figure out how things work there as well. Oh, and Azure DevOps, AWS Developer Tools, Octopus, Github Actions and all the other DevOps tools & processes. Learning, non-stop learning, as you can tell, is literally a major part of the job. It's a big part of your job too. Sure, maybe you only, ever, work within SQL Server/PostgreSQL/Oracle/InsertYourDataToolHere. It could be you're in a position that's not going to do a cloud migration anytime soon, if ever. You may not have a burning need for automation and process improvement through building out DevOps-style deployments and testing. And you may not work for a software vendor constantly churning out new stuff. So, in this position, you can just sit back & relax. No learning needed right? You must be joking. Even if you're doing any of the stuff listed above, your data is growing. The estate you manage is growing. There's new stuff coming from your internal developers. You need to apply the latest service patch or upgrade to a new version of your data management system. You're hitting limitations on your servers and don't understand why. Performance is tanking in an old application. In short, you have metric tonnes of learning that you need to do, all the time, same as me. So, if you're not learning, get on it. If you're unsure where to get started, I suggest starting with your community. Find the local meetup, user group or whatever. Go to that. Talk to people (yeah, I know). Find a [PGDay]( in your area. Track down a [Data Saturday]( or a [SQL Saturday](. Maybe go to [PASS Data Community Summit]( with a couple of thousand of your closest friends. Pick up a book. Do something. Do everything. Keep learning, because technology isn't standing still, and you're going to need that job in the future, so prepare for it now. 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. AI/Machine Learning/Cognitive Services [Detecting AI-Generated Text]( From Schneier on Security There are no reliable ways to distinguish text wri... [AI in Retail: What You Need to Know]( From Past News - RSS Feeds Artificial Intelligence (AI) is revolutionizing th... [Microsoft AI Researchers Accidentally Leaked 38TB of Sensitive Data]( From Petri IT Knowledgebase Cybersecurity researchers have uncovered a 38TB st... [Will Generative AI Shake Up Security Operations Centers?]( From IT Pro - Microsoft Windows Information, Solutions, Tools The growing popularity of generative AI has fueled interest in its application within cybersecurity. Here’s a status report on generative AI’s role in security operations centers. Administration of SQL Server [T-SQL Tuesday #166: Wrap-up]( From Scary DBA (Grant Fritchey) Once more, my apologies for being late on getting ... [Common Mistakes in SQL Server – Part 1]( From SQLServerCentral Blogs In this series of articles I will be sharing the c... [Lesson Learned #429:Leveraging the Full Range SQL Server INT Data Type: Negative and Positive Values]( From Azure Database Support Blog SQL Server's INT data type, by design, provides a ... [SQL SERVER – Understanding Incremental Statistics]( From Journey to SQL Authority with Pinal Dave Statistics are updated automatically or manually r... [How to Upgrade SQL Server from Evaluation Edition to Standard or Enterprise]( From MSSQL Tips Learn how to upgrade SQL Server from the Evaluatio... [SQL Server 2022 Cumulative Update 8]( From Glenn Berry On September 14, 2023, Microsoft released SQL Serv... [Gherkin Scenarios: 3 Examples to Follow and 6 to Avoid]( From Journey to SQL Authority with Pinal Dave The quality of your Gherkin scenarios can make or ... [SQL SERVER – Stripping HTML Tags from Text]( From Journey to SQL Authority with Pinal Dave In this blog post, we'll explore a method for stripping these HTML tags from your text data using SQL Server. Let us explore the post. First appeared on SQL SERVER... [SQL SERVER – Modern Explicit JOIN Syntax – A Brief Note]( From Journey to SQL Authority with Pinal Dave Over time, SQL has evolved and offers two distinct styles for performing JOIN operations: the old-style comma-separated join and the more modern explicit JOIN syntax. First appeared on SQL SERVER... Azure Databricks, Spark and Snowflake [Spark – LIMIT on Large Datasets – CollectLimit, GlobalLimit, LocalLimit, spark.sql.limit.scaleUpFactor]( From Large-Scale Data Engineering and Analytics in Cloud You use the LIMIT clause to quickly browse and rev... [What is the default number of cores and amount of memory allocated to an application in Spark?]( From Hadoop in the Real World Number of cores spark.executor.cores controls the ... [Managing Azure Databricks with the Azure Cloud Shell Command Line Interface]( From MSSQL Tips The Databricks Command Line Interface (CLI) allows... Azure DevOps [General Availability: GitHub Advanced Security for Azure DevOps]( From Azure Updates Learn how to enable GitHub Advanced Security for A... Azure SQL [Private preview of Data Virtualization in Azure SQL Database]( From Azure SQL We are very happy to announce the private preview ... [Lesson Learned #428: SqlError Number:229 provisioning DataSync in Azure SQL Database]( From Azure Database Support Blog We got a new issue when our customer found provisi... [Azure SQL Edge Update - September 2023]( From MS SQL Server Blog Today, I am providing an update on the supported c... [Ledger database vs ledger tables]( From Azure SQL There is sometimes a misconception about the usage... [Lesson Learned #431: Determining Connection Type to Azure SQL Database: Proxy or Redirect]( From Azure Database Support Blog When connecting to Azure SQL Database, it's important to understand the type of connection established. Azure offers two primary connection policies: Proxy and Redirect. Knowing which one you're using... Backup and Recovery [Verify Backups With Test-DbaLastBackup]( From Callihan Data Is the process of testing your backups something y... Cloud - AWS [AWS Weekly Roundup: C7i Instances, Knowledge Base for Amazon Bedrock, and More (Sept. 18, 2023)]( From AWS News Blog While daylight is getting shorter in the Northern ... [SQL Athena Introduction - How it works, Use Cases and Advantages]( From MSSQL Tips Learn about Amazon Athena, how it works, why you w... [New – NVMe Reservations for Amazon Elastic Block Store io2 Volumes]( From AWS News Blog Amazon Elastic Block Store (Amazon EBS) io2 and io... [New – Add Your Swift Packages to AWS CodeArtifact]( From AWS News Blog Starting today, Swift developers who write code fo... [New Amazon X2iedn High-Memory Instances]( From Brent Ozar Unlimited Amazon just announced new X2iedn instance types for Amazon RDS SQL Server. They’re a sweet deal for people who want a high-performance managed database, with really fast cores and... Cloud - Azure [Microsoft Azure Data Leak Exposes Dangers of File-Sharing Links]( From Dark Reading: Dark Reading News Analysis Shared Access Signature (SAS) link exposed a stora... [Lesson Learned #430: Addressing Error 3201 with Azure Blob Storage: "Operating system error 86"]( From Azure Database Support Blog Today, I worked on a service request that our cust... Cloud - GCP [Configuring a Virtual Private Cloud (VPC) for Google Cloud Platform (GCP)]( From MSSQL Tips Learn how to use the Google Cloud Platform to shar... Community Interests [DataMoshpit!]( From SQLServerCentral Blogs Today I’m presenting at DataMospit, the most met... [The Last Price Bump for the Data Community Summit]( From SQLServerCentral Blogs This week the cost of the PASS Data Community Summ... [Security Conferences Keep Us Honest]( From Dark Reading: Dark Reading News Analysis Conferences are where vendors and security researc... [New approaches to the tech talent shortage]( From Technology Review Feed - Tech Review Top Stories We live in a tech-enabled world, but for organizations to advance world-changing innovations, they need skilled people who can build, install, and maintain the systems that underlie them. Finding... Computing in the Cloud (Azure, Google, AWS) [Migrating to the cloud transforms business]( From Technology Review Feed - Tech Review Top Stories In 2017, BP took on a cloud-first approach that co... [How to Minimize Multi-Cloud Complexity]( From IT Pro - Microsoft Windows Information, Solutions, Tools Successfully juggling multiple clouds can sometime... [Why Cloud Will Remain Dominant: 4 Reasons]( From Past News - RSS Feeds Cloud computing is having a moment. No longer an e... DMO/SMO/Powershell [PowerShell: Error Handling with $Error]( From Sid 500 PoSh The $Error Variable in PowerShell contains all err... Data Mining / Data Analysis [Breaking the cycle: Data driven strategies for addressing substance use disorder among supervised populations]( From AllAnalytics Some research shows that an estimated 65% percent ... [Avoid domain errors by using Taylor series]( From AllAnalytics The other day I was trying to numerically integrat... [5 practical ways to increase resilience before 2024]( From AllAnalytics The massive disruptions of the last few years have made clear how critical it is for businesses to be resilient. Some companies flexed successfully with the changes, while others... Data Privacy, Compliance, and Governance [Data Governance in the Age of Generative AI]( From Dataversity AI-based business models and products that use gen... [AI and Privacy Issues: What You Need to Know]( From Past News - RSS Feeds Artificial intelligence (AI) is becoming increasin... [CCPA vs. GDPR: Differences and Similarities for Data Protection]( From Dataversity The California Consumer Privacy Act (CCPA) and the General Data Protection Regulation (GDPR) were created to empower individuals with greater control over their personal information. Both laws regulate the... Data Science [What Is Metaflow? Quick Tutorial and Overview]( From Dataversity As data science continues to evolve, new tools and technologies are being developed to help individuals and organizations streamline their workflows, improve efficiency, and drive better results. One of... Database Design, Theory and Development [DBDEBUNK REFRESH]( From Database Debunkings After 23+ years DBDebunk.com has undergone a sligh... [Data Platform SLAs]( From SQLServerCentral Blogs Database professionals of the world – I have a q... [Seamless Data Exchange: Best Practices for Modern Businesses]( From Dataversity In today’s dynamic business landscape, the abili... [Moving data through the supply chain with unprecedented speed]( From Technology Review Feed - Tech Review Top Stories Product information is a powerful commodity in today’s digital economy. Making it accessible can let consumers know if an item contains allergens, help retailers respond swiftly to product recalls,... [Database management and the cost of doing nothing]( From Blog – Redgate Software Your data is one of your most important assets, and the database – the home of it all – has long been the unsung hero in many a business.... DevOps and Continuous Delivery (CI/CD) [How to Set up Jenkins CI/CD on Kubernetes Cluster using Helm]( From Simple Talk Jenkins is an open-source multi-platform software ... [Better Database Development: The Role of Test Data Management]( From Product learning – Redgate Software Any organization that aims for reliable, online de... [Creating an Empty Repo in GitHub–#SQLNewBlogger]( From SQLServerCentral Blogs I saw someone struggling with getting started with... DocumentDB/Key-Value/Graph/other NoSQL Databases [Use PROC SGPLOT to embed a graph inside another graph]( From AllAnalytics Did you know that you can embed one graph inside a... [The Power of Graph Databases to Detect Fraud]( From Dataversity Graph databases play a key role in fraud detection... ETL/SSIS/Azure Data Factory/Biml [Build a Pipeline to Stop an ADF Azure-SSIS IR Course Now Available]( From AndyLeonard.blog() I am excited to announce the availability of Build... Hardware [Intel Shows Off Work on Next-Gen Glass Core Substrates, Plans Deployment Later in Decade]( From AnAndTech Although Intel’s annual Innovation event doesn�... Machine Learning [Video: Using GitHub Actions to Run Azure ML Pipelines]( From 36 Chambers – The Legendary Journeys THE VIDEO THE SYNOPSIS In this video, we use GitHu... [Make machine learning work for you]( From Technology Review Feed - Tech Review Top Stories The enthusiasm for AI and its applications is reaching a nadir, according to an August 2023 Gartner Hype Cycle press release, where generative AI is nearly perched atop the... [Bolstering enterprise LLMs with machine learning operations foundations]( From Technology Review Feed - Tech Review Top Stories Generative AI, particularly large language models (LLMs), will play a crucial role in the future of customer and employee experiences, software development, and more. Building a solid foundation in... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Microsoft Fabric Personas]( From MSSQL Tips Learn about personas when working with Microsoft F... [Share a Microsoft Fabric Data Warehouse Database Project with the new target platform]( From Kevin Chant Reading Time: 5 minutes In this post I want to co... [Azure Service Fabric 10.0 Release]( From Azure Updates This release includes new features and quality imp... [Microsoft Azure Data Leak Exposes Dangers of File-Sharing Links]( From IT Pro - Microsoft Windows Information, Solutions, Tools A Shared Access Signature (SAS) link exposed 38TB ... [Microsoft Fabric: Checking and Fixing Tables V-Order Optimization]( From Simple Talk Download the notebook used on this blog I explained in a previous article how the Tables in a lakehouse are V-Order optimized. We noticed this configuration depends on our... [Using Microsoft Fabric Workspaces (Power BI and more!)]( From Guy in a Cube Workspaces are a way to organize and manage conten... [New Microsoft Fabric Data Warehouse Target Platform is now included as part of the latest Azure Data Studio update]( From Kevin Chant Reading Time: 2 minutes In this post I want to raise awareness about the fact that the new Microsoft Fabric Data Warehouse Target Platform is now included as... [Editing your Direct Lake Datasets from Tabular Editor? Yes please!]( From Guy in a Cube Wanting to edit your Direct Lake Power BI Dataset ... Oracle/PostgreSQL/MySQL/other RDBMS [Microsoft Unveils New Partnership to Bring Oracle Cloud Hardware to Azure Datacenters]( From Petri IT Knowledgebase Microsoft is expanding its existing partnership wi... [Learn MySQL : Path to Data Management Excellence]( From Journey to SQL Authority with Pinal Dave Let us explore Learn MySQL : Path to Data Manageme... Performance Tuning SQL Server [A Little About Select Queries That Cause Writes In SQL Server]( From Erik Darling Data A Little About Select Queries That Cause Writes In... [Improving Merging & Appending Power Query (Queries) with Ken Puls]( From Havens Consulting Video by: Reid HavensLearn an improved way to merg... [Parameter Sniffing Issue with Temporary Tables in SQL Server 2022]( From MSSQL Tips In this article, we look at how parameter sniffing... [Three Free Things You Should Do Before You Have Your Next SQL Server Performance Problem]( From Erik Darling Data Attribution SQL Server doesn’t do much to help y... [The Waiting Life Of A SQL Server Query, Revisited]( From Erik Darling Data Often Asked Sometimes people will ask me penetrating questions like “why does SQL Server choose a bad execution plan?” or “why is this query sometimes slow?” Like many things... PowerPivot/PowerQuery/PowerBI [Multiple Connections To The Same Data Source In The Power BI Service With Shareable Cloud Connections]( From Chris Webb's BI Blog Why Shareable Cloud Connections solve Power BI con... [(Livestream Replay) Pareto Principle for Power BI: Few Tricks, Big Wins - with Denis Selimovic]( From Havens Consulting DESCRIPTION By focusing on a few key tricks, you can solve the majority of your Power BI issues and achieve big wins with your reports. We'll cover a range... Professional Development [Dissolving Partnerships]( From Prologika (Teo Lachev's Weblog) I’ve been an independent consultant for almost 2... [3 ways upskilling and continuous learning drive long-term career advancement]( From AllAnalytics From solutions engineers and students to analysts ... [A Playbook for Bridging Africa's Cybersecurity Skills Shortage]( From Dark Reading: Dark Reading News Analysis A pledge to solve the skills and talent shortage b... [Software Engineering Talent in Strong Demand in 2023]( From IT Pro - Microsoft Windows Information, Solutions, Tools A new survey reveals that software engineering tal... [On the Cybersecurity Jobs Shortage]( From Schneier on Security In April, Cybersecurity Ventures reported on extre... [How Organizations Can Overcome the Lack of Tech Talent]( From IT Pro - Microsoft Windows Information, Solutions, Tools Organizations are turning to automation, citizen d... [How Choosing Authentication Is a Business-Critical Decision]( From Dark Reading: Dark Reading News Analysis MFA may go a long way in improving password securi... [Strategies for Tackling Digital Transformation Resistance]( From Dataversity The often-overused phrase “digital transformation” instills a sense of excitement and progress for many executives. But for some business leaders, digital transformation means intimidation or mystery. When the former group is... Python [How to combine images using Python]( From Purple Frog Systems In this blog post, I will be showing how to combin... SQL Server Security and Auditing [SQL Server Row Level Security Deep Dive. Part 4 – Integration, Anti-patterns, and Alternatives]( From Simple Talk One of the primary reasons to implement RLS is to ... [How to Find and Block Breached Passwords in Active Directory]( From Petri IT Knowledgebase Cybercriminals love passwords. They’re simple to... Security News and Issues [How to Get Your Board on Board With Cybersecurity]( From Dark Reading: Dark Reading News Analysis CISOs can refine their soft skills to help get the... [GitLab Users Advised to Update Against Critical Flaw Immediately]( From Dark Reading: Dark Reading News Analysis The bug has a CVSS score of 9.6 and allows unautho... [FBI, CISA Issue Joint Warning on 'Snatch' Ransomware-as-a-Service]( From Dark Reading: Dark Reading News Analysis The group's use of malware that forces Windows com... ['Culturestreak' Malware Lurks Inside GitLab Python Package]( From Dark Reading: Dark Reading News Analysis The GitLab code hijacks computer resources to mine... [T-Mobile Racks Up Third Consumer Data Exposure of 2023]( From Dark Reading: Dark Reading News Analysis The mobile company states that the issue was due t... [Secure Browser Tech Is Having a Moment]( From Dark Reading: Dark Reading News Analysis Cloud adoption is driving secure browsers' moment ... [Mastering Defense-In-Depth and Data Security in the Cloud Era]( From Dark Reading: Dark Reading News Analysis Though widely used in many organizations, the conc... [Hikvision Intercoms Allow Snooping on Neighbors]( From Dark Reading: Dark Reading News Analysis The intercoms are used in thousands of apartments ... [Understanding the Differences Between On-Premises and Cloud Cybersecurity]( From Dark Reading: Dark Reading News Analysis The nature of cloud environments means security an... Software Development [Quick Tip: Taking advantage of Read-Only SQL Server replicas in your C# application]( From SQLServerCentral Blogs If you happen to be using C# there is a very easy ... T-SQL and Query Languages [Alternatives To SQL Server 2022 Built-in function GREATEST]( From Simple Talk If you haven’t already heard, SQL Server 2022 ... [Rounding Numbers to the Nearest Integer with T-SQL]( From MSSQL Tips In this article, we look at how to use T-SQL to ro... Tech News [Advanced Linux User Management: Privileges, Resource Limits, and More]( From IT Pro - Microsoft Windows Information, Solutions, Tools If you are looking to better manage Linux environm... [Unified Acceleration Foundation Goes Beyond oneAPI to Revolutionize Accelerated Computing]( From IT Pro - Microsoft Windows Information, Solutions, Tools The new Linux Foundation project aims to build a u... [What’s next for the world’s fastest supercomputers]( From Technology Review Feed - Tech Review Top Stories MIT Technology Review’s What’s Next series looks across industries, trends, and technologies to give you a first look at the future. You can read the rest of our series... [Microsoft Teams Premium to Retain Real-time Telemetry Data for Up To Seven Days]( From Petri IT Knowledgebase Microsoft is set to enhance how organizations harn... [How electricity could clean up transportation, steel, and even fertilizer]( From Technology Review Feed - Tech Review Top Stories This article is from The Spark, MIT Technology Review’s weekly climate newsletter. To receive it in your inbox every Wednesday, sign up here. Have you ever repeated a word... [Cisco Moves into SIEM with $28B Deal to Acquire Splunk]( From Dark Reading: Dark Reading News Analysis Cisco's surprise agreement could reshape secure in... [Linux User and Group Management Security Best Practices]( From IT Pro - Microsoft Windows Information, Solutions, Tools This guide explores how to manage Linux users and groups for better system security. Tools for Dev (SSMS, ADS, VS, etc.) [Azure Data Studio 1.46 and New Features]( From MS SQL Server Blog We’re rolling towards conference season and the Azure Data Studio engineers have been working hard on two things:  adding new functionality improving stability and performance within the application  As always, new features... flyway [Friday Flyway Tips–Commit and Push]( From SQLServerCentral Blogs Flyway Desktop includes version control features w... [Practical uses for Database Models with Flyway]( From Product learning – Redgate Software A database model is a standard document that represents the logical design and structure of a database. If we save a model each time Flyway creates a new version... history [New Revelations from the Snowden Documents]( From Schneier on Security Jake Appelbaum’s PhD thesis contains several new revelations from the classified NSA documents provided to journalists by Edward Snowden. Nothing major, but a few more tidbits. Kind of amazing that...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -