Server Dashboards in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the server and database dashboards and how you can custom …
Adding a new AI usage policy to Simple-Talk
I used to think plagiarism was my worst thing to deal with as an editor. That is only sort of true now. Now the biggest headache has become figuring out who has used AI to do their writing and to what extent. Often that is even less easy than it even s …
What PowerBI Questions Do You Have for Eugene Meidinger?
Eugene Meidinger, aka SQLGene.com, makes Power BI concepts easy and accessible. He’s got a free introduction to Power BI performance tuning here. People come to him with questions like: What kind of tools are there for performance tuning Power BI …
State of the Database Landscape 2024: Shifting skills to match constant demands
The post State of the Database Landscape 2024: Shifting skills to match constant demands appeared first on SQLServerCentral.
Django's ORM vs. Raw SQL: When to Use Which
When it comes to building websites, how you work with your database can make a huge difference in how well your site runs. That’s especially true if you’re using Django, a popular tool for making websites with Python. Django comes with something called …
Top-Down and Bottom-Up Approaches in Microsoft Fabric
Nikola Ilic, best known as Data Mozart, published a great article and video about how to make semantic model data available in Microsoft Fabric. This allows the data to be used in lakehouses or data warehouses. One major question that arises is, …
Query Exercise: Find Tagged Questions Faster.
For this week’s Query Exercise, we’re going to start with an existing query that has performance problems from time to time, depending on how it’s used. This query’s goal is to find the top-voted Stack Overflow questions for any …
Finding the Best Time for Maintenance: Answers & Discussion
Your Query Exercise was to find the best time to do database maintenance by querying the Users table, looking for a one-hour window with the lowest number of created users. We kept this one pretty simple by looking at the data in just one table, and we …
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 …