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

 

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