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)
11,896 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)
275 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
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,563 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
4 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,008 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
3 reads
Today, I was called in the early hours because the transaction log of one of the SQL Server 2016 database...
2017-08-20
486 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
1 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,057 reads
By Steve Jones
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...
By alevyinroc
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...
By Brian Kelley
Tech conferences aren't just for networking and learning how to address a problem you're...
Comments posted to this topic are about the item Getting the Schema for Tables
Comments posted to this topic are about the item An Unexciting Exciting Release
Comments posted to this topic are about the item UNLOGGED Tables in PostgreSQL: When...
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers