Microsoft recently held the 2020 Ignite conference. Just like in previous years, there were many announcements introducing new services and expanded capabilities of existing ones, especially in Azure. Ahead of Ignite, I was asked to take a test drive of one of the new features, Azure Resource Mover (in preview). It’s easy to move a […]
In this article we take a look at setting up and configuring MySQL to run on Azure along with some performance metrics for this database platform running on Azure.
In this article, we will review how to migrate the data from on-premises SQL Server to AWS RDS for SQL Server using transactional replication. There are several ways to migrate data from on-premises SQL Server to AWS RDS for SQL Server and transactional replication is one among them. Configuring transactional replication between the on-premises SQL Server […]
It's not the first task when I start a new job, but often as a DBA or developer, I usually ask about Disaster Recovery (DR) plans sometime within the first six months. If I'm a DBA, of course I need a plan. If I'm a developer, however, I still need to understand how this might […]
SQL Compare has a simple premise: it will compare two databases, a source, and a target, and generate a script that, when executed on the target, will make its schema the same as the source. Tony Davis explores all the ways this can be helpful during database development work.
Learn about how ownership chaining allows you to limit permissions on specific database objects yet give users access through other objects such as views and stored procedures.
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how ADS works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azure Data Studio Using Azure Data Studio with TFVC Using Azure Data Studio with […]
This tip provides a step by step process to create a cross tabulation report in SQL Server Reporting Services.
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...
BCA KCU MANGGA DUA RAYA Telpon/wa.085373737699.Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5,...
Telp/WA.0821°3111°179 Jl. Gunung Krakatau No.51 F-G, Glugur Darat II, Kec. Medan Tim., Kota Medan,...
Jl. Glugur Jl. Gatot Subroto No.11-12, Petisah Tengah, Kec. Medan Petisah, Kota Medan, Sumatera...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers