Viewing 15 posts - 91 through 105 (of 9,244 total)
I'll assume Azure SQLDB since you cite "logical server".
Important to remember with Azure SQLDB there is no concept of server logins and permissions, indeed, you shouldn't be (and shouldn't need...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 4, 2024 at 11:40 am
start here as this has all the info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 4, 2024 at 11:04 am
You don’t need to use a file for the delete records, you have a memory resident recordset which you can loop through, could then output this status to a log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 4, 2024 at 6:12 am
ok, but as suggested by others why dont you just connect directly to the source first, build your recordset and then connect to the target and perform whatever work needs...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2024 at 12:47 pm
This is the snippet from script. The serverInstance and Query both use servers that have the Dash(-) in their names.
stopwatch = [System.Diagnostics.Stopwatch]::StartNew()
# Define your SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2024 at 9:29 am
Azure SQLDB or Azure SQL Managed Instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 2, 2024 at 7:29 pm
Vdis can be started and disposed to meet dev requirements
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 29, 2024 at 4:07 pm
What errors did checkdb report? how often do you run dbcc checkdb on your databases?
Hi,
we check our databases every day with dbcc. If you got an...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 24, 2024 at 7:52 am
Why use sql auth and not windows auth?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 24, 2024 at 7:44 am
You also need to bear in mind that even after decrypting the database and dropping the encryption key and cert it is still possible part of the transaction log is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 23, 2024 at 2:28 pm
Obvious question, why does this person have the ability to do this in prod in the first place, kill this and you resolve 99.9% of the issues
Put delete triggers on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 22, 2024 at 6:30 pm
again VDI will be best
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 22, 2024 at 3:13 pm
Virtual desktop infrastructure is a common usage for exactly this, it keeps the organisation’s data where it should be and still easily accessible to those who have dev and test...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2024 at 11:18 pm
Original DBCC CHECKDB output would be helpful, with no outputs available would be safe to say data loss is unknown
if you knew what table(s) or index(es) were affected could restore...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2024 at 1:44 pm
Paul Randal details backup with checksum on this blog
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2024 at 11:23 pm
Viewing 15 posts - 91 through 105 (of 9,244 total)