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
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…
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…
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…
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
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…
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…
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:
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.…
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…
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
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…
How to delete instance I created in Microsoft SQL Server
I installed an instance with analysis service and I want to undo this action.
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…
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…
How to contact Microsoft for technical support
We are running 2017 SQL enterprise and standard version. How to contact Micrsoft for technical support?
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…
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…
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…
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.…