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
 

Keep Sharing

I was given a little reward the other day. My son came home telling me that the manufacturing company he works for wants to build some custom test equipment using Arduino-style controller chips. I've been experimenting, pretty darned lightly so far, with these over the last year. He starts asking me about which controllers I think are going to help him the most. My immediate response is "What the heck do I know about it. I'm still barely learning." His response, my reward, "Well, you know, an expert is a person who is one page ahead of you in a book."

Yeah, I taught him that.

My editorial today then is, keep sharing. You really never know when the stuff you put out there is going bear fruit. Just because it seems like people aren't listening, they may well be. You are providing help, guidance, insight, as you share. Whether it's in formal settings like a presentation at a conference, answering questions on the forums here at SQL Server Central, taking part in the #sqlhelp or #pghelp hash tags, or just chatting with some colleagues, your sharing is influencing people. Please, keep it up.

If you feel like you don't have anything to share, well, I'm here to tell you that you do. It may not be as much as the next person. It may not be some huge, powerful insight that changes the course of nations. It could be as little as sharing some positivity when someone is having a rough day. You can, and do, influence those around you all the time, whether you know it or not. So, as much as you can, try to direct it and make that influence a positive, helpful, force.

As they say, every little bit helps. Share, keep sharing, start sharing. And thank you!

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

Six Things to Monitor with PostgreSQL

This article describes six performance metrics that ought to be central to your PostgreSQL monitoring strategy. By using a tool like SQL Monitor to track these metrics over time, and establish baselines for them, you'll be able to spot resource pressure or performance issues immediately, quickly diagnose the cause, and prevent them becoming problems that affect users.

AI/Machine Learning/Cognitive Services

Build an AI strategy that survives first contact with reality

From Technology Review Feed - Tech Review Top Stories

Whether you think next-generation AI heralds an ex...

Humans may be more likely to believe disinformation generated by AI

From Technology Review Feed - Tech Review Top Stories

Disinformation generated by AI may be more convincing than disinformation written by humans, a new study suggests.  The research found that people were 3% less likely to spot false...

Universal data intelligence: The backbone for AI

From Technology Review Feed - Tech Review Top Stories

As organizations transition to data-driven business models, they must store, protect, and most importantly analyze their data. AI, automation, cloud, and as-a-service models all must frictionlessly interweave to achieve universal...

Large Language Models in the Enterprise: It’s Time to Find a Middle Ground

From Dataversity

ChatGPT, the conversational chatbot released by OpenAI in November, garnered 100 million users in just two months, making it the fastest-growing consumer app in Internet history. But the technology that underpins...

Generative AI vs. Machine Learning

From Past News - RSS Feeds

Generative AI is a form of artificial intelligence that is designed to generate content, including text, images, video and music. It uses large language models and algorithms to analyze...

Novelists Sue OpenAI for Copyright Infringement Over Books Used as Training Data

From Tom's Hardware US

The authors say that ChatGPT's use of their text i...

AI-Enabled Voice Cloning Anchors Deepfaked Kidnapping

From Dark Reading: Dark Reading News Analysis

Virtual kidnapping is just one of many new artific...

Administration of SQL Server

Unmasking SQL Server Dynamic Data Masking, Part 4, Unmasking Formatted and Unformatted Text

From Simple Talk

Continuing from the previous entry in this series ...

Protecting Your SQL Server: The Importance of Running Regular SQL Backups 

From Steve Stedman

As a business owner or IT professional, you know t...

Typing Strange Characters–#SQLNewBlogger

From SQLServerCentral Blogs

I’ve had to type a few non-English characters lately, and this blog talks about how to do this. Another post for me that is simple and hopefully serves as... The...

Lesson Learned #386: Can I log when Query Data Store (QDS) fails to capture a query?

From Azure Database Support Blog

In a recent service request, a customer asked if there was a way to identify when QDS fails to capture a query due to various reasons, such as high...

Early release – July is Database Health Monitor Month

From Steve Stedman

This month marks the anniversary of Database Health Monitor, that I started building in 2011. To celebrate I am offering 25% off the licensing fee for the annual subscription...

Restore SQL Server Backup to Docker Container

From SQLServerCentral Blogs

Restoring a SQL Server backup in a Docker container is quite easy. To begin with, you will need persistent storage on your Docker container to follow this blog post.... The...

Analysis Services / BI on the MS Stack

SQLBI+ updates in June 2023

From Sqlbi

This month we have a new video course and whitepaper for SQLBI+ subscribers: Inside Calculation Groups is available! This course is a deep dive into calculation groups in DAX....

Azure Databricks, Spark and Snowflake

Creating Random Data in Snowflake

From Sherpa of Data

One of the many things that the business team asks...

Snowflake's New AI Services Taps Large Language Models

From IT Pro - Microsoft Windows Information, Solutions, Tools

Updates include Snowpark Container Services, which...

Azure SQL

Lesson Learned #383: Loading multiple extended file using sys.fn_xe_file_target_read_file

From Azure Database Support Blog

In today's technologically advanced world, data pl...

Lesson Learned #385: Failed to validate the server name in a certificate during Secure Sockets Layer

From Azure Database Support Blog

The error message "Failed to validate the server name in a certificate during Secure Sockets Layer (SSL) initialization" indicates that there was a failure in validating the server name...

Lesson Learned #387:Monitoring Query Data Store State Changes in Azure SQL Database using PowerShell

From Azure Database Support Blog

This morning, I have been working on a support case where our client was not able to see certain queries when querying the Query Data Store. We have observed that...

Career, Employment, and Certifications

The Value of Adventure

From Simple Talk

One of the things that makes you a well-rounded pe...

Moments that matter: The Auditors

From MARTIN'S BLOG

I know it's a cliche, but there's a reason the phr...

Why You Shouldn't Specialize in AI/ML Development

From IT Pro - Microsoft Windows Information, Solutions, Tools

Despite the hype surrounding generative AI, specia...

Employer Demand for Technology Workers Across Europe Remains on Firm Footing

From Dark Reading: Dark Reading News Analysis

More than 950,000 job postings for tech positions ...

5 Tips for Current and Aspiring CTOs

From IT Pro - Microsoft Windows Information, Solutions, Tools

Being a CTO requires not only technical expertise but also business acumen and leadership skills. By following these tips, you can succeed in this role and contribute significant value...

Cloud - AWS

AWS Week in Review – Step Functions Versions and Aliases, EC2 Instances with Graviton3E Processors, and More – June 26, 2023

From AWS News Blog

It’s now summer in the northern hemisphere, and ...

New AWS AppFabric Improves Application Observability for SaaS Applications

From AWS News Blog

In today’s business landscape, companies strive ...

Cloud - Azure

Public preview: Using a common port for public and private listeners

From Azure Updates

Easily manage public-facing and private-facing tra...

Community Interests

Adding a Netlify contact form to a Hugo static site

From Kendra Little's Blog

I redid my static site’s contact form with a free option from my host, Netlify. Here’s why I changed my static site host and how I got a Netlify contact...

Computing in the Cloud (Azure, Google, AWS)

You Are Overspending on Cloud and SaaS: Here’s Why and What to Do

From Dataversity

The shift to public cloud, private cloud, and SaaS...

Conferences, Classes, Events, and Webinars

PostgreSQL 101: The journey towards PostgreSQL - tips and lessons from Grant Fritchey

Want to hear someone else’s experience of learning PostgreSQL from scratch? Then look no further. Grant Fritchey, Microsoft Data Platform MVP, started working with SQL Server in 1995 but more recently has needed to support and understand PostgreSQL. In this webinar, he will go on a deeper dive into the PostgreSQL database and will share top tips from his own learning journey. Join us on July 25th

DMO/SMO/Powershell

PowerShell: Playing with Background Jobs

From Sid 500 PoSh

In this blog post, I’d like to give you a few ex...

Data Mining / Data Analysis

What it takes to be a game changer in retail in these challenging times

From AllAnalytics

Amidst the ever-evolving retail industry landscape...

Fun With KQL – Union Modifiers

From Arcane Code

Fun With KQL - Union Modifiers

4 ways that data and AI can facilitate sustainability transformation

From AllAnalytics

In the first of this two-part blog series, we disc...

3 ways organizations can use SAS® and Snowflake to do more with their data

From AllAnalytics

With SAS® Viya® and Snowpark Container Services ...

Best Text Analysis Tools 2023

From Past News - RSS Feeds

Discover the best text analysis tools to help you ...

Compute the geometric median in SAS

From AllAnalytics

Given a set of N points in k-dimensional space, ca...

5 takeaways from being a judge at the SAS Hackathon

From AllAnalytics

I was recently asked to be on the jury for the As...

Eat the rainbow: Bring on the blue + purple

From AllAnalytics

By now, you know that each color of the rainbow �...

Database Design, Theory and Development

Three more chapters of my data architecture book are available!

From SQLServerCentral Blogs

As I have mentioned in a prior blog post, I have b...

RavenDB Docker image updates for the v6.0 release

From Ayende @ Rahien

We are going to be making some changes to our RavenDB 6.0 docker image, you can already access them using the nightly builds: docker pull ravendb/ravendb-nightly:6.0-ubuntu-latest The purpose of those changes...

DevOps and Continuous Delivery (CI/CD)

The Four Different Types of Flyway Files

From SQLServerCentral Blogs

This is documented, somewhat, but I wanted to put ...

How Infrastructure as Code Can Help Minimize Human Error

From Dark Reading: Dark Reading News Analysis

Infrastructure as code lets organizations manage c...

ETL/SSIS/Azure Data Factory/Biml

ADF Activity State Property Disables Pipeline Activities

From AndyLeonard.blog()

Part of one of my consulting gigs is helping a client lift and shift SQL Server Integration Services (SSIS) to Azure Data Factory (ADF). While developing some test pipelines...

Excel

Excel Data Forensics

From Schneier on Security

In this detailed article about academic plagiarism...

Hardware

Raspberry Pi E Ink Frames Keep Loved Ones Connected

From Tom's Hardware US

Olivier Simard-Hanley is using a couple of Raspber...

Arduino Offers Up Two New Uno Boards

From Tom's Hardware US

Arduino's latest boards retain the same Uno form f...

ChatGPT-Powered Clippy Comes to Modern Windows via FireCube

From Tom's Hardware US

Thanks to the power of OpenAI, Clippy will now be ...

Seagate IronWolf Pro 14TB HDD Review: The Warranty Advantage

From Tom's Hardware US

We review the 14TB Seagate IronWolf Pro, an HDD bu...

Iran Admits Its Quantum Computer Had Zero Quantum in It

From Tom's Hardware US

Three weeks after its "quantum computer turned US-...

Modders Equip Asus's ROG Ally with 4 TB M.2 2280 SSD

From AnAndTech

The Asus ROG Ally game console comes with a tiny M.2-2230 SSD featuring a 512 GB capacity, which can be a bit tight for modern games. But enthusiasts from...

Fixed Wireless Access: An Enterprise Broadband Alternative

From IT Pro - Microsoft Windows Information, Solutions, Tools

Depending on availability, fixed wireless access could deliver the bandwidth IT managers need to connect far-flung workers and remote sites.

Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science)

A Day in the Life of a Fabric Administrator: Balancing Governance and Collaboration

From Data – Marc

Frequently, I am approached by curious individuals...

SQL Server in Microsoft Fabric? Use CETaS to move data!

From Guy in a Cube

People have been asking "What about SQL Server?" w...

Oracle/PostgreSQL/MySQL/other RDBMS

A Guide to INSERT, UPDATE, and DELETE Statements in Oracle

In this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, UPDATE, and DELETE. These commands are used to insert new data into tables, update existing data, and delete data from tables, respectively.

Performance Tuning SQL Server

Battle of the Query Hints in Query Store

From Grant Fritchey

I recently presented a session on the Query Store ...

SQL Server 2022 – Cardinality Estimation (CE) Feedback for Performance

From Journey to SQL Authority with Pinal Dave

SQL Server 2022introduces an enhanced Cardinality ...

SQL SERVER 2022 – Persistence and Percentile Memory Grant Feedback

From Journey to SQL Authority with Pinal Dave

We will particularly focus on Persistence and Perc...

When do Statistics get updated?

From SQLServerCentral Blogs

Statistics objects are important for allowing the ...

SQL SERVER – Thread Pool Waits: Monitoring and Optimization

From Journey to SQL Authority with Pinal Dave

Thread pool waits management plays a vital role in maximizing the utilization of threads and ensuring the smooth execution of tasks. First appeared on SQL SERVER – Thread Pool Waits:...

How I Use sp_BlitzCache To Find Poor Performing SQL Server Queries To Tune

From Erik Darling Data

How I Use sp_BlitzCache To Find Poor Performing SQL Server Queries To Tune Going Further If this is the kind of SQL Server stuff you love learning about, you’ll...

PowerPivot/PowerQuery/PowerBI

Power BI Direct Lake – What is it and Why it is Important When Working With Fabric

From RADACAD

With the Microsoft Fabric announcement, There are ...

Can you use Power Query Dynamic M Parameters for multi-select?

From Guy in a Cube

Dynamic M parameters in Power Query isn't anything...

Create MEANINGFUL data labels with measures in Power BI

From Guy in a Cube

Tired of the usual text data labels that only have...

R Language

Repetition in R with rep()

From Curated SQL

Steven Sanderson shows off a function in R: As a p...

SQL

Generating sequential numbers in a distributed manner

From Ayende @ Rahien

On its face, we have a simple requirement: Genera...

How to Generate Package Private Code with jOOQ’s Code Generator

From Java, SQL and jOOQ.

Java’s package private visibility is an underrated feature. When you omit any visibility modifier in Java, then the default (for most objects) is package private, i.e. the object is...

SQL Server Security and Auditing

Implementing Access Controls using Microsoft Intune

From Petri IT Knowledgebase

Implementing identity and access management proces...

Security News and Issues

Twitter Celeb Account Hacker Heads to Jail for 5 Years

From Dark Reading: Dark Reading News Analysis

Extradited from Spain, PlugWalkJoe has been senten...

Typing Incriminating Evidence in the Memo Field

From Schneier on Security

Don’t do it: Recently, the manager of the Harvar...

