Viewing 15 posts - 16 through 30 (of 6,676 total)
On the off chance you didn't do this - try refreshing object explorer.
If you have already tried that, then try opening the system databases - then master database - and...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 13, 2025 at 7:03 pm
There is nothing 'out of the box' that monitors calls to procedures/functions and logs those somewhere. If you have not setup an extended event, profiler trace - or possibly query...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 10, 2025 at 8:38 pm
We always use an extra sqlagent job step to check it the database is primary. If not : fail the step and end the job
Else run the next step(s)
We...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 10, 2025 at 8:33 pm
USE statements can be tricky. I suggest splitting your code into two procs, one to test status and one to do actions.
You could make the test status proc a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 7, 2025 at 7:29 pm
That was just an example of how to call out to powershell from C# - and not something specific to an SSIS script task. You need to make sure you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 7, 2025 at 7:23 pm
USE <your database>;
GO
IF coalesce(sys.fn_hadr_is_primary_replica(db_name()), 1) <> 1
BEGIN
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 6, 2025 at 10:19 pm
I would check the connection settings - and verify ARITHABORT setting is the same for both. It definitely sounds like a different plan is being used when called from VB.NET...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 6, 2025 at 10:16 pm
You could change the approach to use a script task to execute your powershell script. However, if you can do this in PS - then you almost certainly can do...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 6, 2025 at 10:12 pm
I am curious as to why you need to call out to PS directly from SQL Server. If I need to call a PS script from SQL Server - I...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 24, 2025 at 8:05 pm
Best practise is always subjective, create the instances as they are needed, but my best practise is to never have more than 1 instance per cluster/machine, unless someone can...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 20, 2025 at 4:57 pm
Depends on the resource - if it is SQL Server installed into the cluster, the delays could be caused by how long it takes SQL Server to start and recover...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 18, 2025 at 3:45 pm
CipherTrust is one - you can search for others.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 18, 2025 at 3:41 pm
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.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 17, 2025 at 8:46 pm
There are products available that will encrypt the data at a folder/volume level - so any file in that folder will be encrypted. They are not inexpensive - but they...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 17, 2025 at 8:38 pm
Thanks and I tend to agree on Choose. It seems like a "magic hard coding" way of putting in values, which worries me. I prefer things to be more...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 13, 2025 at 6:36 pm
Viewing 15 posts - 16 through 30 (of 6,676 total)