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
 

Small Changes, Big Results

Last week I was able to attend THAT conference in Wisconsin Dells, Wisconsin. It was my first time in the great state of cheese, and the conference lived up to its reputation.

As a developer focused conference (rather than a database conference), I didn't have much expectation that my session about automating database changes would strike a chord with this crowd. Nonetheless, I spent the day and night before prepping my demos (again), re-ran the demo in the morning, and was ready to go at 1PM when the session started. Five minutes before the session started there were maybe 15 people in the room. Again, I wasn't expecting this topic to be a big draw and I was delighted to share what I had with whoever showed up.

One minute before the session started, there were about 35 people. To my surprise, by the time I was three minutes into the talk, the room was almost full. And not just full, the people present were engaged in the topic.

I'm happy with how the session went and I felt like I was able to give the attendees a vision and some hope for how they could start to make positive changes in their development processes to include database changes. My main challenge was to start small, choose one thing they could begin to change now, and slowly incorporate more processes as time goes by.

By the end of that first day and follow-up conversations during the "hallway track", I learned two things by attending THAT and presenting a database DevOps session.

First, somebody is always at the beginning of their journey. I've been working with database change management for years now. I've invested time and energy into understanding it because I knew there was a better way than what I did for the first half of my career. Many of the people that attended the session had questions about how to get started, how to overcome resistance, what their biggest challenges would be, and more. They're in the spot I was 10 years ago. Again, there's always someone around you at the beginning of their journey. Be kind and patient with them.

Second, big changes can't come all at once. Whether in life or business, change takes time. When I am able to realize that many of the people that I'm talking with are at the beginning of their journey, it's so much easier to make progress with small, concrete steps. Find the next, small change that's important to tackle and find progress. For DevOps, taking just one process and shifting it left in your workflow can have a significant impact in your ability to deliver customer value. In other areas of your life, it might be the spark to make the positive change that's been needed for a while.

What do you think? Ready to tackle something new and make that first, small change?

Ryan Booz

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 Essential Tools for Standardizing SQL Server Database Development

To achieve rapid delivery of database functionality, database development must both support craftsmanship and incorporate the ideas of standardization and automation that allow for 'mass production'. This article explains how to achieve this 'balance' using the specialist database development tools in SQL Toolbelt Essentials. These tools allow database experts to work quickly and accurately, with structured and repeatable processes to ensure all required checks and coding standards are applied before delivery.

Kubernetes Services: What Are They and How to Protect Them

In this article, you will learn what a Kubernetes service is and different types of Kubernetes services in detail. In addition, you will learn how to implement and protect Kubernetes services.

Beyond Personalization, Overcoming Bias in Recommender Systems

Recommender systems are ubiquitous in our everyday lives, providing personalized recommendations on social media, e-commerce platforms, and streaming services. These systems aim to simplify our decision-making by offering products, services, and content tailored to our interests and preferences. However, despite their impressive capabilities, recommender systems are not immune to flaws, and there are concerns about their fairness, particularly in their potential to affect marginalized groups.

Managing the challenge of migrating to the cloud

Migrating to the cloud has many advantages… until you’re the one tasked with making it happen. There are a lot of considerations, and the key is to break it down into four steps, not one. Find out how you can manage the challenge of migrating to the cloud.

Administration of SQL Server

How using a database monitoring tool helps DBAs create value for the whole organization

From Blog – Redgate Software

As the size and complexity of database estates increases, with more workloads and data being hosted on more platforms, both on-premises and in the cloud, so the appeal of...

A Little About Locking And Isolation Levels In SQL Server

From Erik Darling Data

A Little About Locking And Isolation Levels In SQL...

Running Queries Across Many SQL Server Databases

From Simple Talk

A challenge that reappears periodically in the wor...

Introducing sp_LogHunter: Quickly Search For Important Error Log Messages From SQL Server

From Erik Darling Data

Sick Of It All SQL Server has incredibly verbose error logs, and sifting through them for the highlight reel can be a pain. They’re often full of messages that...

Using Secrets in Docker Swarm for SQL Server

From DBA From The Cold

In a previous post I went through how to run SQL Server in Docker Swarm and in this post I want to continue delving into the Docker Swarm platform...

Azure SQL Managed Instance

What’s in a SQL Server Managed Instance?

From SQLStudies

My current position involves a lot of work with SQL Server Managed Instances so you’ll probably be hearing a lot ... Continue reading

Cloud - AWS

AWS to Start Charging for Public IPv4 Addresses in February 2024

From Petri IT Knowledgebase

Amazon Web Services (AWS) is planning to charge or...

Cloud - Azure

Fun With KQL Windowing Functions – Row_CumSum

From Arcane Code

Fun With KQL Windowing Functions - Row_CumSum

General Availability: Major version upgrade in Azure Database for PostgreSQL – Flexible Server

From Azure Updates

Eliminate the need to set up new servers and complete manual upgrades with in-place major version upgrade for Azure Database for PostgreSQL – Flexible Server.

Community Interests

Here’s how much heat your body can take

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 think I’m running out of...

T-SQL Tuesday #165: What Do All The Database Job Titles Actually Mean?

From SQLServerCentral Blogs

It’s an honor to host this month’s T-SQL Tuesday. In case you don’t know the rules already, here is a recap of them: Earlier this year, when I was... The...

Who’s Hiring in the Microsoft Data Platform Community? August 2023 Edition

From Brent Ozar Unlimited

Is your company hiring for a database position as of August 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up some...

Computing in the Cloud (Azure, Google, AWS)

Prime Day 2023 Powered by AWS – All the Numbers

From AWS News Blog

As part of my annual tradition to tell you about how AWS makes Prime Day possible, I am happy to be able to share some chart-topping metrics (check out...

Conferences, Classes, Events, and Webinars

Standard Sponsor Rates End August 30!

Secure your Sponsorship package before the rates go up. PASS Data Community Summit 2023 is where the database community meets every year to make life-long connections with peers, network with industry leaders, and advance their careers. With over 170 technical sessions, and a great line-up of sponsors, this is your time to secure your space before August 30 and get a preferred booth location.

Meet the Summit 2023 Sponsors

Preparations for Summit 2023 are fully underway! We thought what better way to introduce you to some of this year’s sponsors than sit down with them and find out what they have in store for you in November…

Data Visualisation

#SWDchallenge: what does your audience know?

From Storytelling with Data

It's no surprise that we have to know our audience in order to communicate effectively with our data. Unless we consider who they are, what they care about, and...

Machine Learning

Book Review: Prediction Machines

From Little Miss Data

A brief review of the book “Prediction Machines” by Ajay Agrawal, Joshua Gans and Avi Goldfarb

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

Fabric Data Wrangler: A Tool for Data Scientist

From RADACAD

Microsoft Fabric is an end-to-end Analytics Software-as-a-service offering. One of the editors and tools in Microsoft Fabric is Data Wrangler. Data Wrangler is a tool that provides the ability...

Performance Tuning SQL Server

Finding a Particular Query Plan in Query Store’s UI

From Curated SQL

Andrea Allred does a search: I have this problem where I want to see how a newly released query is performing, but it may not…

PowerPivot/PowerQuery/PowerBI

Decoding URIs in Power Query

From Curated SQL

Imke Feldmann decodes a URI: When working with cloud data sources you might encounter links where spaces show up as “%20” instead for example. This…

Comparing different school terms in Power BI

From Sqlbi

This article describes how to implement the comparison between school terms. The same technique can be applied to any arbitrary time periods that do not match regular months or...

Creating and Configuring a Power BI VNet Data Gateway

From SQLServerCentral Blogs

If you are using Power BI to connect to a PaaS resource on a virtual network in Azure (including private endpoints), you need a data gateway. While you can... The...

Tracking Power BI Import Throughput Variance

From Curated SQL

Chris Webb continues a series on using Log Analytics with Power BI: In the second post in this series I discussed a KQL query that can be…

Professional Development

Updated training list for a new DBA

From SQLServerCentral Blogs

Met an eager young volunteer at SQLSatBR over the weekend who inspired me to update a blog post that hadn't been refreshed in a few years. See the [UPDATED] Training... The...

Security News and Issues

Instagram Flags AI-Generated Content

From Dark Reading: Dark Reading News Analysis

Amid the national discussion about AI safety and non-human-originated content in the US, an app researcher spotted an effort by the social media app to flag AI posts for...

Why the California Delete Act Matters

From Dark Reading: Dark Reading News Analysis

Bill 362 is a perfect template for a nationwide win against data brokers and the privacy infringements they cause.

T-SQL and Query Languages

Data Wrangling in SQL Server for Cleaning, Transforming and Merging Data

From MSSQL Tips

Learn about data wrangling which can be time-consuming and complex, as it entails cleaning, transforming, and merging data from diverse sources.

Managing Query Store Hints

From Simple Talk

I wrote about query store hints before when they were first released in Azure SQL databases. However, there are some tricks related to managing query store hints we will...

SQL SERVER – The Flight Connection Puzzle

From Journey to SQL Authority with Pinal Dave

Today we are going to see another such puzzle - The Flight Connection Puzzle. This blog post is going to be really fun blog post. First appeared on SQL...

Tech News

These new tools could help protect our pictures from AI

From Technology Review Feed - Tech Review Top Stories

This story originally appeared in The Algorithm, our weekly newsletter on AI. To get stories like this in your inbox first, sign up here. Earlier this year, when I...

New Relic Acquired by Francisco Partners and TPG for $6.5B

From IT Pro - Microsoft Windows Information, Solutions, Tools

The observability and AIOps vendor is going private in a move that is part of a wider industry trend.

flyway

Infrequently Asked Questions About Flyway

From Product learning – Redgate Software

You can have Flyway up and running in minutes if you're a solo developer managing a single database. However, as you seek to 'scale up' Flyway to accommodate more...

 
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

 

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