| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| 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 |
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 Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training.... |
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... |
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) |
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 |
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. |
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... |
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... |
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 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. |
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 |
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... |
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... |
Analyze the performance of different DAX techniques to identify any products without sales in an area or a time period. |
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) |
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 |
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 |
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. |
Fabric makes it easier to add new data to the data you have already loaded into Power BI |
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… |
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 |
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?... |
So far this year, Google has disclosed six vulnerabilities that attackers were actively exploiting before the company had a patch for them. |
It's the latest step in the gradual shift away from traditional passwords. |
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... |
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... |
While cloud-based email offers more security than on-premises, insurance firms say it matters whether you use Microsoft 365 or Google Workspace. |
National Student Clearinghouse, a nonprofit serving thousands of universities with enrollment services, exposes more than 900 schools within its MOVEit environment. |
Traditional CAPTCHAs, such as reCAPTCHA, no longer protect online businesses adequately. Real users hate them. Bots bypass them. It's time to upgrade. |
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 |
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... |
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… |
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... |
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... |
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... | 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. |
|
|