An Azure relational database service.
Microsoft SQL Server Studio - Dark Mode
Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?
Azure SQL Database
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
Developer technologies | Visual Studio | Other
A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Unable to import data using MS OLE DB Provider for SQL Server
Using SSMS version 21, I am unable to import data from Excel to SQL server using the MS OLE DB Provider for SQL Server. It all goes fine to the point where you have to select Source Tables and Views. At this point it shows each worksheet three times in…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
how to fix this sqlserver 2019 installation detectPreviousRulesDownloadActivityFatalExceleption issues.
hey there , I'm writing a PowerShell script to execute the installer to install a sqlserver2019. I use the following command to run it. C:\SQL2019-SSEI-Expr.exe /Q /IACCEPTSQLSERVERLICENSETERMS /CONFIGURATIONFILE=C:\Configuration.ini config in…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
SQL server 2022 remote query timeout
Scenario: HP DL 380 G11 Server Windows Server 2025 Std DC SQL 2022 Std Workstations integrated into the domain with Windows 11 Pro. ODBC Version 18. On the workstations, runs an application that works with a database existing in the single SQL…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
How to delete subscriptions in PowerBI RS
Hello, I have a user which has lot of subscription in PowerBI Report server. I want to delete all the subscriptions associate with this user. Please let me know how can i do it? Thanks
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.
Upgraded VS to version 16.11.49 but now my original SSIS package is not appearing
Hi I updated VS to version 16.11.49 but now my original SSIS package is not available. I can create new SSIS package but I cannot access my original one. Below are some screenshots: Message I get when I open my original SSIS package: SSIS is…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Does Passive DR Licensing Still Apply Without Software Assurance (SA)?
In SQL server 2022, without Software Assurance (SA), does Passive DR node require license?
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.
Unable to install SQL Server 2022 Developer. Error code : 2068052294
Hello, I'm currently having issue with installing SQL Sever 2022 Developer. After processing, the installer showed the error with code 2068052294. I have tried to uninstall then reinstall with the Express Edition as well, and both didn't work. My laptop…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
How do fix Microsoft SQL server installation issue.
I’m facing an issue with SQL Server Agent and SQL Server services. Initially, both services were not starting. After multiple troubleshooting attempts, I managed to start them successfully. However, I am still unable to log in to the database using SSMS…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Is there any code difference between SQL Developer edition and Standard edition.
I am planning to migrate our non prod server from SQL Server 2019 standard edition to Developer edition. Our prod servers are all standalone servers. no encryption enabled for any of the databases. Now, I have below questions. Do we face any issues if…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Is there a hotfix for MS SQL Server 2022 on the latest patch level for SQLCLR hashing functions running slow since Cumulative .NET update was installed?
We have a number of Microsoft SQL servers in multiple environments that are having issues related to SQLCLR hashing performance that gets perceived as a user's login duration getting bumped from ~0.5sec to 10+sec with the .NET cumulative update…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
Hello everyone, I am currently preparing for the DP-900: Microsoft Azure Data Fundamentals exam and would like to get an expert's clarification on a specific question. The question is as follows: Which T-SQL statement or clause should be used to…
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
Best practice with sp_syspolicy_events_reader and ##MS_PolicyEventProcessingLogin##
The SQL Server logs on our primary replica (Microsoft SQL Server 2022 with Always On) has been filling up with this repeated message: The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'SQLAG1_msdb.dbo.syspolicy_event_queue'…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
My company already has access to a third-party SQL server that we currently access via ODBC. How much will it cost to use SMSS and SSRS to access the same server?
My company already has access to a third-party SQL server that we currently access via ODBC. How much will it cost to use SMSS and SSRS to access the same server?
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.
Data Synchronization - Syncing Two Databases in SQL Server
I'm needing to take one database and have it on two separate sql servers (in two different physical locations) and have it stay in sync. Is there a way that I can do this? I've looked into SQL Server Replication ie:…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
how to fix issue om.microsoft.sqlserver.jdbc.TDSChannel enableSSL WARNING: TDSChannel ( ConnectionID:1 TransactionID:0x0000000000000000) SSL handshake failed: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
Previously, I used JDK 1.6.0, but due to company requirements, I had to switch to OpenJDK 8u422 in Eclipse. After making the change, I received warnings, and some functions also showed warnings when running. There are a few functions that do not display…
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Unable to Pull Docker Image for SQL Server
docker pull mcr.microsoft.com/mssql/server Using default tag: latest Error response from daemon: failed to resolve reference "mcr.microsoft.com/mssql/server:latest": failed to do request: Head…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
SQL Server 2022 : Issue Restoring Database from 2014 Fails Without 'sysadmin' Role
We are attempting to restore a SQL Server 2014 database to SQL Server 2022. The process includes updating the database compatibility level from 120 (SQL 2014) to 160 (SQL 2022) after restoration. The issue we are encountering is: The restore and…
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
Using IsNull with different data types in SQL SERVER
Hi Team, I am working on on premises SQL Server. I have a requirement where I need to apply left outer join between 2 tables and use IsNull to show default data when columns are having null. Under ISNULL, if a column is null what shall i put for below…
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
Microsoft SQL Server Migration Assistant for Oracle Extension Pack missing SSMA for Oracle Data Migration Assistant.dll
We installed SSMA for Oracle 10.1 and were trying to use the client side migration but it is calling for too much ram, so we tried to use the server side migration. However that fails immediately without much info as to why. We installed the…
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.