Starting the Flyway PoC–Environment
I’ve had a goal to redo my demo environments and get them set up to work for a variety of customers in different places. I decided to do this...
2023-02-03 (first published: 2023-01-23)
114 reads
Blog Posts
Daily Coping 2 Feb 2023
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m struggling with some negative thoughts outside of work. This year as I coach older girls,...
2023-02-02
14 reads
Daily Coping 1 Feb 2023
Today’s coping tip is to decide to lift people up rather than put them down. This is something I am trying to practice more as a coach, pointing out...
2023-02-01
13 reads
Goal Progress for Jan 2023
The grade for January is a D. Details below, but just not making a lot of progress in these areas. I set goals at the beginning of the year,...
2023-02-01
13 reads
Introducing… Data On Rails!
Data On Rails is a Data On Wheels project designed to give a platform for up and coming data professionals in the data community. This project is the brainchild...
2023-02-01
25 reads
Recovering a TDE Database Without the Certificate
If you don’t have the backups of the certificate and private key from the old server, as well as the password used to encrypt the private key backup then...
2023-02-01
198 reads
What is calling my T-SQL scalar function (millions of times)?
In this post we look at a method using Extended Events (XE) to identify what parent objects are calling a given SQL function and how often. The background is...
2023-02-01 (first published: 2023-01-23)
467 reads
When to have multiple data lakes
A question I get asked frequently from customers when discussing Data lake architecture is “Should I use one data lake for all my data, or multiple lakes?”. Ideally, you...
2023-02-01 (first published: 2023-01-23)
479 reads
Daily Coping 31 Jan 2023
Today’s coping tip is to take a small step towards and important goal. One of my goals this year was to work on a way to score myself with...
2023-01-31
7 reads
Flyway Desktop Projects for My PoC
In a previous post, I set up the basic databases for the PoC project I’m working on. In this next post, we’ll get the Flyway Desktop projects set up...
2023-01-31 (first published: 2023-01-30)
31 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA Finance WTC Mangga Dua Telpon/WA:08218168291
BCA Finance WTC Mangga Dua Telpon/WA:08218168291.Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6,...
Kantor BCA Finance pusat Telpon/WA:08218168291
Kantor BCA Finance pusat Telpon/WA:08218168291.Jl. Metro Pondok Indah No.10 Lt 2, RT.3/RW.17, Pd. Pinang,...
BCA KCP Benhil Telpon/WA:08137887595
BCA KCP Benhil Telpon/WA:08137887595.Jl. Bendungan Hilir No. 44/I, Bend. Hilir, Kecamatan Tanah Abang, Kota...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers