The Impact of Small Changes (2023-09-09 DBW)

Database Weekly for September 9, 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  The Impact of Small Changes A year ago, I started a monthly blogging event for the PostgreSQL community, inspired by T-SQL Tuesdays. I decided to call it PGSQL Phriday. (Time will tell if my insistence on trying to use a literation was a good idea or not.) Like the event for the SQL Server community, we ask someone to be a host each month, reveal a topic one week ahead of time, and then on the first Friday of each month, we look to see who contributed blog posts from within the community. It's been a blast to see this little project reach more people each month. For September, I asked people to write about the features they're most excited about for the upcoming release of PostgreSQL 16. While I didn't put any constraints on the features people could write about, I suggested that they try to identify some features that hadn't gotten a lot of attention yet. Although there were only a few submissions this month (September and October are busy in the PostgreSQL community), one thing stuck out to me from everything that people wrote about. Some of the smallest, and seemingly insignificant changes, are the most exciting to a lot of people. At Redgate, we talk often about the concept of "shifting left", working to bring database development automation as early in pipeline as possible. And for many of these little features that people got excited about, it's often because it solves a small, but consistently annoying need for many people. It's almost as if the tasks that took just a little bit longer in previous versions of PostgreSQL are now more easily accessible and developers can "shift left" and be more productive directly within the database. What does that look like in your world right now? - Are there tasks at work that you can automate in a new way to free up more of your time for something more productive? - Is there a feature of the database platform you use that has always been a little bit confusing to you, but may result in large productivity gains if you spent a little extra time figuring it out? - Can you call a lunch-and-learn meeting at work sometime this month and pass on that cool trick you just learned at the conference you went to? What I continually see, much like in the responses to PostgreSQL 16 features, is that the mundane improvements often have the largest impact. Take a look around you and see what small change you can make this week that might have an outsized impact in the future. Ryan Booz [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 [Mastering a Cloud Migration: 10 Video Tips]( If you haven’t had time to catch up on our latest full-length webinar on Cloud Migration, here’s an easy way to digest the tips from our experts in less than 20 minutes! AI/Machine Learning/Cognitive Services [You need to talk to your kid about AI. Here are 6 things you should say.]( From Technology Review Feed - Tech Review Top Stories In the past year, kids, teachers, and parents have had a crash course in artificial intelligence, thanks to the wildly popular AI chatbot ChatGPT.  In a knee-jerk reaction, some... [We know remarkably little about how AI language models work]( From Technology Review Feed - Tech Review Top Stories AI language models are not humans, and yet we evaluate them as if they were, using tests like the bar exam or the United States Medical Licensing Examination. The... [Video: A Primer on Machine Learning Operations (MLOps)]( From 36 Chambers – The Legendary Journeys THE VIDEO THE SYNOPSIS In this video, we briefly cover the core principles of DevOps and DataOps, then learn how we can apply those ideas to machine learning projects.... [Kinetica CEO Nima Negahban on Data Management and Generative AI]( From Past News - RSS Feeds I spoke with Nima Negahban, CEO of Kinetica, about... Administration of SQL Server [Is Your SQL Server Ready for a Compliance Audit?]( From StraightPath Solutions SQL Blog Compliance audits ensure that organizations adhere to regulatory guidelines, industry standards, and internal policies. As SQL Server DBAs, you can be prepared for most audits if you already check... [Yet another kind of orphan users in SQL Server]( From SQLServerCentral Blogs Yet another kind of orphan users in SQL Server Or YAOU for short. (This silly acronym, I just made it up so don’t try... The post Yet another kind of orphan... Azure SQL [Scale-Out Read-Only Databases in Azure SQL DB]( From Curated SQL Etienne Lopes begins a new series: “As part of High Availability architecture, each single database, elastic pool database, and managed instance in the Premium and Business… Azure SQL Managed Instance [How to restore backups from Amazon S3 to Azure SQL Managed Instance]( From Azure SQL Support for restoring database backups from Amazon S3 to Azure SQL Managed Instance (MI) is now Generally Available (GA)! This feature offers users a flexible way of restoring backups and... Career, Employment, and Certifications [Who’s Hiring in the Microsoft Data Platform Community? September 2023 Edition]( From Brent Ozar Unlimited Is your company hiring for a database position as of September 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up some... [Finding the Right Data Science Role: 4 Key Criteria]( From Dataversity Landing a Data Science role is one thing, but joining an organization where you can truly thrive is quite another. As a Data Science talent strategy leader, I can share... Cloud - Azure [Australian Azure Downtime After-Action Report]( From Curated SQL Brent Ozar shares some thoughts: Note that 11:34, the decision was made to shut down infrastructure without Microsoft failing your databases over elsewhere. If you were an… Community Interests [BotChat BiWeekly 1.00.00]( From SQLServerCentral Blogs Hey there, I’m Mala. I’ve been in the data game for a good 25 years, first as a DBA and then as a Data Engineer, mainly working with Microsoft... The... Conferences, Classes, Events, and Webinars [DevOps Rocks - Don’t Miss the Tour]( Your DevOps learning journey starts here. Join Redgate's Roadshow as it goes from coast to coast, wrapping up in Seattle at the PASS conference. Sign up today. [Secrets Declassified: How Federal agencies can streamline cybersecurity compliance with DevSecOps]( The Federal sector has traditionally been slower in adopting advanced software development practices like Agile and DevOps, but organizations like the DoD and DISA are now raising the game to a new level with DevSecOps. Data Access / ORMs [Choosing a Data Serialization Format]( From Curated SQL Rathish Kumar says more than “JSON and Parquet”: In the world of software, we often work with different types of data like lists, tables, and… Database Design, Theory and Development [Managing Test Data for Database Development]( In coming up with a strategy for managing test data, first you need to understand what the many test requirements are likely to be for the particular database you are developing. Next, you need to create all the different categories of test data required to suite test requirements and, finally, work out how to manage it in a way that allows a test-driven approach to development. [Optimizing Queries in MySQL: Optimizing Updates]( In the previous parts of these MySQL optimization series, we’ve told you how queries work on a high level, then dived deeper into the power of SELECT and INSERT statements. In this blog, I will cover some of the ways to optimize modifying your data too. [Why You Should Build Debugging Into Your SQL Server Stored Procedures]( From Erik Darling Data Quotable SQL Server is pretty good at a lot of things, but there’s no great way to debug logic or performance issues in longer stored procedures. Whenever I’m writing... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Fabric Dataflows Gen2: To Stage Or Not To Stage?]( From Chris Webb's BI Blog Enabling or disabling staging on a Dataflows Gen2 query can have a big impact on performance Oracle/PostgreSQL/MySQL/other RDBMS [Orchestrating a MySQL Container on Kubernetes]( From Simple Talk If you’ve been using MySQL for a while and want to learn how to orchestrate MySQL containers, you’ve come to the right place. And while using Docker on its... Performance Tuning SQL Server [A Reintroduction To sp_PressureDetector]( From Erik Darling Data A Reintroduction To sp_PressureDetector  Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount... PowerPivot/PowerQuery/PowerBI [The Value of KPIs and Cards in Power BI]( From Curated SQL Kurt Buhler and Stepan Resl give you a card: When a user arrives at your report, they should be able to answer their most important… [Yet Another Currency Conversion Pattern]( From Prologika (Teo Lachev's Weblog) Currency conversion is a common requirement, such ... SQL Server Security and Auditing [Row-Level Security Setup in SQL Server]( From Curated SQL Ben Johnston configures row-level security in SQL Server: Implementing RLS is as much a business endeavour as technical. Without a business case to implement RLS,… [MSSQL Databases Under Fire From FreeWorld Ransomware]( From Dark Reading: Dark Reading News Analysis The sophisticated attacks, tracked as DB#JAMMER, r... [SQL Server Row Level Security Deep Dive. Part 2 – Setup and Examples]( From Simple Talk The previous section in this series was an introduction to Row Level Security (RLS) and some use cases. This section focuses on basic setup of RLS, methods for implementing... Software Development [How Vercel Shipped Cron Jobs in 2 Months Using Amazon EventBridge Scheduler]( From AWS News Blog Vercel implemented Cron Jobs using Amazon EventBridge Scheduler, enabling their customers to create, manage, and run scheduled tasks at scale. The adoption of this feature was rapid, reaching over... T-SQL and Query Languages [What is the READPAST Query Hint?]( From Callihan Data Have you ever heard of the READPAST query hint? I would say it’s kind of a sibling to NOLOCK. With NOLOCK, you’ll get data back faster but risk dirty... Tech News [Zinc batteries that offer an alternative to lithium just got a big boost]( From Technology Review Feed - Tech Review Top Stories One of the leading companies offering alternatives to lithium batteries for the grid just got a nearly $400 million loan from the US Department of Energy.  Eos Energy makes...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -