Same Language, Different Words (DBW 2023-07-17)

Database Weekly for June 17, 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  Same Language, Different Words I had to come to the Redgate office in Cambridge this past week for a department onsite. As a result, my wife and I were able to come early for a few days adventuring together, the first trip we've taken by ourselves in nearly seven years. As a large family with six kids, it takes lot of planning and effort to make a getaway like this possible (and the kindness of family and friends to help!). Additionally, after 20 years of joking that "someday we'll celebrate our anniversary in Paris!", we did, in fact, get to take the Eurostar from London to Paris for the day and celebrate 21 years together on the second floor of the Eiffel Tower looking out over the city. The trip was a privilege, for sure, but a blessing nonetheless. Aside from that day trip to Paris, the other few days we had together were all in the UK. This meant that in theory, most of our travel was among cities and towns that spoke English and getting around should be straightforward. It was my wife's first time in the UK, and my first opportunity to spend time in London, specifically. What struck us both pretty quickly was that while we did speak the same language, we weren't using the same words all the time. Sometimes it was cute, and we'd chuckle at the differences. Other times, like running around in the subway Underground to get back to our hotel, it wasn't as fun trying to decipher the nuances. Here are a few quick examples of things we noticed often: - To exit of the Underground (or anywhere really), follow the "Way Out ->" signs. - When crossing the street, look right, not left, first (or play it safe and look both ways many times first!) - The street level of a building is the ground floor, not the first floor, so our second-floor room was up two flights of steps, not one. - And while most of the English speaking world knows that you "Mind the Gap" in the Underground, you need to "mind" your step, your head, your car, the construction, or anything else that could potentially harm you. There area a lot of "mind your…" signs about. These are simple examples, none of which prevented us from getting to the next stage of our journey. But we both quickly realized that we had to learn a new way of using the same language. So why am I sharing this with you? How might our experience last week relate to you as a data professional in June 2023? I believe the time is soon approaching (or has already arrived for some of us) when we'll need to get comfortable using the language we know in a slightly new (and sometimes frustrating) way. I also think there's a good chance that experience will involved PostgreSQL. In fact, I had to take that journey 6 years ago, and in our [most recent PostgreSQL 101 webinar]( I shared some high-level differences between SQL Server and PostgreSQL that I've learned throughout the journey. I spoke for a solid 60 minutes, and I could have easily gone for two or three hours. Interestingly, none of the things I shared were show-stoppers if your primary base of knowledge is T-SQL. There are differences, but they can be overcome with a little knowledge and a different perspective. Even if you've never used PostgreSQL, I'm positive that you would be able to insert and query basic data aggregations in the first few minutes of using it. When a query doesn't work the same and it requires a new understanding of the same language, you might step back and say, "oh, that's cute", like we did when someone called the evil character in a story the "baddie", rather than the "bad guy". Other times, you might want to scream and curse when you type "SELECT TOP(10)…" over and over while PostgreSQL gives you a syntax error each time. "But I'll never use {PostgreSQL|MySQL|Snowflake|etc.} so that doesn't pertain to me." Maybe not. However, Stack Overflow [released their yearly developer survey this past week,]( and the big story in the non-SQL Server world is that PostgreSQL overtook all databases as the #1 most sought-after database among developers, passing MySQL for the first time in the survey's history. Yes, you and I (along with Louis Davidson whom I discussed this with in Cambridge) are probably asking the same question. "Who are these developers?" I don't know, but there were more than 76,000 that answered the question. I suspect many of them are probably "full stack" developers, using JavaScript or Python ORMs to manage and query the database. They might use a tool like Vercel or Netlify to organize their entire stack, including one-click database creation and access. The thing is, this isn't an anomaly in the trend. Over the last five years, the combined investment of all organizations and cloud providers, old and new, in database technology has arguably been the greatest in PostgreSQL. And I can promise you that investment is going to keep growing in the coming years. If you have a few years left in your career but have never connected to a PostgreSQL database, I personally think it's a safe bet that you'll have to in the next 4-5 years. Consider giving it a try sometime in 2023. One way to get started is to listen to our previous PostgreSQL 101 webinars or attend the one [this coming Thursday, June 22]( when I'll discuss your first steps to setting up and connecting to a PostgreSQL database. Maybe you could follow some of the [tutorials for Azure DB for PostgreSQL]( or try the in-browser [Crunchydata PostgreSQL Playground](. Or consider coming to [PASS Data Community Summit]( where we'll have a new PostgreSQL learning path, a pre-con, and a handful of sessions to teach you many of the differences and similarities to help you on your learning journey. We'll even have several of the long-time core maintainers of the project at Summit! The main thing to remember is that the primary language is the same. However, the T-SQL implementation won't always match what the PostgreSQL implementation is, and vice versa. You're likely to find the "Way Out ->" when needed, and as long as you look both ways before crossing the street, there won't be unrecoverable damage. You'll just be learning some new ways of using the language you're already comfortable with, and a database that offers some exciting new opportunities to grow and learn. What about you? Have you recently tried to use a new database or data technology? What were some of the challenges or similarities that surprised you? 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 [Searching Flyway Migration Files using Grep and Regex]( This article demonstrates a cross-RDBMS way of searching through a set of SQL migration files, in the right order, to get a narrative summary of what changes were made, or will be made, to one or more of the tables or routines within each migration file. Getting these summary reports, even from a set of SQL migrations, isn't difficult, but having a few examples makes it a lot quicker to get started. AI/Machine Learning/Cognitive Services [European Parliament Preps AI Regulation Targeting Apps Like ChatGPT]( From Tom's Hardware US MEPs have proposed new regulation that addresses h... [Generative AI Will Change the Future of Technology Organizations]( From IT Pro - Microsoft Windows Information, Solutions, Tools To tackle the challenge of tech talent supply, technology leaders are leveraging AI-driven technologies. [You Can’t Regulate What You Don’t Understand]( From O'Reilly Radar - Insight The world changed on November 30, 2022 as surely as it did on August 12, 1908 when the first Model T left the Ford assembly line. That was the... [Plagiarism Engine: Google’s Content-Swiping AI Could Break the Internet]( From Tom's Hardware US The AI service is stealing content from publishers... [AWS Uses Intel's Habana Gaudi for Large Language Models]( From Tom's Hardware US AWS uses PyTorch with DeepSpeed to train large lan... Administration of SQL Server [Debunking Security Myths with SQL Server]( From Curated SQL Eitan Blumin has some myths for us: Many organizations assume that their SQL Server is secure because it is behind a firewall. However, firewalls only… [sp_PressureDetector: Why You Need The Remote DAC Enabled]( From Erik Darling Data sp_PressureDetector: Why You Need The Remote DAC Enabled Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering... Azure Databricks, Spark and Snowflake [Computed Columns in Snowflake]( From Curated SQL Kevin Wilkie does the math: Sometimes to make our lives easier, we, as database engineers, can create a table that automatically tells us the answer… Azure SQL Managed Instance [Impact of Memory Grant Feedback on Azure SQL Managed Instance]( From Azure Database Support Blog Issue Incorrect memory grants on certain queries c... Career, Employment, and Certifications [From Tech Worker to IT Management: Ten Steps to Success]( Congratulations! You got the promotion! Once the excitement and adrenaline rush of a promotion passes, it is common to find yourself staring at the yawning abyss of the unknown. Community Interests [The Simple-Talk Editor’s Blog]( From Simple Talk Today I am starting (well, restarting) a new feature here on Simple-Talk, The Editor’s Blog. This blog will cover topics about writing technical blogs and articles, how to access the... [The New Redgate Office in Cambridge]( From SQLServerCentral Blogs I’m in Cambridge, UK this week for the internal Global Marketing Week and Level Up Conference. This is my first visit to Cambridge in 2023, and we have a... The... [Poll Results: Are You Going Back to In-Person Events?]( From Brent Ozar Unlimited Last week, I asked if y’all had been to in-person regional events before, and whether you were going back. I wanted to know because Data Saturdays and SQL Saturdays... Computing in the Cloud (Azure, Google, AWS) [How GoDaddy Implemented a Multi-Region Event-Driven Platform at Scale]( From AWS News Blog GoDaddy, a leading global provider of domain registration and web hosting services, has served over 84 million domains and 22 million customers since its establishment in 1997. Among its... [Have You Reviewed Your Azure Storage Bill Lately?]( From Jeff Taylor At the end of 2021, I started using the new SFTP preview feature on Azure Data Lake Storage Gen 2. It was a great new addition to the... [Public Preview: Redis extension for Azure Functions]( From Azure Updates You can now leverage Redis data types as triggers for serverless app development. Conferences, Classes, Events, and Webinars [First speakers announced for Summit 2023]( Your first speakers in the lineup for PASS Data Community Summit 2023 have been announced! Check out the full details for this year's Pre-Cons and Learning Pathways, and find out why some of our speakers are particularly excited for what’s in store this year. [PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers]( In the first two webinars, we've discussed why PostgreSQL has become such a force in recent years and some of the main differences for SQL Server users to know. In this follow-up webinar, find out how to take your first steps using PostgreSQL. Join Ryan Booz, PostgreSQL Advocate at Redgate, and discover: The freely available options to help you get started The essential tools you will need when using PostgreSQL Some learning resources to help you take the next steps DMO/SMO/Powershell [Implementing Multiple Retries in Powershell]( From Curated SQL Jose Manuel Jurado Diaz has a script for us: We often encounter support cases where our customers leave the query execution timeout value at its… [Measure Link Speed (Bandwith) with PowerShell]( From Sid 500 PoSh Recently I have been working on a script which should check the download speed. With PowerShell of course. I would like to share it here. The Code Here is... General [Shiny Apps and Fullscreen Behavior]( From Curated SQL Tim Brock gives us a demo: Browsers have been implementing variations on a JavaScript fullscreen API for over a decade. Unfortunately, for much of that… Hardware [Microsoft Now Offering Replacement Hardware for Surface Devices]( From Curated SQL Laurent Giret shares the good news; Starting today, Microsoft is now offering replacement components for Surface devices in its Microsoft Store. This should be great news for… Hardware Testing [Apple's M2 Ultra Seemingly Can't Beat AMD and Intel Rivals]( From Tom's Hardware US Apple's M2 Ultra cannot beat Intel's Core i9-13900... MDX/DAX [Understanding the TIMELINE in DAX Studio]( From Guy in a Cube We brought Marco in to help explain the TIMELINE update within DAX Studio. This can help you understand performance a bit deeper when optimizing your DAX and models. This... [Calculating Moving Averages with DAX]( From Curated SQL Leila Etaati smooths the curve: The calculation will be done for all rows, till we don’t have the anymore data ahead ( 3 rows ahead)… [Calculating the trend of a Chart using DAX ( Smoothing Moving Average)]( From RADACAD Calculating the trend of a line chart can be possi... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Data Intelligence on light speed: Microsoft Fabric]( Microsoft Fabric brings all the services needed for a data intelligence environment aggregated together, heavily integrated and built in a way that requires far less technical effort for the implementation. [Drillthrough support in Paginated Reports now available!]( From Dan English's BI Blog Last month there was a new update that has been made that provides support for drillthrough report actions in the Power BI service (Microsoft Fabric)! Those of you who... [Contrasting Lakehouse, Warehouse, and Datamart in Fabric & Power BI]( From Curated SQL Reza Rad disambiguates three terms: Three types of objects in the Microsoft Fabric have similarities in what they can do for an analytics system. These… [Create your own Microsoft Fabric environment]( From Kevin Chant Reading Time: 5 minutes In this post I want to cover one way that you can create your own Microsoft Fabric environment. Plus, this post contains additional content... [Power Query Templates In Excel And Fabric]( From Chris Webb's BI Blog Export and import Power Query template files in Ex... Oracle/PostgreSQL/MySQL/other RDBMS [Thoughts on Community-Driven Documentation in Postgres]( From Curated SQL Robert Haas shares some thoughts: In my opinion, the PostgreSQL documentation is simultaneously excellent and fairly poor, and both its excellence and its shortcomings are… [Optimizing MySQL: Adding Data to Tables]( In this blog, we’re further learning ways to optimize INSERT operations and look at alternatives when you need to load more than a few rows in the LOAD DATA INFILE statement. PowerPivot/PowerQuery/PowerBI [Changing Visual Titles on Filter with DAX]( From Curated SQL Allison Kennedy has a new title: Today’s post is a short one with a video to demonstrate what I have learned. I’m a big believer… [Data Modelling for DirectQuery]( From Excelerator BI In my last article I introduced the three different connectivity modes that are available for Power BI to fetch data from a source, with a specific focus on when and where... R Language [Listing Files by Date in R]( From Curated SQL Steven Sanderson shows off a built-in function: In R, the file.info() function is a useful tool for retrieving file information, such as file attributes and metadata. It… Security News and Issues [Microsoft Drops Support for Windows 10 Version 21H2]( From Petri IT Knowledgebase Microsoft has officially dropped support for Windo... [Have I Been Pwned Domain Searches: The Big 5 Announcements!]( From Troy Hunt Presently sponsored by: Kolide can get your cross-... T-SQL and Query Languages [SQL SERVER – Difference Between ISNULL and COALESCE]( From Journey to SQL Authority with Pinal Dave SQL Server provides two commonly used functions, ISNULL and COALESCE, to address this requirement. Difference Between ISNULL and COALESCE First appeared on SQL SERVER – Difference Between ISNULL and COALESCE [Video: Betwixt and BETWEEN]( From 36 Chambers – The Legendary Journeys THE VIDEO THE SYNOPSIS In this video, we will look at a variety of inequality operators in T-SQL, including the new IS [NOT] DISTINCT FROM syntax in SQL Server... [T-SQL Tuesday Throwback]( From Callihan Data As I’m writing this, it’s June 11, 2023. I’ve been checking each day over the last week to see if a T-SQL Tuesday topic would come out for this... [Avoid “Constants” in T-SQL]( From SQLServerCentral Blogs Here we look at a common query "anti-pattern" that can create performance problems - and how you work around it. The post Avoid “Constants” in T-SQL appeared first on SQLServerCentral. Tech News [As Amazon’s Second HQ Opens in Virginia, Neighbors Brace for a Transformation]( From IT Pro - Microsoft Windows Information, Solutions, Tools The opening of Amazon's massive new campus has left the tech giant's new neighbors with wildly divergent predictions about what might happen next. [How tactile graphics can help end image poverty]( From Technology Review Feed - Tech Review Top Stories In 2020, in the midst of pandemic lockdown, my hus... [Escrow Buddy: An open-source tool from Netflix for remediation of missing FileVault keys in MDM]( From Netflix TechBlog - Medium Netflix has open-sourced Escrow Buddy, which helps Security and IT teams ensure they have valid FileVault recovery keys for all their Macs in MDM.To be a client systems engineer is... [An Inside Look at How Raspberry Pis Are Made]( From Tom's Hardware US Jeff Geerling shares an inside look at how Raspber... [Migrating Critical Traffic At Scale with No Downtime — Part 2]( From Netflix TechBlog - Medium Migrating Critical Traffic At Scale with No Downtime — Part 2Shyam Gala, Javier Fernandez-Ivern, Anup Rokkam Pratap, Devang ShahPicture yourself enthralled by the latest episode of your beloved Netflix series, delighting in an... Tools for Dev (SSMS, ADS, VS, etc.) [SQL Server Management Studio (SSMS) 19.1 and Recent Changes, Part 2]( From MS SQL Server Blog This is the second post in a series discussing changes between SSMS 18.12.1 and SSMS 19, and new functionality in SSMS 19.1. You can view the first post covering...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -