Viewing 15 posts - 826 through 840 (of 6,400 total)
Yes very possible as long as you have verified no Enterprise features are actually in use.
But that being said some enterprise features became available in standard edition from 2016SP1.
The only...
July 28, 2021 at 6:50 am
The problem with creating indexes on the subscriber is that if you ever did failover to it for DR purposes, then all your CRUD statements in the app are going...
July 21, 2021 at 2:33 pm
The log chain doesn't break as the way availability groups work is to ensure the LSN's match between all replicas, so there is never any drift in the chain.
With that...
July 21, 2021 at 1:23 pm
Use powershell and dbatools
get-dbauserpermission will do exactly what you need
June 19, 2021 at 6:24 pm
What if you cannot remove the replica from the group?
If you have multiple databases in the group then removing the replica will affect them all, not just the database which...
June 16, 2021 at 10:58 am
You need to unload and reload the counters.
Plenty on the internet with a quick search for this.
Heres one from Pinal https://blog.sqlauthority.com/2014/11/07/sql-server-performance-counter-missing-how-to-get-them-back/
June 16, 2021 at 10:55 am
We implement CIS and have AOAG's the SA account is fully disabled and we dont get the error.
What was the implementation path, did you do the AOAG's before applying CIS. ...
June 15, 2021 at 11:47 am
The instance name yes you can use the same. The same Virtual Name no
EG your 2014 instance is MySQLVirtName\Prod1 and you build a new 2019 instance of MySqlVirtName\Prod1 will not...
June 15, 2021 at 11:26 am
Size the database as best you can and keep an eye on it for adding more space when it gets below a certain threshold but would still have auto grow...
June 14, 2021 at 9:15 pm
Restoring the database flushes the cache so the first time you run the proc your having to pull all the data back from disk. If your talking multiple 100s of...
June 12, 2021 at 6:15 am
Also speak to your network security team they may have introduced firewalls between the servers and also the windows team if they have enabled or restricted the windows firewall
June 11, 2021 at 5:19 am
May need to start the dbmail process sometimes it’s a bit funny and will refuse to auto start when mail items hit the queue.
sp_start_dbmail
June 11, 2021 at 5:17 am
PBI can link to certain parts of SSRS reports, gauges, datasets etc, don’t know if it can link to a whole report though.
If you want MFA you will need to...
June 10, 2021 at 6:18 am
You should really be keeping things insync, so I would do both nodes at the same time. You never know what will happen so if a patch fixes a bug...
June 9, 2021 at 7:01 am
Maybe able to do it with an application proxy, https://docs.microsoft.com/en-us/azure/active-directory/app-proxy/application-proxy, but I would be going down the PowerBI route now instead of SSRS, it gets more love from Microsoft and...
June 9, 2021 at 5:50 am
Viewing 15 posts - 826 through 840 (of 6,400 total)