Sprinkling Powershell On It

Database Weekly for June 29, 2024 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  Shout Your Successes I was at a customer this week (sorry, can't share who). I spent the day talking about Redgate Monitor and how it can help with query tuning, server management, and estate management. Through the day, the data pros at the company were sharing how they were managing hundreds of servers and several thousand databases. They were good. No, scratch that. They were pretty great. These people had a thorough and deep knowledge of their systems, how they worked, and what was needed to keep the whole thing up and running. Sure, I contributed a little to their knowledge, but they were already great at their jobs. Oddly, and this isn't meant to be a criticism, just an observation, they were just almost apologetic about how good they were. It felt a little weird. Cause let's be clear, if I was doing as good a job as these people were, I'd be standing on my desk crowing about it pretty much non-stop. I think you should too. What we do isn't easy. In fact, it can be pretty darned hard. When you've been in fire fighting mode for a while, just dealt with major outages, or had a few rough deployments, it can feel like your best bet is to hide in a corner and hope no one notices you're there. Instead, stand up. Square your shoulders. Share your accomplishments with the company. Scream about it. Let them know you're busting your behind for the organization. Don't be humble. Brag. There 100% is a time and place for humility, especially in inter-personal conversations. However, when it comes to broad talks to your company, not individuals, shout your success. Let them know what you and your team are accomplishing. They need to hear it. Let's also be honest about it, you could use that bit of ego boost too. Nothing wrong with that, especially when you are in fact doing a good job. Still gotta own your mistakes, but we don't have to be loud about those. Just clear & honest. Thump your chest and shout, "We did good. Our team rocks. Look at our accomplishments!" 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 [Redgate recommended in Bloor Test Data Management market update]( Last year, Redgate announced the launch of their latest in test data management (TDM) technology – Redgate Test Data Manager. This year, they’re proud to have been recommended in Bloor’s 2024 Test Data Management Market Update! This paper highlights the increasing adoption of TDM technology among enterprise organizations and offers insight into the trends and approaches to look out for when looking for a TDM solution. AI/Machine Learning/Cognitive Services [Windows Copilot vs. Google Gemini to Build SQL Queries]( From MSSQL Tips Learn how to use Windows Copilot to write SQL code... [My colleagues turned me into an AI-powered NPC. I hate him.]( From Technology Review Feed - Tech Review Top Stories This story originally appeared in The Algorithm, o... [OpenAI Taking Steps to Block China’s Access to Its AI Tools]( From IT Pro - Microsoft Windows Information, Solutions, Tools OpenAI reportedly sent warnings to developers acro... [Bill Gates Says AI's Green Benefits Will Outweigh Its Emissions]( From IT Pro - Microsoft Windows Information, Solutions, Tools The Microsoft co-founder says data centers will be less energy-intensive in the future as artificial intelligence makes computations more efficient. [AI in Social Media: Examples, Tips, and Tools for Success]( From Past News - RSS Feeds Developments in AI are bringing automation and con... [How AI video games can help reveal the mysteries of the human mind]( From Technology Review Feed - Tech Review Top Stories This article first appeared in The Checkup, MIT Technology Review’s weekly biotech newsletter. To receive it in your inbox every Thursday, and read articles like this first, sign up here. This week... Administration of SQL Server [Database Build Error – Incorrect syntax near DISTINCT]( From SQLServerCentral Blogs I wrote a piece of SQL that had some new T-SQL syn... [The Real Danger Regarding the xp_cmdshell Setting]( From StraightPath Solutions SQL Blog This post is part of our SQL Server security blog ... [What the SQL Server TDE Certificate Expiration Date Does (and does not) Mean]( From StraightPath Solutions SQL Blog This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the... [Your SQL Server Database Owner Might be Causing Privilege Escalation]( From StraightPath Solutions SQL Blog This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the... [A Walkthrough – DATETRUNC Function in SQL Server]( From Journey to SQL Authority with Pinal Dave One such tool is the DATETRUNC function, introduce... Azure SQL [Create a copy of an Azure SQL DB]( From SQLServerCentral Blogs Where I work, we will be migrating data from one s... Cloud - AWS [Optimizing Amazon Simple Queue Service (SQS) for speed and scale]( From AWS News Blog Amazon SQS boosts performance, scaling capabilities, and energy efficiency without impacting existing behavior - a behind-the-scenes look at AWS's continuous improvement journey. [Introducing end-to-end data lineage (preview) visualization in Amazon DataZone]( From AWS News Blog Trace data from origin to insights with an intuitive visual graph, empowering engineers, analysts, and admins to validate provenance, troubleshoot pipelines, and ensure governance with ease. [Amazon WorkSpaces Pools: Cost-effective, non-persistent virtual desktops]( From AWS News Blog Streamline virtual desktop management: provision non-persistent desktops, configure apps and resources, and automatically scale capacity based on demand, all from a centralized platform. Community Interests [Robert Haas: Mentoring Program for Code Contributors]( From Planet Postgres Yesterday, I announced a call for applications fo... [Karen Jex: When I grow up I want to be a Database Administrator (said no-one ever)]( From Planet Postgres Instead of just sharing the slides from the keynot... [Take the SQL Saturday Topic Survey]( From SQLServerCentral Blogs What topics do you want to see presented at a futu... [Data Technology Learning Resources]( From Scary DBA (Grant Fritchey) Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put together an interesting collection of data over on GitHub. It’s titled DBA Resources, but it... Computing in the Cloud (Azure, Google, AWS) [Optimize Your Cloud Strategy: 6 Key Takeaways From FinOps X 2024]( From IT Pro - Microsoft Windows Information, Solutions, Tools These key insights from FinOps X 2024 will help guide your FinOps decisions, says Kyle Campos, chief technology & product officer at CloudBolt Software. [How Cloud-Native Development Benefits SaaS]( From IT Pro - Microsoft Windows Information, Solutions, Tools For many organizations, SaaS and commercial off-the-shelf software are at best an 80% solution to the business need. Find out how cloud-native development can help close the gap. DMO/SMO/Powershell [PowerShell String Manipulation for Dynamic Code Generation]( From IT Pro - Microsoft Windows Information, Solutions, Tools PowerShell enables dynamic code generation by cons... [Remove Duplicate Records in CSV Files with PowerShell]( From Callihan Data In a recent comment on a my post about combining CSV files using PowerShell, a reader named Oliver asked how duplicate values should be handled when combining multiple CSV... [Advanced String Manipulation Techniques in PowerShell]( From IT Pro - Microsoft Windows Information, Solutions, Tools Explore these string manipulation techniques, including converting strings to arrays, inserting and removing text, and correctly using single and double quotes, to dynamically construct commands. Data Mining / Data Analysis [Demystifying Advanced Analytics: Which Approach Should Marketers Take?]( From Dataversity “Advanced analytics” has been the new buzzword... [3 approaches to strengthening your social benefits program]( From AllAnalytics Social benefits are crucial government services, e... [What is elastic weight consolidation?]( From Statistical Odds & Ends Elastic weight consolidation (EWC) is a technique ... [3 reasons why marketers need SAS® for customer analytics]( From AllAnalytics Customer analytics is becoming imperative for organizations that desire to create and provide personalized and satisfying customer experiences. To understand and anticipate customer needs, preferences and behaviors in a... [Enhancing the Reliability of Predictive Analytics Models]( From Dataversity Predictive analytics is a branch of analytics that identifies the likelihood of future outcomes based on historical data. The goal is to provide the best assessment of what will... DevOps and Continuous Delivery (CI/CD) [Resetting Git and Abandoning Changes–#SQLNewBlogger]( From SQLServerCentral Blogs I recently had an issue in one of my Git repos, an... [Getting a Handle on IT Change Management]( From IT Pro - Microsoft Windows Information, Solutions, Tools Change is inevitable. It's also challenging. Here'... [Stress test]( From Technology Review Feed - Tech Review Top Stories Elizabeth Sajdel-Sulkowska was just three months o... [Simpler Enterprise Test Data Management using Database Instance Provisioning]( From Product learning – Redgate Software Business applications are rarely self-contained, o... DocumentDB/Key-Value/Graph/other NoSQL Databases [Deleting Documents from a MongoDB Collection]( From Simple Talk So far in this series, we’ve looked at different... ETL/SSIS/Azure Data Factory/Biml [Debugging Failed Function Calls in Data Factory]( From Andy Broadsword I recently ran into an issue when trying to call a... [How to use a Script Activity in ADF as a Lookup]( From SQLServerCentral Blogs In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a typical scenario where you retrieve some metadata from a database and then loop over... The... Hardware [Toys can change your life]( From Technology Review Feed - Tech Review Top Stories In a November 1984 story for Technology Review, Ca... [I tested the cheapest Surface Pro Copilot+ PC for a week, and it easily replaced my daily driver]( From All about Microsoft Blog RSS | ZDNet I'm impressed by almost everything Microsoft's first Snapdragon X-powered device has to offer. [Micron: U.S. Fabs Will Start Operating in 2026 - 2029]( From AnAndTech When Micron announced plans to build two new fabs in the U.S. in 2022, the company vaguely said both would come online by the decade's end. Then, in 2023,... Internet of Things [Monetizing the Data Delivered by IoT Medical Devices]( From Dataversity Recent years reflect medical device manufacturers ... [What do you get when you fuse GenAI with IoT?]( From AllAnalytics GenAI's creative and analytical capabilities, integrated with IoT devices' connectivity and data insights, could lead to remarkable advancements. The market could become a mega-value creator, potentially exceeding $4.5 trillion... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Easily scale up or scale down your Fabric Capacity using Power Automate (Via email)]( From FourMoo Easily scale up or scale down your Fabric Capacity... [Building a Modern Data Platform with Data Fabric Architecture]( From Dataversity In today’s data-driven landscape, organizations face the challenge of integrating diverse data sources efficiently. Whether due to mergers and acquisitions (M&A) or the need for advanced insights, a robust... Performance Tuning SQL Server [XML Performance Tuning and Added Options]( From Simple Talk SQL Server provides a variety of ways to tune XML ... [Exploring Windows Function Execution Plans]( From Scary DBA (Grant Fritchey) There are quite a few different ways that you’re... [Add Indexes to Improve SQL DELETE Performance]( From MSSQL Tips This article examines whether creating SQL indexes... [Some Notes On Query Tuning With Batch Mode In SQL Server]( From Erik Darling Data Some Notes On Query Tuning With Batch Mode In SQL Server Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about,... [Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes]( From MSSQL Tips Learn how to use SQL Server Query Store to identif... PostgreSQL [Andrei Lepikhov: PostgreSQL Sort estimation volnurability]( From Planet Postgres As a PostgreSQL developer, I am inevitably stumbli... [Luca Ferrari: pg_dump and --if-exists little gem]( From Planet Postgres An option I was not aware of… pg_dump and �... [Gabriele Bartolini: Making the world my single point of failure with PostgreSQL]( From Planet Postgres The upcoming CloudNativePG 1.24 introduces a game-changing feature: the ability to declaratively manage PostgreSQL cluster switchover across cloud regions or different Kubernetes clusters. This advancement enables the seamless demotion... [David Wheeler: Patch: Postgres ABI and API Guidance]( From Planet Postgres TL;DR: If you’re a Postgres extension developer interested in understanding what to expect from core API and ABI stability, please review and give feedback on this patch (or pull... [Christoph Schiessl: Using Transaction Chaining to Reduce Server Round-Trips]( From Planet Postgres Cut the number of required PostgreSQL server round-trips by up to 50% using the `AND CHAIN` parameter of the `COMMIT` and `ROLLBACK` statements. PowerPivot/PowerQuery/PowerBI [Power BI and Fabric capacities: Understand the difference and cost structure]( From Data – Marc P-SKUs, A-SKUs, EM-SKUs and now we also have F-SKU... [Easy-to-Read Multi-Variance Native Visual in Power BI]( From Havens Consulting Video by: Reid HavensLearn how to combine a series... Professional Development [7 tips for overcoming Imposter Syndrome]( From AllAnalytics Do you feel the need to be flawless in your work t... [Learning from catastrophe]( From Technology Review Feed - Tech Review Top Stories The philosopher Karl Popper once argued that there... [Inside the US government’s brilliantly boring websites]( From Technology Review Feed - Tech Review Top Stories The United States has an official web design syste... [The New Work Etiquette: If You Can't Spot the Jerk, It Might Be You]( From IT Pro - Microsoft Windows Information, Solutions, Tools From avoiding unclear meeting invitations to gossiping more, these are some rules of the modern workplace. Security News and Issues [The State of Data Breaches]( From Troy Hunt Presently sponsored by: Push Security. Stop identi... [Demand for Better Cybersecurity Fuels a Booming Job Market]( From IT Pro - Microsoft Windows Information, Solutions, Tools Gen Z and mid-career jobseekers are enrolling in c... [Law Enforcement Is Spying on Thousands of Americans’ Mail, Records Show]( From IT Pro - Microsoft Windows Information, Solutions, Tools The Postal Service approves thousands of requests ... [Multifactor Authentication Is Not Enough to Protect Cloud Data]( From IT Pro - Microsoft Windows Information, Solutions, Tools Ticketmaster, Santander Bank, and other large firm... [BlackSuit Cybercrime Gang Blamed in CDK Hack That Roiled Car Dealers]( From IT Pro - Microsoft Windows Information, Solutions, Tools The extortion group has demanded tens of millions ... [How To Implement Zero-Trust Security in Linux Environments]( From IT Pro - Microsoft Windows Information, Solutions, Tools Unlike traditional security models, zero trust ass... [Why China’s dominance in commercial drones has become a global security matter]( From Technology Review Feed - Tech Review Top Stories This story first appeared in China Report, MIT Tec... [The US Is Banning Kaspersky]( From Schneier on Security This move has been coming for a long time. The Bid... [Security Analysis of the EU’s Digital Wallet]( From Schneier on Security A group of cryptographers have analyzed the eiDAS 2.0 regulation (electronic identification and trust services) that defines the new EU Digital Identity Wallet. [How To Scan a Website for Vulnerabilities: Top Tools and Techniques]( From Past News - RSS Feeds Learn strategies and tools to effectively scan and... [Space: The Final Frontier for Cyberattacks]( From IT Pro - Microsoft Windows Information, Solutions, Tools A failure to imagine — and prepare for — threats to outer-space related assets could be a huge mistake at a time when nation-states and private companies are rushing... Software Development [5 Steps for Enhancing Software Developer Experience]( From IT Pro - Microsoft Windows Information, Solutions, Tools Take these five actionable steps to improve the jo... [Video: What about Multi-Class Classification?]( From 36 Chambers – The Legendary Journeys THE VIDEO THE SYNOPSIS In this video, I get past t... [Implementing "Suggested Destinations" in a few lines of code]( From Ayende @ Rahien Today I got in my car to drive to work and realize... [AI-Assisted Development Tools vs. Low-Code/No-Code: What to Use When]( From IT Pro - Microsoft Windows Information, Solutions, Tools There are pros and cons to using AI-assisted development tools versus low-code/no-code platforms for creating applications with minimal coding. Here are the key differences between the two techniques. [Is .NET Aspire NuGet for Cloud Service Dependencies?]( From You've Been HAACKED .NET Aspire has similar goals to NuGet in that it ... Tech News [Sweat may protect against Lyme disease]( From Technology Review Feed - Tech Review Top Stories Most people’s sweat contains a protein that can ... [Sprayable gel simplifies surgeries]( From Technology Review Feed - Tech Review Top Stories Colonoscopies are a boon for preventing colon canc... [Evaporation without heat]( From Technology Review Feed - Tech Review Top Stories In a series of painstakingly precise experiments, ... [Drugs are more effective at certain times of day]( From Technology Review Feed - Tech Review Top Stories Using engineered mini-livers derived from donated ... [SuperLimbs for astronauts]( From Technology Review Feed - Tech Review Top Stories It’s hard not to laugh at NASA’s blooper reel ... [Enhancing Netflix Reliability with Service-Level Prioritized Load Shedding]( From Netflix TechBlog - Medium Applying Quality of Service techniques at the appl... [Job title of the future: Space debris engineer]( From Technology Review Feed - Tech Review Top Stories Stijn Lemmens has a cleanup job like few others. A... [Microsoft clamps down on Windows 11 users who want local accounts - but this trick still works]( From All about Microsoft Blog RSS | ZDNet The company has removed online steps for switching from a Microsoft account to a local one and has killed off a past trick for choosing a local account in... [How to sign in to Windows 11 with your Microsoft 365 Business account (and why you should)]( From All about Microsoft Blog RSS | ZDNet There are differences between Microsoft business and consumer accounts. Here's what those contrasts mean. [Robots, Drones and Driverless Tractors Usher In New Age of Farming]( From IT Pro - Microsoft Windows Information, Solutions, Tools Companies offer high-tech ways to make growers more efficient. The Lighter Side [CodeSOD: Nothing is True]( From Daily WTF Alexander sends us this snippet, where we change o... Virtualization and Containers/Kubernetes [Going serverless in Kubernetes with Knative]( From Simple Talk Serverless computing has become increasingly popul... [Going serverless in Kubernetes with Knative]( Serverless computing has become increasingly popular in the field of cloud computing, with more organizations opting for cloud-based architectures. The introduction of serverless technologies has led to server management abstraction, where the focus has shifted towards coding and services rather than hardware and infrastructure. With Knative you can now leverage the benefits of serverless computing, such as scalability, reduced operational overhead, and cost efficiency within your own Kubernetes clusters.  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -