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
 

To Each Their Own

I recently came back from a trip to Las Vegas. I was privileged to be able to take part in the very first Fabric Community Conference. It was a great event, well attended. BUT... It was in Las Vegas.

I am not a fan.

First of all, Vegas is just far too noisy for me. I prefer to hear the world as opposed to machines and constantly blasting music. I'm not a show person. I, mostly, don't care for gambling (I do find craps fascinating, but I hate losing money). I feel like Vegas is overpriced too. Food's great though, but it costs a fortune. Overall, Vegas just isn't for me, even though I tend to go there at least once a year, sometimes more. It's the job.

On the other hand, I saw a lot of people, even families with kids (spring break week here in the States), having a blast. They love it. Maybe it's the shows. Maybe it is gambling. The games. The bars. Heck, the noise and lights. People love it.

And that's OK.

Just because I don't care for it doesn't mean I'm going to try to take it away from others. I am firmly against the idea of "wrong fun." Meaning, you can have fun in ways that I approve and enjoy. We really are individuals. I might enjoy sitting at a quiet bar, murmuring crowd in the background, while I sip a wine and read a book. Others would find that incredibly dull. Still others would find the bar distracting them from their reading. More others (I have a limitless supply) would object to the alcohol. All of that is OK, as long as we don't try to force anyone to "right fun" and away from "wrong fun."

In short, to each their own.

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

The Flyway Migrate Command Explained Simply

The 'Migrate' command automates the process of applying the database schema changes that are defined in migration scripts, while Flyway tracks the version of every copy of the database. This makes it much easier to maintain consistency across different database environments, and so facilitates continuous integration, continuous deployment, and database version control practices.

AI/Machine Learning/Cognitive Services

Your Cloud Strategy Is Now Your AI Strategy, Too

From IT Pro - Microsoft Windows Information, Solutions, Tools

Just because it's easy to get going with an AI clo...

Why the Rise of LLMs and GenAI Requires a New Approach to Data Storage

From Dataversity

The new wave of data-hungry machine learning (ML) ...

Copilot or autopilot? Unpopular opinions on copilot

From Data – Marc

Lately it’s copilot before and after in all Micr...

Why It’s Time to Rethink Generative AI in the Enterprise

From Dataversity

If you’ve been keeping an eye on the evolution of generative AI (GenAI) technology recently, you’re likely familiar with its core concepts: how GenAI models function, the art of...

Administration of SQL Server

Upgrade SQL Server on your workstation

Lately, I’ve seen many people struggling to upgrade their workstation to the latest version of SQL Server. The main source of the problem is usually the web installer/wrapper, which can fail for a variety of reasons that aren’t always made clear by the error messages. Today, I’m going to walk through one way you can approach a workstation upgrade and avoid these web installer issues altogether. I’ll focus on SQL Server 2022, but most of the information applies to any modern major version. Most of the information applies if you’re installing a brand-new instance, too.

When was my SQL Server Database Last Accessed?

From SQLServerCentral Blogs

Your boss walks up to you one morning and says, �...

SQL Server Diagnostic Information Queries for April 2024

From Glenn Berry

Introduction These are my SQL Server Diagnostic In...

A SQL script to automatically infer the data types of data that someone just dumped in your DB with no effort

From T-SQL Tech

Do you know the feeling when someone gives you a f...

SQL Server Filtered Index Essentials Guide

From MSSQL Tips

Learn about using filtered indexes for SQL Server ...

Dynamic Partitioning and a Simple Incremental Load

From Simple Talk

Let’s consider a simple statement for partitioning and save a table in a lakehouse: df.write.mode("overwrite").format("delta").partitionBy("Year","Month","Day").save("Tables/" + table_name) Let’s consider we load the data daily, with all the transactions from...

SQL Server

From MSSQL Tips

I am new to SQL Server and I have heard the term u...

Analysis Services / BI on the MS Stack

Using scatterplots to find details in reports

From Sqlbi

This article describes how you can use a scatterpl...

Azure SQL

Lesson Learned #480:Application-Level Locking in Azure SQL Database - Ensuring Exclusive Access

From Azure Database Support Blog

In certain circumstances, we need to apply product...

Public preview: Azure Backup supports long term retention for backup of Azure Database for MySQL– Flexible Server

From Azure Updates

Now you can retain backups for up to 10 years by d...

Lesson Learned #482: Identifying Potential Duplicate Statistics

From Azure Database Support Blog

Some time ago, we encountered a support case where...

What’s new in SQL Server and Azure SQL: 2024 so far | Data Exposed News Update

From Azure SQL

Read the 2024 recap of all the Azure SQL and SQL S...

Introduction to Optimized Locking in Azure SQL Database | Data Exposed: MVP Edition

From Azure SQL

When updating data in SQL Server, operators run th...

Backup and Recovery

World Backup Day: Expert Tips for Securing Critical Data

From IT Pro - Microsoft Windows Information, Solutions, Tools

On World Backup Day, explore our curated collectio...

Cloud - AWS

How I use Terraform to deploy my AWS amplify react js project

From SQLServerCentral Blogs

As a Software Engineer, I would like to deploy my ...

AWS Weekly Roundup — AWS Chips Taste Test, generative AI updates, Community Days, and more — April 1, 2024

From AWS News Blog

Today is April Fool’s Day. About 10 years ago, s...

Introducing AWS Deadline Cloud: Set up a cloud-based render farm in minutes

From AWS News Blog

Customers in industries such as architecture, engi...

Cloud - Azure

Public Preview: Resiliency Review on Azure Advisor

From Azure Updates

Improve your workload’s resiliency and optimize ...

Community Interests

#TSQL2sday Invitation: Has AI Helped You with Your SQL Server Job?

From Journey to SQL Authority with Pinal Dave

I'm thrilled to be your host for this month's epis...

Off to SQL Saturday Salt Lake City … on Friday

From SQLServerCentral Blogs

I’m off on Thursday for Salt Lake City and a SQL...

The London Redgate Summit Comes on Apr 17

From SQLServerCentral Blogs

I’m heading to the UK in a few weeks for the Lon...

DMO/SMO/Powershell

PowerShell GUI Examples: How To Add a Slider to Your Scripts

From IT Pro - Microsoft Windows Information, Solutions, Tools

Learn about the practical applications of sliders ...

Powershell Logging - Transcripts, they're GREEEEAT!

From SQL Rod

No breakfast cereals or comic tigers were harmed i...

PowerShell Error Handling: Learn These Key Techniques

From IT Pro - Microsoft Windows Information, Solutions, Tools

Join PowerShell expert Brien Posey as he explains ...

Data Mining / Data Analysis

Unlocking the Power of Data with Process Mining 

From Dataversity

Data is invaluable to an organization, but it can also represent a major stumbling block if an enterprise hasn’t optimized how data is used to support processes that run...

Data Privacy, Compliance, and Governance

What is data classification, and why is it important?

From SQLServerCentral Blogs

The benefits of data classification and the featur...

DevOps and Continuous Delivery (CI/CD)

DevOps and Data: Lessons Teams Can Learn About Managing Databases

From Dataversity

According to the Bureau of Labor Statistics, the o...

DevOps Performance Metrics Measure Speed, Stability but Overlook Human Element

From IT Pro - Microsoft Windows Information, Solutions, Tools

Organizations need to also acknowledge and support...

Video: Infrastructure as Code in GitHub

From 36 Chambers – The Legendary Journeys

THE VIDEO THE SYNOPSIS In this video, we look at h...

Transforming CI/CD Pipelines for AI-Assisted Coding: Strategies and Best Practices

From IT Pro - Microsoft Windows Information, Solutions, Tools

Here's how developers can enhance their CI/CD processes to leverage AI-powered coding tools more effectively.

DocumentDB/Key-Value/Graph/other NoSQL Databases

Building MongoDB Aggregations in MongoDB Compass

From Simple Talk

In the previous article in this series, I demonstr...

ETL/SSIS/Azure Data Factory/Biml

Managing Failed Pipeline Runs in Azure Data Factory

From MSSQL Tips

In this article, we look at how to set up differen...

Building a framework for orchestration in Azure Data Factory: A series

From MARTIN'S BLOG

Most people will describe a framework as the "buil...

ELT is Not a Typo

From Callihan Data

Chances are that if you’ve found your way to this blog, you’re somewhat familiar with ETL (Extract-Transform-Load). If you’ve ever been reading a blog post or article and saw...

Gaining Insights from Azure Data Factory Per Pipeline Billing Details

From MSSQL Tips

In this article, learn how to configure per pipeli...

Oracle/PostgreSQL/MySQL/other RDBMS

Ross Anderson

From Schneier on Security

Ross Anderson unexpectedly passed away Thursday ni...

Ahsan Hadi: PostgreSQL clustering solutions

From Planet Postgres

Introduction In my previous post A Brief History o...

David Wheeler: Talk: Postgres Yum Extensions

From Planet Postgres

Quit reminder that Devrim Gündüz of EnterpriseDB...

Sai Srirampur: Exploring versions of the Postgres logical replication protocol

From Planet Postgres

Introduction Logical Replication is one of the man...

Laurenz Albe: Syslog logging with journald in PostgreSQL

From Planet Postgres

© Caroline Albe 2024   Logging to sys...

Álvaro Hernández: Why Postgres Extensions should be packaged and distributed as OCI images

From Planet Postgres

There is an ongoing and engaging open discussion i...

muhammad ali: Pitfalls of using SELECT *

From Planet Postgres

Understand how SELECT * can be bad for database pe...

muhammad ali: PostgreSQL Roles and Privileges Simplified

From Planet Postgres

Learn to manage roles and privileges in PostgreSQL...

Performance Tuning SQL Server

