Cosmos DB is a powerful, fully-managed, globally distributed, and multi-model database service provided by Microsoft Azure. One of its key features is the ability to create and execute stored...
2023-01-23 (first published: 2023-01-13)
12,057 reads
Problem Recently, when I tried to install SQL Server 2017 (mssql-server package) in Ubuntu 18.04, I encountered the error below: The command that I used to install the mssql-server...
2019-06-06 (first published: 2019-05-20)
295 reads
Problem Today, I have a request to create a new database on two-node SQL Server 2016 failover cluster instance, which is in an active/passive configuration. I connected to the...
2019-05-28 (first published: 2019-05-14)
3,605 reads
Problem Recently, when I tried to install SQL Server 2017 (mssql-server package) in Ubuntu 18.04, I encountered the error below: The command that I used to install the mssql-server...
2019-05-20
4 reads
Problem Today, I have a request to create a new database on two-node SQL Server 2016 failover cluster instance, which is in an active/passive configuration. I connected to the...
2019-05-14
16 reads
To change the Integration Services Catalog (SSISDB) database Master Key encryption password, run the following Transact-SQL statement:
USE [SSISDB];
GO
OPEN MASTER KEY...
2017-09-19
2,055 reads
To change the Integration Services Catalog (SSISDB) database Master Key encryption password, run the following Transact-SQL statement: In the above Transact-SQL fragment, we first open the Integration Services Catalog...
2017-09-19
9 reads
Today, I was called in the early hours because the transaction log of one of the SQL Server 2016 database...
2017-08-20
496 reads
Today, I was called in the early hours because the transaction log of one of the SQL Server 2016 database was full. I logged onto the SQL server instance...
2017-08-20
17 reads
Commercial database systems like SQL server have many recovery mechanisms to restore data hardware or software failure. Checkpoints are part...
2015-01-26
15,079 reads
By Vinay Thakur
The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related...
My old Dell XPS that I used for personal stuff started to degrade; well,...
By Steve Jones
At the Redgate Summits this year, we’ve highlighted a few things in the Flyway...
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Comments posted to this topic are about the item Forward Deployed Engineers
Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL...
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers