Viewing 15 posts - 16 through 30 (of 9,244 total)
Just about all professional DBAs revoke access to database diagram SPs, it's a best practice.
I have used dbForge and it's useful but you wouldn't broadcast this to all and sundry
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2025 at 10:15 am
Have you read the documentation Microsoft provide for Azure SQL DB redundancy, that would be a good starting place
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2025 at 10:13 am
I would add to Perry's statements - ideally you should be using MSA or gMSA accounts to run SQL Server services.
agree, gMSAs are way forward.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2025 at 6:32 am
I found it is best to create the SPN manually, and assign to it the permissions it needs. Doing things this way also requires that you use the same...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 15, 2025 at 8:48 am
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html
Not sure on the licensing - that is going to depend on how AWS charges for each instance. I would definitely look into that and compare the costs.
It...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2025 at 9:21 am
message 1 is a warming so you can ignore it.
message 2 is informing you an SPN couldnt be created, what account do you run the sql server service under, guessing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2025 at 9:16 am
No you’re just changing the owner of the folder, is your sql instance running under system account and not user acct or msa?
once you’ve taken ownership you can add acls...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2025 at 7:03 pm
Hi Experts,
One of my Large database having about 4TB in size is taking almost 3 days to complete the backup . To reduce the backup I stripped the same...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2025 at 3:47 pm
There isn't a setting in SSMS I'm aware of.
No, its pretty much all at the external level to sql server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2025 at 3:40 pm
ok, using AlwaysEncrypted.
Firstly do you understand exactly how this feature works and the degrees of separation that can be used, see my blog post at this link
Is your colleague...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2025 at 2:56 pm
Take this as a base to identify orphaned windows and instance logins, then wrap around to create statements required
select dp.name, sp.name
from sys.database_principals dp
LEFT OUTER JOIN sys.server_principals...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2025 at 12:50 pm
also, check the log produced by the installer, full details are in there for failures
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2025 at 12:44 pm
take ownership and change the owner from system to the sql admins group if you have one or server admins.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2025 at 12:30 pm
So random question about Windows Certificates --
I administer and develop a SQL Server DB App -- Back End is on an Azure Server/Front End is MS Access, about 35...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2025 at 12:24 pm
don’t use sysusers and sp_change_users_login, they’re deprecated and will be removed, also don’t use a cursor.
use the ALTER USER command to fix orphaned database users
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2025 at 6:04 am
Viewing 15 posts - 16 through 30 (of 9,244 total)