Advanced Query Optimization Techniques in SQL Server – Video Course

From Journey to SQL Authority with Pinal Dave

Facing the challenge of optimizing complex SQL Ser...

Join me In Boston May 10 For A Full Day Of SQL Server Performance Tuning Training

From Erik Darling Data

Spring Training This May, I’ll be presenting my ...

Solving Parameter Sniffing with Multiple Execution Plans

From Andy Broadsword

Dynamic SQL has many uses and one of these can hel...

Why INSERT/EXEC Causes Weird Blocking In SQL Server

From Erik Darling Data

Why INSERT/EXEC Causes Weird Blocking In SQL Server Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering...

PowerPivot/PowerQuery/PowerBI

Revolutionizing Power BI: Introducing the Ultimate Formula Language

From SQLBI

Exciting news has just landed in the Power BI univ...

Power Query ODBC bug affecting date calculations

From SQLServerCentral Blogs

I was working on an imported Power BI semantic mod...

Wait!?! It’s the same data source! What’s going on???

From Guy in a Cube

Think you are using the same data source in Power ...

Boost DAX Performance in Power BI with Dual Mode

From Guy in a Cube

Don't ignore Dual Mode! If you are leveraging Dire...

Professional Development

How Do You Decide What to Learn?

From SQLServerCentral Blogs

There are so many choices and so little time. How ...

Building a Culture of Data

From Simple Talk

One of the major trends in enterprise computing, and really in enterprises themselves is an increased emphasis on data. My career has always revolved around data, but this is...

IT Professionals Prioritizing Work-Life Balance

From IT Pro - Microsoft Windows Information, Solutions, Tools

The 24/7 on-call nature of work for many IT professionals is leading to a shift in priorities in favor of a more sustainable work-life balance, a change accentuated by...

Security News and Issues

Feds to Microsoft: Clean Up Your Cloud Security Act Now

From IT Pro - Microsoft Windows Information, Solutions, Tools

A federal review board demanded that the tech giant prioritize its "inadequate" cloud security posture.

Surveillance by the New Microsoft Outlook App

From Schneier on Security

The ProtonMail people are accusing Microsoft’s new Outlook for Windows app of conducting extensive surveillance on its users. It shares data with advertisers, a lot of data: The window informs...

Maybe the Phone System Surveillance Vulnerabilities Will Be Fixed

From Schneier on Security

It seems that the FCC might be fixing the vulnerabilities in SS7 and the Diameter protocol: On March 27 the commission asked telecommunications providers to weigh in and detail what...

Software Development

Database Feature Toggles

In software development the concept of feature toggles are used to selectively turn on and off features. They are, for example, used to restrict some newly introduced features to a select group to see how these features work. While this concept has been long used for user-facing application code, it is also a practice that is useful for database code.

T-SQL and Query Languages

Find and Replace Text in Strings in T-SQL

String manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts to normalize databases, eventually we are faced with some sort of text-based data stored within a relational database and need to extract detailed information from it. Those of us who have tackled these challenges fully understand how code can quickly go from simple to absurdly complex, one function at a time. This article is focused on how to write, simplify, and get the most out of string data using the least amount of code to do so. It’s a reminder that code complexity is equivalent to technical debt and that in these scenarios, less is always more.

Tech News

The race to fix space-weather forecasting before next big solar storm hits

From Technology Review Feed - Tech Review Top Stories

Tzu-Wei Fang will always remember February 3, 2022...

How to reopen a nuclear power plant

From Technology Review Feed - Tech Review Top Stories

A shut-down nuclear power plant in Michigan could ...

The Download: Harvard’s geoengineering failure, and extending nuclear plants’ lifetimes

From Technology Review Feed - Tech Review Top Stories

This is today’s edition of The Download, our weekday newsletter that provides a daily dose of what’s going on in the world of technology. The hard lessons of Harvard’s failed geoengineering...

How to safely watch and photograph the total solar eclipse

From Technology Review Feed - Tech Review Top Stories

On April 8, the moon will pass directly between Earth and the sun, creating a total solar eclipse across much of the United States, Mexico, and Canada.  Although total...

Virtualization and Containers/Kubernetes

Comparing Container Orchestration Tools: Kubernetes, Docker Swarm, Apache Mesos

From IT Pro - Microsoft Windows Information, Solutions, Tools

When selecting a container orchestration tool, considerations such as project size, resource constraints, and team expertise should guide the decision.

Web

Making Accessibility Part of the Design Process – Part 3

In this last segment of the series, we’ll delve into the crucial elements of navigation and flow, exploring further the part of web accessibility that ensures users can effortlessly navigate online content. Additionally, we’ll shine a spotlight on the indispensable practice of regular testing, an ongoing commitment that goes beyond compliance, providing invaluable insights into real user experiences and fostering continuous improvement.

flyway

Using environments in Flyway commands

From Blog – Redgate Software

Deploying database code using pipelines in various...

 
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

 

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