17,931 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers One of the answers was accepted by the question author.

How to delete instance I created in Microsoft SQL Server

I installed an instance with analysis service and I want to undo this action.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
asked 2024-04-26T16:39:40.5433333+00:00
Omar Abdallah 0 Reputation points
accepted 2024-04-27T08:03:38.13+00:00
Omar Abdallah 0 Reputation points
0 answers

How to Calculate salary of employee

I am calculating salary using below query SELECT '29' as Total_Days,'28' as Present_Days, (14000 / 29) AS Per_Day, (14000 / 29) * 28 AS Total_Salary; But Total_Salary should be 14000 because Total_Days 29 and Present_Day 29

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
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.
2,800 questions
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.
42 questions
asked 2024-04-27T06:08:58.23+00:00
Analyst_SQL 3,531 Reputation points
0 answers

ADF pipeline with upsert throwing error "The data type text cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable"

ADF pipeline writing data from AZURE sql to on prem SQL Server with upsert operation. TEXT fields are part of target system, Even though TEXT fields are not selected in select query and are not mandatory fields still throwing error. I cannot change…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,545 questions
asked 2024-04-27T01:42:51.18+00:00
Shantanu Dekapurwar 0 Reputation points
1 answer

How to handle Azure SQL Virtual Machine discovery and cost together with Azure DevOps Server?

Hello, I am looking for answers for the scenario when we install Azure DevOps Server on Azure Virtual Machine. In this scenario we have VS Enterprise licenses so we have Azure DevOps Server license with SQL Standard license covered. However Azure came…

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,129 questions
Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,036 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.
12,715 questions
asked 2024-04-25T08:00:03.7266667+00:00
Milan 56 Reputation points
edited a comment 2024-04-27T00:51:44.3233333+00:00
kobulloc-MSFT 23,416 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

Inquiry on Course Material Usage in Online Series

I have found a YouTube series that explains the content of the course ‘20463-D: Implementing a Data Warehouse with Microsoft SQL Server’. It uses the course slides and code to assist with their explanations -we as viewers don't have an access for the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
asked 2024-04-25T11:46:38.41+00:00
Alaa Mh 20 Reputation points
commented 2024-04-26T23:30:06.91+00:00
Alaa Mh 20 Reputation points
4 answers One of the answers was accepted by the question author.

need help downloading sql server on my ,mac,

Hi everyone im trying ways to download the sql server and cant do it, need help downloading sql server on my ,mac, provide a info and download link if possible

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
asked 2024-04-26T21:28:59.2166667+00:00
andy 0 Reputation points
accepted 2024-04-26T23:00:37.92+00:00
andy 0 Reputation points
0 answers

Preview Error Adding Extension Assembly to SSRS RDL Report in VS2022

I am using Visual Studio 2022 with the Microsoft Reporting Services Projects extension. I've created a Reporting Services project and added a simple report. In this report, I included a textbox with the expression =User!Language and successfully…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
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.
2,800 questions
asked 2024-04-25T20:50:57.0033333+00:00
James, Alec (Basingstoke) 0 Reputation points
commented 2024-04-26T22:42:57.85+00:00
Greg Low 1,495 Reputation points Microsoft Regional Director
2 answers One of the answers was accepted by the question author.

MSSQL : How do i look at contents of a schema?

Hi I am trying to understand schemas better in MSSQL/ SQL Server. I can find the list of schemas, and see what tables are covered in schemas... however is there a way to simply dump the contents of a schema, much like a table? Many sources say it…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
asked 2024-04-25T22:06:36.2733333+00:00
joe yang 40 Reputation points
commented 2024-04-26T22:15:55.45+00:00
Bruce (SqlWork.com) 56,026 Reputation points
1 answer

Microsoft OLE DB Driver for Sql Server 18.7.2 x86 installer fails with unsupported operating system error on Windows 10

x64 works, but x86 gives me this message on multiple Windows 10 computers:

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
10,619 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.
12,715 questions
asked 2024-04-26T14:24:11.66+00:00
Erik Schlorholtz 0 Reputation points
commented 2024-04-26T21:23:34.9+00:00
Erland Sommarskog 101K Reputation points MVP
1 answer

Dynamic data masking with deterministic values

