Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
In this level we learn how to ensure our keys are backed up to the Azure Key Vault for safekeeping.
In this level we learn how to ensure our keys are backed up to the Azure Key Vault for safekeeping.
The magic way to get better performance from your system is to write better code from the start.
A SQL Server Agent job can start other jobs. Writing jobs this way makes it easy to compartmentalize jobs: start a “child” job only when the “parent” reaches a certain step. Finding these steps can be challenging. There is no field or property in sysjobs or its associated tables to help find child jobs.
A few countries are looking to reduce their reliance on US technology. While they might leave Windows, Steve thinks they will continue to run SQL Server.
Power BI DirectQuery can quietly overwhelm your SQL Server. Unlike Import mode, DirectQuery sends live T-SQL for every visual interaction, multiplying queries and placing heavy analytical load on the database. This article explains how to identify the worst offending DirectQuery queries, why the generated SQL is often inefficient, and what you can do from the database side, including indexing, Query Store, and reporting views, to improve performance. It also outlines practical changes on the Power BI side and when DirectQuery is simply the wrong architectural choice.
Pat Wright details how to plan cloud migration with minimal downtime. Learn key cutover strategies, testing methods, and critical questions to avoid data loss and system failure.
I’m sure I’m not alone when I say, sometimes I get sidetracked. In this particular instance, I hadn’t intended to start learning about User-Defined Types (UDT) in PostgreSQL – I just wanted to test a behavior that involved creating a UDT. But, once I started reading, I was hooked. I mean, four distinct UDTs with different behaviors? That’s pretty cool. Let’s get into it.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
BCA KCP Hayam Wuruk Telpon/wa:0813.7887.595.Jl. Hayam Wuruk No.54, Maphar, Kec. Taman Sari, Kota Jakarta...
Gedung Grand Indonesia Mall A, Lower Ground No. 20-21, Jl. M.H. Thamrin No.1, Daerah...
BCA KCP Mall Grand Indonesiab Telpon/wa:0813.7887.595.Gedung Grand Indonesia Mall A, Lower Ground No. 20-21,...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers