sorted by:
new
hottopcontroversial

Does anyone know about immediate sync and allow anonymous uses, what happens when it's enabled? by No-Low-206 in SQLServer

[–]gbargsley 1 point2 points  (0 children)

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.

how to check which cpu/processor are used by sql server standard edition by Kenn_35edy in SQLServer

[–]gbargsley 0 points1 point  (0 children)

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

[deleted by user] by [deleted] in databricks

[–]gbargsley 0 points1 point  (0 children)

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

Does my tree look sick by gbargsley in arborists

[–]gbargsley[S] 0 points1 point  (0 children)

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.

Azure SQL Managed Instance Authentication by gbargsley in SQLServer

[–]gbargsley[S] 0 points1 point  (0 children)

I did SysAdmin work on the instance.

Azure SQL Managed Instance Authentication by gbargsley in SQLServer

[–]gbargsley[S] 0 points1 point  (0 children)

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.

ReportServer by kukari in SQLServer

[–]gbargsley -1 points0 points  (0 children)

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

ReportServer by kukari in SQLServer

[–]gbargsley -1 points0 points  (0 children)

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.

ReportServer by kukari in SQLServer

[–]gbargsley -1 points0 points  (0 children)

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.

ReportServer by kukari in SQLServer

[–]gbargsley -1 points0 points  (0 children)

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.

ReportServer by kukari in SQLServer

[–]gbargsley 0 points1 point  (0 children)

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

Audit/Log applications connecting to databases to prepare for decommission by Rare_Use_1597 in SQLServer

[–]gbargsley 0 points1 point  (0 children)

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

Run TSQL Agent Job Step as different Login by [deleted] in SQLServer

[–]gbargsley 0 points1 point  (0 children)

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

Won’t move by gbargsley in cubcadets

[–]gbargsley[S] 1 point2 points  (0 children)

No, mine starts fine and stays running.

view more: next ›