Goals for 2024
Way back in 2019 I set some goals…. well I wrote some goals and posted them here 2019 seems a lifetime ago…..that was the year I travelled 200,000 air...
2024-03-20
47 reads
DevOps: It’s About the Team, Not Just the Tech
In November 2023 I did a session at PASS Summit and one of my sessions was voted https://passdatacommunitysummit.com/about/news/have-you-watched-some-of-the-most-popular-sessions-from-summit-2023/ That session was called DevOps is about Growing People rather than...
2024-03-27 (first published: 2024-03-20)
204 reads
What Does Redgate Test Data Manager Do?
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM), which was a new product for us. You can watch the video linked above to...
2024-03-27 (first published: 2024-03-18)
148 reads
Extracting PostgreSQL database metadata for presentation in Excel format
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks for more than half of my life. I believe it's the most widely used spreadsheet...
2024-03-25 (first published: 2024-03-16)
269 reads
Change Notebook Spark Session Time-Out in Microsoft Fabric
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric and suddenly you have to leave your workstation for a while. Someone ran the doorbell...
2024-03-25 (first published: 2024-03-16)
135 reads
Friday Flyway Tips – Inserting Column in the Middle of a Table
I had a customer question whether Flyway Desktop (FWD) would cause problems if developers were adding columns into the middle of tables. It’s a valid concern, and this post...
2024-03-22 (first published: 2024-03-15)
434 reads
A New Word: Malotype
malotype– n. a certain person who embodies all the things you like the least about yourself – a seeming caricature of your worst tendencies – which leave you feeling...
2024-03-15
25 reads
#ThankfulThursday
Wednesday March 13th 2024 I had the honor of speaking at the Redgate Summit in Atlanta and got to meet a lot of new people and get to hang...
2024-03-20 (first published: 2024-03-15)
142 reads
How to Retrieve all the Spark Session Configuration Variables in Microsoft Fabric
I was trying some stuff out in a notebook on top of a Microsoft Fabric Lakehouse. I was wondering what some of the default values are of the configuration...
2024-03-20 (first published: 2024-03-13)
184 reads
Atlanta for Two Days
Today is the first Redgate Summit of 2024 in Atlanta. I flew to town yesterday, There is a packed schedule, which is mostly repeated at our other events coming...
2024-03-13
18 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Alamat Kantor BCA KCU Suryopranoto Telp:08218154374
Hub Via Wa:628218154374 Alamat: Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Alamat BCA KCU Pangeran Jayakarta Telp:08218154374
Hub Via Wa:628218154374 Alamat: Jl. P Jayakarta Komp. No.127, RT.7/RW.7, Mangga Dua Sel., Kecamatan...
Alamat Kantor BCA KCU Mangga Dua Raya Telp:08218154374
Hub Via Wa:628218154374 Alamat: Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5, RT.11/RW.5,...
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers