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 …
Unlock the Power of Google Cloud SQL: Setting Up SQL Server and PostgreSQL Instances
Introduction to Google Cloud SQL Google Cloud SQL is a powerful and easy-to-use managed database service that lets you run MySQL and PostgreSQL databases on the Google Cloud Platform. With Cloud SQL, you can focus on building your applications without …
Microsoft Build Announcements for Data Professionals
This week was Microsoft Build. After four years, it was back in person in Seattle and available online. I didn’t attend in person, but I did watch a number of sessions and also went through the Build 2023 Book of News. You can download the book if you …