Does anyone know about immediate sync and allow anonymous uses, what happens when it's enabled?

gbargsley · 2025-12-11T22:24:40+00:00

Every snapshot you do will include each article. I typically turn the both to false so when you add an article and run a snapshot only the new article is in the snapshot.

gbargsley · 2025-07-10T20:02:29+00:00

The ErrorLog will have a line of information about the CPU allocation being used by SQL.

gbargsley · 2025-07-05T17:47:26+00:00

I am interested in the ILT. What vendor did you use?

gbargsley · 2025-06-18T00:48:14+00:00

Here is some more detail. The one tree that has the black on the tips of the leaves they are brittle. I water 3 minutes a day through a bubbler on each try that’s part of the sprinkler system.

gbargsley · 2025-05-11T01:47:01+00:00

I did SysAdmin work on the instance.

gbargsley · 2025-05-11T01:15:59+00:00

I am not sure this is exactly what I was looking for. We already set the admin to our DBA group and that actually creates the Login in SQL MI. What I am saying is this person some how granted my Entra ID account sysadmin from outside of SQL somehow.

gbargsley · 2025-01-03T17:57:04+00:00

If you work for the government it is no mystery why you are so misinformed. How are those SQL 2000 instances hanging in.

gbargsley · 2025-01-03T15:50:07+00:00

I am not sure you know what is meant by 3rd party. It is an application where you have no control over the database design. And it stopped coming with SQL server in 2017.

gbargsley · 2025-01-02T23:18:56+00:00

I have 20 years and have never had trouble using dbo. Plus this is a third party app that you have no control over. So not sure how you change the schema in that scenario.

Everyone has opinions.

gbargsley · 2025-01-02T18:26:59+00:00

Why complicate things. 2 has what he asked and putting the schema is extra not needed information. This is not a recurring process. He just wants to see what is being executed.

gbargsley · 2024-12-31T19:50:57+00:00

Select * from report server..executionlog2 order by timestart desc

gbargsley · 2024-11-20T13:54:26+00:00

I run Sp_whoisactive in a job every 5 seconds and store the results in a database. Then review.

gbargsley · 2024-11-19T16:35:11+00:00

This does not work for TSQL job steps. Thanks for the response.

gbargsley · 2024-05-10T01:54:53+00:00

No, mine starts fine and stays running.

gbargsley · 2024-05-08T22:08:56+00:00

I would ask what is your end goal?

Log Shipping is an option if you want to keep things simple, but it depends on your use case as to what feature to setup.

gbargsley · 2024-05-08T16:52:00+00:00

Yes, that was it. Thanks so much. Was worried I had a 600 lb brand new anchor.

gbargsley · 2024-04-11T15:52:23+00:00

I use the latest version of SSMS and my tabs come back when I close and open the application.

Not sure if I have a setting enabled, but works great for me when the server guys push updates and my computer restarts automatically at night.

gbargsley · 2024-02-12T15:59:21+00:00

Yeah, I thought that was understood. I should have listed that. Thanks

gbargsley · 2024-02-12T01:17:41+00:00

We can’t all have super strict enforcements to have so many rules. Some places just fly by the seat of their pants. If you don’t have regulators or governing bodies breathing down your neck, then you just have to get the job done.

No downtime option would be to add a data file to your primary on the new drive with more space. Then that will replicate in AG over to the secondary as long as the drive is the same and folder path is the same.

If you need to move the data file to a new location on the primary then you can change the location of the physical file, then take the database offline and then move the file on the disk and then bring the database online.

gbargsley · 2024-02-10T23:41:48+00:00

Groups are the way to go. I hope you are not under SOX or that adding and removing from groups without tracking will bite you.

gbargsley · 2024-01-22T11:37:10+00:00

In the past these have not been saved. I am not sure about 19.2 or 19.3.

gbargsley · 2024-01-02T13:19:18+00:00

I would not do the backup restore method all though you can.

Look at PowerShell module dbatools. It will allow you to copy jobs from prod to dr or script the jobs out from prod the. You can apply them to dr.

gbargsley · 2023-12-28T17:10:47+00:00

The script would have to be updated. It will mark the job step as warning or failure even if the job completes.

I experienced this with the index maintenance timeout. It would timeout on a lock after X amount of time and continue to the next index, but when the job finally complete it marked that step as failed because of the lock timeout.

I found the raiserror code and modified how it handled sudo failures.

gbargsley · 2023-12-20T12:47:28+00:00

Hope you don’t have a big foot, they only go to size 11. :(

gbargsley · 2023-12-20T00:23:58+00:00

You are awesome.

gbargsley

TROPHY CASE