Viewing 15 posts - 346 through 360 (of 2,356 total)
I would recommend that these networks be completely separate segments. I would definitely use a static IP address for the heartbeat, as well as the normal traffic. Your networking folks may...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 21, 2022 at 7:39 pm
Is anyone using Idera's SQL Compliance Manager, or something similar? Auditing requests from our clients is becoming a hot topic. Some of these are kind of ridiculous, but hey, the...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 26, 2022 at 3:10 pm
Thanks Michael - that approach works fine in normal situation, but doesn't actually protect against this particular usecase as a local windows administrator can simple disable the startup of...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 25, 2022 at 9:41 pm
I think you are wasting your time. SQL should use all the memory made available to it. You WANT it to use the available memory. I would be concerned if...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 25, 2022 at 6:32 pm
Set up a SQL job that executes on start up. Create a stored procedure that is executed by this job, and sends an email.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 25, 2022 at 5:12 pm
Hi
How we can check in a Instance which process is consuming more memory.
Can we release memory without re-starting Sql Server
Thanks
What specifically are you trying to do or solve?
Unless you...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 25, 2022 at 5:10 pm
Grant the service account full control on the drives that contain the SQL database files. In my case, that's D, L, H, and T
Grant the service...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 18, 2022 at 1:48 pm
Grant the service account full control on the drives that contain the SQL database files. In my case, that's D, L, H, and T
Grant the service account full...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 17, 2022 at 1:46 pm
Short version: SQL Agent will not start unless the domain service account is runs under is part of the local admins group on the server. SQL Server, running under...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 16, 2022 at 2:48 pm
We have a SQL 2019 Failover Cluster Instance - Default Instance. Question seems lame but...
My question is, what is the "Best Practice" on connecting? Directly to the SQL Cluster...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 16, 2022 at 2:18 pm
I think your idea is a lot of work.
I would create an operator, and the email address would be a group, such as "SQL Notifications". You should rarely have an...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 16, 2022 at 1:07 pm
Wouldn't posting this on one of the WordPress forums make more sense?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 12, 2022 at 5:48 pm
If you have SSAS also installed with Database services on the server, do you need to apply cumulative updates separately or it will give you the option to select...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 12, 2022 at 5:45 pm
In our environment we have about 10 Always on Set up. The application has configured to connect using listener. The applications are didn't hard coded with server (They are...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 12, 2022 at 5:28 pm
Why do you have McAfee scanning your database files??? Those should be excluded.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 12, 2022 at 5:06 pm
Viewing 15 posts - 346 through 360 (of 2,356 total)