Development: Professional, Software and Database

Database Weekly for January 13, 2024 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  Play To Your Strengths I really enjoy playing with radios [ed: we know, you won't shut up about it]. Something as simple as checking in to a local net (basically saying hi to a bunch of people on the radio) is fun. However, there's so much more to it. In the last few weeks I've been testing a new digital mode (M17), texting over the radio (andFlMsg), and sending lots of emails on the radio (Winlink). I've also been experimenting with mesh networks (LoRa). Fact is, after 35+ years in IT, constantly learning new stuff, I kind of can't stop learning new stuff. I can't decide if it's a problem or a reward [ed: it's a problem for us because you can't keep quiet about it]. I do sometimes wish I'd taken a different turn though. I have some friends who have chosen to climb the corporate ladder rather than just stay technologists. Sometimes, not often at all, I get a little jealous when I see the great things they've accomplished. But, I long ago realized that I'm good at figuring out coding problems, data problems, problems on machines, but horrible at figuring out people problems. Overall, I'm pretty gleeful to just be a technologist [ed: a noisy one]. My thoughts for today are simple. Play to your strengths. Sure, work on your weaknesses, but play to your strengths. You'll do better and be happier. At least, that's been my experience. What do you think? 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 [Flyway Baselines and Consolidations]( Phil Factor demonstrates why we occasionally need to 'baseline' a database, when automating database deployments with Flyway, and a simple way of reducing the number of migration files that are required for a build. [Getting Started with Flyway Desktop]( Robert Sheldon helps you get started with Flyway Desktop by walking you through the process of creating a Flyway Desktop project for an existing database. It covers the basics of building a schema model, generating and running migration scripts, and saving changes to source control. [Working with Flyway and Entity Framework Code First: Automation]( This article will demonstrate how to automate a hybrid database change management system that uses Entity Framework Code First for development and Flyway for deployments. We automatically convert C# migrations, produced by EF, to the Flyway format and then use Flyway command line to deploy the migrations and save the 'object-level state' of each new database version, so we can track exactly which objects changed, and how, between versions. AI/Machine Learning/Cognitive Services [Balancing Act: The Value of Human Expertise in the Age of Generative AI]( From Dataversity Humans are considered the weakest link in the ente... [What the AI Adoption Surge Means for IT Skill Development]( From IT Pro - Microsoft Windows Information, Solutions, Tools The latest IBM Global AI Adoption Index suggests t... [Three Myths About Generative AI in the Workplace – and How You Can Bust Them]( From Dataversity In the past year or so, generative AI has received more media attention than any other type of technology. Up until this point, data science has been at the... Administration of SQL Server [SQL Server Dynamic Data Masking in Practice]( From MSSQL Tips Learn how to use dynamic data masking in SQL Serve... [SQL Server Diagnostic Information Queries for January 2024]( From Glenn Berry Introduction These are my SQL Server Diagnostic In... [Step-by-step Installation of SQL Server 2022 on a Windows Server 2022 Failover Cluster - Part 2]( From MSSQL Tips This article covers all the steps to install SQL S... [Backup SQL Server Database with SQL Server Management Studio (SSMS)]( From MSSQL Tips In this tip, we walk through the steps of how to b... [SSMS 19.3 Is Available]( From Glenn Berry Introduction On January 10, 2024, Microsoft releas... [Cumulative Update #11 for SQL Server 2022 RTM]( From MS SQL Server Blog The 11th cumulative update release for SQL Server ... Azure SQL [Lesson Learned #469:Implementing a Linked Server Alternative with Azure SQL Database and C#]( From Azure Database Support Blog In scenarios where direct Linked Server connection... [Optimized locking in Azure SQL Database]( From Simple Talk I don’t think I’ve ever had a great impression... [Lesson Learned #471: Why Can't I Expand the Database Table List from my Application?]( From Azure Database Support Blog In the dynamic world of database management, we en... [Lesson Learned #472:Why It's Important to Add the TCP Protocol When Connecting to Azure SQL Database]( From Azure Database Support Blog In certain service requests, our customers encount... [Lesson Learned #473:Harnessing the Synergy of Linked Server, Python, and sp_execute_external_script]( From Azure Database Support Blog In an era where data management transcends individ... [What's new in security for Azure SQL and SQL Server | Data Exposed]( From Azure SQL Check out this episode to learn the newest information on security for Azure SQL and SQL Server!  Watch on Data Exposed  View/share our latest episodes on Microsoft Learn and YouTube! Azure SQL Managed Instance [Lesson Learned #470: Resolving 'EXECUTE Permission Denied' Error on sp_send_dbmail in Azure SQL MI]( From Azure Database Support Blog We worked on a service request that our customer e... Cloud - AWS [Amazon ECS supports a native integration with Amazon EBS volumes for data-intensive workloads]( From AWS News Blog Today we are announcing that Amazon Elastic Contai... Computing in the Cloud (Azure, Google, AWS) [Benefits of Managed Cloud Hosting in the Evolving Cloud LandscapeÂ]( From Dataversity The business landscape has undergone a transformat... [How to Gain a Competitive Advantage with Cloud]( From IT Pro - Microsoft Windows Information, Solutions, Tools Here's how businesses can use the cloud to achieve a competitive advantage amid uncertainty. DMO/SMO/Powershell [How To Create and Append a Text File in PowerShell]( From IT Pro - Microsoft Windows Information, Solutions, Tools PowerShell users can enhance their scripting skills by learning these techniques for creating and modifying text files. Data Mining / Data Analysis [Reporting statistics for unobserved levels of categorical variables]( From AllAnalytics An unobserved category is one that does not appear... [Meet our inspiring keynote speakers at SAS Innovate 2024]( From AllAnalytics Where can you meet an iconic Silicon Valley report... [Blog posts from 2023 that deserve a second look]( From AllAnalytics In a previous article, I presented some of the mos... [Electrolyte water: helpful or just hype?]( From AllAnalytics Electrolyte drinks (think Gatorade and Powerade) h... [Four Perspectives on the Art of Data Analytics]( From Dataversity As data science professionals, we are often viewed as people who draw conclusions based only on data and minimize other factors. This perception usually becomes contentious when the insights and... Database Design, Theory and Development [The Cool Kids Corner: Data Mesh and Enabling Your Data StoryÂ]( From Dataversity Hello! I’m Mark Horseman, and welcome to The Coo... [Backing up the Teslamate Database]( From SQLServerCentral Blogs I was worried about some of my data, so I wanted t... [Eternal Data: Exploring Infinite Storage Concepts for the Digital Age]( From Dataversity The digital age in which we live demands consisten... [Optimizing cache resets for higher transaction output]( From Ayende @ Rahien One of the most frequent operations we make in RavenDB is getting a page pointer. That is the basis of pretty much everything that you can think of inside... DevOps and Continuous Delivery (CI/CD) [Top 10 Stories About DevOps in 2023]( From IT Pro - Microsoft Windows Information, Solutions, Tools ITPro Today's most read stories about DevOps explo... [Provisioning Multi-Database Environments using Clones, Indirectly]( From Product learning – Redgate Software This article describes how we implemented lightwei... [Create tests by adding HTTP requests in Azure Load Testing]( From Azure Updates Azure Load Testing now supports creating load test... ETL/SSIS/Azure Data Factory/Biml [Video: SQL Server Integration Services on Linux]( From 36 Chambers – The Legendary Journeys THE VIDEO THE SYNOPSIS In this video, we bang our ... Hardware [CES 2024: Intel Briefly Shows Lunar Lake Chip; Next-Gen Mobile CPU Uses On-Package Memory]( From AnAndTech As part of the final segment of Intel’s "Intel C... [Using the Pure Storage PowerShellSDK2 - Part 4 - Classifying Workloads With FlashArray Tags]( From SQLServerCentral Blogs Welcome back to the fourth installment of our blog... Internet of Things [IoT Data Governance: Taming the Deluge in Connected Environments]( From Dataversity The Internet of Things (IoT) has rapidly redefined... MDX/DAX [Automating DAX Measure Formatting in Power BI with Tabular Editor]( From Purple Frog Systems Until coming across this piece of code, I often us... [(Livestream Replay) Introducing DAX Optimizer - with Marco Russo]( From Havens Consulting DESCRIPTION DAX Optimizer is a tool that perfo... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Fabric: Test-Driving the New Office 365 Outlook Data Factory Activity]( From AndyLeonard.blog() In my last post titled Fabric: Load Data from a CS... [Microsoft Fabric – Notebook session usage explained (And how to save CU’s or billed time)]( From FourMoo I was working on a blog post to determine which co... [Fabulous Stuff in Fabric – Part 3: Shortcuts]( From SQLServerCentral Blogs A while ago I had a little blog post series about�... Oracle/PostgreSQL/MySQL/other RDBMS [A Beginners Guide To MySQL Replication Part 6: Security Considerations in MySQL Replication]( Protecting and controlling access to your data against unauthorized person(s) is crucial in any organization. Unauthorized entry or modification of your data can lead to severe and sometimes irreversible damage. Performance Tuning SQL Server [Plansplaining part 27 – LAG and LEAD]( From SQL Server Fast This is part twenty-seven of the plansplaining ser... [Free SQL Server Troubleshooting Stored Procedures]( From Erik Darling Data Giveaway I’ve been doing a lot of work on all of... [Indexing SQL Server Queries For Performance: Fixing Predicate Key Lookups]( From Erik Darling Data Make Things Fast Our very lofty goal as query tuners is to make the time from request to result shorter. Sometimes that requires a bit of sacrifice on the... PowerPivot/PowerQuery/PowerBI [Visualising Power BI Import Mode Refresh Job Graphs]( From Chris Webb's BI Blog A few years ago a new pair of Profiler events was ... [Switching between different active physical relationships in a Power BI model]( From SQLServerCentral Blogs A couple of weeks ago, I encountered a DAX questio... Professional Development [Mistakes: A Painful and Effective Way to Supercharge Your Growth]( From Little Miss Data How making and sharing mistakes can supercharge yo... [T-SQL Tuesday #170 – Learning the Hard Way]( From Andy Broadsword This month’s invitation from Reitse asks us to... [Announcing the 2024 Data Professional Salary Survey Results.]( From Brent Ozar Unlimited This is the 8th year now that we’ve been running... [T-SQL Tuesday #170 – Learning from Failure]( From SQLServerCentral Blogs So what did I learn? I think a better question is,... [A temper, soft skills, and almost losing a job : T-SQL Tuesday #170]( From SQLStudies It’s T-SQL Tuesday again! In fact, it’s the fi... R Language [Aggregating by Month and Year in R]( From Curated SQL Steven Sanderson groups by month and year: Taming ... Security News and Issues [Protecting your Cloud Assets]( Organizations of all types and sizes are turning to the cloud for their application and data storage requirements. The cloud makes it possible for them to deploy their workloads more quickly and to scale them up and down as requirements change. [What Is IAM? A Guide to Identity and Access Management]( From Petri IT Knowledgebase Identity and Access Management (IAM), is a crucial... [Canada Will Use Letter Grades To Assess Companies’ Cyber Resilience]( From IT Pro - Microsoft Windows Information, Solutions, Tools Canada is partnering with SecurityScorecard to strengthen critical infrastructure cybersecurity. Software Development [A Hidden Benefit of Implicit Joins: Join Elimination]( From Java, SQL and jOOQ. One of jOOQ’s key features so far has always bee... [Software optimisation: leveraging algorithms for optimized performance/search.]( From Simple Talk Software optimization refers to the process of improving the performance, efficiency, and resource utilization of a software application. It involves making changes to the code, algorithms, or system configurations... [How to Reduce Performance Debt in Software Development Without Falling Behind]( From IT Pro - Microsoft Windows Information, Solutions, Tools Here are the best strategies for reducing performance debt in software development, and when to implement them for maximum effectiveness. T-SQL and Query Languages [Don’t use DISTINCT as a “join-fixer”]( I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a “join-fixer,” and I can explain what that means using an example. [T-SQL Tuesday #170 – Learning from Abandoned Projects]( From Callihan Data Sometimes you have to abandon the game plan. A foo... Tech News [The end of anonymity online in China]( From Technology Review Feed - Tech Review Top Stories This story first appeared in China Report, MIT Tec... [Some Duolingo Workers Were Fired in Favor of AI]( From IT Pro - Microsoft Windows Information, Solutions, Tools Former contract workers at the language app say they were cut as the company uses more AI tools to create lessons. [5 Software Development Trends to Watch in 2024]( From IT Pro - Microsoft Windows Information, Solutions, Tools In 2024, expect a retreat from cloud-native and outsourced development, as well as fewer developer jobs but more software security problems. [Tech's Job Cuts Give Little Hope for Return to Rapid Growth]( From IT Pro - Microsoft Windows Information, Solutions, Tools Tech layoffs may be back with Amazon, Twitch, Unity, and Duolingo job cuts. [The Download: enhanced geothermal systems, and promising climate tech]( From Technology Review Feed - Tech Review Top Stories This is today’s edition of The Download, our weekday newsletter that provides a daily dose of what’s going on in the world of technology. Enhanced geothermal systems: 10 Breakthrough Technologies 2024... [On IoT Devices and Software Liability]( From Schneier on Security New law journal article: Smart Device Manufacturer Liability and Redress for Third-Party Cyberattack Victims Abstract: Smart devices are used to facilitate cyberattacks against both their users and third parties. While users... Testing Software [Azure Load Testing supports Web Driver Sampler plugin for Apache JMeter]( From Azure Updates With Azure Load Testing, you can now measure respo...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -