Released: Microsoft.Data.SqlClient 5.1.5
We have released an update to Microsoft.Data.SqlClient, version 5.1.5. The update addresses several issues that are important to […]
Archives du mois : janvier 2024
Released: Microsoft.Data.SqlClient 5.2 Preview 5
Microsoft.Data.SqlClient 5.2 Preview 5 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider […]
Finding Tagged Questions Faster: Answers & Discussion
Your query exercise was to take this Stack Overflow query to find the top-voted questions for any given […]
Install SSMS using Powershell DSC
Introduction In the previous article, we have seen how to install the SQL Server database engine using Powershell […]
Gracefully Handle Errors using TRY CATCH Logic in SQL Server ...
The post Gracefully Handle Errors using TRY CATCH Logic in SQL Server Stored Procedures appeared first on SQLServerCentral.
Free Video Training: Estimation and Statistics by Dave Ballantyne
It’s hard to find good 400-500 level SQL Server training at any price, let alone free. Dave Ballantyne’s […]
Lancement de la chaine YouTube Data Chouette
Nous avons démarré une nouvelle chaîne YouTube pour les passionnés de données : https://www.youtube.com/@DataChouette Apprenez, explorez et […]
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 […]
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 […]
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 […]
Released: SCOM Management Packs for SQL Server, RS, AS (7.4.0.0)
Updates to SQL Server, SQL Server Dashboards, Reporting Services, and Analysis Services Management Packs are available (7.4.0.0). You […]
State of the Database Landscape 2024: Shifting skills to match ...
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 […]
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 […]
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 […]
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, […]
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 […]
State of the Database Landscape Results 2024
Every year, Redgate surveys technologists to ask a big question (through lots of little questions, naturally.) This […]
Querying MongoDB Documents
MongoDB provides an efficient environment for storing document data at scale. However, most of your interactions with […]
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 […]
[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 […]
The Importance of Retention
It is always an afterthought. New objects are created that start off small and current. New feature […]
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 […]
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 […]
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 […]
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 […]
Working on Technology Off the Clock
I have always spent time learning relational databases on my own, non-work time. As the years have […]
The Publisher failed to allocate a new set of identity ...
Problem: =========== Assume that you have tables with Identity columns declared as datatype INT and you are using […]
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 […]
[Video] Office Hours: Ask Me Anything About the Microsoft Data ...
Forgive the hoarse voice – I’m recovering from something COVID-ish. I went through your top-voted questions from https://pollgab.com/room/brento […]
Cumulative Update #11 for SQL Server 2022 RTM
The 11th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
Dimensional Modelling Case Study Part 1 – Age Group
Background Age plays an important role in medicine and medical research. A patient’s ages is commonly grouped into […]
Query Exercise: Find Posts with the Wrong CommentCount
For 2024, I’m trying something new: weekly homework challenges! For this week’s query challenge, we’re going to do […]
The Mastering Azure Data Studio Series
This is the index for a series of articles on Azure Data Studio (ADS), which will help you […]
Security Update for SQL Server 2022 RTM CU10
The Security Update for SQL Server 2022 RTM CU10 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2022 RTM
The Security Update for SQL Server 2022 RTM GDR is now available for download at the Microsoft Download […]
Semantic Model: More than a Simple Name Change
The animation on the top of this article tries to track the evolution of the enterprise architecture […]
Find Foreign Key Problems: Answers & Discussion
Your Query Exercise was to find foreign key problems: data that might stop us from successfully implementing foreign […]
Adding Cookie Consent to SQL Server Central
To comply with various regulatory requirements, we are adding a cookie consent form to the website. You will […]
Connecting SQL Server to SaaS applications with a Linked Server
The post Connecting SQL Server to SaaS applications with a Linked Server appeared first on SQLServerCentral.
An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page Allocation
When it comes to managing data in SQL Server, efficient page allocation is crucial for performance and storage […]
Released: Security updates for Microsoft.Data.SqlClient and System.Data.SqlClient
We have released security updates to supported versions of Microsoft.Data.SqlClient and System.Data.SqlClient. It is recommended to update references […]
Announcing the 2024 Data Professional Salary Survey Results.
This is the 8th year now that we’ve been running our annual Data Professional Salary Survey, and I […]
Optimized locking in Azure SQL Database
I don’t think I’ve ever had a great impression of Azure SQL Database as a place for […]
Machine learning K-Means applied to SQL Server data
Introduction In this article, we will use K-Means applied to SQL Server using Python. We will learn what […]
PowerShell Dynamic Parameters and SQL Server
Have you ever been in a situation that you want to call a cmdlet or a function […]
New Power BI Explore this Data Feature: An Alternative to ...
The post New Power BI Explore this Data Feature: An Alternative to Excel Pivot Tables appeared first on […]