Technology news I'd probably be too shy to give you in person!

Database Weekly for October 5, 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  Being an extroverted introvert at a conference As I start this editorial, I am sitting at a PostgreSQL conference in New York City during the nighttime reception. The sound of 100 voices is not quite deafening, but it is certainly loud and understanding anyone in this group would be hard. It is also hard because I only know about four people at this conference well enough to hold a conversation. If you know me, you may think I am a loud, boisterous person, and I absolutely can be. Once I get to know a person or two in a group, I rarely stop talking, and I always have an opinion (for better or worse depending on the situation). Actually though, I am pretty introverted until the ice is broken, which is not terrible difficult when in a group where I have something directly in common with people. You’re at a database conference, what more do you need? The key here is something “directly in common”. Here at a PostgreSQL conference, I have a LOT of indirect commonalities with all of the people. The basics of relational databases is very similar between all platforms. Dr Codd set it up this way for a reason (actually at least [12 very specific reasons](. The most important part of this goal was to create this common data abstraction that would let databases, and their users not spend a lot of time relearning everything to go from platform to platform. But as any reader of this website and my articles probably knows, there are a lot of differences between PostgreSQL and SQL Server, especially in the stuff that Codd left alone (like indexes and physical storage). So, getting into most conversations at a conference like this means while I can listen in on conversations, and may actually understand most of the principles that are being discussed, I am also a novice at how and why PostgreSQL works as it does, especially at the internal level. So as an extroverted introvert, I spend a lot more time listening until I feel comfortable to speak. I eventually found a few conversations and met some new people though the few people I knew, but a lot of that is that I have learned to force myself to do this. In my first years of going to conferences (even as a speaker!) I didn’t really meet anyone until I made a few friends and finally started to expand my community. Just listening in and horning into other conversations feels really hard. I spent some time thinking about why this is (for me), and it comes down to not wanting to seem dumb. I asked a question in a session, and I was corrected because I used a term in a way that the speaker found too improper, kind of like you might in a college class or when tech editing a book. I might have said the same thing there, but her it wasn’t that big of a deal. All of this means missing out on a lot of quality conversations and meeting new people. This is an editorial, so what is the opinion? Do what you can to help newbies get along without making it seem too forced. When I was at [THAT Conference]( earlier this year, there was a big emphasis on networking. I was probably asked “what was my favorite session” 15 times over 5 days. Most of the time this was from people who weren’t really involved with technology directly, but it did start several conversations where we discovered common opinions and topics to talk about. I was not really that enthusiastic about this kind of interaction most of the time, because it didn’t always feel very authentic (especially when in the context of people who weren’t also going to sessions). A few times a felt like I was going on about something the person really didn’t want to hear or understand. On the other hand, there were Open Spaces where we registered topics we wanted to talk about, and people gathered and spoke. I did one with Steve Jones on writing and it was quite nice. The idea is that you have areas set up, and you let people pick their own topics. There were a few really odd sessions that seemed out of bounds for a conference like this (like politics… but I did learn some cool stuff from the photography one). For the most part it was a great way to break the ice and find other people who want to share something interesting. At the [PASS Summit]( most years, there is a Birds of a Feather event which is similar, but the topics are pre-vetted. In either case, if you are at a conference where there are things like this, drop by and check it out. The big opinion, try to find ways to get connected to people at a conference, and even more importantly, when you are running a conference, try to find ways to get people to connect to one another in an authentic manner. Lifetime memories will be made, and lifetime friend too. Final bit of honesty Do I know how to do this? Of course not, in fact, as the title of this article foreshadowed, I will actually dread the whole process. But every time I get involved it is always worth it.  Louis Davidson (@drsql) [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. Administration of SQL Server [The Only Valid Test of a Backup is a Restore]( From Scary DBA (Grant Fritchey) Please, let me reiterate: The only valid test of a... Azure Databricks, Spark and Snowflake [Trying out the Databricks For-Each Task]( From Curated SQL Chen Hirsh goes in a loop: Databricks recently added a for-each task to their workflow capability. Workflows are Databricks jobs, like Data factory pipelines, or… Conferences, Classes, Events, and Webinars [Register for PASS Summit 2024 before October 23 to save $300]( Secure your 3-day ticket to PASS Summit 2024 for $2,295, a saving of $300 on the final on-site price which comes into effect on October 23. [Attend Microsoft’s AI webinar to be in with a chance of winning a 3-day ticket to PASS Summit 2024]( On October 15, Microsoft’s Rie Merritt will join Redgate’s Steve Jones to share a sneak peek of Microsoft’s sessions at this year’s PASS Data Community Summit, covering how AI is reshaping the role of the data professional. The webinar will not only be a great preview of what’s to come, but everyone who attends live will have the chance to win a 3-day ticket to the November 6-8 conference (or on-demand access should you be unable to travel to Seattle). For more information and to sign up, click the title above. [Join Me And @Kendra_Little At @PASSDataSummit For 2 Days Of SQL Server Performance Tuning Precons!]( From Erik Darling Data Last Year Kendra and I both taught solo precons, a... [Small Data SF 2024]( From SQLServerCentral Blogs I can’t remember how I heard about Small Data SF 2024, but it caught my eye. The mix of sessions had me interested in going, especially with Mother Duck... The... Data Science [An Overview of Differential Privacy]( From Curated SQL Zachary Amos covers a topic of note: Data analytics tools allow users to quickly and thoroughly analyze large quantities of material, accelerating important processes. However,… Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Spaces in Microsoft Fabric Delta Table Names]( From Curated SQL Sandeep Pawar is looking for a bit more space: One of the annoying limitations of Direct Lake (rather of the SQL endpoint) was that you… [Role-Playing Dimensions In Fabric Direct Lake Semantic Models]( From Chris Webb's BI Blog Did you know you can add the same physical table i... [Data science with Microsoft Fabric – Plotting ROC curve and distribution of scores]( From TomazTsql ROC (Receiver Operation Characteristics) – curve... [Some GOTCHAs when using Mirroring in Microsoft Fabric]( From Guy in a Cube Mirroring in Microsoft Fabric can be very powerful... [Checklist for the DP-700 beta exam for the new Microsoft Fabric Data Engineering certification]( From Kevin Chant Reading Time: 4 minutes In this post I want to sh... Performance Tuning SQL Server [Optimize SQL LIKE Wildcard Searches]( From MSSQL Tips Learn about different ways to improve the performa... [A Little About Index Union Query Plans In SQL Server]( From Erik Darling Data A Little About Index Union Query Plans In SQL Server Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll... PostgreSQL [Nikolay Samokhvalov: AI-assisted Postgres experiment: number of partitions vs. planning time]( From Planet Postgres In one of the recent PostgresFM episodes, Michael ... PowerPivot/PowerQuery/PowerBI [Recovering Power BI Reports You Cannot Download]( From Curated SQL Kurt Buhler grabs a report: Read on to see how you can nonetheless recover these published reports using the semantic-link-labs library. R Language [Splitting Data into Equally-Sized Groups in R]( From Curated SQL Steven Sanderson splits out some data: As a beginner R programmer, you’ll often encounter situations where you need to divide your data into equal-sized groups.… Security News and Issues [Navigating Google’s Updated Cookie Policies To Safeguard User Data]( From IT Pro - Microsoft Windows Information, Solutions, Tools SMEs must navigate evolving privacy regulations an... [Thousands of Linux systems infected by stealthy malware since 2021]( From Ars Technica The ability to remain installed and undetected makes Perfctl hard to fight. [We’re Worried About Deepfake Voice Scams. How Do We Protect Employees?]( From IT Pro - Microsoft Windows Information, Solutions, Tools Scammers can mimic someone's voice with as little as a 10-second audio sample, using AI tools to create convincing deepfake phone calls. T-SQL and Query Languages [Techniques for Unpivoting Data in SQL Server]( From Curated SQL Jared Westover performs a technique showdown: A few weeks ago, I helped someone combine multiple integer columns into a single column. The common term for… [Reviewing the DATE_BUCKET() and DATETRUNC() Commands]( From Curated SQL Chad Callihan checks out a pair of functions new to SQL Server 2022: If you haven’t experimented much with SQL Server 2022, you may not… [Combine Multiple Columns Performance Comparison - SQL UNPIVOT, UNION ALL vs CROSS APPLY]( From MSSQL Tips In this article, we combine multiple columns from ... [Comparing an Old Running Total to Window Functions]( From SQLServerCentral Blogs Often I see running totals that are written in SQL... [Enabling an Index: #SQLNewBlogger]( From SQLServerCentral Blogs I don’t do a lot of work with disabled index, bu... Tech News [X fails to avoid Australia child safety fine by arguing Twitter doesn’t exist]( From Ars Technica Elon Musk merging Twitter into X didn't absolve X from child safety fine. Testing Software [Testing a Stored Procedure with tSQLt]( From Curated SQL Olivier Van Steenlant runs a test: In the previous data recipe, Create a Test Class & First Unit Test with tSQLt, we created our very first… Theory and Design [Transforming Queries Based on Human Intent]( From Curated SQL Andrei Lepikhov and Alena Rybakina ask a question: As usual, this project was prompted by multiple user reports with typical complaints, like ‘SQL server executes… Virtualization and Containers/Kubernetes [A Unified Approach to Managing Deployments in Kubernetes with Kluctl]( For every phase or environment in which you run your applications, there are configurations, resource requirements, or other settings that are unique to each environment. Kluctl allows you to define environment-specific parameters and configurations in a structured and maintainable way.  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -