Question : We are getting ready to upgrade our SQL Server 2014 systems to SQL Server 2019. As part of […]
Tag: sql-server-2019
High availability primary does not automatically take secondary role when back online
Question : Setup: Basic high availability 2 replicas (1 primary, 1 secondary). DB01 => initial primary. DB02 => initial secondary […]
SQL Server 2019 – using MSA as a proxy account
Question : I’m thinking about using MSA (or gMSA) as proxies inside my SQL Server instances. This proxies would be […]
SQL Server – memory usage per database level and query level
Question : I am trying to find a query for two things: Get Current Memory Usage per database There are […]
Need to maintain execution plans on SQL Server Upgrade 2017 to 2019
Question : We are working on a performance issue and need to maintain the execution plans for troubleshooting. Need to […]
Turn off Error AND Usage Reporting SQL Server
Question : Unfortunately, SQL Server usage internet bandwidth and us activity in SQL, for R&D. You can find in your […]
Allow create table (dynamic name) and insert but nothing else
Question : I’m trying to find a way to allow an application to create tables and insert data into them […]
Replication problem in SQL Server 2019
Question : I have installed SQL Server 2019 RC1 and cannot create a snapshot. I keep getting the same message […]
Which authentication is better for MS-SQL Server 2019 : integrated security=SSPI vs uid=sa;pwd=xx | windows auth vs sa auth
Question : In my different web applications I use both ways, however, I would like to learn which method is […]
SQL Server 2019 – using MSA as a proxy account
Question : I’m thinking about using MSA (or gMSA) as proxies inside my SQL Server instances. This proxies would be […]