| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| 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 |
Recorded on April 30, 2024 Inside the Next Era of ... |
Microsoft has released a new learning path yesterd... |
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. |
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 |
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. |
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. |
We all know that choosing the right basic SQL trai... |
The world of databases keeps growing, and the pres... |
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 Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning... |
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 -... |
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... |
Joe Sack is an old friend. (I've known him a long ... |
Maybe you already take advantage of the C# code an... |
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... |
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... |
In November 2023, we made two new Cohere models av... |
Ruby developers can now use AWS CodeArtifact to se... |
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... |
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) |
Forrester describes its Cloud Operating Model Fram... |
The Big 3 cloud providers start 2024 off strong, fueled by organizations' growing adoption of AI. |
Conferences, Classes, Events, and Webinars |
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. |
PowerShell offers extensive capabilities for manag... |
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 |
Before I started as the editor of Simple Talk, I w... |
In the rush to adopt AI across diverse sectors, t... |
In the expansive landscape of software development... |
Server migrations don’t happen overnight. They t... |
When looking to migrate, consolidate or deprovisio... |
Implement these five best practices if you want to become a truly data-driven business. |
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).... |
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) |
On Thursday, May 2, we have the Redgate Seminar in... |
This blog post is about Test Data Management – o... |
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... |
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... |
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 |
In the previous articles this series, I demonstrat... |
We are proud to announce the availability of our n... |
Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
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. |
Join us live as we answer your questions about Mic... |
After a lengthy period in Public Preview it seems,... |
Microsoft Fabric is the new data offering in Micro... |
The structure of storing data in OneLake for the L... |
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 I was working with the customer and was looking for some information in the Scanner API. For a... |
Oracle/PostgreSQL/MySQL/other RDBMS |
A lot of the world’s data lives in data lakes, h... |
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... |
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 |
This is already the 29th part of the plansplaining... |
PowerPivot/PowerQuery/PowerBI |
You probably know that semantic models in Power BI... |
Good UX design is critical in enabling stakeholder... |
A Quick Start Guide to Transitioning Existing Powe... |
Power Platform is part of the Microsoft universe o... |
Have you ever wanted to filter a visual by selecti... |
This looks at a scenario of a hierarchy but the ch... |
THE VIDEO THE SYNOPSIS In this video, I explain so... |
Structured query language (SQL) is now 50 years ol... |
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... |
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. |
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... |
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. |
Video by: Reid HavensLearn about three visual/repo... |
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. |
The data shared with other companies may have incl... |
Strong password habits are important year-round. World Password Day gives us an opportunity to brush up on our skills. |
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. |
When our universe was less than half as old as it ... |
This is today’s edition of The Download, our w... |
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... |
When I first saw Nick L's submission, I thought to... |
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 |
If migrating from VMware, consider doing more than a "mere migration." Instead, consider accomplishing your long-term objectives through an infrastructure redesign. |
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. |
|
|