Released: Microsoft.Data.SqlClient 2.1.5
We have released an update to Microsoft.Data.SqlClient, version 2.1.5. The update addresses a few issues that are important […]
Archives du mois : août 2022
Into the unknown, sort of
Over half of my life ago, I was looking for a job. I had written a bunch […]
[Video] Fragmentation Explained in 20 Minutes at SQLBits
What does fragmentation mean? How does it happen? Can you fix it with fill factor? Should you rebuild […]
How to use fn_builtin_permissions SQL Server Security Function
The post How to use fn_builtin_permissions SQL Server Security Function appeared first on SQLServerCentral.
T-SQL Language Changes in SQL Server 2022
SQL Server 2022 is in preview in August 2022. I assume this version will be released later this […]
SQL ConstantCare® Population Report: Summer 2022
Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for […]
HOW IT WORKS: dm_os_ring_buffer vs XEvent *_ring_buffer_reported events
Many of the sys.dm_os_ring_buffer entries support matching XEvent (security_error, resource_monitor)_ring_buffer_reported events. For example: How It Works: What are […]
Drawing Entity Relationship Diagrams with Stable Diffusion
Documenting your database and code is such a pain in the rear. Wouldn’t it be awesome if artificial […]
The ultimate guide to web accessibility
The post The ultimate guide to web accessibility appeared first on SQLServerCentral.
Understanding the Metadata Function DATABASEPROPERTYEX()
SQL Server offers various metadata functions to return metadata information about databases and its objects. Today, I will […]
Getting Started with Python Pandas and Dataset Profiling
The post Getting Started with Python Pandas and Dataset Profiling appeared first on SQLServerCentral.
Database Deployment with Terraform – The Basics
This article is an introduction to automated database deployments with Terraform. Terraform is now one of the most […]
Performance Testing Databases with Flyway and PowerShell
The post Performance Testing Databases with Flyway and PowerShell appeared first on SQLServerCentral.
PSPO: How SQL Server 2022 Tries to Fix Parameter Sniffing
Parameter sniffing is a notorious problem for Microsoft SQL Server because it tries to reuse execution plans, which […]
Updates to the modern servicing model for SQL Server 2017 ...
We would like to announce the recent change made to the Announcing the Modern Servicing Model for SQL […]
Azure Data Studio August Release
Thank you to Erin Stellato (Program Manager, SQL Experiences) and Drew Skwiers-Koballa(Program Manager, SQL Experiences) for contributing to this blog. […]
What’s New in SQL Server 2022 Release Candidate 0: Undocumented ...
Microsoft has an official list of what’s new in 2022 overall, but here I’m specifically focusing on system […]
How to Install SQL Server 2022 Release Candidate 0
SQL Server 2014’s end of support date is coming in less than two years: July 9, 2024. I […]
SQL SERVER – Reasons – Not Able to Shrink the ...
Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they […]
Capturing SQL Server Deadlocks using Extended Events
The post Capturing SQL Server Deadlocks using Extended Events appeared first on SQLServerCentral.
Running Unit and Integration Tests during Flyway Migrations
The post Running Unit and Integration Tests during Flyway Migrations appeared first on SQLServerCentral.
PostgreSQL Triggers Part 1
Article Overview In this article we will cover the following topics: Database trigger and concept Types of triggers […]
SQL Server 2022 Release Candidate 0 is now available
Continuing with our release cadence, we’re excited to announce the release of SQL Server 2022 Release Candidate 0. Since […]
New granular permissions for SQL Server 2022 and Azure SQL ...
In the last 3 years, the SQL Security team has put more emphasis on enabling customers to use […]
Register today—Free Azure Data training at Data Platform Summit 2022
Data Platform Virtual Summit 2022 (DPS 2022) is just a few weeks away, running from September 1923. A […]
Database DevOps: Standardize, Automate, Monitor & Protect
The post Database DevOps: Standardize, Automate, Monitor & Protect appeared first on SQLServerCentral.
Tips to improve Power BI report appeal
Introduction This time we will provide some tips to improve the Power BI report appeal. Let’s face it. […]
Your Turn: I’m Not Answering These 13 Office Hours Questions
Normally, after I do a round of Office Hours of going through the questions that got posted at […]
INSERT EXEC statement cannot be nested, the Simple Solution
If you use the tSQLt unit testing framework for long enough, you will eventually run into the “An […]
Create a Table in Microsoft SQL Server
The post Create a Table in Microsoft SQL Server appeared first on SQLServerCentral.
5 things to look for in a 3rd party database ...
The post 5 things to look for in a 3rd party database monitoring tool appeared first on SQLServerCentral.
Query Store is enabled by default in SQL Server 2022
Part of the SQL Server 2022 blog series. Query Store is one of the most powerful database-scoped features […]
[Video] 300-Level Guide to Career Internals at SQLBits
You’re overwhelmed with choices: so many things you could learn, so many ways you could specialize in your […]
[Video] Office Hours at the End of the World
I hopped down to Cabo San Lucas and sat at the End of the World to answer the […]
Getting More Information From the String or Binary Data Truncated ...
One of the more annoying things that I have dealt with in SQL Server is inserting a large […]
Power BI Dynamic X and Y Axis Using Groupings in ...
The post Power BI Dynamic X and Y Axis Using Groupings in Field Parameters appeared first on SQLServerCentral.
Introduction to Testing a Flyway Development
The post Introduction to Testing a Flyway Development appeared first on SQLServerCentral.
How to use PowerShell to set secure SA passwords for ...
In this article, I will help you how to set secure SA passwords for bulk servers, sometimes, we […]
Azure Cosmos DB SQL Studio is a Hidden Gem!
This post was authored by Microsoft MVP and Azure Cosmos DB community champion Hasan Savran. You can […]
Download the Current Stack Overflow Database for Free (2022-06)
Stack Overflow, the place where most of your production code comes from, shares a version of their data in […]
How to Visualize Python Charts in Power BI
Introduction In this article, we will learn how to visualize data using Python in Power BI Desktop. Python […]
Re-baselining a Database using Flyway Desktop
The post Re-baselining a Database using Flyway Desktop appeared first on SQLServerCentral.
Released: Microsoft.Data.SqlClient 3.1.1
We have released an update to Microsoft.Data.SqlClient 3.1, version 3.1.1. The update addresses several issues that are important […]
Metrics that matter for IT organizations on an agile journey
The post Metrics that matter for IT organizations on an agile journey appeared first on SQLServerCentral.
Searching a Flyway Database
The post Searching a Flyway Database appeared first on SQLServerCentral.
Data Flow Formatters – Flatten, Parse and Stringify in Azure ...
Introduction I recently worked on a data pipeline project where I had to process JSON files and transform […]
Cumulative Update #17 for SQL Server 2019 RTM
The 17th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
Microsoft Purview access policies for SQL Server 2022
Part of the SQL Server 2022 blog series. Overview Microsoft Purview is a family of data governance, risk, […]
[Video] Office Hours: Speed Round Edition
Not all of the questions you post at https://pollgab.com/room/brento require long answers. Here’s a quick speed round: Here’s […]
SQL Backup using Azure File Share
SQL Backup is more than 12TiB, you can choose to backup using Azure File Share Standard file […]