Using Technology for Health (2022-03-05 DBW)

Database Weekly for March 5, 2022 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  Using Technology for Health I've been fairly healthy and fit for most of my life. While I've always had a few extra pounds, I do try to eat better than average and I exercise regularly. That didn't stop age and some pandemic laxity from catching up with me. My annual checkup last December had my doctor (and me) slightly concerned about a few things. I made a goal of [exercise for January]( and [better eating]( in 2022. I thought about how I've used technology to help me with this after reading [Robert Cain's post on his efforts to get more healthy](. Robert is a friend and I enjoy seeing him at various events. I'm looking forward to our next meeting and seeing the changes in person. He uses an Apple Watch and his iPhone, as well as a few devices to measure and track different aspects of his health. He can review his progress towards goals and export data for his physician. The post provides some recommendations and explanations of how technology helps. I found it interesting, as well as a contrast to what I do. Technology is more of a substitute for my memory, giving me a view into how I work on my health and fitness with a light touch. I don't track food, but I have been on a fairly limited diet, which means I have a rough idea of what I consume and the calories involved. I don't track hydration, but I started to fill 4 water bottles, about 120oz, and empty them each day. I use my watch to log exercise and heart, but I mostly glance to see if I am working hard enough and if my long-term trend for heart rate changes. I do track my weight, but I step on a scale every day or two and record the value in an app. It's common for people working at desks, especially in technology, to lead a less than healthy lifestyle. While I go to the gym often, my wife is probably healthier because she works outside and is active most every day. Technology can help some of us improve our health. The gamification and community aspects of technology apps definitely change how we may approach the challenge. Various devices also lower the effort of data entry. If you are looking to improve your health, or you struggle with making changes in diet or exercise, read Robert's post and think about harnessing some of the power of tech devices to help you improve your life. If you do use some technology, write about it and maybe you'll inspire others. As for my goals? From Jan 4 to Mar 2, I exercised on 48 different days. Not every day, but good enough for me. I have lost about 15 pounds and my long-term resting heart rate has dipped below 50bpm. Technology didn't really make this happen, but it helped, and I am glad that I can easily see some incremental progress, which isn't always apparent when I rely on my memory of what my stats were a month ago. Steve Jones - SSC Editor [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 [Exploring New SQL Prompt Features in SQL Toolbelt and SQL Toolbelt Essentials]( Roseanna Whitelegg explores new SQL Prompt functionality that has been added to SQL Toolbelt and SQL Toolbelt Essentials to help teams increase their productivity, improve code quality, and make collaboration easier. [Bulk Formatting of the SQL Server SQL Files]( How to apply SQL formatting styles as part of an automated process, using the SQL Prompt command line formatter, with examples of bulk applying styles from the command prompt, PowerShell or a DOS batch. AI/Machine Learning/Cognitive Services [How AI Is Modernizing Online Transactions]( From Dataversity Braving the global pandemic for the past two years has changed online transactions for consumers and businesses alike. As a result, the digitization of customer online activity with retailers... Administration of SQL Server [A simple guide to Microsoft SQL Server Migration Assistant for Access]( From SQLServer-DBA.Com Don't think of SQL Server as just a bigger version of MS Access. [Recipe 9: Capturing Queries and Plans]( From SQLServerCentral Blogs Welcome to a new recipe of this Extended Events co... [MySQL server Query Store]( From SQLServerCentral Blogs The query store, sounds familiar? The idea of the ... [Saving your requests]( From SQLServerCentral Blogs The other day a friend of mine mentioned that they... [Recipe 10: Writing Events to InfluxDB]( From SQLServerCentral Blogs Welcome to the last recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the... The... [Hit me with them good vibes, CTfP is set nice. Everything is so fire, little bit of sunshine!]( Cost Threshold for Parallelism (CTfP) is one of my favorite server level settings in SQL Server. I remember the first time I heard this setting mentioned by Grant Fritchey. I quickly hopped on my servers and found them all set at the default (5) and adjusted them to 50 for the non SSRS servers and 30 for the SSRS ones. [Recipe 7: Finding Unused Tables]( From SQLServerCentral Blogs Welcome toa new recipe of this Extended Events coo... [Don’t change your default SQL Server port for security reasons]( From Born SQL Since we’re on a recent theme of revising long-held best practices that are not, here’s a timely one for you: Don’t change your default SQL Server port for security... [Recipe 8: Analyzing a Workload]( From SQLServerCentral Blogs Welcome to a new recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the... The... [Microsoft’s Analytics Road Map, SQL Server 2022 and S3 Based Data Lakes]( From TL;DR This post presents some high-level architectural ideas for implementing Data Lakes using SQL Server 2022, specifically SQL Server 2022 S3 data virtualisation. Whilst SQL Server 2022 is under... [How can a table with 0 records use so much space?]( From SQLServerCentral Blogs Just like that puppy you got during the pandemic, your databases hunger for more. And they grow. And occasionally make a mess. I’ll stop the analogy. Anyhow, it’s worthwhile... The... Azure CosmosDB [Azure Cosmos DB Consistency Levels - Strong, Bounded Staleness, Session, Consistent Prefix and Eventual]( From MSSQL Tips In this article we cover the different data consistency levels in Cosmos DB such as Strong, Bounded Staleness, Session, Consistent Prefix and Eventual. Azure Databricks, Spark and Snowflake [Building a Similarity-based Image Recommendation System for e-Commerce]( Online shopping has become the default experience for the average consumer – even established brick-and-mortar retailers have embraced e-commerce. To ensure a smooth user experience, multiple factors need to be considered for e-commerce. One core functionality that has proven to improve the user experience and, consequently revenue for online retailers, is a product recommendation system. [Introduction to Snowflake Data Platform]( From SQLServerCentral Blogs Snowflake is a columnar cloud native data platform for data warehouse and big data analytics. Snowflake provides massive scale and high-performance compute resource for data(more...) The post Introduction to Snowflake... The... [How to Architect Data Quality on Snowflake]( From Dataversity Without effective and comprehensive validation, a data warehouse becomes a data swamp. With the accelerating adoption of Snowflake as the cloud data warehouse of choice, the need for autonomously... [Storage, Compute and Workspaces in Databricks]( From MSSQL Tips In this article you will learn about the various components of workspaces, compute, and storage in Databricks to help you make some decisions for your environment. Azure SQL Managed Instance [How to manage & measure database file autogrowth impact on Azure SQL Managed Instance]( From Azure SQL Continuing the topic of data space configuration d... [Azure SQL Managed Instance - Configure Managed Instance Disabled]( From SQL Seeker Quick post on an issue I encountered earlier when trying to create a new Azure SQL Managed Instance on a brand new Azure subscription. Unfortunately I can't recreate the... [SQL Managed Instance closing the gap on SQL Server application compatibility - Part 2]( From Azure SQL This blog post was co-authored by Eric Hudson, Senior Product Marketing Manager, Data & AI.  This is the second blog of a series focused on SQL Managed Instance, where we... Azure Synapse (SQL Data Warehouse and Data Lake) [Azure Synapse and Delta Lake]( From SQLServerCentral Blogs Many companies are seeing the value in collecting data to help them make better business decisions. When building a solution in Azure to collect the data, nearly everyone is... The... Career, Employment, and Certifications [Who’s Hiring in the Database Community? March 2022 Edition]( From Brent Ozar Unlimited Is your company hiring for a database position as ... [Data Analysis Techniques]( From SQLServerCentral Blogs This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can... The... Community Interests [Women’s History Month Computer Giveaway]( From Glenn Berry Introduction This is Women’s History Month, so I... [Supporting Women in Technology]( From Simple Talk We make a special effort in March to acknowledge t... Computing in the Cloud (Azure, Google, AWS) [Deleting an AWS RDS Instance]( From Callihan Data We’ve created an AWS RDS instance and logged into it successfully. One thing to remember when creating test instances is when to them when you’re finished. While a lot... [How to get the Query Text of Azure database for PostgreSQL]( From Azure Database Support Blog Introduction: Recently, due to security and privacy compliance, Query Text is no longer shown on Query Performance insights for Azure PostgreSQL and Azure MySQL. this to help avoiding unauthorized access... [Azure: Small Changes that Matter]( From Simple Talk I believe I’m not alone on this feeling: It seems like every time we use the Azure Portal some new feature appear. The features reproduce themselves faster than rabbits.... Conferences, Classes, Events, and Webinars [Redgate at SQLBits]( From SQLServerCentral Blogs Redgate and the Advocates are attending SQL Bits next week in London. I’m excited to see Grant and Kathi in person, as it’s been far too long since I... The... [DevOps 101: Getting buy-in across your organization]( Implementing DevOps isn’t just a matter of being great at writing code. The key to successful DevOps implementation is gaining buy in across your organization. Join Grant Fritchey live for his tips on how to achieve this. [Demo webinar: SQL Monitor]( Managing your entire SQL Server estate, on premises, in the cloud or a hybrid, with instant problem diagnosis, intelligent and customizable alerting has never been more vital. Discover how Redgate’s SQL Monitor enables all this from a single pane of glass. DMO/SMO/Powershell [Get-AdUser: How to Audit Active Directory Users with PowerShell]( From Petri IT Knowledgebase PowerShell is an essential tool for IT admins, and it makes it easy to audit Active Directory user accounts with the Get-AdUser command. In this guide, we’re going to... [Use PowerShell To Find Password-protected Word Documents]( From IT Pro - Microsoft Windows Information, Solutions, Tools PowerShell can come in handy when you need to find an elusive file on your network. Here’s an example PowerShell script that searches for password-protected Word documents. [Metric Meta PowerShell Scripting]( From The lonely Administrator I was fiddling around with PowerShell the other day. I spend my day in front of a PowerShell prompt and am always looking for ways to solve problems or... [How to Build a SQL Server Inventory Using PowerShell]( From Lee Markum You’re a data professional and you’ve been given the keys to a new SQL Server environment. You know you need to build a SQL Server inventory so you know... Data Science [What Makes Data Science Teams Thrive]( From IT Pro - Microsoft Windows Information, Solutions, Tools Data science has the power to transform your business. Here are some best practices to make sure your data science team is able to truly shine. Data Visualisation [#SWDchallenge: qualitative data]( From Storytelling with Data  ... [what’s the right amount of detail to include in a single visualization?]( From Storytelling with Data Through virtual and in-person workshops around the globe, we have taught tens of thousands of people how to communicate effectively with data. This series captures some of the noteworthy... Database Design, Theory and Development [Building PollGab.com: February’s Hosting Bill: $1.85.]( From Brent Ozar Unlimited Earlier this week, I wrote about how we designed t... [Database Design Chats (and where the heck have I been?)]( From Simple Talk This is going to be the last time I say it (well, at least on my blog). Last year sucked. Partly due to Covid as my wife was hit... [Building PollGab.com: Designing the Data Model]( From Brent Ozar Unlimited In the last post, I talked about how Richie and I sketched out the goals of PollGab.com, the site where you can post questions for other folks to answer... DevOps and Continuous Delivery (CI/CD) [DevOps 101: What, who, why, and how?]( From Blog – Redgate Software Organizations around the world are turning to DevOps as a way of working together to improve the efficiency and quality of software delivery and increase value to the business.... [DBAs and DevOps: A match made in heaven?]( DevOps is a buzzword thrown around a lot. But what does it mean for you as a DBA? And how can the whole team work together to achieve peak performance across multiple projects? Join Kathi for the discussion. DocumentDB/Key-Value/Graph/other NoSQL Databases [How to copy selective documents from one index to a new index in Elasticsearch?]( In this post we are going to show how to copy selective documents from one index to a new index in Elasticsearch. [How to copy selective documents from one index to a new index in Elasticsearch?]( From Hadoop in the Real World In this post we have shown how to copy an index and all its contents to a new index in Elasticsearch. In this post we are […] The post How... ETL/SSIS/Azure Data Factory/Biml [What Is Azure Data Factory]( From MSSQL Tips In this article we explain what the Azure Data Factory service can do and how you can get started learning more about it. General [How to back up and restore in PostgreSQL: Learning PostgreSQL with Grant]( You can perform PostgreSQL backups with the pg_dump command. In this article, Grant Fritchey explains how to back up and restore with the pg_dump and pg_restore utilities. Hardware [The Intel Core i3-12300 Review: Quad-Core Alder Lake Shines]( From AnAndTech Just over a month ago Intel pulled the trigger on the rest of its 12th generation "Alder Lake" Core desktop processors, adding no fewer than 22 new chips. This... [Building a Mid-Range Intel Content Creation PC]( From Glenn Berry Introduction After building an Intel budget gaming PC for $700, I wanted to see what I could build with a somewhat higher budget. To make it more interesting, I... MDX/DAX [ISFILTERED, ISCROSSFILTERED – DAX Guide]( From Sqlbi ISFILTERED: Returns true when there are direct filters on the specified column. ISCROSSFILTERED: Returns true when the specified table or column is crossfiltered. [Understanding the IN operator in DAX]( From Sqlbi Learn the IN operator in DAX, which simplifies logical conditions by checking whether a certain value belongs to a list of values. [[DAX] Anti-Patterns Episode Four: FORMAT() Function (with Daniil Maslyuk)]( From Havens Consulting A lot of videos and articles teach you how to write [DAX]. In this video Daniil Maslyuk and I will show you you how avoid bad [DAX] patterns! This... [SQRTPI, PI – DAX Guide]( From SQLBI SQRTPI: Returns the square root of (number * pi). PI: Returns the value of π, 3.14159265358979, accurate to 15 digits. Oracle/PostgreSQL/MySQL/other RDBMS [Data Types in PostgreSQL: Learning PostgreSQL with Grant]( From Simple Talk PostgreSQL has an unusually large number of data types. Grant Fritchey reviews each data type and discusses the good and bad points of each.… The post Data Types in PostgreSQL:... Performance Tuning SQL Server [Understand Your Plan: Processing Data With An Aggregate Operator]( From Erik Darling Data Smack Dab Aggregates can be useful for all sorts ... [Understand Your Plan: Processing Data With A Join Operator]( From Erik Darling Data Your Girlfriend Anyone who tells you there are only three types of joins in SQL Server isn’t your friend. Okay, maybe that’s harsh. Maybe they’re just getting you prepared for the... [#SQLServer Trivial Plans for Inserts; Stats Expectations and Reality]( From sql.sasquatch OK. SQL Server trivial plans for rowstore table INSERT. And related optimizer stats interaction. TL;DR cached trivial plans for INSERT can be surprisingly stubborn. If a query matches to one,... [Understand Your Plan: Getting Data With A Scan Operator]( From Erik Darling Data They Live I’m not sure why scans got such a bad rap. Perhaps it’s a leftover from the Bad Old Days© when people worried about logical fragmentation and page splits. What... [Understand Your Plan: Operator Times In SQL Server Execution Plans]( From Erik Darling Data Wiseacre When I was sitting down to figure out what to write about this, one of the topics that I thought would be interesting was the width of lines/arrows in... PowerPivot/PowerQuery/PowerBI [Data Engineer Diary: How to take over Power BI Gateway]( From Joyful Craftsmen – The Business Intelligence Agency Sometimes when you start to work on a project ther... [Dealing with orphaned Power BI workspaces]( From Guy in a Cube What are orphaned Power BI Workspaces and how do you get rid of them? What if you have a lot of them? Adam walks through some options including a... [Cognos vs. Power BI: 2022 Software Comparison]( From Past News - RSS Feeds IBM Cognos Analytics and Microsoft Power BI are two of the top business intelligence (BI) and data analytics software. Both of these applications are in heavy demand, as organizations... [Analyzing report performance of Power BI Desktop reports]( From SQLShack In this article, we will learn how to analyze the performance of Power BI Desktop reports using the Performance Analyzer. Introduction Data reporting is a large area of data... [Create Hybrid Tables with Tabular Editor for Power BI? YES!!!]( From Guy in a Cube Hybrid Tables are an incredibly powerful feature in Power BI. But what if you wanted to create them outside of Power BI Desktop? Patrick shows you how you can... [Displaying measures as percentages in Power BI charts – Unplugged #43]( From Sqlbi How can you display the measure as a percentage in... [Refreshing Excel Power Query Queries With VBA And Power Automate For Desktop]( From Chris Webb's BI Blog At the end of last year two new, fairly minor, improvements were made to Excel VBA’s support for Power Query: you can now refresh and delete individual Power Query... Product Reviews and Articles [A New Command Palette in SQL Prompt]( From SQLServerCentral Blogs I’ve gotten used to using the Command Palette in VS Code/ADS/Sublime Text regularly to find some setting or change something. What felt strange at first has become a habit... The... Product Upgrades and Releases [Azure SQL—Public preview updates for early March 2022]( From Azure Updates Public preview enhancements and updates released f... [Microsoft Defender for Cosmos DB is Now Available in Public Preview]( From Petri IT Knowledgebase Microsoft has announced the public preview of Microsoft Defender for Azure Cosmos DB, a new database protection solution for enterprise customers. The latest security offering allows organizations to constantly... [Zone Redundancy for Azure SQL Database Hyperscale tier in preview]( From Azure SQL Now in preview, new Azure SQL Hyperscale databases can enable the zone redundant configuration. The zone redundant configuration utilizes Azure Availability Zones to replicate databases across multiple physical locations within an... [Public preview: Azure Synapse Link for Azure Cosmos DB partitioning Spark 3.1]( From Azure Updates Use Azure Synapse Spark 3.1 to partition your Azure Cosmos DB data in analytical store for improved query performance. [General availability: Asset certification in Azure Purview data catalog]( From Azure Updates Data stewards can now certify assets that meet their organization's quality standards in the Azure Purview data catalog [General availability: Azure Cosmos DB API for MongoDB supports version 4.2]( From Azure Updates Utilize new aggregation pipeline functionality and... Python [Connect Azure SQL Database using Python from Ubuntu]( From SQLShack Azure SQL Database or Managed instance is a Microsoft cloud offering for SQL Server in the managed cloud environment. Usually, we connect databases from SQL Server Management Studio, Azure... [AutoML using Pycaret]( In this post we will have a look at using the AutoML feature in the Pycaret Python library. AutoML is a popular topic and allows Data Scientists and Machine Learning people to develop potentially optimized models based on their data. [Using Web Crawling in Python to Conduct a Website Content Audit]( From MSSQL Tips In this article we look at how to use Python to build a web crawler and conduct a website content audit. [Python for the win]( From Thirty Years Tapping A Keyboard I’ve been using Python a lot for personal programming projects. The REPL makes it fun to explore a problem space and the number of libraries is truly astounding. CPython... SQL Server News [System Page Latch Concurrency Enhancements in SQL Server 2022 (Ep. 6) | Data Exposed]( From Azure SQL Over the past several SQL Server releases, Microsoft has improved the concurrency and scalability of the tempdb database. Starting in SQL Server 2016 several improvements address best practices in... [PolyBase versus the March of Time]( From 36 Chambers – The Legendary Journeys PolyBase is dead: Today, we are announcing the retirement of PolyBase scale-out groups in Microsoft SQL Server. Scale-out group functionality will be removed from the product in SQL Server... SQL Server Security and Auditing [Don’t change your default SQL Server port for security reasons]( From SQLServerCentral Blogs Since we’re on a recent theme of revising long-h... [Understanding security testing for SQL Server environments]( From SQLShack This article will explain various aspects of security testing for the SQL Server environment. Security is a very critical area for any database environment. We must properly plan, deploy,... Security News and Issues [8-Character Passwords Can Be Cracked in Less than 60 Minutes]( From Dark Reading: Dark Reading News Analysis Researchers say passwords with less than seven characters can be hacked "instantly." [Samsung Encryption Flaw]( From Schneier on Security Researchers have found a major encryption flaw in 100 million Samsung Galaxy phones. From the abstract: In this work, we expose the cryptographic design and implementation of Android’s Hardware-Backed Keystore in... [Secure Travel]( From John Morehouse Last Updated on March 4, 2022 by John Morehouse Update: This post was originally published on March 8th, 2019 and a lot of things have changed over the last... [DORA's Global Reach and Why Enterprises Need to Prepare]( From Dark Reading: Dark Reading News Analysis The new EU regulation is a response to the rise of ransomware attacks and other new cyberthreats that have proliferated in the wake of the global pandemic. [Toyota Halts Production After Suspected Supply Chain Attack]( From Dark Reading: Dark Reading News Analysis Toyota suspends production at all 14 plants in Jap... Software Development [What Makes A Good Backlog Story?]( From Paul Andrew Requirements vs Design vs Delivery Another quick, softer skills blog post relating to the ‘art’ of writing good backlog stories. Background Building on the post I recently wrote about... [Architecture – Commonality is an accelerator]( From SQLServerCentral Blogs In IT, commonality is an accelerator. When I say commonality, I mean commonality of: Components, like libraries Object models Interface definitions Tools Let me give you an example. Imagine... The... [Understanding Transfer database objects in SSDT 2017]( From SQLShack In this article, we are going to learn how we can copy database objects between two databases of different instances of SQL Server. Sometimes, we receive the request to... T-SQL [Learn the SQL WHILE LOOP with Sample Code]( From MSSQL Tips In this article we will look at examples of a SQL Server WHILE loop in T-SQL and discuss alternatives like a CTE and cursor. [Ain’t Nothing Like Saying STUFF this & Moving On]( From Sherpa of Data Previously, we talked about the REPLACE and TRANSLATE functions and how similar, but not quite the same they are. Today, I want to talk about yet another function that... [FORMAT is a convenient but expensive function, part 2]( From SQLBlog.org In the second part of this series, I show two ways to shift expensive computations to write time. Tools for Dev (SSMS, ADS, VS, etc.) [Azure Data Studio - Azure SQL Migration Extension SKU Recommendations]( From SQL Seeker Microsoft recently announced the Public Preview of SKU recommendations in the Azure SQL Migration extension in Azure Data Studio. This enables us to use a performance assessment on our... [Database Fundamentals #31: Unique Constraints from the GUI]( From Scary DBA (Grant Fritchey) In the last few Fundamentals posts you were introduced to a couple of ways to limit and control the data stored in the tables in your database. A primary... [Introducing new and improved updates to SQL tools on Azure]( From Microsoft SQL Server Blog In this post, we'll recap the updates to SQL tools over the past few months, including the recent releases of Azure Data Studio and SQL Server Management Studio (SSMS).... Virtualization and Containers/Kubernetes [Expert Series webinar – Understanding SQL Server on VMware Storage Options]( From SQLServerCentral Blogs I’m thrilled to be presenting a new session on S...  [RSS Feed]([Twitter]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -