Lots of Interesting Tech News

Database Weekly for July 16, 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  Time To Recharge Redgate is a great place to work for a lot of reasons. One of those has come up for me. It's time for my sabbatical. Every five years we get six weeks paid leave. Mine starts Monday. I'll still be clearing out my email (the thought of six weeks worth gives me horrors), and I'll be working on rewriting my query tuning book for SQL Server 2022 (that's independent from work). However, except for those two things, no work for me for a while. Instead, I've got a couple of plans. First, off to see some American Civil War battlefields I wouldn't otherwise have visited. Only two on this trip, but one is a large one; Pea Ridge and Vicksburg. Second, I'm learning how to solder. Why are you looking at me like that? I'm a film school dropout, and a Nuke Machinist Mate. No CS degree, so no soldering. Third, I'm going to goof off. Play some golf. Take a hike. Maybe rent a boat & go fishing. It's summer. Most people take at least a few days off. I think it's a necessary part of life. Not so much switching off the brain as building new pathways in it so that you can come back to work fresh. I hope you can take some time, even if it's not six weeks, to recharge. Any plans? 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 [Inside a radical new project to democratize AI]( From Technology Review Feed - Tech Review Top Stories PARIS — This is as close as you can get to a roc... [Training vs Inference – Memory Consumption by Neural Networks]( From frankdenneman.nl This article dives deeper into the memory consumption of deep learning neural network architectures. What exactly happens when an input is presented to a neural network, and why do... Administration of SQL Server [SQLServerCarpenter Tools]( From SQLServerCentral Blogs Over the past couple of years, I’ve developed se... [How to install SQL Server 2022 step by step]( From MSSQL Tips In this article, we cover how to install SQL Serve... [Fixing Ordered Column Store Sorting In SQL Server 2022]( From Erik Darling Data Groove Is In The Heart When Brent posted about th... [New Database Job – The 90 Day Plan]( From SQLServerCentral Blogs In my first post, I reference that by the end of y... [Extended Events for Anything But Query Tuning: xml_deadlock_report_filtered]( From Grant Fritchey One of my favorite little bits of information abou... [Emulating the GROUPS Window Frame Option]( From SQLPerformance Itzik Ben-Gan shows two supported approaches to mi... [Azure SQL Interview Questions and Answers]( From SQLShack Interested in becoming an Azure SQL DBA but don’... [SQL Server 2022 DOP Feedback: Related Extended Events]( From Erik Darling Data Short Round Sort of on the heels of yesterday’s post, here are some Extended Events related to the DOP Feedback feature new to SQL Server 2022. Here’s the complete text of... [Importance of Disk Caching in Azure storage disks for SQL Server workloads]( From SQLShack This article will explore the importance of disk caching in Azure storage for SQL Server workloads. Azure premium storage is used to store IO-intensive workloads like SQL Server database... Analysis Services / BI on the MS Stack [5 steps to build agile and resilient collections]( From AllAnalytics High unemployment rates of the post-pandemic era i... [The Whiteboard video series on the SQLBI YouTube channel]( From Sqlbi The Whiteboard is a new series on the SQLBI YouTube channel where I use a whiteboard to describe abstract DAX and Tabular concepts in a more interactive way. I... [Making the invisible visible: Doing more with data]( From Technology Review Feed - Tech Review Top Stories Thank you for joining us on “The cloud hub: From... Azure Databricks, Spark and Snowflake [Snowflake Editions]( From SQLServerCentral Blogs You have decided that snowflake is the technology ... Azure DevOps [Getting Started with Azure Automation]( From AndyLeonard.blog() Azure Automation has been around for a few years now. I just got started because my brother and friend, Aaron Nelson (@SQLvariant), shared some automation he’s been working on.... Azure SQL Managed Instance [Lesson Learned #222:Hands-On-Labs: Configure/Troubleshoot Linked Server Azure SQL Managed Instance]( From Azure Database Support Blog We used to have cases where our customers reported... [Resumable restore improves SQL Managed Instance database migrations experience]( From Azure SQL Today we are announcing improvements that 1) Enable resumable database backup restores for Azure SQL Managed Instance in case of impactful system updates, and 2) Removal of the 36... Community Interests [Thank You Allen!]( From SQLServerCentral Blogs I know I can say that I’m a friend of Allen Whit... [T-SQL Tuesday #152]( From No Column Name Words: 375 Time to read: ~ 3 minutes I don’t kno... [Register as a Pre-Con Speaker]( From SQLServerCentral Blogs I’ve been debating how we better organize speake... Computing in the Cloud (Azure, Google, AWS) [AWS Week In Review – July 11, 2022]( From AWS News Blog This post is part of our Week in Review series. Ch... [AWS Announces Streamlined Deployment for .NET Apps]( From Petri IT Knowledgebase This past July 6, 2022, Amazon announced the relea... [Amazon Redshift Serverless – Now Generally Available with New Capabilities]( From AWS News Blog Last year at re:Invent, we introduced the preview ... [Google Cloud Announces First Arm-based VMs for High-Performance Workloads]( From Petri IT Knowledgebase Google Cloud today announced Tau T2A, its first virtual machines... DMO/SMO/Powershell [#PowershellBasics: Write the output to a file.]( From SQLServerCentral Blogs Last week I posted about a request to get a list of services. The first problem I ran into was ... Continue reading The post #PowershellBasics: Write the output to... Data Access / ORMs [T-SQL Tuesday 152: An ORM Will Not Save You From Yourself]( From FLX SQL T-SQL Tuesday is a monthly blog party hosted by a ... Data Mining / Data Analysis [A better 3D scatter plot macro]( From AllAnalytics SAS SGPLOT already provides the necessary graphica... [Why learn SQL?]( From AllAnalytics SQL (Structured Query Language) is the most widely... Database Design, Theory and Development [MISSING DATA AND MULTI-RELATION QUERY RESULTS (T&N)]( From Database Debunkings Note: "Then & Now" (T&N) is a new version ... [Recording: Non relational data modeling & Database engine internals]( From Ayende @ Rahien A few days ago I talked for close to three hours d... DevOps and Continuous Delivery (CI/CD) [T-SQL Tuesday #152 – Which version of my database was deployed? It depends!]( From Eitan Blumin One of the things that are not so clear about SSDT... [Process Orchestration: Connecting Process Automation Across People, Systems, and Devices]( From Dataversity As organizations push to be more customer-focused and efficient, most are trying to streamline their operations by automating processes. Recent research shows that 92% of IT decision-makers who are... PowerPivot/PowerQuery/PowerBI [Using an IN Condition for multiple values in Power Query (Power BI)]( From FourMoo In the example I did not want to specify all the c... [Is it a KNOWN ISSUE in Power BI?]( From Guy in a Cube Hitting issues with Power BI can be frustrating. Having to call support can be even more frustrating! What if there was a way to see if it was a... [Quality Checks for your Power BI Visuals]( From SQLServerCentral Blogs For more formal enterprise Power BI development, many people have a checklist to ensure data acquisition and data modeling quality and performance. Fewer people have a checklist for their... The... Professional Development [Government tech insider: Technology you need to know right now]( From Technology Review Feed - Tech Review Top Stories Thank you for joining us on “The cloud hub: From... [The Download: tracking teachers online, and how influencers navigate algorithms]( From Technology Review Feed - Tech Review Top Stories This is today’s edition of The Download, our w... Replication [Transactional Replication: Where did my data go???]( From SQLServerCentral Blogs Good morning dear reader. Today I am writing this ... SQL Server News [Upcoming updates to SQL Server container images on Microsoft Artifact Registry aka (MCR)]( From MS SQL Server Blog As you may be aware, SQL Server container images are published and available on the Microsoft Artifact Registry (aka MCR or Microsoft Container Registry). To know more, please see Overview... [Bringing the power of blockchain to Azure SQL Database and SQL Server with ledger | Data Exposed]( From Azure SQL Establishing trust around the integrity of data stored in database systems has been a longstanding problem for all organizations that manage financial, medical, or other sensitive data. Ledger is... Security News and Issues [Data of Nearly 2M Patients Exposed in Ransomware Attack on Healthcare Debt Collection Firm]( From Dark Reading: Dark Reading News Analysis Professional Finance Company (PFC) was hit in Febr... [Estimating impact of data breaches on brands across industries and defining a future-ready strategy]( From Technology Review Feed - Tech Review Top Stories Thank you for joining us on “The cloud hub: From... [DHS Review Board Deems Log4j an 'Endemic' Cyber Threat]( From Dark Reading: Dark Reading News Analysis Vulnerability will remain a "significant" threat f... [How Hackers Create Fake Personas for Social Engineering]( From Dark Reading: Dark Reading News Analysis And some ways to up your game for identifying fabr... Software Development [DateOnly and TimeOnly structures are introduced in NET 6. Can you save them to the database?]( From Hasan Savran     DateOnly and TimeOnly are the new mem... [How Reducing Technical Debt Improves Sustainability]( From IT Pro - Microsoft Windows Information, Solutions, Tools ITOps teams can become more environmentally friend... [Production postmortem: The data corruption in the node.js stack]( From Ayende @ Rahien A customer called us, complaining that RavenDB isn... T-SQL and Query Languages [Generate Random Dates in T-SQL]( From MSSQL Tips In this article we look at how to generate random ... [Getting Starting with SQL COUNT() and COUNT_BIG() Functions]( From MSSQL Tips In this article, we look at how to get a count of ... Tech News [How to Upgrade Your Internet Bandwidth]( From Glenn Berry Introduction I recently did some work and spent so... [New York City is drowning in packages]( From Technology Review Feed - Tech Review Top Stories Amazon, Hello Fresh, Stitch Fix. Click a button, a... [The James Webb Space Telescope just delivered some incredible new images of the universe]( From Technology Review Feed - Tech Review Top Stories The first images taken by the James Webb Space Tel... [Raspberry Pi Pico Adds USB Mouse Support to PlayStation 1]( From Tom's Hardware US This Raspberry Pi Pico project, created by Vojtěc... [The Virtual Office: What Challenges Does It Solve?]( From IT Pro - Microsoft Windows Information, Solutions, Tools VR, AR, and mixed reality technologies provide employees with different meeting and training experiences, and encourage productivity. [Raspberry Pi Peers into Deep Space with James Webb Space Telescope Digital Frame]( From Tom's Hardware US Cellar Nerd is using a Raspberry Pi to power his J... [Deloitte to Tech Companies: Carpe Diem on Digital Transformation]( From IT Pro - Microsoft Windows Information, Solutions, Tools Organizations should strategically ramp up on efforts that began during the COVID-19 pandemically, Deloitte said. [Low-code no-code applications will herald a revolution in app creativity and usability]( From Technology Review Feed - Tech Review Top Stories Thank you for joining us on “The cloud hub: From... [Razer’s Stream Controller Let’s You Control Your PC Easily]( From Tom's Hardware US Razer's Stream Controller has 12 haptic switchable... [How IoT Security Affects Data Monetization]( From Dataversity Understanding how IoT security affects data monetization is crucial for businesses to effectively trade intel without the risk of online threats. Today, almost every business shares important data, but... Virtualization and Containers/Kubernetes [Liberty Mutual’s Container Deployment – From Docker to Kubernetes]( From IT Pro - Microsoft Windows Information, Solutions, Tools Liberty Mutual made an early bet on containers and...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -