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 FeedTwitter
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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -