Heap Praise On Others

Database Weekly for October 21, 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  Celebrate THEIR Accomplishments I can't hide this in any way. I love it when I accomplish something. It's such a great feeling. Even more than that, I really do love getting some acknowledgement for it. Almost as good, is when I see others, especially friends and acquaintances, doing well. So many people I know, regularly just knock it out of the park. I'm not always as good at this as I truly want to be, but I try, and I try hard, to acknowledge what they've done. I point it out and promote it, as much as, occasionally even more than, anything I've done. Why? Accomplishment doesn't come from a single bucket or a pie. If one person accomplishes something great, that accomplishment doesn't diminish anything anyone else has done. Further, that accomplishment doesn't take away from others. It's not like, if someone you know does something cool, then, well, now, you can't because the pie is smaller, or there's less in the bucket. Doing good, great, fantastic, that's a truly limitless resource. So look around. If you see someone doing great things, sing their praises. I'll let you in on a little secret. Doing so, yeah, it makes you feel better too. Share that celebration of others, and get something good in return. That's a great deal. 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 [Unleashing the Power of AI and ML in Data]( From Dataversity In today’s insight-informed world, businesses of... [AI-Powered Israeli 'Cyber Dome' Defense Operation Comes to Life]( From Dark Reading: Dark Reading News Analysis The Israelis are building a cyber defense system that will use ChatGPT-like generative AI platforms to parse threat intelligence. [Developers and the AI Job Wars: Here's How Developers Win]( From IT Pro - Microsoft Windows Information, Solutions, Tools AI writes code for itself, programmers, and non-pr... [The Dangers of User Profiling in Large Language Models]( From IT Pro - Microsoft Windows Information, Solutions, Tools New research from NCC Group explored the potential... Administration of SQL Server [Common Mistakes in SQL Server – Part 5]( From SQLServerCentral Blogs Last week, in the post Common Mistakes in SQL Serv... [Bad Habits and Best Practices]( From SQLBlog.org Over a decade of posts and videos involving bad ha... [SQL SERVER – Ins and Outs of Online Index Operations]( From Journey to SQL Authority with Pinal Dave I recently talked about Ins and Outs of Online Ind... [October 2023 SQL Server Updates]( From Callihan Data In case you missed it, Microsoft released a slew o... [T-SQL Tuesday 167 – Encryption and Data Protection Roundup]( From SQLServerCentral Blogs Huge thanks to everyone who responded to my invita... [SQL Server Backups are Not a High-Availability Solution]( From SQLServerCentral Blogs Please continue doing your backups! Backups are Di... [I ❤️ QUOTENAME()]( From Sunday morning T An underrated, and perhaps less well-known T-SQL f... [SQL SERVER – Generating Secure Passwords]( From Journey to SQL Authority with Pinal Dave We’ll explore industry guidelines for complex pa... [Drop Table SQL Server Examples with T-SQL and SQL Server Management Studio]( From MSSQL Tips Learn drop table SQL Server examples with T-SQL an... [DROP TABLE IF EXISTS Examples for SQL Server]( From MSSQL Tips In this article we cover various ways to check if ... [Setup Ola Index Maintenance with Azure Runbooks and Terraform]( From SQLServerCentral Blogs Yes, you still need to do some work to maintain in... [SQL SERVER – Best Practices for Securely Storing Passwords]( From Journey to SQL Authority with Pinal Dave This post will explore industry-standard technique... Analysis Services / BI on the MS Stack [Wrapping up the SAS Championship, in photos]( From AllAnalytics The 23rd annual SAS Championship has come to a clo... Azure SQL [Troubleshooting High Log Utilization Due to ACTIVE_TRANSACTION]( From Azure Database Support Blog Please keep in mind that the SQL Server transactio... Cloud - AWS [New – Seventh Generation Memory-optimized Amazon EC2 Instances (R7i)]( From AWS News Blog Earlier, we introduced a duo of Amazon Elastic Com... [AWS Weekly Roundup – EBS Status Check, Textract Custom Queries, Amazon Linux 2, and more – October 16, 2023]( From AWS News Blog With just 41 days until AWS re:Invent 2023 opens, ... [AWS Athena Partitioning to Improve Query Performance and Cost Reduction]( From MSSQL Tips In this article, we will look at how Amazon Athena... [New Customization Capability in Amazon CodeWhisperer Generates Even Better Suggestions (Preview)]( From AWS News Blog An AI coding companion, such as Amazon CodeWhisper... [Amazon Quietly Wades Into the Passkey Waters]( From Dark Reading: Dark Reading News Analysis The move by the e-commerce kahuna to offer advance... [Introducing Amazon MSK Replicator – Fully Managed Replication across MSK Clusters in Same or Different AWS Regions]( From AWS News Blog Amazon Managed Streaming for Apache Kafka (Amazon ... [Rotate Your SSL/TLS Certificates Now – Amazon RDS and Amazon Aurora Expire in 2024]( From AWS News Blog Don’t be surprised if you have seen the Certific... Community Interests [SQL Saturday Boston 2023 Recap]( From SQLServerCentral Blogs First Things First Thank you to everyone who atten... Computing in the Cloud (Azure, Google, AWS) [Migrating Your Data to the Cloud? Don’t Overlook These Key Considerations]( From Dataversity Initially perceived as insecure and unstable, clou... [Should You Use Multiple Availability Zones in the Cloud?]( From IT Pro - Microsoft Windows Information, Solutions, Tools The answer is it depends on whether your need for ... Conferences, Classes, Events, and Webinars [DevOps Rocks]( Your DevOps learning journey starts here. Join Redgate's Roadshow as it goes from coast to coast, wrapping up in Seattle at the PASS conference. Sign up today. DMO/SMO/Powershell [Master the Power of File and Directory Management with Get-ChildItem in PowerShell]( From Petri IT Knowledgebase The Get-ChildItem PowerShell cmdlet is a powerful ... [How Using Windows Forms Changes PowerShell Script Logic (With Sample Script)]( From IT Pro - Microsoft Windows Information, Solutions, Tools PowerShell scripts are typically linear in executi... [Lesson Learned #446: Simplifying SQLPackage Log Debugging with PowerShell]( From Azure Database Support Blog Abstract: Handling massive SQLPackage diagnostic l... Data Mining / Data Analysis [3 ways Medicaid leaders are using data and analytics to be a catalyst for change]( From AllAnalytics Can you imagine a world where Medicaid isn’t jus... [How to draw a radar chart in SAS® Visual Analytics using a custom graph – Part I]( From AllAnalytics In the first of a two-part series, SAS' Cindy Wang... [5 wows for Women's Day]( From AllAnalytics The 10th Annual SAS Championship Women's Day event... Data Privacy, Compliance, and Governance [The Data Puppets Preview]( From Dataversity The Data Rants video blog series begins with host�... Database Design, Theory and Development [AI/ML- Death of the Database? Long Live the Database!]( From DBAKevlar One undeniable truth is that we often lean towards... DevOps and Continuous Delivery (CI/CD) [Creating a SQL Clone Image from a SQL Clone Database]( From SQLServerCentral Blogs A customer asked if a new image could be created f... [Atlassian Compass Brings New Direction to Improve Developer Experience]( From IT Pro - Microsoft Windows Information, Solutions, Tools Atlassian looks to improve DevOps workflow with de... [Why Database Discussions Have Moved From the Backroom to the Boardroom]( There are good reasons why business leaders should care about their databases—and hidden costs for neglecting them. Our CMO, Kate Duggan, wrote about the risks and potential costs in this article on Bloomberg. ETL/SSIS/Azure Data Factory/Biml [SSIS Catalog Browser v0.9.14.0 is Available]( From AndyLeonard.blog() I am honored to announce the latest version of SSI... [When All You Have is a Hammer…]( From Prologika (Teo Lachev's Weblog) Someone asked the other day for my opinion about t... Machine Learning [The Rise of Single-Purpose ML Frameworks]( From Curated SQL Pete Warden describes a phenomenon: The GGML frame... [Azure Machine Learning - General Availability for October]( From Azure Updates Three features now available in GA enable you to s... [Enabling enterprise growth with data intelligence]( From Technology Review Feed - Tech Review Top Stories Data — how it’s stored and managed — has bec... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Git integration and deployment pipeline updates on the Microsoft Fabric roadmap]( From Kevin Chant Reading Time: 5 minutes In this post I want to co... [Cloning Tables in Microsoft Fabric]( From Curated SQL Koen Verbeeck is interested: A while ago I had a l... [Fabric Real-Time Analytics]( From RADACAD Microsoft Fabric offers a workload for real-time s... Oracle/PostgreSQL/MySQL/other RDBMS [MySQL substring uses with examples]( From SQLShack This article will provide an understanding of diff... [New SQL Server and Oracle Cloud White Papers on Github!]( From DBAKevlar I’ve been pretty busy with work and travel, but ... Performance Tuning SQL Server [Lesson Learned #444:Handling the "Row Value Expressions Exceeds Maximum Allowed" Error in SQL Server]( From Azure Database Support Blog Some days ago, we faced the following error messag... [Don’t use DISTINCT as a “join-fixer”]( From SQLBlog.org I talk about an inefficient but common use case fo... [Free SQL Server Training: Batch Mode For Row Store Demo In SQL Server 2019 Part 2]( From Erik Darling Data Batch Mode For Row Store Demo Going Further If thi... [SQL Server query runtime is not everything]( From SQLServerCentral Blogs SQL Server query developers, listen up! Query exec... [Improve Query Performance when SQL Server Ignores Nonclustered Index]( From MSSQL Tips In this article, we look at why SQL Server may not... [Lesson Learned #445:Unlocking the Mystery of Recompilations in SQL Server: A Practical Lab]( From Azure Database Support Blog Some days ago, I worked on a service request that ... [Free SQL Server Training: UDF Inlining In SQL Server 2019 Demo Part 1]( From Erik Darling Data UDF Inlining Demo Part 1  Going Further If this ... PowerPivot/PowerQuery/PowerBI [Finish the Puzzle: Querying Power BI Semantic Models with Semantic Link!]( From Guy in a Cube Want to use notebooks to leverage data from a Powe... Professional Development [American Work-From-Home Rates Drop to Lowest Since the Pandemic]( From IT Pro - Microsoft Windows Information, Solutions, Tools The push by employers to get American workers back... [Prompting Isn’t The Most Important Skill]( From O'Reilly Radar - Insight Anant Agarwal, an MIT professor and of the founder... SQL Server Security and Auditing [SQL Server Security Primer]( From Simple Talk SQL Server security structure, mechanisms and meth... Security News and Issues [Why Zero Trust Is the Cloud Security Imperative]( From Dark Reading: Dark Reading News Analysis The security principle of zero trust is the corner... [Top 6 Mistakes in Incident Response Tabletop Exercises]( From Dark Reading: Dark Reading News Analysis Avoid these errors to get the greatest value from ... [5 Ways Hospitals Can Help Improve Their IoT Security]( From Dark Reading: Dark Reading News Analysis HIPAA compliance does not equal security, as conti... [The Need for a Cybersecurity-Centric Business Culture]( From Dark Reading: Dark Reading News Analysis Building a culture of cybersecurity is achievable ... [What Is Data Tracing? How Does It Enhance Security?]( From IT Pro - Microsoft Windows Information, Solutions, Tools Data tracing can serve critical roles in complianc... [Inside the quest for unbreakable encryption]( From Technology Review Feed - Tech Review Top Stories When we check email, log in to our bank accounts, ... [Iran-Linked 'MuddyWater' Spies on Mideast Gov't for 8 Months]( From Dark Reading: Dark Reading News Analysis The state-sponsored threat actors (aka APT34, Crambus, Helix Kitten, or OilRig) spent months seemingly taking whatever government data they wished, using never-before-seen tools. [The Most Popular IT Admin Password Is Totally Depressing]( From Dark Reading: Dark Reading News Analysis Analysis of more than 1.8 million admin portals re... [Boosting Efficiency: Microsoft’s New Feature Simplifies Management of Azure Role Permissions]( From Petri IT Knowledgebase Microsoft has announced a new security tool that e... [Accidental Insider Threats Are More Likely Than Malicious Insider Threats]( From IT Pro - Microsoft Windows Information, Solutions, Tools Mitigating the risk of accidental insider threats ... T-SQL and Query Languages [SQL WHERE IN Filtering Examples for SELECT, UPDATE, and DELETE]( From MSSQL Tips Learn how to filter data using SQL WHERE IN for SQ... Tech News [Government technology is famously bad. It doesn’t have to be.]( From Technology Review Feed - Tech Review Top Stories Every Tuesday, Jessica Ramgoolam heads down to the... [Arm Total Design to Facilitate Development of Custom Datacenter SoCs]( From AnAndTech Arm this week introduced its Arm Total Design init... [Intel, Siemens Pull Out of Web Summit After Israel Remarks]( From IT Pro - Microsoft Windows Information, Solutions, Tools Intel and Siemens are pulling out of Web Summit, f... [From Clutter to Clarity: How Data Drives Sustainability]( From Dataversity Deloitte’s 2023 global survey found that the th... The Lighter Side [This startup wants to find out if humans can have babies in space]( From Technology Review Feed - Tech Review Top Stories Egbert Edelbroek was acting as a sperm donor when ... flyway [Flyway Alerting and Notifications]( From Product learning – Redgate Software Once a scripted Flyway task is tested and bedded-i...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -