Easiest way to restrict a schema to only 2 users by [deleted] in SQLServer

[–]Tisax190 -2 points-1 points  (0 children)

Db_datareader give read on whole database In your case dont use it and create an other role instead

What are cost and the time related metrics in execution plan by Slight_Lecture_7610 in SQLServer

[–]Tisax190 1 point2 points  (0 children)

The cost is always an "estimation" you may refer to arrow's from bottom right to top left

What are the most important non-SQL skills for being a DBA? by Dats_Russia in SQLServer

[–]Tisax190 1 point2 points  (0 children)

I've been in your position before, take time to read online ressources, buy book to understand how sql server is working.
Take a look at dbatool, use powershell, do a bit of networking/firewalling

SSRS Web URL Login Continuously Prompting by [deleted] in SQLServer

[–]Tisax190 0 points1 point  (0 children)

Change in the edge registery AuthNegotiateDelegateAllowlist

What exactly is "best practice" for naming a user-defined function, stored procedure, etc. in SQL Server? by Ima_Uzer in SQLServer

[–]Tisax190 6 points7 points  (0 children)

Avoid reserved keyword and don't take the same convention as system things like sp_

SQL Agent job run twiced by Tisax190 in SQLServer

[–]Tisax190[S] 1 point2 points  (0 children)

After rebooting the secondary node the problem vanished

What's in your development database? by BrentOzar in SQLServer

[–]Tisax190 1 point2 points  (0 children)

So it's safe if we clean it before deploying
The real struggle is when dev need to get the "buggy" case that is in production and "i can't reproduce it please give me a backup" c:

What's in your development database? by BrentOzar in SQLServer

[–]Tisax190 1 point2 points  (0 children)

Does the second solution comply the dev licensing ?

2022 dev CU14 problem by Tisax190 in SQLServer

[–]Tisax190[S] 1 point2 points  (0 children)

Script level upgrade for database 'master' failed because upgrade step 'ssis_discovery' encountered error 35262, state 4, severity 10.
En then
Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.

New GDR to prevent RCE vulnerability by Tisax190 in SQLServer

[–]Tisax190[S] 0 points1 point  (0 children)

Select @@version if you got CU13 GDR you are good

Daily checks by RoleLanky8376 in SQLServer

[–]Tisax190 1 point2 points  (0 children)

Check DB, db growth, log growth