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
 

Take Care

The world seems to be proceeding through some stuff at the moment. IT and our industry as a whole, equally seems to be going through some stuff. As such, allow this oldster to offer some advice: Take care of yourself.

I know, I'm the same, you may have responsibilities for others. You need to take care of family, whether it's aging family members (Hi!), or kids or grandkids. You're in a management role and have team members that you look after. So putting yourself first seems either wrong or impossible. In some circumstances, at some times, it may well be. However, if you're literally not there, due to sickness, injury, or worse, then you're not meeting those responsibilities anyway. So, you must take of yourself in order to be able to take care of others.

When I say to take care of yourself, I mean it on multiple levels too. First up, emotionally and mentally. All the stuff going on around is draining. I know I feel it. So, you need to find those things that get you recharged. It might be a good night's sleep. Maybe for you it's some time out on the water. Visiting a museum? Heck, seeing the therapist. Whatever it might be, make sure you carve out some time to get your brain reset.

Next, physically. I'm not great at it (oh, my wife can tell you), but I try to get in three workouts in a week. Plus, weekends I'm frequently doing physical labor. And again, I know because I've got (new) hard limits on what I can do, you may not be able to exercise or do hard labor. Do what you can. Physical fitness and exercise has been proven, time and again, in replicated studies, that it not only improves your physical well-being, but positively impacts your mental and emotional wellness. See point one. Again, carve some time out for whatever physical exercise you can do.

Finally, safety. Stuff is happening around us. Personally, I'd suggest taking a self-defense class or three if you don't already study it. No, I don't mean "I know Kung Fu" classes. Find classes in your area that teach situational awareness, things like that. None of us is John McClain. We're not going to karate chop our way to freedom. No, in terms of safety I'm talking about the biggest self-defense technique there is: don't be there. Avoid the situation entirely. When you hear the chants coming down the street, head the other way, even if it's going to make you late to work. Keep your head on a swivel. Know your surroundings and respond accordingly. Learn to recognize escalating violence, both in groups and individually. Learn to deescalate, or better still, just walk (or run) away. Keep yourself safe.

Yeah, I know. Kind of a depressing topic. Still, it's something to think about. Don't obsess over it, but have it in mind. In order to take care of others, you must take care of yourself. Neither of these is mutually exclusive in the long run. Please, take care.

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

Roundtables: Inside the Next Era of AI and Hardware

From Technology Review Feed - Tech Review Top Stories

Recorded on April 30, 2024 Inside the Next Era of ...

New Learning Path: AI Apps with Azure Database for PostgreSQL

From 36 Chambers – The Legendary Journeys

Microsoft has released a new learning path yesterd...

Optimizing Investments in Copilot for Microsoft 365: How To Get Started

From IT Pro - Microsoft Windows Information, Solutions, Tools

Organizations should not only invest in AI technology like Copilot Microsoft 365 but also prioritize education, continuous training, and analytics to ensure successful implementation and maximize ROI.

Now Is the Time for Executives to Deploy Ethical Rules Around AI

From Dataversity

For better or worse, AI is causing disruption in almost every field imaginable. Corporations around the world are embracing its possibilities to make work more efficient. The success of...

Administration of SQL Server

Snake draft sorting in SQL Server, part 2

In my previous post, I showed how to borrow a snake draft concept from fantasy football, or a packing technique from the shipping industry, to distribute different portions of a workload to run in parallel. In the previous example, we determined a distribution order for databases based on size – though you can rank by literally any attribute (or combination of attributes). Once we’ve determined how to build out this order, we may want to store that data somewhere because, sometimes, the source of that data is not directly accessible.

Snake draft sorting in SQL Server, part 1

I recently had a restore job where I needed to split the work up into multiple parallel processes (which I’ll refer to here as “threads”). I wanted to balance the work so that the duration was something significantly less than the sum of the restore times. Imagine a job that loops through and restores each database in sequence.

6 Best SQL Training Courses for Beginners (2024 Updated)

From SQLServerCentral Blogs

We all know that choosing the right basic SQL trai...

Will AI Replace SQL Developers? The Answer Might Surprise You!

From SQLServerCentral Blogs

The world of databases keeps growing, and the pres...

SQL Server Management Studio issues with Central Management Servers in v20.1

From The Bit Bucket

I've recently been doing work with a site that makes extensive use of Central Management Servers. And that's an issue if you upgrade past v19.3 of SSMS. Central Management...

Why Read Committed Queries Can Still Return Bad Results In SQL Server

From Erik Darling Data

Why Read Committed Queries Can Still Return Bad Results In SQL Server Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning...

SMS: PRIMARY KEYS & INDEXES

From Database Debunkings

Note: I am working on entirely new papers (not re-writes) in the PRACTICAL DATABASE FOUNDATIONS series. Two were already published:THE FIRST NORMAL FORM - A DEFINITIVE GUIDEPRIMARY KEYS -...

SQL Server Diagnostic Information Queries for May 2024

From Glenn Berry

Introduction These are my SQL Server Diagnostic Information Queries for May 2024, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration...

Azure SQL

SQL Down Under show 90 with guest Joe Sack discussing Azure SQL Database and Copilot is now published!

From The Bit Bucket

Joe Sack is an old friend. (I've known him a long ...

Code Analyze your SQL scripts in Visual Studio and elsewhere | Data Exposed: MVP Edition

From Azure SQL

Maybe you already take advantage of the C# code an...

Check Azure SQL DB Space Used

From SQLServerCentral Blogs

A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some files to lower the bill. To check my progress I needed to... The...

Introducing Regular Expressions (Regex) support in Azure SQL Database | Data Exposed

From Azure SQL

In this episode of Data Exposed, we'll introduce the new Regular Expressions (Regex) feature in Azure SQL Database. Join us to discover the built-in T-SQL REGEX functions in Azure...

Cloud - AWS

Run scalable, enterprise-grade generative AI workloads with Cohere Command R & R+, now available in Amazon Bedrock

From AWS News Blog

In November 2023, we made two new Cohere models av...

Add your Ruby gems to AWS CodeArtifact

From AWS News Blog

Ruby developers can now use AWS CodeArtifact to se...

Stop the CNAME chain struggle: Simplified management with Route 53 Resolver DNS Firewall

From AWS News Blog

Updated 2 May 2024: I removed the reference to Route53 Alias that was incorrectly referred as a chain Starting today, you can configure your DNS Firewall to automatically trust...

Build RAG applications with MongoDB Atlas, now available in Knowledge Bases for Amazon Bedrock

From AWS News Blog

Foundational models (FMs) are trained on large volumes of data and use billions of parameters. However, in order to answer customers’ questions related to domain-specific private data, they need...

Computing in the Cloud (Azure, Google, AWS)

Can Your IT Operating Model Keep Up With Cloud?

From IT Pro - Microsoft Windows Information, Solutions, Tools

Forrester describes its Cloud Operating Model Fram...

AWS, Microsoft, Google Continue to Invest in Cloud as Demand Grows in AI Era

From IT Pro - Microsoft Windows Information, Solutions, Tools

The Big 3 cloud providers start 2024 off strong, fueled by organizations' growing adoption of AI.

Conferences, Classes, Events, and Webinars

Introducing the pre-con schedule for PASS Summit 2024

The first speakers and sessions have just been announced for PASS 2024! We’re delighted to share the pre-con schedule for Monday, November 4, and Tuesday, November 5, 2024. Check out the full pre-con line up and the incredible speakers taking part and secure your spot today.

DMO/SMO/Powershell

How To Use PowerShell To Edit the Windows Registry

From IT Pro - Microsoft Windows Information, Solutions, Tools

PowerShell offers extensive capabilities for manag...

Data Science

Granularity Is the True Data Advantage

From Dataversity

Commerce today runs on data – guiding product development, improving operational efficiency, and personalizing the customer experience. However, many organizations fall into the trap of thinking that more data...

Database Design, Theory and Development

Database technology learning resources

From Simple Talk

Before I started as the editor of Simple Talk, I w...

Data Labeling Challenges and Solutions

From Dataversity

In the rush to adopt AI across diverse sectors, t...

DBA and Developer: Allies or Adversaries?

From SQLServerCentral Blogs

In the expansive landscape of software development...

Start-DbaMigration for SQL Server Migrations

From Callihan Data

Server migrations don’t happen overnight. They t...

Identifying Object Dependencies

From Andy Broadsword

When looking to migrate, consolidate or deprovisio...

What Being a Data-Driven Organization Really Means

From IT Pro - Microsoft Windows Information, Solutions, Tools

Implement these five best practices if you want to become a truly data-driven business.

Mind the Gap: The Data Chasm

From Dataversity

Welcome to the inaugural edition of Mind the Gap, a monthly column exploring practical approaches for improving data understanding and data utilization (and whatever else seems interesting enough to share)....

3rd Party Applications Have Issues

From DallasDBAs.com

As a SQL DBA, what do you do when a vendor application has performance problems that are code related? Server settings don’t generally seem to be an issue. Queries...

DevOps and Continuous Delivery (CI/CD)

The Redgate Seminar – Brisbane

From SQLServerCentral Blogs

On Thursday, May 2, we have the Redgate Seminar in...

Test Data Management – 2024 is your year to do it

From SQLServerCentral Blogs

This blog post is about Test Data Management – o...

Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger

From SQLServerCentral Blogs

I wrote a post recently about pruning branches in git. That’s part of the job, but the other part is removing local branches. This post looks at one way... The...

Develop and Test Your Rollback Plan

From SQLServerCentral Blogs

he rollback plan... what to do when things go wrong to get back to where you were before the deployment or implementation. I've seen too many cases where a... The...

Flyway’s Baseline Command Explained Simply

From Product learning – Redgate Software

The Baseline command is intended to make it easy to turn any preexisting production database into a Flyway database so that, subsequently, versioned migrations can then be applied to...

DocumentDB/Key-Value/Graph/other NoSQL Databases

Updating Documents in MongoDB

From Simple Talk

In the previous articles this series, I demonstrat...

MDX/DAX

The Optimizing DAX book is available

From SQLBI

We are proud to announce the availability of our n...

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

Fabric and Azure SQL in a few clicks: Mirroring a Database

Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for CosmoDB and Snowflake as well, but in this article, I will focus on Azure SQL. It is 100%, no, but it is definitely a feature that is really great even now. Before getting into a step-by-step of the process, let’s understand the basics.

Microsoft Fabric / Power BI Q&A w/ Kasper de Jonge (April 27, 2024) (Member Chat 2nd Half)

From Guy in a Cube

Join us live as we answer your questions about Mic...

Azure Elastic Jobs - The NonPlastic, Elastic Fantasic

From SQL Rod

After a lengthy period in Public Preview it seems,...

Microsoft Fabric Training and Tutorials

From SQLServerCentral Blogs

Microsoft Fabric is the new data offering in Micro...

Delta Lake Table Structure Demystified in Microsoft Fabric

From RADACAD

The structure of storing data in OneLake for the L...

Get row counts of all tables in a Microsoft Fabric warehouse

From SQLServerCentral Blogs

I loaded some built-in sample data from Wide World Importers into a Fabric warehouse. You get an option to load sample data when you create a new pipeline in... The...

All Fabric Workload Items are now available from the Scanner API

From FourMoo

All Fabric Workload Items are now available from the Scanner API I was working with the customer and was looking for some information in the Scanner API. For a...

Oracle/PostgreSQL/MySQL/other RDBMS

New Learning Path: AI Apps with Azure Database for PostgreSQL

 

Marco Slot: Crunchy Bridge for Analytics: Your Data Lake in PostgreSQL

From Planet Postgres

A lot of the world’s data lives in data lakes, h...

Robert Haas: Hacking on PostgreSQL is Really Hard

From Planet Postgres

Hacking on PostgreSQL is really hard. I think a lot of people would agree with this statement, not all for the same reasons. Some might point to the character...

David Z: Bringing IvorySQL to Neon Autoscaling Platform

From Planet Postgres

1. Overview In this blog post, we will guide you through the process of integrating IvorySQL, an open-source database built on PostgreSQL, into Neon Autoscaling Platform. Throughout this...

Performance Tuning SQL Server

Plansplaining part 29 – Introduction to cursor processing

From SQL Server Fast

This is already the 29th part of the plansplaining...

PowerPivot/PowerQuery/PowerBI

Power BI Semantic Model Memory Errors, Part 1: Model Size

From Chris Webb's BI Blog

You probably know that semantic models in Power BI...

Pretty Power BI – Adding GIFs

From Adatis

Good UX design is critical in enabling stakeholder...

Quick Guide to Transition Power BI Reports to Power BI Paginated Reports

From Purple Frog Systems

A Quick Start Guide to Transitioning Existing Powe...

Power Apps Connection References to SQL Server

From Deb the DBA

Power Platform is part of the Microsoft universe o...

Use a slicer to filter a visual based upon a measure in Power BI

From DCAC

Have you ever wanted to filter a visual by selecti...

Can’t create a Relationship? Time for a surrogate key in Power BI!

From Guy in a Cube

This looks at a scenario of a hierarchy but the ch...

Professional Development

Video: A Primer on Classification

From 36 Chambers – The Legendary Journeys

THE VIDEO THE SYNOPSIS In this video, I explain so...

SQL at 50: A Lesson in How to Stay Relevant Around Data

From Dataversity

Structured query language (SQL) is now 50 years ol...

Technology For Humanity

From Simple Talk

There was a time, when I was in a team that was designing an important IT system for a multinational bank, the testers arranged for perfectly normal office workers...

How to Manage a Rapidly Growing IT Team

From IT Pro - Microsoft Windows Information, Solutions, Tools

Maintaining IT staff performance and efficiency during rapid growth requires careful planning and structure. Here's how to expand your team without missing a beat.

SQLBits 2024: Learning about people at a technical event

From Purple Frog Systems

It has been a hot minute since I attended a SQLBits conference. It’s a techie event! I’m not technical. Project Managers must surely be classed as ‘persona non-grata’. Last...

R Language

R Programming Bug Exposes Orgs to Vast Supply Chain Risk

From IT Pro - Microsoft Windows Information, Solutions, Tools

The CVE-2024-27322 security vulnerability in R's deserialization process gives attackers a way to execute arbitrary code in target environments via specially crafted files.

Reporting Services

3 Report Configurations You Need to Review in Reader Mode!

From Havens Consulting

Video by: Reid HavensLearn about three visual/repo...

SQL

How to Use Any SQL Database With Rust

Rust is emerging as a frontrunner for ensuring memory safety without sacrificing performance. Its growing popularity isn’t solely based on the “fearless concurrency” mantra but also on its expanding ecosystem that fosters integration with various technologies. A domain Rust proves to be formidable is database interaction, and a pivotal player in this realm is the Diesel ORM. In this article, I will demonstrate how to get up and running with Rust, connecting to SQL databases using the Diesel ORM.

Security News and Issues

Kaiser Health System Sent Private Patient Data to Tech Giants

From IT Pro - Microsoft Windows Information, Solutions, Tools

The data shared with other companies may have incl...

World Password Day 2024: Best Practices for Secure Accounts

From IT Pro - Microsoft Windows Information, Solutions, Tools

Strong password habits are important year-round. World Password Day gives us an opportunity to brush up on our skills.

Rare Interviews with Enigma Cryptanalyst Marian Rejewski

From Schneier on Security

The Polish Embassy has posted a series of short interview segments with Marian Rejewski, the first person to crack the Enigma. Details from his biography.

Tech News

Inside the quest to map the universe with mysterious bursts of radio energy

From Technology Review Feed - Tech Review Top Stories

When our universe was less than half as old as it ...

The Download: mysterious radio energy from outer space, and banning TikTok

From Technology Review Feed - Tech Review Top Stories

This is today’s edition of The Download, our w...

Three takeaways about the current state of batteries

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. Batteries are on my mind this...

The Lighter Side

CodeSOD: Article tF7q2

From Daily WTF

When I first saw Nick L's submission, I thought to...

Error'd: Testing 1,2,3,4,5

From Daily WTF

An anonymous friend sent us our frist test in prod for this week. And then there will be more, and more, and more. "This came up in Kaspersky's Blog's RSS....

Virtualization and Containers/Kubernetes

How to Leverage Your VMware Migration to Redesign Your Infrastructure Architecture

From IT Pro - Microsoft Windows Information, Solutions, Tools

If migrating from VMware, consider doing more than a "mere migration." Instead, consider accomplishing your long-term objectives through an infrastructure redesign.

 
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

 

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