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!"

https://www.passdatacommunitysummit.com

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 FeedTwitter
This email has been sent to newsletter@newslettercollector.com. 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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -