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…
The 'Publish and Subscribe' feature does not work on SQL Server2019 installed using Docker technology on Linux
Database server information : Linux (Rocky 9.1) , Podman platform install (A kind of docker technology),SQLServer 15.0.4033.1(2019),docker image downloaded from the microsoft website,The service startup command is: podman run --name mssql2019 --net=host…
SQL Server Express 2022 Reinstall
Hi I have a question regarding the install process of SQL Server 2022 Express. I was running the platform successfully. My laptop was then migrated to a different domain and SQL Server stopped working (folder rights). I subsequently uninstalled SQL…
How Can I set the right value according to comparison conditition
Hello, i have 2 tables , the first one is a referential of the quality services and the second is a historical tables as bellow the DDL : drop table if exists #oderstatus_quality create table #oderstatus_quality ( id int identity primary key, label…
DCI Client Level Reporting Not Available
Is there any plan to fix the following error: The item '/DCI/DCI_Client_Level' cannot be found. (rsItemNotFound) Get Online Help for the Digital Contact Data reporting at a client level? This error is consistent across many representatives and has been…
Syntax to PRINT the row counts using Dynamic SQL?
Hello, what would be the syntax to PRINT the row counts using Dynamic SQL (in my case here need to get the row counts via a Linked Server View) I would like to have this as a step in a SQL Agent job which after it runs it PRINTs the row counts in it's…
Error loading report.rdlc,Unable to copy bin\debug\
Good afternoon again, I have already searched for information online, but I have not been able to find the error. The error is the following: An error occurred during local report processing. The report definition has not been specified, the file is not…
My emails have completely disappeared off my iPhone and I can’t get it back
I believe since the update I can’t access my Hotmail account and it displays the above messages, I have tried deleting and reinstalling but that haven’t worked my emails say connection to the server has failed
SQL2022-SSEI-Expr setup file is not opening
I downloaded the express edition file from here :https://www.microsoft.com/en-us/sql-server/sql-server-downloads When I try to open it , the file dont open . dont know whats wrong with it. Need Help with the installation. TIA
analysis services pivot taking a long time to refresh
We have an analysis services object that we connect in excel for pivot tables. This has been running fine for 3 years. IN the past month it is taking very long to refresh and also prevents anything else in Excel from being opened (even outlook). What…
Logic app to on-premise SQL server connectivity using service principle (Azure AAD)
Hi Team, Our Agenda is to connect On-premise SQL server using Logic app with SQL server connector. We successfully setup Azure AAD with On-premise SQL. Also, using SSMS we are successfully able to make connection to on-premise SQL using service…
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…
how to fix this issue Msg 64, Level 20, State 0, Line 114 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
When I am trying to run two queries on same database but in different windows one query is doing deletion of a table from particular date ranges along with roll back mechanism and another query is doing fetching data by joining different tables based on…
Microsoft sql studio - dark mode enabling.
do we have a dark mode on Microsoft SQL Server Management Studio ?, of so, can anyone help me on how to get that enabled.
Row-level security in SQL server
In this scenario, I seek assistance in implementing row-level permissions for a table named 'user' with columns 'username' and 'role'. The objective is to establish a security model where access to individual rows is controlled based on the role assigned…
VIEW SERVER STATE vs DB role for DMV on master
Hi, I have a logging procedure that reads from the two tables on master: sys.dm_exec_connections sys.dm_exec_sessions I had to assign permissions to a group for correct execution: GRANT VIEW SERVER STATE TO [domain\mygroup]; but I didn't want…
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…
Using SSDT on a build server
I need to use SSDT on my build server. What exactly do need to install to get it working? I have a docker image that does the builds. It's based on mcr.microsoft.com/dotnet/framework/sdk:4.8-20230110-windowsservercore-ltsc2019Ideally, it would be nice…
SQL server backup in a 2019 VM to s3 using backup URL
Hi I have set up a Windows Server 2019 VM with SQL server 2016. I want to take the backup of SQL server in AWS S3. It should have monitoring and auditing capability and cost effective and secure. I have looked at below…
GDR upgrade path question
I have a SQL Server updated to version 15.0.4326.1, which is on the GDR path but on a GDR + CU version. Can I install the next update on the GDR path to go to version 15.0.2110.4 that is GDR only, or do I have to install the next GDR + CU update?