Sites anglophones


Six Things to Monitor with PostgreSQL

Publié le 3 juillet 2023 sur sqlservercentral.com
 

The post Six Things to Monitor with PostgreSQL appeared first on SQLServerCentral.

Searching Flyway Migration Files using Grep and Regex

Publié le 30 juin 2023 sur sqlservercentral.com
 

The post Searching Flyway Migration Files using Grep and Regex appeared first on SQLServerCentral.

Unpivot Data Using Python

Publié le 30 juin 2023 sur sqlservercentral.com
 

Problem Statement In one of the Business Analytics Dashboards Projects, Sales data is received from different countries (100 +) around the globe. This data is consolidated and depicts trend analysis KPIs, such as MTD, YTD, and ITD. The data received is …

[Video] How to Use ChatGPT to Write WordPress Blog Posts

Publié le 29 juin 2023 sur brentozar.com
 

Today’s live stream was a little different: I demonstrated using the Aiomatic WordPress plugin, ChatGPT, and Azure Open AI to write blog posts. I showed the kinds of content it writes, the kinds of blog post content it doesn’t include, and …

[Video] Office Hours: As They Pour My Patio Concrete Edition

Publié le 28 juin 2023 sur brentozar.com
 

I can finally see the finish line in my backyard renovation, now that the concrete’s going in. I took a break from watching the construction folks to go through your highly upvoted questions at https://pollgab.com/room/brento: Here’s what w …

How to Reduce the Need for Bookmarks Using Parameters in Power BI

Publié le 28 juin 2023 sur sqlservercentral.com
 

Introduction to the Problem When developing Power BI reports, it’s often necessary to slice and interpret datasets in different ways. Using a combination of multiple pages, overlaying visuals and toggling their visibility, setting navigation and action …

 

Unmasking SQL Server Dynamic Data Masking, Part 4, Unmasking Formatted and Unformatted Text

Publié le 27 juin 2023 sur simple-talk.com
 

This is part of a series on Dynamic Data Masking by Ben Johnson. For the rest of the series, click here Continuing from the previous entry in this series on security concerns with using Dynamic Data Masking, in this blog I want to close out that discus …

 

 

On the Road Again, Next Up Columbus

Publié le 27 juin 2023 sur simple-talk.com
 

January 18, 2020, was the last time I stood in front of a live group of people and spoke about anything. It was at the location where I did my first SQL Saturday presentation, back at the first SQL Saturday in Nashville. Speaking at the time was a norm …

 

How to Make Database Changes Without Breaking Everything

Publié le 27 juin 2023 sur brentozar.com
 

You’ve got an existing application with a database back end. You’re thinking about changing the database, and you don’t wanna break stuff. The most important thing to understand is difference between constructive and destructive chang …

 

Using a Subquery in a SELECT statement

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

This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 10 items in the series, click here. Did you know you can include a SELECT statement within another SELECT statement? When a SELECT statement is embedded within anothe …

 

[Video] Office Hours: Professional Development & Training Questions

Publié le 26 juin 2023 sur sqlservercentral.com
 

The post [Video] Office Hours: Professional Development & Training Questions appeared first on SQLServerCentral.

SQL Server Resumable Index Operations

Publié le 26 juin 2023 sur sqlservercentral.com
 

As the DBA, have you ever had to cancel an online rebuild or create index process on a very large table? Perhaps it didn’t finish during your maintenance window or consumed valuable resources, causing other queries to run slowly? It is a headache for a …

Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance

Publié le 26 juin 2023 sur sqlservercentral.com
 

The post Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance appeared first on SQLServerCentral.

Pipelining Configuration Information Securely to Flyway

Publié le 23 juin 2023 sur sqlservercentral.com
 

The post Pipelining Configuration Information Securely to Flyway appeared first on SQLServerCentral.

It’s Friday. I’m Not Answering These 14 Office Hours Questions.

Publié le 23 juin 2023 sur brentozar.com
 

Sometimes, I don’t care if questions get a lot of upvotes at https://pollgab.com/room/brento – I just don’t wanna answer ’em. They’re not necessarily bad questions, but I’m just not interested in them, or I’ve …


Pages :