The SUM function, statistics, and more in Database Weekly (2021-08-28)

Database Weekly for August 28, 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  What to do with more free time Many data professionals have begun working remotely over the past year and a half which translates to less time spent commuting. In my own case, I’ve been a remote worker for almost ten years, but before that I spent two hours on the road each day. This got me wondering what folks have done with the extra time no longer used driving back and forth to work. There have been more childcare duties in some cases, as kids may have been attending school remotely, but it also has been the time to pick up some new hobbies or volunteer at a nonprofit. Since I’ve been working from home, I get more sleep. I’m a night owl, so I love waking up 15 minutes or so before my workday begins. I would guess the most popular new hobby of the pandemic was baking bread, especially sourdough. Many of my friends posted about baking on social media. This article lists the [top new hobbies]( although I wouldn’t call watching TV a hobby! Since the lockdowns began, I’ve devoted more time to my interests in crocheting and 3D printing, but I also picked up a new one, cookie decorating. Over the years, friends in the data platform community have formed unofficial interest groups around running, photography, scuba diving, karaoke, and more. These hobbies may be relaxing or at least a creative outlet that allows one to forget about work for a bit. The best was when many us with 3D printers made [ear-savers to help hospital and other front-line workers](. On the other hand, no one should feel guilty for downtime, and hobbies shouldn’t add more stress. I love the [session]( given by Jes Schultz where she explains how not to be “busy” and when to say “no.” I’ve used her advice many times, although I do love big projects and sometimes take on too much. Hobbies should be enjoyable and not make our lives more hectic. Free time is precious, so we all must spend it wisely, and sometimes doing nothing is better than filling up every minute.  Kathi Kellenberger [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. Administration of SQL Server [Moving Data to a New Filegroup]( From Callihan Data There are plenty of scenarios where you may want t... [Deep Dive into SQL Server Statistics]( From SQLShack In this article, we will go through some details a... [How to change an Azure SQL Database Collation]( From SQLShack This article explores the Azure SQL Database Collation configuration and how to change it while importing the database from a BACPAC file. Introduction The collation refers to a configuration... Azure SQL Database [Data Migration from Azure SQL Database to Azure Database for PostgreSQL]( From SQLShack In this article, we will learn how to migrate data... Azure Synapse (SQL Data Warehouse and Data Lake) [An Introduction to Azure Data Integration Pipelines]( From Paul Andrew Azure Data Factory & Azure Synapse Analytics F... [Azure Test Plans example for Azure Synapse Analytics]( From Kevin Chant Reading Time: 8 minutes In this post I want to co... Big Data [Big Data at 10: Did Bigger Mean Better?]( From Dataversity Click to learn more about author Mathias Golombek.... Career Growth and Certifications [Looking for a new job in tech? It may be your lucky day]( From Ars Technica Employers are turning on the charm to attract engi... Community Interests [Why a Code of Conduct is Valuable]( From SQLGene – Learning SQL Slowly I believe having a Code of Conduct is valuable and... [Recorded conference sessions]( From SQL Server Fast Since the start of the Covid-19 pandemic, conferen... [The Power of User Groups]( From SQLServerCentral Blogs Fascination has always been with me when thinking ... Computing in the Cloud (Azure, Google, AWS) [Single-cloud versus Multi-cloud]( From SQLServerCentral Blogs A discussion I have seen many companies have is if they should be single-cloud (using only one cloud company) or multi-cloud (using more than one cloud company). The three... The... Conferences, Classes, Events, and Webinars [Register Now For PASS Data Community Summit 2021]( Registration is now open for our free and online data platform conference. Join 1000s of your data peers at PASS Data Community Summit and get access to up to 5 days of training, sessions, networking activities, and events. This year's program has been carefully designed to help you achieve your goals, wherever you are in your data career. [Donovan Brown & Mark Fussell: Cloud Native development with Dapr]( Donovan Brown and Mark Fussell, Program Managers from the Azure CTO Incubations team at Microsoft, join Steve Jones to talk all things modern Cloud Native development with Dapr. [Why effective monitoring is essential for your growing estate]( Join Grant Fritchey and database professionals from WestJet, Fiducia Gad and Richemont to learn how effective estate monitoring enables them to manage continually evolving environments, and intensifying data demands. DMO/SMO/Powershell [How to resolve a hostname or ip address with Powershell]( From SQLServer-DBA.Com How to resolve the fully qualified name of a serve... [Fun with PowerShell Loops]( From Arcane Code Fun with PowerShell Loops Data Science [Now that machines can learn, can they unlearn?]( From Ars Technica Researchers see if they can remove sensitive data ... Database Design, Theory and Development [The sysname datatype defaults to not NULL.]( From SQLStudies The other day I was creating a table to store some... [When Is It OK to Drop ACID Database Safeguards?]( From IT Pro - Microsoft Windows Information, Solutions, Tools ACID database safeguards can come at a performance... DevOps and Continuous Delivery (CI/CD) [How to Use AI for SQL Tuning for a Real Automated Process]( From SQL Server – {coding}Sight The rapid evolution in development from rigidly structured data to responsive, flexible databases allows database administrators (DBAs) to work closely with developers. DBAs are often tasked with finding ways... ETL/SSIS/Azure Data Factory/Biml [Develop ETL templates for Data Warehousing using Azure Data Factory]( From SQLShack In this article, we will learn how to develop ETL ... JSON [Think twice about storing JSON in your SQL Server database]( From Born SQL During routine maintenance on a customer’s production server, I discovered that they have one table consuming 40% of the storage in their database. That table contains just under 10... Performance Tuning SQL Server [Persist sampling rate for automatic SQL Server statistics updates]( From SQLShack This article explores Persist sampling rate featur... [The APPEND_ONLY_STORAGE_INSERT_POINT Latch]( From SQLPerformance In his ongoing series on latches, Paul Randal expl... [SARGability Week: Using Dynamic SQL To Fix Non-SARGable Queries]( From Erik Darling Data Specific The non-SARGABLE pattern that dynamic SQL helps you deal with is the the catch all query pattern, which can look like: col = @parameter or @parameter is null col = isnull(@parameter,... [Fundamentals of SQL Server Statistics]( From SQLShack In this article, we will take a glance at the fund... [SARGability Week: What Is It, Anyway?]( From Erik Darling Data SARGability is the in-club way of saying ... PowerPivot/PowerQuery/PowerBI [Comparing Events in Power BI]( From Excelerator BI Today I am sharing another of those videos where I... [Working with Python in Power BI]( From SQLShack In this article, we are going to learn about worki... [A Step-by-Step Overview of Paginated Reports in Power BI]( From BlueGranite Blog Paginated Reports for Power BI offer pixel-perfect control over the format of each element of a report. They allow users to fine-tune each field of the report, such as... [How Query Folding And The New Power BI Dataflows Connector Can Help Dataset Refresh Performance]( From Chris Webb's BI Blog You may have noticed that a new dataflows connecto... [CROSSJOIN – DAX Guide]( From SQLBI CROSSJOIN: Returns a table that is a crossjoin of ... Professional Development [5 Guy in a Cube tips to make BETTER VIDEO!]( From Guy in a Cube Recording video is hard. So much goes into it that... [Goodbye WordPress, Hello Hugo!]( From Cathrine Wilhelmsen In 2021, I said goodbye WordPress and hello Hugo. ... Security News and Issues [5 Vexing Cloud Security Issues]( From IT Pro - Microsoft Windows Information, Solutions, Tools Address these five common cloud security issues to... T-SQL [Optimizing a string split and search]( From Sunday morning T We’re no strangers to doing things in T-SQL that... [How to Use SQL SUM Function]( From SQL Server – {coding}Sight SQL is a powerful and widely-used programming language for data storage, retrieval, and manipulation. One of the most commonly-used operators in SQL is SUM – a logical operation that... [Using the OUTPUT Clause in TSQL for Auditing]( From Steve Stedman The OUTPUT clause is often times underappreciated ... [SQL Server identity column]( From Simple Talk The SQL Server identity column is used to populate... [Distinct List in String_Agg]( From Greg's Ramblings SQL, Programming and IT Life SQL introduced the new STRING_AGG feature in SQL 2... [CROSS vs OUTER: Knockdown drag-out free for all]( From Sherpa of Data In this corner, with a total of 10 letters – we ... Virtualization and Containers/Kubernetes [Virtual Machines in the Cloud can be smaller than On-Premises]( From DCAC One of the big mistakes that I see when working wi...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -