I was talking with a good friend that has an environment with terabytes of information and to create a homolog or dev environment to him is a pain. He comes to me with a solution : A PowerShell script that gets only the first 1000 lines of each table, creates the inserts and schema files
Today Steve has a few thoughts on his keynote topic today at the Redgate Summit.
The APPLY operator allows you to join a record set with a function, and apply the function to every qualifying row of the table (or view). The APPLY operator takes on two formats: CROSS APPLY, or OUTER APPLY. This article will explain the differences between these two formats, and show you examples of how each of these formats work.
In this tip, I will demonstrate how to migrate an existing database schema from SQL Server to PostgreSQL.
Learning about the Availability Group technology can be valuable for your career. Today Steve asks if you've deployed one, and if not, perhaps you want to try.
So, I messed up. In my calendar on Friday were the words, "Database Weekly." That's because I was supposed to put this editorial together and put out the Database Weekly. But I messed up. I was traveling on Friday. Not an excuse, but it's why I messed up. I'm sorry. However, what I did this […]
Power BI doesn't always detect relationships, and this article explains a bit about the problem.
An experienced DBA asks an AI to perform some common tasks. Read to see how it fairs and if an AI will impact DBA jobs.
As discussed in Part 1, by segregating our focus on developing code that behaves as expected from the focus on developing code that will be well structured, we have achieved the ability to eliminate wasteful and error prone manual chores.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Tlpn/wa0853.7373-7551 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah...
Tlp/WA.(+62 821°3111°179 Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar., Kec. Cilincing, Jkt...
BCA KCU MATRAMAN Telp/WA.0851°8812°0691 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers