153 questions
2 answers
SQL Server Buffer Pool Persistence Feature Request
SQL Server Buffer Pool Persistence Feature Request Could SQL Server implement a feature to export buffer pool data? This would eliminate the need for data warm-up after database restarts or initial startups. By directly importing previously saved buffer…
SQL Server Database Engine
asked 2025-05-03T14:12:23.3433333+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 12%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Steven Lam
20
Reputation points
commented 2025-05-04T02:44:56.13+00:00
Steven Lam
20
Reputation points
0 answers
MSSQL connection in Visual Studio Mac->(Socket Exception)
HI Community! I am facing the following problem and it is driving me crazy. I was creating a SQL Server in Azure, and I was trying to connect via Visual Studio Code, but using the exactly same configuration n Mac I am getting this error…
SQL Server Database Engine
153 questions
0 answers
I am not seeing any option to upgrade. I am trying to connect to my Azure SQL datadase from ssms
I am not seeing any option to upgrade. I am trying to connect to my Azure SQL datadase from ssms
SQL Server Database Engine
153 questions
asked 2025-05-03T19:29:31.69+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 83%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Moyan Martin
0
Reputation points
asked 2025-05-03T19:29:31.69+00:00
Moyan Martin
0
Reputation points
1 answer
Can I do an SQL Server Edition upgrade from Express to Developer on Azure VM?
I'm trying to upgrade an SQL Express database that comes with an application to SQL Developer edition. The machine is an Azure VM, not Azure SQL server instance. The application is Best Practice, a medical practice management software. The base…
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
564 questions
asked 2025-05-01T23:21:26.8166667+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 81%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Melchor Buenaflor Admin
0
Reputation points
commented 2025-05-03T15:39:16.3566667+00:00
Erland Sommarskog
120.3K
Reputation points MVP
1 answer
Unable to install SQL server. Error code : -2068119551
I keep fail to install the SQL server. I have already tried using Basic and Media which is ISO. When i used ISO, the error is -The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an…
SQL Server Database Engine
153 questions
asked 2025-05-02T17:11:52.83+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 81%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Blaze
0
Reputation points
answered 2025-05-03T15:34:43.4633333+00:00
Erland Sommarskog
120.3K
Reputation points MVP
2 answers
Msg 206, Level 16, State 2, Line 9 Operand type clash: int is incompatible with date (I want only year not full date then how I get)
CREATE TABLE employe ( ID INT, YEar DATE, FirstName VARCHAR(50), LastName VARCHAR(50), ); Insert into employe values (1,2020, 'John', 'Doe'), (2, 2021,'Jane', 'Smith'), (3, 2022,'Alice', 'Johnson')
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
15 questions
asked 2025-05-03T13:48:28.6233333+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 67%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
pallavi potnuru
0
Reputation points
answered 2025-05-03T15:33:40.6633333+00:00
Erland Sommarskog
120.3K
Reputation points MVP
2 answers
Error when installing SQL server 2022 - Log attached
Hello! Im trying to install microsoft SQL server but im stuck. Im getting this error page: I have tried most of the possible solutions from different forum pages, everything from deleting files and changing the registry. I have downloaded and run the…
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
12,074 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
asked 2023-05-12T09:32:44.8533333+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 57.00000000000001%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
Johan Karlsson
0
Reputation points
commented 2025-05-03T09:48:41.98+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 85%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
UNKNOW
0
Reputation points
1 answer
How to fix SSRS issues when running them on Windows 11?
SSRS reports that had been running on Windows 10 are not running on Windows 11. Kerberos authentication issues.
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,042 questions
asked 2025-05-02T21:27:00.1733333+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 8%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Sleight, Jeannette
0
Reputation points
commented 2025-05-02T22:10:23.88+00:00
Sleight, Jeannette
0
Reputation points
5 answers
One of the answers was accepted by the question author.
Analysis Services Processing Task: Error A connection cannot be made
Hi, We are executing an SSIS package.. it fails with the below error Analysis Services Processing Task: Error A connection cannot be made. Ensure that the server is running. We have a separate SSAS instance on this server which is up and running.…
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,339 questions
asked 2024-09-03T04:30:09.63+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 21%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
Bilal H. Bhatt
136
Reputation points
commented 2025-05-02T21:54:39.98+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 17%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Gary Melhaff - US
6
Reputation points
1 answer
Polybase accessing s3 storage error - Content of the directory cannot be listed
I have the following script for accessing on-prem S3-compatible storage. CREATE DATABASE SCOPED CREDENTIAL s3 WITH IDENTITY = 'S3 Access Key', SECRET = '****:****' ; END GO CREATE EXTERNAL DATA SOURCE ds_s3 WITH ( LOCATION =…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
1 answer
Problem upgrading encryption for multidimensional analysis services database in SQL 2022
I am migrating 2 analysis services databases that are in multidimensional mode from a 2017 instance to a 2022 instance that has had the CU1 update applied. I need to upgrade the encryption on these DBs so i can amend the connection string. This article…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,339 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,339 questions
asked 2023-08-09T11:11:35.6666667+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 36%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Jim Dale
15
Reputation points
commented 2025-05-02T16:09:13.2066667+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 28.999999999999996%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
Céline Rodríguez
16
Reputation points
1 answer
Problem upgrading encryption for multidimensional analysis services database in SQL 2022
I am migrating 2 analysis services databases that are in multidimensional mode from a 2017 instance to a 2022 instance that has had the CU1 update applied. I need to upgrade the encryption on these DBs so i can amend the connection string. This article…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,339 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,339 questions
asked 2023-08-09T11:11:35.6666667+00:00
Jim Dale
15
Reputation points
commented 2025-05-02T16:09:13.2066667+00:00
Céline Rodríguez
16
Reputation points
1 answer
How to fix SQL Server Setup has encountered the following error: Failed to retrieve data for this request..
I'm trying to patch SQL Server 2019 in a clustered environment. The setup is failing with this error: Setup has encountered the following error: Failed to retrieve data for Summary.txtthis request..Detail.txt
SQL Server Database Engine
153 questions
asked 2025-05-02T08:55:59.86+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 33%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Talent Mabuto
0
Reputation points
answered 2025-05-02T10:01:10.67+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 28.999999999999996%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Alban Berisha
80
Reputation points
2 answers
One of the answers was accepted by the question author.
Why TUF file is required in Log shipping when uncommitted transactions are already in memory?
I know that while restoring the log backup, un-committed transactions will be recorded to the undo file and only committed transactions will be written to disk there by making users to read the database. When we restore next Tlog backup SQL server will…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
asked 2023-04-10T14:18:55.13+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 11%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chirag Sachdeva
281
Reputation points
commented 2025-05-02T07:35:20.0533333+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 60%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY3%3C/text%3E%3C/svg%3E)
YaragoppaSunil-3326
0
Reputation points
1 answer
Issue to restore the schema
Dear all, How to resolve it below? Exclusive access could not be obtained because the database is in use. I ran the following USE db_to_restore go ALTER DATABASE db_to_restore SET SINGLE_USER WITH ROLLBACK IMMEDIATE go but it…
SQL Server Database Engine
153 questions
asked 2025-04-25T03:14:41.97+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 43%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Peter_1985
2,731
Reputation points
edited a comment 2025-05-02T06:48:40.9333333+00:00
Peter_1985
2,731
Reputation points
1 answer
I need to find a missing report
I'm searching for a report for one of our specialists on 04/07/25 who is no longer with TD as of this month. However the specialist name is no longer listed under the team manager for TD bank. I've left a comment but I have no idea who it goes to our…
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,042 questions
asked 2025-04-29T12:38:40.2833333+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 22%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Gordon, Cliff (he/him/his)
0
Reputation points
commented 2025-05-02T05:52:30.48+00:00
Olaf Helper
46,636
Reputation points
1 answer
Third party backup tools for SQL server
Anyone please share a few names of good and faster backup tools for SQL server? Preferably a snapshot of physical file backup It is for stand-alone server and should support VM too.
SQL Server Database Engine
153 questions
asked 2025-04-24T18:18:03.1466667+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 9%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Asharaf Pattarathil
0
Reputation points
commented 2025-05-02T05:48:02.1333333+00:00
Olaf Helper
46,636
Reputation points
1 answer
Sql Server to Excel
Hi Trying to export data from sql server to a Table formated excel. But after the data insert the Format of excel not coming properly. I mean the odd and even rows with different color Thanks
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
177 questions
asked 2025-05-01T10:49:51.06+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SVA
116
Reputation points
answered 2025-05-02T05:44:35.3033333+00:00
Olaf Helper
46,636
Reputation points
1 answer
SQL Server Management Studio 18 - Maintenance Plan
I have setup SQL backups to run daily at midnight for 5 servers, all works fine except 1 server does not run/create backup files. No errors or logs just does not run and not sure why. Any suggestions? Thanks! David
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
177 questions
asked 2025-05-01T12:56:03.21+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 47%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Chun, David
0
Reputation points
answered 2025-05-02T05:42:54.2466667+00:00
Olaf Helper
46,636
Reputation points
0 answers
MDS migration - No data in the mdm view MasterDataServices
Hi , I migrated a model of Master Data Services using MDSModelDeploy.exe createpackage -package "C:\temp\pck.pkg" -model "Product" -service MDS1 -includedata -version VERSION_1 and MDSModelDeploy.exe deploynew -package…
SQL Server Database Engine
153 questions
asked 2025-05-01T09:43:27.76+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 66%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Maneesh Murali
0
Reputation points
edited the question 2025-05-01T10:15:07.23+00:00
![](https://learn.microsoft.com/data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
simo-k
7,885
Reputation points