Trans-Rights Hacktivists Steal City of Ft. Worth's Data

From Dark Reading: Dark Reading News Analysis

In a move to embarrass the city, hacking group kno...

US Patent Office Data Spill Exposes Trademark Applications

From Dark Reading: Dark Reading News Analysis

Misconfiguration exposed the physical addresses of...

3 Tips to Increase Hybrid and Multicloud Security

From Dark Reading: Dark Reading News Analysis

As cloud adoption grows, organizations need to ret...

Newbie Akira Ransomware Builds Momentum With Linux Shift

From Dark Reading: Dark Reading News Analysis

A new version of the double-extortion group's malw...

Hackers Claim $70 Million Ransomware Attack on TSMC, Hits Supplier Instead

From Tom's Hardware US

LockBit ransomware group demands $70 million for not disclosing allegedly sensitive TSMC data.

T-SQL and Query Languages

Using a Subquery in a SELECT statement

From Simple Talk

Did you know you can include a SELECT statement wi...

Video: Learning the T-SQL Syntax from the WHERE Clause

From 36 Chambers – The Legendary Journeys

THE VIDEO THE SYNOPSIS In this video, we will lear...

Tech News

SolarWinds Execs Targeted by SEC, CEO Vows To Fight

From IT Pro - Microsoft Windows Information, Solutions, Tools

CEO says SEC penalties related to the 2020 SolarWi...

Patches to the rescue

From Technology Review Feed - Tech Review Top Stories

Patches stuck to the skin can be an appealing alte...

Curiosity unbounded

From Technology Review Feed - Tech Review Top Stories

“It only takes a few hours on this campus to lea...

Welcome to the big blimp boom

From Technology Review Feed - Tech Review Top Stories

Floating is the new flying, at least according to ...

Why Cyber Funding Flows for Rural Water Systems

From Dark Reading: Dark Reading News Analysis

The $7.5 million in new funds from the Cybersecuri...

Raspberry Pi Radiation Monitor Goes Wireless With Pico W

From Tom's Hardware US

Sboger is using a Raspberry Pi Pico W to remotely ...

Is the ‘Internet Apocalypse’ Nigh? Breaking Down the Solar-Storm Science

From IT Pro - Microsoft Windows Information, Solutions, Tools

The idea of a widespread internet outage caused by a solar superstorm has captured imaginations and sparked misinformation, but concern isn't totally unfounded.

Lab-grown meat just reached a major milestone. Here’s what comes next. 

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. I briefly became a vegetarian around...

Chinese Spy Balloons Used American Tech, Report Says

From Tom's Hardware US

Preliminary investigations indicate that the Chine...

How gene-edited microbiomes could improve our health

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

Mend.io Launches Inaugural Open Source Reliability Leaderboard

From Dark Reading: Dark Reading News Analysis

New report offers valuable resource to help organi...

Testing Software

Why Test-Driven Development? (Part 1)

What is the main challenge we’re faced with when attempting to program computers? We are focused on writing the code that will behave as expected, and will be well structured. It turns out that holding both expectations in our head at the same time tends to produce a lot of confusion.

The Lighter Side

Raspberry Pi Pico Tamagotchi is The Perfect Virtual Pal

From Tom's Hardware US

Kevin McAleer has programmed a Tamagotchi-like pro...

Best Budget 3D Printers 2023: High-Quality Output on the Cheap

From Tom's Hardware US

You can find great FDM or Resin 3D Printers for un...

Voron 3D Printer Turns into Death Racing Robot

From Tom's Hardware US

Voron Design conquered the last “Death Racer” ...

Raspberry Pi Music Player Has All Your Greatest Hits

From Tom's Hardware US

Damaniel2 is using a Raspberry Pi to drive a custo...

Rooftops, Cafes and Zoom Rooms: Libraries Evolve to Serve Remote Workers

From IT Pro - Microsoft Windows Information, Solutions, Tools

Libraries have become a popular co-working space in the hybrid era.

Steam Deck Drops to All-Time Low Price for Top Two Models

From Tom's Hardware US

As part of the Steam Summer sale, Valve is selling...

Virtualization and Containers/Kubernetes

Containers vs. Virtual Machines (and Why It Matters for Data Center Professionals)

From Dataversity

In the world of IT not so very long ago, there was...

Docker Grows Software Development Capability with Mutagen Acquisition

From IT Pro - Microsoft Windows Information, Solutions, Tools

The Docker Desktop development tool is getting new features that will help bridge the gap between local and cloud development.

Kubernetes Services: What Are They and How to Protect Them

From Simple Talk

Kubernetes is a vast distributed platform that utilizes services to communicate internally and externally. Understanding different types of services and how they work is the beginning of knowing how...

 
RSS FeedTwitter
This email has been sent to newsletter@newslettercollector.com. 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

 

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