[Video] Office Hours: Wrong Side of the Bed Edition
I woke up on the wrong side of the bed after a nap. How does that even happen?!? To take the edge off, I poured myself a gin & tonic and went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 …
Sending resource alerts on Managed Instance using db_mail
The post Sending resource alerts on Managed Instance using db_mail appeared first on SQLServerCentral.
Why Don't You Upgrade in Place?
Ask a senior-level SQL Server or Windows administrator about doing in-place upgrades and you’ll likely get a negative response ranging from « that’s a bad idea » to a puzzled look and a polite scoff. To someone with less experience or a higher-level view …
Interesting Aurora MySQL Feature: The Buffer Pool Survives Restarts
“Documentation! Hey, look at that.” Lemme start this off by saying this is probably irrelevant to you. (It’s irrelevant to me, too.) If you’re strapped for time, just skip past this blog post. This one’s for the curious fo …
Le DataOps pour Power BI et Microsoft Fabric
Petit article de retour sur un événement communautaire du Club Power BI Les communautés sont des groupes de personnes qui se retrouvent pour discuter et apprendre ensemble. Elles sont passionnées par un sujet et elles ont envie et besoin de partager de …
Using a SQL Tokenizer
Imagine this: you have several directories full of SQL script files, and you need to know where a certain table is used. You’d rather like the context too, so you can check the whole SQL Expression and work out why it is running so slowly. Maybe, …
Configuring an SSIS ForEach Loop for Multiple File Types
The Problem The SSIS Foreach Loop component has a limitation when it comes to selecting different sets of files from a folder, for example, it can be easily configured to loop through TXT files or PDF files or even all types of files by setting the Fil …
Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft Fabric
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
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
The post Running Azure CosmosDB queries from SQL Server using ODBC driver appeared first on SQLServerCentral.
MySQL Error Log Management in DevOps Operations
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
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
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
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
The post SQL GROUP BY Alias – An Oracle feature that would be great in SQL Server appeared first on SQLServerCentral.