I would like to check for data masking solution when reading data from a SQL Server database. To elaborate further, the data elements should be encrypted/masked when a set of users querying the tables. The data stored at rest should be clear (i.e.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
asked 2024-04-24T06:20:07.5333333+00:00
Aravindhan Ravichandran 0 Reputation points
commented 2024-04-26T21:17:08.2333333+00:00
Erland Sommarskog 101K Reputation points MVP
2 answers

Log Shipping on SQL Server 2019 on Linux

I am attempting to set up log shipping in docker containers. I was able to set up the samba share and get everything setup and jobs deployed to both primary and secondary servers where the logs will be shipped. I think I have narrowed down the issue to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
asked 2024-04-25T18:11:39.8466667+00:00
Pepe-8078 0 Reputation points
commented 2024-04-26T21:04:41.03+00:00
Erland Sommarskog 101K Reputation points MVP
1 answer

How to fix Database Engine Services Failure during SQL server 2022 installation

I was trying to install SQL Server 2022 on my windows virtual machine and got the following error: Unable to install SQL Server(setup.exe) I have attached the summary file too.Summary.txt

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
asked 2024-04-25T17:10:02.28+00:00
Juwairiyyah Ahmed 0 Reputation points
commented 2024-04-26T20:54:42.74+00:00
Erland Sommarskog 101K Reputation points MVP
4 answers

Is it Possible or is there a way to use the database you have been working on the developer option for production?

Can I migrate the database I made on the developer version to the express version or is there a way to use the database you created using the developer version for production purposes, say if you can transfer my database to the express version or pay for…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
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.
494 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,002 questions
asked 2024-04-23T12:11:55.2666667+00:00
Betselot Getahun 0 Reputation points
edited the question 2024-04-26T20:42:14.2566667+00:00
Mike Bowen 1,276 Reputation points Microsoft Employee
1 answer

Synapse Python/Spark Notebook code with SQL to query data from linked service to SQL Server

In Synpase, I have linked service to a SQL Server database. I'm looking for a sample notebook code, either in python or spark, that I can run a complex SQL qery within this code to get data from multiple SQL Server tables, put the rsults in a dataframe…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,370 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.
12,715 questions
asked 2024-04-24T13:45:40.7233333+00:00
ylycfj88 0 Reputation points
commented 2024-04-26T15:47:51.8433333+00:00
Smaran Thoomu 9,530 Reputation points Microsoft Vendor
0 answers

Powershell from SSIS - Empty environment variable

I'm running a script in an SSIS package and I specify an account to run the package in SQL Server Agent. When it runs, I am unable to get the value of $ENV:LOCALAPPDATA Here's my code along with writing out the LOCALAPPDATA value Start-Transcript…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,453 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,059 questions
asked 2024-04-26T14:36:22.63+00:00
HSB 25 Reputation points
3 answers One of the answers was accepted by the question author.

How to contact Microsoft for technical support

We are running 2017 SQL enterprise and standard version. How to contact Micrsoft for technical support?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
asked 2024-04-25T15:06:44.48+00:00
szh8866-8371 100 Reputation points
accepted 2024-04-26T13:37:32.5566667+00:00
szh8866-8371 100 Reputation points
0 answers

Does PolyBase support JOIN PUSHDOWN to Oracle Data Source

From my testing PolyBase on SQL 2019 does not push JOIN to the data source, even though the data source is setup with PUSH DOWN on. The documentation it states JOINS can be pushed down to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
asked 2024-04-26T13:00:58.79+00:00
Mihaela 1 Reputation point
3 answers One of the answers was accepted by the question author.

Locking comparison SQL Server 2017 versus SQL Server 2022

We upgraded from SQL Server 2017 to SQL Server 2022. With SQL Server 2022 we are experiencing a lot more and longer locks. When long lasting locks happens, a lot of process are getting suspended. As soon that the lock is resolved, the processes are like…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
asked 2024-04-22T12:53:22.4133333+00:00
Paolo Taverna 71 Reputation points
commented 2024-04-26T11:36:16.8166667+00:00
Paolo Taverna 71 Reputation points
1 answer

Azure Data Share to Share data from Azure Managed Instance SQL Server

As part of my migration project requirements, I am looking to share data from my source system which is in Azure MI SQL Server and to the target system which is also in Azure MI SQL Server. I need to share the source data which is in Azure MI SQL Server…

Azure Data Share
Azure Data Share
An Azure service that is used to share data from multiple sources with other organizations.
44 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.
12,715 questions
asked 2024-04-26T06:54:52.4633333+00:00
Balan Murugan 41 Reputation points
commented 2024-04-26T10:50:29.0133333+00:00
Balan Murugan 41 Reputation points
2 answers

MSSql 2k16 cannot switch version

running an express edition of 2k16, that reached file size limit, on a w10/64 OS. All OS updates done. SMSS v 20.1 Purchased serial with 20 cals. Started the "2k16 install center" --> Maintenance --> Edition upgrade type in the serial.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
asked 2024-04-26T04:19:36.4433333+00:00
rnervi 0 Reputation points
commented 2024-04-26T10:08:17.86+00:00
rnervi 0 Reputation points