Community at PASS Summit (DBW 2023-09-30)

Database Weekly for September 30, 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  Community at PASS Summit Last Saturday, September 23, was the first day of Fall. Regardless of how much has happened and changed over the last three and a half years, time keeps marching forward. And yet, there's exciting familiarity every time I see November approaching because I know something special is about to happen for those of us in the data community. In just over six weeks, PASS Data Community Summit will kick off once again. With 17 different pre-con sessions and nearly 200 regular sessions, there are many opportunities to grow your skills and learn something new. We tend to be a curious bunch that thrives on hearing about new technologies and seeing new ways of applying the skills we have. PASS Summit is the best place to do that for data professionals. But the real advantage, the real reason to consider attending is community. At least that's what I think… alongside many others in the #SQLFamily. What do I mean by community? Great question! In the cycle of seasons, some are going to knock your socks off… and others will make you pine for years gone by. Professionally and personally. Having some anchors to mark time by is important. PASS Summit provides a consistency of friendly, familiar faces, people actively looking to share and learn from each other. As the saying goes, "a rising tide lifts all boats," and that's how I see the community working together each November at Summit. That's where I see the power of community working for the good of everyone. I understand that not everyone will be able to make it. There will be some FOMO as things get underway and social media posts go live. But don't let that discourage you. Watch the keynotes and any other sessions that might be streamed. Be curious about the topics that people are talking about online throughout the week. If you see a particular speaker is presenting a session you would have liked to attend, reach out to them, and see if you can have the slides or if there's a previous recording of a similar talk. Again, community is about lifting one another up, whether you're able to be in Seattle or not. If you've been on the fence about attending, give the schedule another look. The content is top notch, the partners and sponsors are stellar, and the nightly opportunities to meaningfully connect with other attendees abound. Consider diving into the #SQLFamily and data community in a new way this year, November 14-17, in Seattle. And if you come, please reach out and say "hello!" []( 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. AI/Machine Learning/Cognitive Services [What’s changed since the “pause AI” letter six months ago?]( From Technology Review Feed - Tech Review Top Stories This story originally appeared in The Algorithm, our weekly newsletter on AI. To get stories like this in your inbox first, sign up here. Last Friday marked six months... Administration of SQL Server [A Little About The CXSYNC_PORT Wait In SQL Server 2022]( From Erik Darling Data A Little About The CXSYNC_PORT Wait In SQL Server 2022 Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training.... Cloud - AWS [Amazon MSK Introduces Managed Data Delivery from Apache Kafka to Your Data Lake]( From AWS News Blog I’m excited to announce today a new capability of Amazon Managed Streaming for Apache Kafka (Amazon MSK) that allows you to continuously load data from an Apache Kafka cluster... Community Interests [T-SQL Tuesday: Encryption and Data Protection]( Matthew McGiffen is hosting T-SQL Tuesday for October and has already posted the topic to give you a little extra time: Encryption and Data Protection... Computing in the Cloud (Azure, Google, AWS) [Upgrading SQL Server Cloud VMs]( From Curated SQL Brent Ozar recommends you check your cloud provider’s VM listings: If you’ve been in Azure or Amazon for a few years, you’re probably on old,… Conferences, Classes, Events, and Webinars [PostgreSQL 101: An introduction to Multi-Version Concurrency Control and Vacuum]( Both Multi-Version Concurrency Control (MVCC) and vacuuming are essential concepts to understand when using PostgreSQL. Join this webinar on October 24th and find out how MVCC is implemented in PostgreSQL, the role of vacuuming, and the settings and processes to tune for optimal performance. [My Precon At PASS Data Summit: The Foundations Of SQL Server Performance Tuning @PASSDataSummit #PASSDataSummit]( From Erik Darling Data The Foundations Of SQL Server Performance Tuning This year at the PASS Data Summit, I’m presenting my precon The Foundations Of SQL Server Performance Tuning: Whether you want to... DMO/SMO/Powershell [Enable PowerShell Remoting]( From SQLServerCentral Blogs Enable PowerShell Remoting I use PowerShell quite a lot to manage servers, especially SQL Servers. So I need to be able to run PowerShell... The post Enable PowerShell Remoting appeared first... Data Visualisation [ggplot2 in Python Notebooks]( From Curated SQL John Mount runs R in Python with rpy2: For an article on A/B testing that I am preparing, I asked my partner Dr. Nina Zumel… Database Design, Theory and Development [Database Monitoring for Developers]( Database monitoring is an essential part of database development and testing because it will reveal problems early and allow you to drill down to the root cause, as well as look for any worrying trends in behavior of the database, when under load. If you are delaying doing this until a database is in production, you're doing it wrong. [What Is an Execution Plan and How to Find It in PostgreSQL]( In the last blog (When PostgreSQL Parameter Tuning is not the Answer), we compared several execution plans for a SQL statement as we made changes to parameters and indexes. Still, there was no mention of what an execution plan is, how one can obtain an execution plan for a query, and how to interpret the result. In this blog, we’ll take a deep dive into this topic ETL/SSIS/Azure Data Factory/Biml [Deploy an SSIS Project to an ADF Azure-SSIS IR Course Now Available]( From AndyLeonard.blog() I am excited to announce the availability of Deploy an SSIS Project to an ADF Azure-SSIS IR, a new Azure QuickStart course! Access the new course – along with... Excel [How to easily send an Excel extact using a paginated report in Power BI]( From FourMoo The goal of this blog post is to show you how to create a subscription which sends the data in an Excel attachment. To do this I will first... MDX/DAX [Finding products without sales by using DAX]( From Sqlbi Analyze the performance of different DAX techniques to identify any products without sales in an area or a time period. [Finding products without sales by using DAX]( From Sqlbi This article analyzes the performance of different DAX techniques to identify any products without sales in an area or a time period. What products did not sell in a... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Saying Yes to Fabric OneLake Shortcuts, No to Duplicate]( From RADACAD Microsoft Fabric uses OneLake as the single logical layer for storage management across the Fabric. OneLake offers Domains and workspaces to work with Fabric Items, and amid all those... Oracle/PostgreSQL/MySQL/other RDBMS [MySQL joins]( From Simple Talk Tables in a MySQL database are commonly related to one another, often in multiple ways, and it is only by linking the tables together that you can derive meaningful... PowerPivot/PowerQuery/PowerBI [Exploring the Split Columns Option in Power Query Editor for Power BI]( From MSSQL Tips Learn how to use Power BI and Power Query to split up data from one column into multiple columns using various ways of delimiting the data. [Keep Your Existing Power BI Data And Add New Data To It Using Fabric]( From Chris Webb's BI Blog Fabric makes it easier to add new data to the data you have already loaded into Power BI R Language [Data Exploration in R with dplyr]( From Curated SQL Adrian Tam continues a series on R: I like dplyr a lot for its “functional flow”—you pipe outputs of one function to be inputs of… [Pairs Plots in Base R]( From Curated SQL Steven Sanderson shows how we can create a pairs plot using the pairs() function in R: A pairs plot, also known as a scatterplot matrix,… SQL Server Security and Auditing [Penetration Testing your SQL Server, Part 1 – The Recon Mission]( From SQL Undercover Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking quite a bit about security. Do we really know how secure our SQL Servers are?... Security News and Issues [Chrome Flags Third Zero-Day This Month That's Tied to Spying Exploits]( From Dark Reading: Dark Reading News Analysis So far this year, Google has disclosed six vulnerabilities that attackers were actively exploiting before the company had a patch for them. [Microsoft Adds Passkeys to Windows 11]( From Dark Reading: Dark Reading News Analysis It's the latest step in the gradual shift away from traditional passwords. [How to get your security team on board with your cloud migration]( From Blog – Redgate Software To find out more about cloud migrations, the pitfalls that await the unwary, and what the security implications are, I recently sat down with Dustin Dorsey, Systems & Data... [Security in the cloud: Whose responsibility is it?]( From Blog – Redgate Software While the cloud is recognized as more secure than on-premises servers and infrastructures, it does come with the often talked about shared responsibility model. Cloud providers are responsible for... [When It Comes to Email Security, the Cloud You Pick Matters]( From Dark Reading: Dark Reading News Analysis While cloud-based email offers more security than on-premises, insurance firms say it matters whether you use Microsoft 365 or Google Workspace. [MOVEit Flaw Leads to 900 University Data Breaches]( From Dark Reading: Dark Reading News Analysis National Student Clearinghouse, a nonprofit serving thousands of universities with enrollment services, exposes more than 900 schools within its MOVEit environment. [Don't Get Burned by CAPTCHAs: A Recipe for Accurate Bot Protection]( From Dark Reading: Dark Reading News Analysis Traditional CAPTCHAs, such as reCAPTCHA, no longer protect online businesses adequately. Real users hate them. Bots bypass them. It's time to upgrade. Software Development [Bots Usage in Artificial Intelligence]( As technology advances, the capabilities of bots continue to expand, enabling more sophisticated interactions and driving innovation in AI applications. T-SQL and Query Languages [An update on MERGE]( From SQL Server Fast The MERGE statement compares source and target data, and then inserts into, updates, and deletes from the target table, all in a single statement. This statement was introduced in... [Unit Testing Dynamic SQL]( From Curated SQL Jay Robinson lays out a pattern: Dynamic SQL (aka Ad Hoc SQL) is SQL code that is generated at runtime. It’s quite common. Nearly every… [Using WITHIN GROUP to Order STRING_AGG Results]( From Callihan Data When was the last time you wrote a SQL query and knew something was possible but just couldn’t remember how? I had one of those moments this week with... Tech News [This robotic exoskeleton can help runners sprint faster]( From Technology Review Feed - Tech Review Top Stories A wearable exoskeleton can help runners increase their speed by encouraging them to take more steps, allowing them to cover short distances more quickly. While previous studies have focused... [Will Government Secure Open Source or Muck It Up?]( From Dark Reading: Dark Reading News Analysis The US government aims to support open source projects, while the European Union seeks to make open source projects liable for their software. Which approach will lead to more...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -