SQL WHERE LIKE to Construct More Efficient Queries
The post SQL WHERE LIKE to Construct More Efficient Queries appeared first on SQLServerCentral.
Flyway and SSDT: Merging Work from a Branch
The post Flyway and SSDT: Merging Work from a Branch appeared first on SQLServerCentral.
MuleSoft Integration with Azure Key Vault
Introduction MuleSoft Anypoint is a platform that helps to aggregate and integrate data from different source systems. As part of the data integration, the MuleSoft Anypoint Environment needs source system and target system login credentials stored in …
SQL Server 2022: Capture SQL Anti-Patterns
One of the new Extended Event available in SQL Server 2022 is the query_antipattern. This extended event allows to identify anti-patterns on the SQL queries sent to the server. An anti-pattern in this case is some code that the SQL Server …
Microsoft Fabrics Monitoring Tenant Settings
I am sure you have heard about all great announcements from last Microsoft Build. If it’s not the case, most of them are present in this Book of news 2023. One of the BIG announcements was the Preview of Microsoft Fabric. Microsoft Fabric is an end-to- …
Announcing 30-Day Free Trials for SQL ConstantCare®. Check Your SQL Servers Now.
You’re responsible for the health and performance of your company’s SQL Servers. You can’t afford most monitoring products because they’re priced per-server. Your manager just can’t justify spending tens of thousands of do …
[Video] Office Hours at Sea: SQL Server Q&A
En route from San Francisco to Juneau aboard the Ruby Princess, I stopped to hit a few of your questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:46 DBACAT: Hi Brent, what statistics impact occurs when a transa …
Database Sequence Objects with dbatools
dbatools bring us a set of useful commands to manage sequence objects in SQL Server. In this article, we are going through the five new commands. The commands are shown below. # get commands that have something to do with sequence within dbatools modul …
Last Call for My 21st Anniversary Sale
I’m still blown away that I have a blog post here that says, “Last updated: 21 years ago.” It’s pretty fun to see old pictures of me in the media library, too. When I first started blogging over two decades ago, it wasn’t …
How Snowflake Creates and Detects Deadlocks
The post How Snowflake Creates and Detects Deadlocks appeared first on SQLServerCentral.
Install SQL Server using Powershell Desired State Configuration (DSC)
Introduction As per Microsoft, Desired State Configuration (DSC) is a management platform in PowerShell that enables you to manage your IT and development infrastructure with configuration as code. DSC allows administrators to define the desired stat …
T-SQL Gap-Filling Challenge
A student of mine sent me a T-SQL challenge involving gap-filling of missing dates and balances. I found the challenge interesting and common enough and figured that my readers would probably find it interesting to work on as well. I’ll present t …
Flyway and SSDT: Extracting a DACPAC from a Flyway-managed Database
The post Flyway and SSDT: Extracting a DACPAC from a Flyway-managed Database appeared first on SQLServerCentral.
Unmasking SQL Server Dynamic Data Masking, Part 1, Intro
This is the beginning of a series on SQL Server Dynamic Data Masking. Dynamic Data Masking is a concept familiar with all developers and users of sensitive data. It is implemented in SQL Server with simplicity and elegance, requiring minimal changes to …
Breaking News: SQL Server 2022 Keeps Getting Worse.
<sigh> Okay, so, the last few Cumulative Updates have had known issues around broken remote queries using the generic ODBC connector and errors with contained availability groups, but I couldn’t really care less about those. If you use thos …