| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| 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 |
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. |
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. |
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. |
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 |
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... |
A challenge that reappears periodically in the wor... |
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... |
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 |
My current position involves a lot of work with SQL Server Managed Instances so you’ll probably be hearing a lot ... Continue reading |
Amazon Web Services (AWS) is planning to charge or... |
Fun With KQL Windowing Functions - Row_CumSum |
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. |
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... |
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... |
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) |
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 |
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. |
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… |
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... |
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) |
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 |
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 |
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… |
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... |
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... |
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… |
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... |
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... |
Bill 362 is a perfect template for a nationwide win against data brokers and the privacy infringements they cause. |
T-SQL and Query Languages |
Learn about data wrangling which can be time-consuming and complex, as it entails cleaning, transforming, and merging data from diverse sources. |
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... |
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... |
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... |
The observability and AIOps vendor is going private in a move that is part of a wider industry trend. |
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... |
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. |
|
|