Say we have a database that we want to migrate a copy of into Kubernetes for test/dev purposes, and we don’t want to backup/restore. How can it be done?...
2024-08-05 (first published: 2024-07-26)
339 reads
The final 2024 Redgate Summit in the US takes place in a few weeks, on Aug 21. Redgate Summit: The Database Landscape is coming to the Microsoft Office at...
2024-08-05
17 reads
We are trying to get apps and users off of using SQL accounts to access the Azure SQL DBs where I work. To make our lives easier, we are...
2024-08-05 (first published: 2024-07-25)
354 reads
bareleveling – v. trying to improve yourself without anyone else knowing about it, afraid that they’ll think it’s silly or grandiose or unnecessary, or that they’’ll end up calling...
2024-08-02
16 reads
One of the little details that I find matter more and more in enterprises is understanding why a tool behaves a certain way. OSS/home-grown ones often have limited docs,...
2024-08-02 (first published: 2024-07-19)
90 reads
I have heard about many interesting things about programming in Rust and I decided to use Rust for one of my applications. I enjoyed the programming experience in Rust...
2024-08-02 (first published: 2024-07-20)
184 reads
In the digital age, data is the new gold, but it's worthless if you can't understand and use it. That's where SQL (Structured Query Language) comes in. SQL is...
2024-08-02
31 reads
Have you heard the term "fediverse" and wondered what the heck it is? Doc Pop is here to explain. And no, it's not a cheese pun.
2024-08-02
24 reads
Are you struggling with a laggy redo and a build up in the redo queue on your readonly secondaries? Are you suffering with high PARALLEL_REDO_TRAN_TURN waits? Then this magic...
2024-07-31 (first published: 2024-07-17)
314 reads
Here's how we used WordPress Components and Tailwind CSS to build our local development app, Studio.
2024-07-31
19 reads
Setting page visibility and the active page are often overlooked last steps when publishing...
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item Using table variables in T-SQL
I am trying to check out elastic query between two test instances we have...
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers