Creating a cluster with two nodes and a DR in Azure
Hi, I've read some blogs that in scenarios like this say that the recommendation is to change some timeout delay settings in the cluster to avoid false positives. Is there any configuration at the faiolver level or something else that I should worry…
SQL Server Always On Listener IP for Async Nodes??
Hello Team, How can I connect to an Async node using the Listener IP or Listener DNS in an Always on architecture (SQL Server 2016)?? Node1 - Primary Node2 - Secondary (Sync) Node3 - Secondary (Async) Our API's connect to Node1 and Node2 using…
![](https://techprofile.blob.core.windows.net/images/bE-Pq7f2lUSVB8C4wMY6Tw.png?8D8475)
Table replicate using SSIS
Hi, I'm trying to replicate few tables from a Source DB to destination DB. Both Databases are sql server databases. The only issue is that the source DB gets refreshed from production DB backup every night which breaks its replication to the…
Fixing an Instance of SQL Server 2014 - After Cleanning up some duplicte files.
Hi Folks, This is my first time using this forum. I regularly use the C# Forum. The question is: I recently used the CCleaner to sweep out some duplicate files in my notebook, and of course there was a lot of them of all kinds, included SQL Server, and…
![](https://techprofile.blob.core.windows.net/images/f5m7qESyDk63s64hMoxBlQ.png?8D8385)
What is the impact of setting ASPaaS\AlwaysUseGateway to false
HI all everybody, this is my first post and I'm here to ask for your help. This is the scenario on my Team: Client - Visual Studio 2019 connecting to AAS deploy using a server of IaaS as data source - issue And they sent me this image…
Query slow on SQL 2019
There is one specific query that has been executed on MS SQL 2014 for long time. The query is running on AG secondary RO replica. The query execution time on MSSQL 2014 is about 5 seconds. After migration to MSSQL 2019 the same query is running about 5…
![](https://techprofile.blob.core.windows.net/images/f5m7qESyDk63s64hMoxBlQ.png?8D8385)
Configure DB alert
Hello, I am configuring alert for Prodcution databases. I want to get any error message appearing in SQL Server Error log. But while defining the alert it is showing 2 options Error No Severity Pls suggest
Create user to access Alwayson readonly databaes
Hi Our env sql server version is 2016 SP2 EE edition always on enabled. So when we create database user for access the report though link server(expected to connect readonly replica databases ) from other remote node then I I noted permission(DB…
![](https://techprofile.blob.core.windows.net/images/PAU5iz5uskWOKend17-cGA.png?8D84F8)
How does one migrate system databases from an old SQL Server 2012 to a new SQL Server 2017?
How does one migrate system databases from an old SQL Server 2012 to a new SQL Server 2017?
SQL Server 2019 Retreive Data very slow
I have issue in retrieve the Data from Table it is taking at least 1 hr for showing normal Select top 100 * from Table_Name. In my table forty million one hundred twenty-three thousand one hundred six Rows(40123106) and Daily two million seven hundred…
SQL Server IO size
When sql server choose the I/O size for a single read/write (Data file random IO)? 8KB 64KB or even larger
TDE for SQL on Azure VM
I have 3 nodes of AAG replica , 2 on EastAsia and 1 on Southeast asia. and there are also 2 Azure Key vault , one in East Asia and One in South east asia . So I would like to know if there are option to sync the TDE key between two Key vaults, …
Need to change the AG Listner name on my Always On configuration during cut-over
I am migrating from an HA-Cluster to an Always on AG- Solutioning as the DR currently configured is DB mirroring that is deprecated and figuring with my vendor if the app is solution's to an AG move. From DB end i am planning to set dedicated new…
Login failed SSRS Domain\Machinename$
Hi! I have a 4-server Reporting Services 2019 farm, connected to a separate database server. The reporting services starts with a domain user and the reporting was properly configured. Currently the service works without problems and the reports are…
EXEC sp_updatestats.
Hi everyone! Why is the date not updated after executing the command 'EXEC sp_updatestats;' on the database? All help is welcome!
How to get data from a Web Service that has HTTPS, SOAP and WSDL with an SSIS Project
I need to get data from a Web Service that has HTTPS, SOAP and WSDL configuration. Tried following this tutorial https://www.mssqltips.com/sqlservertip/3272/example-using-web-services-with-sql-server-integration-services/ , but stopped on the…
Can't schedule an exam (link goes into a loop) 70-764
Hey , As soon as I want to schedule an exam (https://learn.microsoft.com/de-de/learn/certifications/exams/70-764), the following page got into a loop (reloaded every time, nothing happens.) I only see a white window. I am logged in with my MS account!…
What's wrong with my AlwaysOn?
Hi, I'm setting up an Always On following the whole procedure I found in other laboratories and I notice that mine happens differently. The database goes online only after I run it (Join to Availability Group ...) What can be wrong? I…
![](https://techprofile.blob.core.windows.net/images/4ScXrrpk-E2uuoOuZIV4UQ.png?8D80E5)
![](https://techprofile.blob.core.windows.net/images/bE-Pq7f2lUSVB8C4wMY6Tw.png?8D8475)
Page flag and Page flag description for sys.dm_db_page_info
anyone know the details about the following column ?
![](https://techprofile.blob.core.windows.net/images/ctcyKX4BnU-r4fRclNq-Ww.png?8D9AB2)
Advice to select the best employee business key
Hi, I'd like to get your opinion/advices to select the best employee business key in our system. I work on a multi-country, multi-company data warehouse project. You may find different HR systems all around the world, so I have to choose the appropriate…