Sites anglophones


 

Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft Fabric

Publié le 17 décembre 2023 sur simple-talk.com
 

I have published videos and articles before about Lakehouse maintenance. In this article I want to address a missing point for a lot of Fabric administrators: How to do maintenance on multiple lakehouses that are located in different workspaces. One of …

 

Searching an Encrypted Column

Publié le 15 décembre 2023 sur sqlservercentral.com
 

When encrypting a database column, equality searching can be preserved by using a deterministic encryption algorithm. A deterministic algorithm will always return the same encrypted value for a given value. For example, if a [Customer] table is defined …

Running Azure CosmosDB queries from SQL Server using ODBC driver

Publié le 15 décembre 2023 sur sqlservercentral.com
 

The post Running Azure CosmosDB queries from SQL Server using ODBC driver appeared first on SQLServerCentral.

 

MySQL Error Log Management in DevOps Operations

Publié le 14 décembre 2023 sur simple-talk.com
 

When it comes to the development and operations (DevOps), one thing stands out as a critical aspect and that is troubleshooting. The primary goal of a DevOps team is to ensure that the product experiences zero to no downtime because every moment is cru …

 

[Video] Office Hours: Sunshine Edition

Publié le 14 décembre 2023 sur brentozar.com
 

You know how this works: you posta the questions at https://pollgab.com/room/brento, and I giva the answers: Here’s what you asked in this episode: 00:00 Start 03:18 DBA in VA: I recently discovered the “force order” query hint. I …

 

Fabric Notebooks and Deployment Pipelines

Publié le 13 décembre 2023 sur simple-talk.com
 

On my article about Fabric source control extended features, I explained how Microsoft included the notebooks on the source control. In this way we can include notebooks on a Software Development Lifecycle (SDLC) for Power BI objects. In this way, the …

 

[Video] Office Hours: Really Good Questions Edition

Publié le 13 décembre 2023 sur brentozar.com
 

Y’all were on fire in this one! You posted great questions at https://pollgab.com/room/brento and I worked through ’em: Here’s what we covered: 00:00 Start 04:06 DislikeEntityFramework: In AWS RDS, we inherited a 9TB table with unique …

SQL GROUP BY Alias – An Oracle feature that would be great in SQL Server

Publié le 13 décembre 2023 sur sqlservercentral.com
 

The post SQL GROUP BY Alias – An Oracle feature that would be great in SQL Server appeared first on SQLServerCentral.

What Would You Ask Your Predecessor? Get Answers with ChatGPT.

Publié le 12 décembre 2023 sur brentozar.com
 

So many times in my career, I’ve come across a questionable query, table design, or server configuration decision, and I just wanted to reach out to The Last Person™ to find out what the hell they were thinking. Now, with ChatGPT, I can. Here …

 

Exploring PostgreSQL Indexes

Publié le 11 décembre 2023 sur simple-talk.com
 

In this blog, we continue our exploration on PostgreSQL indexes which we started here. In that article, we learned what an index is, and how exactly indexes can help with query execution. But there is much more to learn about indexes! In this blog, we …

 

What is subsetting, what are the advantages, and how does it make test data management easier?

Publié le 11 décembre 2023 sur sqlservercentral.com
 

The post What is subsetting, what are the advantages, and how does it make test data management easier? appeared first on SQLServerCentral.

Identify log write limits on Azure SQL Managed Instance using QPI library

Publié le 11 décembre 2023 sur sqlservercentral.com
 

The post Identify log write limits on Azure SQL Managed Instance using QPI library appeared first on SQLServerCentral.

SQL Window Functions Series: LAG() and LEAD()

Publié le 11 décembre 2023 sur sqlservercentral.com
 

In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. Whether you’re analyzing sales trends, monitoring server performance, or studying user engagement, there will inevitably come a time …

How using a database monitoring tool helps DBAs create value for the whole organization

Publié le 8 décembre 2023 sur sqlservercentral.com
 

The post How using a database monitoring tool helps DBAs create value for the whole organization appeared first on SQLServerCentral.

Window Function Basics – PARTITION BY

Publié le 8 décembre 2023 sur sqlservercentral.com
 

One of the things that I’ve done over the last year to improve my T-SQL skills is learn to work with the various window functions that exist in the language. These were added in 2012 and there have been a number of improvements across the last decade. …


Pages :