Viewing 15 posts - 16 through 30 (of 7,368 total)
hmmm ... you are wright.
I never payed notice to those connections ( assuming they are encrypted due to the endpoint encryption setting, but apparently only the endpoint to endpoint conversation...
November 7, 2024 at 2:12 pm
Modify your DB mirroring endpoints to force encryption ! ( encryption = required )
Check Create Endpoint
November 7, 2024 at 12:47 pm
Just get a bigger truck may get this thing done $$$$
Did you validate and test other options for your single table ( 476GB ) ?
How much of that data is...
November 7, 2024 at 7:24 am
Your subquery does not make sense as it is not related to the from clause of your query.
(and because it performs the same query as your from clause, it will...
November 5, 2024 at 8:29 am
Just to be clear: A tail log serves the target database at the target server of your restore. ( so in case you need to restore that one back to...
November 4, 2024 at 7:33 am
Do not perform a Tail log backup if you just need a transaction log backup !!
A tail-log backups only purpose is that you can restore the original database as it...
November 3, 2024 at 4:13 pm
Did you actually prefix the correct master database ?
In that case you might as well perform a "union all"
/* contained AG master db */
SELECT 'AG1_master' SourceMaster, *...
October 31, 2024 at 2:58 pm
So you connect to one of the nodes of the Windows cluster hosting the Contained AG ?
( I don't know if access to master db is blocked when connecting to...
October 31, 2024 at 12:34 pm
Enable "auto close" for that database and monitor the sql server errorlog to see when it is being brought online.
ALTER DATABASE [Yourdb] SET AUTO_CLOSE ON WITH NO_WAIT...
October 31, 2024 at 12:24 pm
I first prepared both stand alone instances.
Then I restored the needed db on one instance, configured the needed sql accounts ( using dbatools Copy-DbaUser ) and sqlagent jobs (...
October 28, 2024 at 2:34 pm
You need at least create one FULL backup ( to actually activate the log...
October 23, 2024 at 6:43 am
did you try casting "value" to a numerical data type ?
e.g.
...
SUM(CASE WHEN [Metric] IN (...)
THEN cast([Value] as decimal(18,2)) END) AS [...],
...
October 22, 2024 at 6:07 am
Launch a profiler trace to see what is going on
October 21, 2024 at 11:41 am
FWIW :
Scientists are currently busy recreating tissues or animals that have been extinct for millions of years.
Perhaps that will be the fate for relational DBA and this phase will occur...
October 21, 2024 at 8:59 am
We're not dinosaurs! I saw a Star Trek movie (from the 23rd century mind you) where Spock said that a SQL injection attack was used to do nefarious stuff. ...
October 21, 2024 at 8:55 am
Viewing 15 posts - 16 through 30 (of 7,368 total)