Viewing 15 posts - 16 through 30 (of 7,253 total)
... That login is also disabled, correct?[/quote]
Correct !
March 18, 2024 at 8:35 am
We create a sqluser "NonSA" to serve as dbowner for all user databases (unless other is actually needed - eg during install/upgrade of some software)
March 17, 2024 at 9:51 am
Recently a software vendor required collation Latin1_General_100_CS_AS_KS_WS_SC for their databases.
I still don't understand why, but - as we are used to SQL_Latin1_General_CP1_CI_AS - it really is anoying to say the...
March 15, 2024 at 7:00 am
Why P2V ?
Why not just install a VM, add a SQLinstance ( or 2 if you want ) and move the databases ?
If you can , even upgrade the SQL...
March 14, 2024 at 2:35 pm
mess up = swallow its aftermath ... at least in my opinion.
I know that is not everybody's opinion, but it's the way I roll.
Be honest, especially to yourself.
In many cases,...
March 12, 2024 at 6:50 am
Save the xml in an .XDL file and open the deadlock graph using Solarwinds Plan Explorer.
It has nice replay features to help you detangle it all
March 8, 2024 at 3:05 pm
Restore-DbaDatabase -SqlInstance server1\instance1 -Path Z:\Backup -DestinationDataDirectory Z:\Restore -DestinationLogDirectory Z:\Restore
Restore-DbaDatabase : The term 'Restore-DbaDatabase' is not recognized as the name of a cmdlet, function, script file, or operable program. Check...
March 8, 2024 at 1:21 pm
#RCA :
- Instance was installed and prepared on 2023-08-08.
- AD-groups were created and granted for the instance.
- 2023-08-14 for some reason the AD-group has been deleted and recreated in Active...
March 8, 2024 at 8:47 am
blocking issues ?
Is someone else also using that table at the same time?
Double check for cascading deletes and triggers !
March 5, 2024 at 7:44 am
What collation are you using for these columns ?
If you are actually using case sensitive collations:
How about using lower(userid) , lower(name) and lower(firstname) with the insert statement
or...
February 28, 2024 at 1:24 pm
Just use powershell DBATools ( free modules ) DBARestore
$File = Get-ChildItem c:\backups, \\server1\backups
$File | Restore-DbaDatabase -SqlInstance Server1\Instance -UseDestinationDefaultDirectories
Just keep in mind the target server service account...
February 28, 2024 at 1:13 pm
according to the docs:
February 21, 2024 at 2:15 pm
If performance is your goal: just one huge warning: "Which Version of SQL Server Should You Use?"
February 19, 2024 at 12:48 pm
February 13, 2024 at 2:29 pm
We have a couple of "data domain dedicated" sql stand alone instances ( std edtn ) that only serve as SQLAgent job scheduling environment.
A number of SQLAgent proxy accounts have...
February 9, 2024 at 12:19 pm
Viewing 15 posts - 16 through 30 (of 7,253 total)