Questions about always on’s data synchronization method
Hello I am curious about data synchronization of secondary in always on. Secondary confirmed that the redo thread reads the log cache or redo log file and synchronizes it to the data file and index file. I have doubts about the synchronization method…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Is there a 64 bit SSMS?
I‘ve already downloaded and installed SQL Server and SSMS on my computer and then I noticed that the SSMS running on my computer is a 32-bit program. I wonder if there a 64-bit SSMS, for I didn't find it anawhere, including the MicroSoft offical webpage.…
Bacpac file won't restore due to columnstore indexes on columns with specific data types.
Situation: We are using Serverless Azure SQL Databases as projects. Afterwards we delete these databases but before we do that we create backups of the databases. We are using SqlPackage.exe (version: 162.3.566) to create bacpac files. Restoring bacpac…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
MY SQL SERVER INSTALLATION ERROR
Hello everyone, I'm currently on Win11 Pro 23H2. I have installed and uninstall My SQL express couple times but having no luck in success installation. I didn't know the cause of this issue. Hope you guys could get me a possible fix Thank you and Best…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
How to talk to a SQL Database in Azure Gov from a Teams chat?
How alk to a SQL Database in Azure Gov from a Teams chat?
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Issue with SQL Server compatibility level 2022 and sp_executesql
One of our customers running SQL standard edition 2022 wanted to explore setting their database's compatibility level to 2022; but when they do this, at least one of our queries fails to return metadata. So they have to keep the compatibility level at…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
Cannot create and start Extended Events session in Azure SQL Managed Instance
Hello, I am trying to create an Extended Events session in Azure SQL Managed Instance. First I am trying to use SSMS GUI: Extended Events -> Sessions -> New Session... Add "error_reported" event, configure fields, select Data Storage as…
Database User dbo is orphaned- How to fix
Hello All All feedback is welcome ALTER USER [dbo] WITH LOGIN = [ww] GO Msg 15150, Level 16, State 1, Line 14 Cannot alter the user 'dbo'.
![](https://techprofile.blob.core.windows.net/images/n1e1T7Kg40CswnOHUBFn0A.png?8DCA5C)
VS2017 - SSIS Project
Hello Team, We are using VS2017 with SSDT installed (PFB the screenshot) We cannot find BI projects, unable to create SSIS projects. Please advice. Regards, Nagesh CL
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Transcript Not Sowing Exam Passed May 9, 2024
When logged in here I can see Exam titleExam numberPassed dateAdministering Microsoft Azure SQL SolutionsDP-300May 9, 2024Administering Microsoft Azure SQL SolutionsDP-300May 9, 2024But the anonymous validation does not show it …
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
SQL login issue
I'm trying to connect via local SSMS to the SQL Server on my Azure VM but it's failing saying the Server is not found or accessible. I can RDP into my VM without issue. Any ideas please?
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Additional Cost for Verify Function in SQL DB Backups to Blob Storage
I have a plan to move my SQL backups directly to Blob Storage and want to know what additional costs I may encounter when using the Verify function in my T-SQL query. I have read that Verify may increase costs tenfold, but I need more detail and…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
SQL Server Excel Import - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
I'm trying to do a simple Excel import into a local SQL Server instance installed on my machine (to do some analysis), I'm attempting to use the wizard through SSMS. This worked a few days ago and I imported a couple of thousand tabs into tables in SQL…
DPM 2022 installation: "SQL Server Management Tools not installed on this machine" error during install
Hy! I am deploying a DPM 2022 evironment. A have a separate SQL server and a DPM server. The SQL server has SSMS 19.0.1 (latest). I have installed this SSMS version on DPM server before install the DPM 2022. THE DPM installation show the following error…
Getting errors trying to import data from an SAP Cloud for Customer tenant using OData API in SSIS
Hello, So, I am attempting to import data from an SAP Cloud for Customer (C4C) System into an SQL Server Table using SSIS on Visual Studio 2022. I am using the Odata Source tool to connect to the system and the connection is successful. I can even see…
[Error] SQL Server closes automatically when trying to import files into a database
Hello! During the process of importing files into a database ("Tasks" > "Import flat file" > "Browse"), SQL closes automatically. It doesn't display any error message, it just closes. I've already uninstalled all the…
![](https://techprofile.blob.core.windows.net/images/WVkZDvDmq0-LYMPzRT8z1w.png?8DB1A0)
SQL Server Reporting Services installer not found
All links from all versions of SQL Server Reporting Services are returning the error $set_redirect('https://www.microsoft.com/library/errorpages/smarterror.aspx?correlationId=$(cvToken)') Internal Server Error. The server encountered an internal error…
Linked service authentication options for SQL Server are different amongst ADF within same subscription
In the same Azure subscription, I have several resource groups and each has data factories, however, the linked service authentication options are not the same among them, why? Here is an example: ADF1: SQL SERVER Linked service authentication…
![](https://techprofile.blob.core.windows.net/images/nU6nYqttiUqkasJ2PMYbbQ.png?8DB643)
Share mailbox not same as desktop version, why?
Hi, would like to use internet version for my emails but the shared mailbox favorites doesn't act like the desktop version. Desktop version: instant notifications Web version: just takes forever, the main inbox mailbox is ok, but takes forever to see it…
SQL Query Split
Hello, I have query with result like below pic, now i want to separate the value to 5 columns based on value of al, av, date, int and KB so the expected final result is 07/18/2024 17:47:35 , 1.415.174.0, 07/15/2024 00:00:00, False and 5040430. And also…
![](https://techprofile.blob.core.windows.net/images/zCxR1gzTUkeGX5-wM6PGoA.png?8DB52A)