Upgrade PostgreSQL 9.X to 12.X in Windows
Learn how you can upgrade a PostgreSQL server and ensure your databases follow to the new version.
2021-02-09
41,076 reads
Learn how you can upgrade a PostgreSQL server and ensure your databases follow to the new version.
2021-02-09
41,076 reads
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 […]
2020-10-01
12,205 reads
Learn how to get Windows Authentication working on an Ubuntu SQL Server on Linux instance.
2020-09-08
3,923 reads
In this article, we will review how to configure Always On Availability Groups in Ubuntu Server using the Pacemaker cluster. The following are the high-level steps to configure Always On Availability Groups (AOAG) with an Ubuntu server. Install SQL Server on Ubuntu 16.04 Install Pacemaker agents and configure the cluster Create Always On Availability Groups Create […]
2020-08-25
3,444 reads
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
By alevyinroc
It seems like no matter how long you work with a system beyond a...
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
I have an execute task(has server list from a table) pointing to foraeachloop foreachloop...
In the ss below you can see that I have a table (dbo.clan.spouses) with...
hi i imported a tabular model from production into vs 2022, changed the data...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers