[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 …
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 …
How Snowflake Creates and Detects Deadlocks
The post How Snowflake Creates and Detects Deadlocks appeared first on SQLServerCentral.
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 …
Getting Started with Ensemble AI Models in SQL Server
The post Getting Started with Ensemble AI Models in SQL Server appeared first on SQLServerCentral.
A First Look at PostgreSQL Monitoring in SQL Monitor
The post A First Look at PostgreSQL Monitoring in SQL Monitor appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? May/June 2023 Edition
Is your company hiring for a database position as of May/June 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must i …
Microsoft Fabric: Enabling your Free Trial
After the great announcement of Microsoft Fabric this week, it’s time to get a trial and start playing with this great product. Microsoft Fabric is a very broad product, so it requires some additional configuration for the start of a trial. Confi …