Hardware Heavy

Database Weekly for May 6, 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  Distracted I've found myself to be very distracted this week. Concentration on the task at hand has proven to be a challenge. I'm pretty sure the cause is that I just came off of three weeks of travel, which can be exhausting. Concentration, like so many things in life, requires energy. No energy, no concentration. So, the question is, how to recharge. Now, a big part of that is simply going to be getting a good amount of sleep, in your own bed (with my own pillow, I miss my pillow when I'm on the road). However, you also need to make sure you're eating well, exercising, and getting in whatever "me" time you need. All of this is challenging. Further, except for the sleep, all of it requires effort, which requires energy, which I don't currently have. HA! It's a blocked process. The lesson is, take care of yourself so that you can do what's necessary, including taking care of yourself. 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 [A First Look at PostgreSQL Monitoring in SQL Monitor]( PostgreSQL monitoring is now supported by Redgate SQL Monitor to improve performance and reduce downtime. AI/Machine Learning/Cognitive Services [AI Careers: How to Build a Career in AI]( From Past News - RSS Feeds A career in in artificial intelligence involves s... [AI Pioneer Quits Google to Warn Humanity of the Tech's Existential Threat]( From IT Pro - Microsoft Windows Information, Solutions, Tools Prominent Google computer scientist Geoffrey Hinto... [AI Ethics and Innovation for Product Development]( From Dataversity AI ethics are a factor in responsible product deve... [Video: Geoffrey Hinton talks about the “existential threat” of AI]( From Technology Review Feed - Tech Review Top Stories Deep learning pioneer Geoffrey Hinton announced on Monday that he was stepping down from his role as a Google AI researcher after a decade with the company. He says... [Driving Digital Transformation in the Insurance Industry: Embracing AI-Powered Solutions]( From Dataversity The insurance industry has witnessed a significant shift in recent years as technological advancements continue to transform traditional business models. From underwriting to claims management, artificial intelligence (AI) and... [New Generative AI Tools Aim to Improve Security]( From Dark Reading: Dark Reading News Analysis The debate over whether ChatGPT and other generati... Administration of SQL Server [Monitoring Deadlocks in Azure SQL Managed Instance]( From SQLServerCentral Blogs  Hello Dear Reader! My lastest blog on our Azur... [SQL School: Database Corruption Course]( From Steve Stedman Hello, I’m Steve Stedman, and I want to talk abo... [Get Database Insights Across Your Environment]( From MSSQL Tips Learn how to improve your database efficiency with... [Find LOB tables with no PRIMARY KEY]( From SQLServer-DBA.Com What if there is no primary key in table? [SQL Server Diagnostic Information Queries for May 2023]( From Glenn Berry Introduction These are my SQL Server Diagnostic Information Queries for May 2023, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration... [The Importance of Running CheckDB on SQL ServerÂ]( From Steve Stedman As a business owner or IT professional, you know your SQL Server is critical to the success of your organization. It’s essential to ensure your SQL Server is running... Azure Databricks, Spark and Snowflake [How to use SnowSQL client to work with Snowflake?]( From Hadoop in the Real World In this post, we will discuss how to use SnowSQL client in Windows to connect and work with Snowflake. If you are new to Snowflake, we […] The post How... Azure DevOps [Microsoft Purview DevOps policies now includes all the typical permissions for SQL support personnel]( From Azure SQL The article is published here on the Microsoft Sec... Azure SQL [Remove Azure SQL Databases from a Failover Group and Remove Geo-Replication]( From MSSQL Tips Learn about the steps needed to remove a SQL datab... [What's new in Azure SQL - May 2023]( From Azure SQL Today Data Exposed went live at 9AM PT for a special Ask Me Anything and news update. If you missed the episode, you can find them all at .... Azure Synapse (SQL Data Warehouse and Data Lake) [How to SCHEDULE your notebooks to run with Azure Synapse]( From Guy in a Cube Taking advantage of Notebooks in Azure Synapse Ana... Cloud - AWS [AWS Launches New Verified Access Service to Replace VPN]( From Petri IT Knowledgebase Amazon has announced the general availability of i... [New – Set Up Your AWS Notifications in One Place]( From AWS News Blog Today we are launching AWS User Notifications, a single place in the AWS console to set up and view AWS notifications across multiple AWS accounts, Regions, and services. You... [Introducing Bob’s Used Books—a New, Real-World, .NET Sample Application]( From AWS News Blog Today, I’m happy to announce that a new open-source sample application, a fictitious used books eCommerce store we call Bob’s Used Books, is available for .NET developers working with... Cloud - Azure [Azure Storage Account]( From SQLServerCentral Blogs This blog post aims to provide an overview of Azur... [Generally Available: Azure Backup Server V4]( From Azure Updates V4 is the latest upgrade for Microsoft Azure Backup Server (MABS). Azure Backup Server can now be installed on Windows Server 2022 with SQL Server 2022 as its database.... [Spreading your SQL Server wings with Azure SQL Edge]( From Kevin Chant Reading Time: 3 minutes In this post I want to cover spreading your SQL Server wings with Azure SQL Edge. As part of a series of posts about... [Use Microsoft Purview to provide at-scale access to performance data in Azure SQL and SQL Server]( From Azure SQL In prior articles we have covered how you can use Microsoft Purview as an inexpensive solution to grant read access to SQL’s system metadata information. You achieve this if... Cloud - GCP [Google DeepMind CEO: AGI Is Coming ‘in a Few Years’]( From IT Pro - Microsoft Windows Information, Solutions, Tools Demis Hassabis' view echoes those of Geoffrey Hinton, a giant in AI who now fears the tech he was seminal in developing. Computing in the Cloud (Azure, Google, AWS) [The New Major Cloud Adopters: Financial Services]( From IT Pro - Microsoft Windows Information, Solutions, Tools In 2023, major banks, wealth managers, insurance companies, and other FS organizations are leaning heavily on public cloud for digital banking services. [How to Repatriate a Cloud Workload: Four Essential Considerations]( From IT Pro - Microsoft Windows Information, Solutions, Tools There are virtually no tools designed to help with cloud repatriation, so you are pretty much on your own. Here's a guide on what to think about when planning... Conferences, Classes, Events, and Webinars [PostgreSQL 101: The 10 key differences between SQL Server & PostgreSQL]( Join us for the second webinar in our PostgreSQL 101 series. As a SQL Server developer or DBA, you have a broad skill set and have become accustomed to interacting with the larger #SQLFamily community. Now, by choice or necessity you've begun to explore PostgreSQL and things feel oddly familiar and foreign at the same time. Join Ryan Booze on May 25th to find out the things that often trip up SQL Server users when they first start exploring PostgreSQL. [PASS Data Community Summit 2023 registrations are open!]( In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post to learn more. DMO/SMO/Powershell [Scheduling PowerShell Scripts with Puppet]( From MSSQL Tips In this article, learn about Puppet a tool to help... [Documenting all GPOs with PowerShell]( From Sid 500 PoSh Active Directory Group Policies (GPO) enables you ... [How To Import the PowerShell Active Directory Module]( From IT Pro - Microsoft Windows Information, Solutions, Tools Learn how to import the Active Directory module in... [Fun With PowerShell – Authoring Help]( From Arcane Code Fun With PowerShell - Authoring Help Data Mining / Data Analysis [Visualizing new ways to protect sharks with data and analytics]( From AllAnalytics Where do hammerhead sharks go at night? And perhap... [eWEEK TweetChat, May 17: Best Practices in Data Analytics]( From Past News - RSS Feeds On Wednesday, May 17, at 11 AM PT, @eWEEKNews will host its monthly #eWEEKChat. The topic will be Best Practices in Data Analytics, and it will be moderated by... [Debunking the myth that SAS code doesn't work in Viya: One billion lines later and the results are...]( From AllAnalytics The SAS 9 Content Assessment is a collection of applications that are designed to help users understand the various characteristics of their deployment. SAS Content Assessment delivers information that... [My Love Letter to Data]( From Little Miss Data Sharing my love letter to data which I penned as part of the Pythian “Love Letters to Data” series. Data Warehousing [The first two chapters of my book are available!]( From SQLServerCentral Blogs As I have mentioned in prior blog posts, I have be... [A Proposed Data Warehouse Architecture for Small and Medium Businesses]( From MSSQL Tips Learn about the process and principal components of building a data warehouse and learn about the five predominant architectures Independent Data Marts, Data Mart Buses, Hub-and-Spoke, Centralized Data Warehouses,... Database Design, Theory and Development [5 Ways to Avoid Unscheduled Database Downtime]( From Steve Stedman To prevent unscheduled downtime, here are some bes... [Data Spring Cleaning: How To Deal With ROT Data All Year Round]( From IT Pro - Microsoft Windows Information, Solutions, Tools Clean, high-quality data is critical for business operations, but many companies have a data mess behind the scenes. Here’s how to clean and prevent unwanted data. [Semantic Technology and Integration 101: What It Is and Why It Matters]( From Dataversity New technologies like ChatGPT are all the rage, as they aim to answer questions and provide information that makes our lives easier. Yet, the validity of the results generated... DevOps and Continuous Delivery (CI/CD) [Flyway for SQL Server Data Tools Users]( From Product learning – Redgate Software If you are using SSDT for authoring, building, deb... [Experiments with GitHub CoPilot]( From SQLServerCentral Blogs There has been a lot of attention given to ChatGPT... [How Many Commits Did You Make in Last Month]( From Sheldon Hull Been playing with opencommit and wanted to assess... [FinOps Foundation Launches FOCUS Spec for Cloud Cost Data Sharing]( From IT Pro - Microsoft Windows Information, Solutions, Tools Defining different cloud costs can vary across providers, which is a challenge that the Google- and Microsoft-supported FinOps FOCUS specification aims to solve. General [Graphics Card Cooled With 3D-Printed Housing for Server Fan]( From Tom's Hardware US SamoesA DIY 3D-printed a solution to keep his grap... Hardware [3D Print Your Own USB BusKill Module to Protect Data]( From Tom's Hardware US Melanie Allen with BusKill has designed a 3D-print... [TSMC Plans Up to $11 Billion German Chip Fab Investment: Report]( From Tom's Hardware US TSMC has plans to establish a 28nm chip fab in Sax... [Raspberry Pi Trainspotting Project Watches Tracks So You Don’t Have To]( From Tom's Hardware US Jo M is using a Raspberry Pi to record passing tra... [Ultimate Breadboard Goes Overboard]( From Tom's Hardware US When you need more breadboards, this project from ... [How to Test RAM: Making Sure Bad Memory Isn't Crashing Your PC]( From Tom's Hardware US We take you through a few methods to test RAM to s... [Raspberry Pi Pico Repurposes Aircraft Tachometer as a CPU Monitor]( From Tom's Hardware US Maker Glen Akins has repurposed an old aircraft ta... [Backblaze: HDDs Tend to Fail Before Three Years of Operation]( From Tom's Hardware US Backblaze has poured through its HDD failure rates... [Raspberry Pi Pico Mechanical Keyboard Kits Offer RGB Support and OLED Display]( From Tom's Hardware US 1upKeyboards has released two new Raspberry Pi Pico mechanical keyboard kits to build the DIY ortholinear keyboard of your dreams. [Intel to Show Off E-Core-Based CPU with Backside Power Delivery]( From Tom's Hardware US Intel to describe benefits of PowerVia backside PDN with 4nm-class test chip. KB, Bugs, Fixes [Microsoft Now Provides Email Alerts About Known Issues for Windows Admins]( From Petri IT Knowledgebase Microsoft has released a new email alerts feature ... [Bug chasing, narrowing down the scope]( From Ayende @ Rahien I just completed a major refactoring of a piece of code inside RavenDB that is responsible for how we manage sorted queries. The first two tiers of tests all... MDX/DAX [Optimizing DAX Second Edition – Interview with Alberto Ferrari and Marco Russo]( From Sqlbi Learn more about the new Optimizing DAX second edition video course: who should attend, technologies included, content organization, companion book, and much else! Course announcement: Buy now: Oracle/PostgreSQL/MySQL/other RDBMS [Importing data into a MySQL database using LOAD DATA]( From Simple Talk Database and development teams often load data from plain text files into their MySQL databases. The files might be used to add lookup data, support test and development environments,... Performance Tuning SQL Server [Trying Query Parameterization Settings in SQL Server]( From Curated SQL Tibor Karaszi builds a test: You have probably see... [A Little About Trivial Plans In SQL Server]( From Erik Darling Data A Little About Trivial Plans In SQL Server Going F... [A Little About Memory Grants In SQL Server Query Plans]( From Erik Darling Data A Little About Memory Grants In SQL Server Query Plans Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training.... PowerPivot/PowerQuery/PowerBI [Power BI Cruise Recap – Deep Data Dives]( From SQLServerCentral Blogs Thank you so much to those of you who were able to... [Controlling Workspace Creation in Power BI: How to Strike the Right Balance?]( From Data – Marc Working with many companies that implement Power B... [RLS in the source? How does this work with DirectQuery and Import in Power BI?]( From Guy in a Cube What happens in Power BI when you have row-level s... [The HEART of Power BI]( From Guy in a Cube Remember Analysis Services? Maybe not for some of ... [Automated Remediation Can Make Dashboards a Thing of the Past]( From Dataversity A convergence of events – including the global pandemic, a shift to remote work, and increased use of the cloud – has accelerated companies’ digital transformations over the past... Professional Development [Divorce]( From Troy Hunt's Blog I wish I'd read this blog post years ago.I don't h... [From Good to Great: Boosting Your Performance as a DBA with the SPIN Sales Strategy]( From Eitan Blumin As a DBA, your job involves much more than just ma... [Reflections on My First-Ever Presentation, Fifteen Years Later]( From SQLServerCentral Blogs Today is a small but significant milestone in my c... Python [Validate Data Cleanliness Using Asserts in Python]( From Journey to SQL Authority with Pinal Dave I just released my 49th course on the learning platform Pluralsight. Building this new course Validate Data Cleanliness Using Asserts in Python, was fun. First appeared on Validate Data Cleanliness... [Calculate Non Linear Relationships such as Exponential, Logarithmic, Quadratic and Cubic using Python]( From MSSQL Tips In this article, we look at examples of non-linear relationships such as exponential, logarithmic, quadratic, and cubic using Python. Security News and Issues [Computer System Used To Hunt Fugitives Is Still Down 10 Weeks After Hack]( From IT Pro - Microsoft Windows Information, Solutions, Tools A key law enforcement computer network has been do... [SolarWinds Detected Six Months Earlier]( From Schneier on Security New reporting from Wired reveals that the Departme... [Celebrating World Password Day: Best Practices for Secure Accounts]( From IT Pro - Microsoft Windows Information, Solutions, Tools Strong password practices are important every day of the year. World Password Day is a chance to improve how we protect our our digital lives. [Anatomy of a Malicious Package Attack]( From Dark Reading: Dark Reading News Analysis Malicious packages are hard to avoid and hard to d... [Hotels at Risk From Bug in Oracle Property Management Software]( From Dark Reading: Dark Reading News Analysis Oracle's characterization of the vulnerability in ... [Identifying Compromised Data Can Be a Logistical Nightmare]( From Dark Reading: Dark Reading News Analysis Being able to trace an incident backward from brea... [Netskope: Attackers Double Down on Social Engineering Techniques and Malicious Functionalities]( From Dark Reading: Dark Reading News Analysis Researchers find attackers are successfully evadin... Software Development [Migrating Critical Traffic At Scale with No Downtime — Part 1]( From Netflix TechBlog - Medium Migrating Critical Traffic At Scale with No Downtime — Part 1Shyam Gala, Javier Fernandez-Ivern, Anup Rokkam Pratap, Devang ShahHundreds of millions of customers tune into Netflix every day, expecting an uninterrupted and immersive... T-SQL and Query Languages [One use case for NOT using schema prefixes]( I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server. At Stack Overflow, though, there is a very specific pattern we use where not specifying the schema is beneficial. [SQL Server Essentials: Using SQL Joins]( From Petri IT Knowledgebase In relational databases like SQL Server, the SQL J... [T-SQL Tuesday #162 Invitation – Data Science in the time of ChatGPT]( From TomazTsql This is a great opportunity and I am honoured to b... [Formatting a date in SQL Server with the Z indicator]( From World of Whatever Formatting a date in SQL Server with the Z indicat... [Understanding SQL Ranking Functions ROW_NUMBER(), RANK(), DENSE_RANK() and NTILE()]( From MSSQL Tips Learn about the different ranking functions in SQL Server along with how to use each of these: ROW_NUMBER(), RANK(), DENSE_RANK() and NTILE(). Tech News [The inside scoop on solar geoengineering]( From Technology Review Feed - Tech Review Top Stories This article is from The Spark, MIT Technology Review’s weekly climate newsletter. To receive it in your inbox every Wednesday, sign up here. Sometimes, as a reporter following climate technology,... [Microsoft’s Bing Chatbot Launches in Open Preview and Will Get Third-Party Plugins]( From Petri IT Knowledgebase Microsoft is removing the waitlist for its new AI-... [Famine to Feast and Back: Startups Adjust to Economic Realities]( From Dark Reading: Dark Reading News Analysis Cybersecurity is a hotbed of startup activity, and... Tools for Dev (SSMS, ADS, VS, etc.) [Video: The Top 5 Client Tools for SQL Server]( From 36 Chambers – The Legendary Journeys THE VIDEO THE SYNOPSIS In this video, we will talk... [Classing Up SSMS is as Easy as 1, 2, 3.]( From Brent Ozar Unlimited Step 1: go into Tools, Options and set this: Step ... [Chat GPT says SSMS is the best SQL Server monitoring tool-- and it's right]( From Kendra Little's Blog One thing I enjoy about AI chatbots is that they c... Virtualization and Containers/Kubernetes [Upgrade SQL Server container with Always On availability groups configured on Kubernetes!]( From MS SQL Server Blog This is a follow-up to my previous blog post I pub...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -