Community, Community, Community

Database Weekly for December 16, 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  A Thriving Community Lifts All Boats I'm writing this on the last day of [PGConf.EU]( sitting here in Prague. I'm looking forward to sitting in several more sessions today, as well as having a few more conversations with the people at the conference. It's been a great event and I'm so happy I've been able to take part. Following the [PASS Data Community Summit]( just a few weeks ago, it reminds me, again, of just how important a thriving community is to us as technologists. I've shared my story about how community changed my life and my career before, so I won't bore you with it again. Instead, let me tell you about something that happened in the vendor hall yesterday. A couple of people came up to me, who had attended the training day session that Ryan Booz and myself had put on (OK, mostly Ryan, but I really did help). They had a question about auto-vacuum in PostgreSQL. I'm still learning about the vacuum, so I didn't feel qualified to answer. I looked around and spotted one of the event organizers. I walked them over, made an introduction, and got the conversation started. The organizer then spotted another person walking by and roped them into the conversation. A nice technical discussion followed and the two people left with a lot more information than they had before. Why does this matter? By engaging with the people within the PostgreSQL community, I've started, slowly, to make connections. What matters isn't that I can ask those people questions. Rather, it's that I can then make the right connections for others who have questions that I can't answer. And the PostgreSQL community, like the SQL Server community, is more than happy to literally give out free consulting time, to give some answers. In short, knowledge, skills, understanding, is shared freely and we all improve. Your task is a simple one. Get engaged with your technical community, regardless of the technology. Yes, in-person events such as PGConf.EU make these kind of quick. easy conversations even easier, but online communities thrive and can function in the same way, albeit a little slower. Whether online or off, make those connections because they will help you, yes, but also because they'll enable you to help others. And, follow the lead of both the PostgreSQL community and the SQL Server community, do it with kindness.  Grant Fritchey [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 [Why Enterprises Are Racing to Adopt Automation and AI]( From IT Pro - Microsoft Windows Information, Solutions, Tools A new survey finds enterprises are rapidly adoptin... [Copyright, AI, and Provenance]( From O'Reilly Radar - Insight Generative AI stretches our current copyright law ... [Fast-Tracking SEC Compliance with AI for GRC and Cybersecurity Disclosure]( From Dataversity This year, the U.S. Securities and Exchange Commis... [Warning of ‘Risk to Our Survival,’ Pope Calls for Global Treaty on AI]( From IT Pro - Microsoft Windows Information, Solutions, Tools Pope Francis calls for AI regulation to prevent ha... [Now we know what OpenAI’s superalignment team has been up to]( From Technology Review Feed - Tech Review Top Stories OpenAI has announced the first results from its su... Administration of SQL Server [Baseline SQLServer with SQLMonitor v1.6.0]( From Ajay Dwivedi's SQL Server Blog How to baseline & Monitor SQLServers using ope... [Advanced testing with WAITFOR in SQL Server client tools]( From MSSQL Tips Learn about the WAITFOR command in SQL Server to d... [Just WAITFOR it : tips for testing in SSMS]( From SQLBlog.org I talk about some rarely-used WAITFOR functionalit... [Executing One Line in VSCode–#SQLNewBlogger]( From SQLServerCentral Blogs I wrote about arrays in PowerShell last week, but ... [How to Test Trace Flag 3625]( From SQLServerCentral Blogs Recently, one of my customers considered enabling ... [An overview of SQL Server monitoring tools]( From SQLShack This article explains some of the popular SQL Serv... [Clearing Intellisense in SQL Prompt]( From SQLServerCentral Blogs I got this question from an account rep: if a cust... [Backup SQL Server on Linux Databases using SQL Server Agent on Windows]( From MSSQL Tips In this tip, we're going to look at the steps to b... [Cumulative Update #24 for SQL Server 2019 RTM]( From MS SQL Server Blog The 24th cumulative update release for SQL Server ... Azure SQL [Arc enabled Azure migration & modernization journey]( From MS SQL Server Blog As business demands evolve, applications must be m... [Exploring Custom Spark Pools in Microsoft Fabric Lakehouses]( From Guy in a Cube With Microsoft Fabric Lakehouses you begin with a ... [Save Money on Azure SQL DB]( From AndyLeonard.blog() Regular readers of this blog know I am all about s... Career, Employment, and Certifications [Soft Skills - What we got here, is a failure to communicate...]( From SQL Rod A lot of us are techies right? We love the technic... Cloud - AWS [New for AWS Amplify – Query MySQL and PostgreSQL database for AWS CDK]( From AWS News Blog Today we are announcing the general availability t... Cloud - Azure [Here’s How Run Command Simplifies Management Operations on Azure Arc-Enabled Servers]( From Petri IT Knowledgebase Microsoft has introduced Run Command support in pu... Community Interests [T-SQL Tuesday 169 – Thank you to my old SQL team]( From Kevin Chant Reading Time: 2 minutes For this months T-SQL Tue... [T-SQL Tuesday 169 – Thank you, community!]( From SQL Server Fast It is December. And it is Tuesday. So I guess it�... [T-SQL Tuesday #169 – Thanks!]( From Deb the DBA It’s the last T-SQL Tuesday of 2023. Our host th... [Festive Tech Calendar 2023]( From DBAKevlar It’s almost my turn to present my video this yea... [T-SQL Tuesday #169 : Thanks!]( From SQLBlog.org This month, Kay Sauter encourages us to say thanks... [T-SQL Tuesday #169 – Thank You]( From Callihan Data As hard as it may be to believe, it’s time for t... [T-SQL Tuesday #169 – Giving Thanks]( From Andy Broadsword This month’s invitation from Kay asks us to lo... [don't postpone joy: a holiday message from SWD]( From Storytelling with Data Alberto Cairo, in our recent conversation on the S... Data Mining / Data Analysis [Tech the halls: Celebrating winter wins with Women in Analytics]( From AllAnalytics With the holidays and the new year quickly approac... [Getting Started with DuckDB for Fast Analytical Query Workloads on Large Datasets]( From MSSQL Tips In this article, we learn about DuckDB which is a ... [3 reasons why Model Manager and Intelligent Decisioning are the perfect analytics pairing]( From AllAnalytics The holiday season has arrived, culminating in cel... DevOps and Continuous Delivery (CI/CD) [Passing Parameters and Settings to Flyway Scripts]( From Product learning – Redgate Software This article explains the various ways of using pl... [MySQL Error Log Management in DevOps Operations]( From Simple Talk When it comes to the development and operations (D... Machine Learning [New SAS Training Course: Statistics You Need to Know for Machine Learning]( From AllAnalytics Developing an accurate understanding of statistics... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Advent of 2023, Day 9 – Building custom environments]( From TomazTsql In this Microsoft Fabric series: We have explored ... [Fabric Notebooks and Deployment Pipelines]( From Simple Talk On my article about Fabric source control extended... [Advent of 2023, Day 14 – Data warehouse with Microsoft Fabric]( From TomazTsql In this Microsoft Fabric series: Today we will start exploring the Fabric Data Warehouse. With the data lake-centric logic, the data warehouse in Fabric is built on a distributed... [Creating a Workspace in Fabric]( From AndyLeonard.blog() In November 2023, I shared how to start learning M... Oracle/PostgreSQL/MySQL/other RDBMS [Exploring PostgreSQL Indexes]( From Simple Talk In this blog, we continue our exploration on Postg... Performance Tuning SQL Server [Documenting What Microsoft Won’t: The sys.sp_configure_automatic_tuning Stored Procedure]( From Erik Darling Data Moment Of Silence Automatic tuning is a half-assed... PowerPivot/PowerQuery/PowerBI [Getting Different Versions Of Data With Value.Versions In Power Query]( From Chris Webb's BI Blog Something I mentioned in my recent post about the ... [Building Reports with Power BI vs Tableau from SQL Server Data]( From MSSQL Tips Learn about Power BI vs Tableau reporting comparis... [Most Overlooked Features in Power BI]( From MSSQL Tips Learn about some of the overlooked but extremely u... [Data Modeling for Sankey Charts in Power BI]( From Curated SQL Marco Russo and Alberto Ferrari explain when Sanke... [Create a measure from a filtered visual in Power BI? Of Course, you can!]( From Guy in a Cube A live stream question asked if you could create a... Security News and Issues [New Windows/Linux Firmware Attack]( From Schneier on Security Interesting attack based on malicious pre-OS logo ... [Enhancing Cloud Security: Microsoft Details Best Practices to Thwart Identity Compromise]( From Petri IT Knowledgebase Microsoft has released a comprehensive guide to as... [Getting Into Cybersecurity: A Guide for IT Security Careers]( From IT Pro - Microsoft Windows Information, Solutions, Tools A career in cybersecurity is an exciting journey, ... Tech News [The Download: Yahoo’s misdeeds in China, and AI Act takeaways]( From Technology Review Feed - Tech Review Top Stories This is today’s edition of The Download, our w... [There's a Right Way to End Meetings at Work — and a Wrong Way]( From IT Pro - Microsoft Windows Information, Solutions, Tools Without a proper conclusion, meetings can leave em... [Becoming a Disruptive IT Leader Without Alienating Staff and Colleagues]( From IT Pro - Microsoft Windows Information, Solutions, Tools Everybody loves tech visionaries, at least until t...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -