Time to Volunteer

Database Weekly for September 25, 2021 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  Volunteer For Something I spent a chunk of the day yesterday, after work, but before working on a new book (yeah, I've got two jobs now), playing with my radios. I was programming the digital one to get it to use my Raspberry Pi as a hotspot (it used to work, now it doesn't). I also spent some time on the HF rig (High Frequency), made a simplex contact in Maryland, and failed to make any contacts in [fldigi]( or [JS8Call](. Finally I checked into a local [NTS net]( on one of the UHF radios (Ultra High Frequency), just for practice. In short, I played radio. However, I'm also practicing using all these different forms because I'm a volunteer for the local [ARES group](. I'm looking at joining a couple of other organizations in the area (new town, new volunteer opportunities). Why? Because the world needs volunteers. There's just so much that needs doing. Yeah, I'm volunteering with an emergency service (not my first one either), but there are preservation societies for various historic... stuff, food kitchens, Scouting, charitable organizations, churches, Scouts, synagogues, Freemasons, and did I mention Scouts. All of these organizations do vital work for your community. And, I happen to know, worldwide, these organizations are suffering from a severe [shortage of volunteers](. People just don't engage in these organizations anymore (also, Covid added to the problem, because of course it did). It's a shame. We are going to lose organizations that truly matter. The thing is, volunteering does a whole bunch of stuff. Yeah, you're helping do some worthy cause, which is reason number one. However, you also get to meet people, make friends and contacts. You get to move, even if it's just going to a meeting. Volunteering is also a great help for your emotional well being. In short, absolutely support the worthy cause, whatever it might be, but also improve your own life at the same time. So, please, get out there and volunteer. You are needed. Yes. You. 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. Vendors/3rd Party Products [JPA + Flyway: Database Migration Challenges in Java Apps]( Database migration is an essential part of the development process. It includes many challenges: from writing the migration scripts to making them runnable and avoiding loss of data. In this webinar we’ll look at common DB migration challenges and how to overcome them. AI/Machine Learning/Cognitive Services [Building Ensemble Classifiers in Azure Machine Learning]( From SQLShack Introduction This article is the newest addition t... Administration of SQL Server [SQL queries to change the column type]( From SQLShack This article covers the different SQL queries to change the column type. We are going to learn how we can change the data type of the columns of the... [How to capture SQL login details with Extended Events]( From SQLServer-DBA.Com An application owner wanted to record the usage of... [How to Enable and Disable Full Text Search for SQL Server Databases]( From MSSQL Tips Learn how to enable or disable full text search for a specific database on a SQL Server instance where the Full Text Search components have been setup. [How to Design Backups in SQL Server?]( From SQLServerCentral Blogs The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related to the information to be recovered and the time that it will take to recover.... The... [Building blocks of Extended Events data collection]( Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection. Azure SQL Database [Custom Azure Policy definitions for Azure SQL Databases backup retention periods compliance]( From SQLShack This article uses Azure policies to check complian... Azure Synapse (SQL Data Warehouse and Data Lake) [Performance Improvements to Apache Spark 3.1.2 in Azure Synapse]( Azure Synapse Analytics is continually focused on delivering a highly performant and scalable platform for supporting Spark Workload. We are focused on improving the query performance for the typical workload patterns that we see with our customers. By combining the latest open-source updates in Apache Spark with our team’s focus on performance updates we have made significant performance gains in standard TPC-DS benchmarking tests. [Distributed tables in Azure Synapse Analytics]( From SQLShack This article talks about the table distribution st... Backup and Recovery [Pure Storage Flasharray SQL Server Snapshot Torture...You Kinda Asked for This]( I gotta admit, some of you are really hard to convince. I’ve been saying for years that given a large enough database size (or a really small RTO storage based snapshots should be Plan A for recovering the database in the event of a disaster. Yes, you will have a Plan B, likely native backups. And Plan C. Maybe you’ll run out of letters because you’re so paranoid. [Restore SQL Server databases using File Snapshot Backups]( From MSSQL Tips In this article we will look at how to perform SQL... [Danger Danger Danger – REPAIR_ALLOW_DATA_LOSS]( From Steve Stedman Steve Stedman So years ago, when my kids were grow... Case Studies [The Role of Data Governance in Effective Data Management]( From Past News - RSS Feeds I spoke with four industry experts about the growing challenges in data governance, spotlighting which issues need to be resolved for better data management. The experts: Kelly Symons, Senior... Community Interests [Boost your skills by joining Microsoft at PASS Data Community Summit]( From Microsoft SQL Server Blog Since day one, Microsoft has been right beside you... Computing in the Cloud (Azure, Google, AWS) [Not Optimizing Cloud Computing Spend Costs Enterprises $24B]( From IT Pro - Microsoft Windows Information, Solutions, Tools New research reveals that organizations are not ch... [Triggering Function Apps from Azure Queue Storage]( From SQLShack In this article, we are going to learn how to trigger Function Apps from Queue Storage in Azure. Function Apps has been one of the most popular cloud services... [AWS Cloud Builders – Career Transformation & Personal Growth]( From AWS News Blog Long-time readers of this blog know that I firmly believe in the power of education to improve lives. AWS Training and Certification equips people and organizations around the world... [New for AWS Distro for OpenTelemetry – Tracing Support is Now Generally Available]( From AWS News Blog Last year before re:Invent, we introduced the public preview of AWS Distro for OpenTelemetry, a secure distribution of the OpenTelemetry project supported by AWS. OpenTelemetry provides tools, APIs, and... [New Microsoft Learn Modules: Azure SQL IoT and Azure Arc-enabled data services | Data Exposed]( From Azure SQL Looking for the next Microsoft Learn modules to complete? Bob Ward, Buck Woody, and Anna Hoffman give you a run-down of Microsoft Learn, the learning paths they've launched, and... Conferences, Classes, Events, and Webinars [Database technology trends]( Join Matt Schmelzer, Data Systems and Automation - IT, and Jonathan Holck, IT Associate, from Artisan Partners in discussion with Microsoft MVP Grant Fritchey to learn how they implemented a successful infrastructure and what tools they need to support their growing estate. [Monitoring Large Estates at BMW]( BMW have been monitoring their SQL Server estate for more than 7 years, but with evolving technology and circumstances, monitoring also needs to change and grow. Join Tony Maddonna in conversation with Redgate's James King, to discover how BMW are handling the challenges. DMO/SMO/Powershell [Automating SQL & PowerShell Notebook Execution]( When I first think about automation, I generally think in the following way: in order to automate a script, we want to ensure that the script itself can be run via a command line interface (CLI) and with almost no user interaction (except for input and output parameters). Now, how do we apply this to Jupyter Notebooks so that we can automate SQL notebooks or PowerShell Notebooks? [Fun With the PowerShell Switch Parameter]( From Arcane Code Introduction Over the last few posts I’ve been c... [How Can I Move a File or Folder from the Command Line Using Windows PowerShell?]( From Petri IT Knowledgebase In this article, I’ll show you how to use Window... [#PowershellBasics: Bulk insert.]( From SQLServerCentral Blogs In my last post I talked about invoke-sqlcmd. It?... Data Mining / Data Analysis [The Most Dangerous Equation, or Why Small is Not Beautiful!]( From Learning Machines Over one billion dollars have been spent in the US... [Use simulations to evaluate the accuracy of asymptotic results]( From AllAnalytics The field of probability and statistics is full of... Data Warehousing [Synapse vs Snowflake: The Data Warehouse Debate]( From BlueGranite Blog Data warehousing has become a hot topic for most o... [5 Critical Factors to Consider When Choosing a Data Warehouse Solution]( From Dataversity Click to learn more about author Ammar Ali. We have seen an unprecedented increase in modern data warehouse solutions among enterprises in recent years. Experts believe that this trend... DevOps and Continuous Delivery (CI/CD) [Google DORA Report Details Best Practices to Speed DevOps]( From IT Pro - Microsoft Windows Information, Solutions, Tools The 2021 Accelerate State of DevOps report from Go... [What you need to know about the Accelerate State of DevOps 2021]( From Blog – Redgate Software Every year, the Accelerate State of DevOps Report ... DocumentDB/Key-Value/Graph/other NoSQL Databases [Why Johnny Can’t Model: Understand NoSQL Data Modeling and Why You’re No Good At It]( From IT Pro - Microsoft Windows Information, Solutions, Tools Date: Wednesday, October 13, 2021 Time: 01:00 PM ... General [Building an ETL With PowerShell]( There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to get PowerShell to do more of the work. Performance Tuning SQL Server [Optimizing Spark Performance with Adaptive Query Execution]( From MSSQL Tips Learn about performance of Adaptive Query Executio... [Signs It’s Time To Switch From ORMs To Stored Procedures]( From Erik Darling Data Meet Wall There are, unfortunately, some times wh... [Free Query Tuning Practice]( From Callihan Data If you’re wanting to test out your query tuning ... PowerPivot/PowerQuery/PowerBI [How to show a different contact for each report/dashboard within a Power BI App]( From FourMoo I recently got a request asking if it was possible... [One Click Calculation Group in Power BI]( From Guy in a Cube Calculation Groups in Power BI can be amazing! Pat... [DAX! Uggg – Where do you start? | Power BI]( From Guy in a Cube Not a coder? Don't understand DAX syntax? DAX can ... Professional Development [Improve Your Presentation Skills by Rehearsing with PowerPoint Presenter Coach]( From Cathrine Wilhelmsen Did you know that the PowerPoint Presenter Coach c... [Software Development Estimation is Hard]( From Curated SQL Andy Leonard makes a point: I recently blogged abo... [How to Encourage a New Generation of Leaders in the Remote Workplace]( From Past News - RSS Feeds Companies are starting to finalize their long-term... [Breaking the cycle of bias in decision making]( From AllAnalytics “Bias is not inhuman. To have bias is absolutely human,” says Banu Raghuraman. If data enthusiasts are going to break the cycle of bias, however, “we have to be... Security News and Issues [Three Tips for Safeguarding Against Data Breaches]( From Dataversity Click to learn more about author Balaji Ganesan. S... [Epik data breach impacts 15 million users, including non-customers]( From Ars Technica Scraped WHOIS data of NON-Epik customers also expo... [How Tech Companies Can Boost Cyber Defenses: Building a Cyber-First Culture]( From Past News - RSS Feeds Today’s accelerated pace of digital transformati... [Facebook’s latest “apology” reveals security and safety disarray]( From Ars Technica "Hard to say" who is responsible for platform-wide... [Secure Cloud Migration: Beware Identity Failures and Misconfigurations]( From Past News - RSS Feeds According to Gartner, the worldwide public cloud s... [OMIGOD Vulnerability Exposes Virtual Machines Running Inside Azure]( From IT Pro - Microsoft Windows Information, Solutions, Tools New Azure-based OMIGOD vulnerability is easy to ex... [Multifactor Authentication's Impact on Productivity Still Unknown]( From IT Pro - Microsoft Windows Information, Solutions, Tools Multifactor authentication is a well-known method ... [2021 has broken the record for zero-day hacking attacks]( From Technology Review Feed - Tech Review Top Stories A zero-day exploit—a way to launch a cyberattack... T-SQL [TSQL JOIN Types Sale Continues]( From Steve Stedman Back by popular demand – 50% off our recently re... [Creating a table using the SQL SELECT INTO clause - Part 1]( From MSSQL Tips In this article we look at various ways to create ... [Learn SQL FULL OUTER JOIN with Examples]( From MSSQL Tips In this article we look at what a SQL Full Join is... [How LAG compares to other techniques]( LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques Tech News [Semiconductor firms can’t find enough workers, worsening chip shortage]( From Ars Technica Material costs are rising too, and the shortage wi... [Windows 11 setup warns that you aren’t “entitled” to updates on unsupported PCs]( From Ars Technica It's going to be at least mildly irritating to upg... [European Union announces plans to require all mobile devices to use USB-C]( From Ars Technica Devices using only wireless charging would be exem... [New report suggests Texas’ grid was 5 minutes from catastrophic failure]( From Ars Technica It comes with a long list of recommendations for a... Tools for Dev (SSMS, ADS, VS, etc.) [Removing a Deleted Column from a Data Masker Masking Set]( From SQLServerCentral Blogs Data Masker for SQL Server is a great tool ensurin... Virtualization and Containers/Kubernetes [5 Reasons Why Kubernetes Is So Challenging]( From IT Pro - Microsoft Windows Information, Solutions, Tools Among the reasons why Kubernetes is so challenging... [4 Reasons Why Kubernetes Is So Popular]( From IT Pro - Microsoft Windows Information, Solutions, Tools Among the reasons why Kubernetes has been so widel... [Containers: A Short Rant]( From Scary DBA (Grant Fritchey) I find myself doing more and more work with contai... [Container-Native Storage More Compelling Than Cloud-Native]( From IT Pro - Microsoft Windows Information, Solutions, Tools When storage is built into and run as containers, ...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -