Sites anglophones


[Video] Office Hours at Sea: SQL Server Q&A

Publié le 31 mai 2023 sur brentozar.com
 

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

Publié le 31 mai 2023 sur sqlservercentral.com
 

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

Publié le 30 mai 2023 sur brentozar.com
 

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)

Publié le 29 mai 2023 sur sqlservercentral.com
 

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

Publié le 29 mai 2023 sur sqlservercentral.com
 

The post How Snowflake Creates and Detects Deadlocks appeared first on SQLServerCentral.

 

T-SQL Gap-Filling Challenge

Publié le 29 mai 2023 sur simple-talk.com
 

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

Publié le 29 mai 2023 sur sqlservercentral.com
 

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

Publié le 26 mai 2023 sur simple-talk.com
 

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.

Publié le 26 mai 2023 sur brentozar.com
 

<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

Publié le 26 mai 2023 sur sqlservercentral.com
 

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

Publié le 26 mai 2023 sur sqlservercentral.com
 

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

Publié le 26 mai 2023 sur sqlservercentral.com
 

The post Getting Started with Ensemble AI Models in SQL Server appeared first on SQLServerCentral.

A First Look at PostgreSQL Monitoring in SQL Monitor

Publié le 26 mai 2023 sur sqlservercentral.com
 

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

Publié le 25 mai 2023 sur brentozar.com
 

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

Publié le 24 mai 2023 sur simple-talk.com
 

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 …

 


Pages :