Code Visibility: Browsing through Flyway Migration Files
The post Code Visibility: Browsing through Flyway Migration Files appeared first on SQLServerCentral.
Save 5% on SQLBits Registration with BRENT5.
Going to the SQLBits conference in March? Whether you’re registering in-person or attending virtually, save 5% on your ticket with discount code BRENT5. During the checkout process, look for this: And save yourself some quick bucks. The screen wi …
State of the Database Landscape Results 2024
Every year, Redgate surveys technologists to ask a big question (through lots of little questions, naturally.) This year’s question was about their current data platform configuration and usage. Just before it was released, I read the results, an …
Querying MongoDB Documents
MongoDB provides an efficient environment for storing document data at scale. However, most of your interactions with MongoDB will not be related to storing data but rather to querying data. The better you understand how to retrieve the data you need, …
Understanding the Importance of Data Lineage in Modern Data Management
The post Understanding the Importance of Data Lineage in Modern Data Management appeared first on SQLServerCentral.
Configuration of Azure SQL Database Auditing
Enhance the security, compliance, and monitoring capabilities of your database system with Azure SQL Database Auditing, a feature-rich tool. With the help of this function, which offers a thorough log of database operations, you can monitor changes, ac …
[Video] Office Hours: The Question is Not the Problem Edition
I answer your top-voted Azure SQL DB and SQL Server questions from https://pollgab.com/room/brento and lose my temper about what you’re doing. Here’s what we covered: 00:00 Start 00:40 Mattia: Has bulk logged recovery model ever got you acr …
The Importance of Retention
It is always an afterthought. New objects are created that start off small and current. New feature development takes over and the recently architected data structures become old news. Over time, data grows and suddenly a previously small table contain …
Buy on-demand access for Summit 2023 today
The post Buy on-demand access for Summit 2023 today appeared first on SQLServerCentral.
Leveraging AI Tools for SQL Queries
Some of the many benefits that AI offers include task automation, increased productivity, and increased efficiency. As an SQL Server developer, you may be writing your queries manually or using Query Editor tools available in SQL Server Management Stud …
Query Exercise: Find the Best Time for Maintenance
If we’ve gotta take the database down for maintenance – perhaps a version upgrade, perhaps upgrading our own code, maybe scaling up the hardware – when’s the best time to do it? For this week’s query exercise, the business …
Find Posts with the Wrong CommentCount: Answers & Discussion
Your Query Exercise was to find denormalization accuracy problems: checking the accuracy of a reporting column, Posts.CommentCount. There were two parts: finding the top 100 most problematic Posts with the biggest variances, and thinking about a long t …
We’re Starting to Automate Testing for the First Responder Kit.
Brent says: It’s really funny how the world works. I wrote what you see below in December 2023 and scheduled it for publication on January 16th (today), hoping to get help from the community to get this process started. On January 9, before the p …
Working on Technology Off the Clock
I have always spent time learning relational databases on my own, non-work time. As the years have passed, I have spent less of my own free time on technical learning and writing for many reasons, but still, I spend plenty of my own time learning about …
A Simple Method to Load Excel Data
Problem When we need to load data from Excel sheets to a SQL Server table, we typically use a data flow task. This task doesn’t have the flexibility that we often need and requires a strict orchestration of components to be able to work consistently. T …