I want to mask all user privilege both Admin or owner cannot view mask table.
Dear Sir/Madam https://learn.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver16 Refer to link Official Microsoft above, Administrative users or roles such as sysadmin, serveradmin, or db_owner have CONTROL…
Could drop user sa?
Dear Sir/Madam As we know user sa is default user that have sid=0x01 is_disabled=0 principal_id=1 on sys.server_principals table. Could we drop it to protect from attacker? Srean Regard Thank
Failed to connect to DESKTOP-35COSO3\MSSQLSERVER03:1433 - self-signed certificate
Get this error while connecting my node js to MSSQL server. PS C:\Users\ANJALI\Documents\Curate\Website\Backend> node index.js ConnectionError: Failed to connect to DESKTOP-35COSO3\MSSQLSERVER03:1433 - self-signed certificate at…
Suitable backup location for the Certificate and DEK backup for a database with Transparent Data Encryption Enabled on SQL Server
I have SQL instances that will have TDE enabled soon and I need a backup option for the Certificate and DEK after the database has been encrypted, I don't want to have the files on the same location where the databases are hosted so I thought key vault…
DATEDIFF (YEAR, StartDate, EndDate) returns incorrectly
I am trying to figure out why the DATEDIFF(YEAR) Function is returning incorrectly and am wondering if I have to get the StartDate and EndDate in a certain format before attempting to use the function. SELECT DATEDIFF(YEAR, '2023-12-31 08:31:42.373',…
Does ms sqlserver support JWT or client certificate authentication
We are using JDBC and ODBC to connection MS SQL Server authenticated by user name and password, but from security requirement we need to find a more secure client authentication method. Does SQL Server support client certificate or JWT client…
Sql server agent job fail
The error message is An idle CPU condition has not been defined
Replication Reinitialization from backup
I have Reinitialization transactional replication of 950 GB database from backup. It is working fine. I left allow_anonymous & immediate_sync 1 i.e true. I plan to keep it as true. Is that fine or do I need to change to false. I have tried to put…
In SSRS 2019 Can you change the background color of the Parameters pane?
In SSRS 2019 Can you change the background color of the Parameters pane? It is defaulted to white. I have been unable to find anything about it in the Branding or the SSRS Report Builder information.
sys.dm_os_performance_counters to collect cpu usage
Hello everyone, I use sys.dm_os_performance_counters to collect cpu usage for SQL Server 2016 SP3, but the values are always 0. Is it normal? Thanks,
ResourceDB
If we move master database to a new location, does the ResourceDB database also move?
Determine SQL Licensing Type after installation
Hello, From the Microsoft Volume Licensing Center, I downloaded both Server/Cal and PerCore SQL Server 2022 Standard Edition download (ISO) files and placed them in separate folders, not realizing they were saved with the same name. A coworker installed…
Need to create Powershell report for SQL Always on secondary serves.
Hello All, A strange request. We are running multiple always on servers. Backups takes place on secondary replica of always on server. I need to create a report in powershell or t-sql that would identify secondary replica and verify backup…
[Question] ODBC Read/Write Permission - Can Create a Stored Procedure?
I am not an SQL/Database Expert, but I would like to know more and am curious if a user with an ODBC Read/Write Access to the database. Can it create/alter stored procedures? Thanks a lot!
How to fix an error when installing MS SQL
Hello, I was trying to install MS SQL on my computer but unfortunately i keep getting error with database engine startup handle. I tried to find answers for hours in various forums but nothing I found worked. Below I place screenshot together with…
SQL 2022 Bug - FILESTREAM
Trying to setup database with FILESTREAM. Using scripts that work great on previous versions of SQL Server (2016 to 2019). Getting strange error message when trying to add file to filegroup: Msg 35221, Level 16, State 1, Line 2 Could not process…
How to loop through multiple Sql Server instance, database, and table/view names?
It's been a long time since I write any C# code. I'm trying to query some tables and views from different SQL Server instance, database names, and tables/views. Below is my sample code. public void Main() { // TODO: Add your code here …
What Is the Best Way to See Raw Data Stream Being Passed from SQL to .NET Application?
I am running some functions on application startup for my .NET application. This mostly involves running a bunch of scripts on my SQL database to ensure plans are cached. These queries are generated from EFCore-compiled queries. In doing this, I…
EnableCrossDatabaseFolding for SSAS?
Is there any chance this option will be added also to SSAS? I'd like to no longer have to define views just to fake using only one database.
How to troubleshoot "Read-SqlTableData : Failed to connect to server" error?
I have this PoweShell script code: $sqlView = Read-SqlTableData -ServerInstance $query.Instance -DatabaseName $query.DB -SchemaName $query.Schema -TableName $query.View I keep getting this error: Read-SqlTableData : Failed to connect to server…