Comments for SQL Server Consulting & Remote DBA Service https://johnsterrett.com/ We help supplement your IT team with SQL Server Solutions. We are based in Austin, Texas. Fri, 28 Nov 2025 15:37:40 +0000 hourly 1 https://wordpress.org/?v=6.9.4 Comment on Adding a VLDB database to an SQL Server Availability Group by Cheryl Rodrigues https://johnsterrett.com/2015/08/18/adding-a-vldb-database-to-an-sql-server-availability-group-in-60-seconds/#comment-11645 Fri, 28 Nov 2025 15:37:40 +0000 http://johnsterrett.azurewebsites.net/?p=4311#comment-11645 This just saved me. I’ve been trying all the other ways to get a large database added but your way finally worked so thank you!

]]> Comment on Azure Managed Instance Changing DNS prefix by Mario https://johnsterrett.com/2022/09/20/azure-managed-instance-dns-prefix/#comment-11377 Thu, 01 Jun 2023 18:16:49 +0000 https://johnsterrett.com/?p=18520#comment-11377 Hi,
In the last image, you show the connection with your alias and the domain (as suffix). Is it possible to connect to the Azure SQL MI only with the “short” alias?
Best regards,
Mario

]]> Comment on Allow users to start/stop Azure VMs by John Philipson https://johnsterrett.com/2020/02/04/allow-users-to-start-stop-azure-vms/#comment-11287 Wed, 31 Aug 2022 10:45:18 +0000 http://johnsterrett.azurewebsites.net/?p=17706#comment-11287 Great article – thanks for sharing – I think you have missed a curly bracket at the beginning of the json

]]> Comment on Persist Sample Percent in SQL Server IS NOT PERSISTED! by admin https://johnsterrett.com/2020/08/24/persist-sample-percent-in-sql-server-is-not-persisted/#comment-11286 Fri, 01 Oct 2021 13:12:58 +0000 http://johnsterrett.azurewebsites.net/?p=17993#comment-11286 In reply to Vimal Prajapati.

Vimal,

Thank you for your comment. I was waiting until I got confirmation about this making it into SQL 2017 latest CU so it’s in all versions. I just blogged about it.

]]> Comment on Persist Sample Percent in SQL Server IS NOT PERSISTED! by Vimal Prajapati https://johnsterrett.com/2020/08/24/persist-sample-percent-in-sql-server-is-not-persisted/#comment-11283 Tue, 03 Aug 2021 09:10:43 +0000 http://johnsterrett.azurewebsites.net/?p=17993#comment-11283 This bug has been fixed in SQL 2016 SP2 CU17 and SQL 2019 CU10 now.

]]> Comment on Allow users to start/stop Azure VMs by Peter Ryder https://johnsterrett.com/2020/02/04/allow-users-to-start-stop-azure-vms/#comment-11282 Mon, 26 Jul 2021 00:58:47 +0000 http://johnsterrett.azurewebsites.net/?p=17706#comment-11282 Great post!. BTW the leading “{” is missing from the role definition JSON.

]]> Comment on Rename Server Name for SQL Server Cluster by Seshatheri https://johnsterrett.com/2010/10/07/rename-server-name-for-sql-server-cluster/#comment-11281 Sun, 16 May 2021 09:14:00 +0000 http://johnsterrett.azurewebsites.net/2010/10/07/rename-server-name-for-sql-server-cluster/#comment-11281 Hello John,

Good Article, Can you please share the procedure how to rename clustered named instance ex: I have clstr01\SQL01 if I want to rename it to clstr01\SQL02 is it possible ?

Thanks & Regards,
Seshatheri

]]> Comment on Allow users to start/stop Azure VMs by Alessandro https://johnsterrett.com/2020/02/04/allow-users-to-start-stop-azure-vms/#comment-11280 Fri, 30 Apr 2021 11:00:45 +0000 http://johnsterrett.azurewebsites.net/?p=17706#comment-11280 Hello John, I was reading your article ans I was wandering if you could help or address me in order to upload the json custom roles in Azure blob storage.
I was not able to find documentation that explain this procedure, I am afraid I am looking to the wrong direction.
Could you please give me a clue or help?
Thank you
Alessandro

]]> Comment on Building a Data Warehouse with SQL Server by guest https://johnsterrett.com/2009/09/29/building-a-data-warehouse-with-sql-server/#comment-11279 Thu, 08 Apr 2021 07:51:31 +0000 http://johnsterrett.azurewebsites.net/?p=65#comment-11279 Left image doesn’t open any more (http://farm3.static.flickr.com/2268/2473469841_646e4d2b25.jpg).

]]> Comment on Allow users to start/stop Azure VMs by Amrith Bhogal https://johnsterrett.com/2020/02/04/allow-users-to-start-stop-azure-vms/#comment-11278 Mon, 30 Nov 2020 14:15:27 +0000 http://johnsterrett.azurewebsites.net/?p=17706#comment-11278 Hi, I am struggling to use this, I am new to Azure CLI so not sure if I am doing this correctly. How do you load the JSON file to Azure CLI?

]]>