Dynamic Resource Scheduling (DRS) should be enabled for all VMware host clusters, especially those who run SQL Server. It provides for resource consumption load balancing functionality into a host...
2020-03-25 (first published: 2020-03-16)
164 reads
I’ve talked for months now about the ability to run SQL Server on the Linux platform. For those of you interested in exploring the benefits of this platform, you’re...
2020-03-19
82 reads
By default, the vSphere vCenter deployment contains a virtual appliance where the VMware management and orchestration platform, vCenter, resides and runs from. The default performance metric statistics collection interval...
2020-03-16 (first published: 2020-03-09)
215 reads
I’m proud to announce that I’ve been awarded the VMware vExpert community award for the calendar year 2020. I’m absolutely thrilled to be awarded this title for the eighth...
2020-03-04
2 reads
This Wednesday, February 26th, I will be presenting a new session entitled “All Things SQL in the Microsoft Cloud” for the Omaha Azure Users Group, starting at 6pm Central...
2020-02-24
5 reads
For years, I’ve done consulting around helping organizations tune their database platforms, both from within the database and underneath, to help boost performance and availability. Some database design or...
2020-02-06 (first published: 2020-02-03)
743 reads
A wonderful reader of my blog sent me a note (thanks Jess!) about a single line notation in the latest SQL Server release notes. The notes is as follows....
2020-01-15 (first published: 2020-01-06)
803 reads
GigaOm, an independent research firm that I highly respect, released a study today comparing performance and price between a SQL Server VM on Microsoft’s Azure platform and a SQL...
2019-12-19 (first published: 2019-12-04)
575 reads
As leader of the PASS High Availability and Disaster Recovery virtual chapter, I invite you to bring your questions for a mega open Q&A session on Tuesday, December 10th,...
2019-12-04
36 reads
I’m proud to announce that I’ll be presenting an updated session entitled “Level Up Your Cloud Infrastructure Skills” for the Omaha SQL Server Users Group on December 4th at...
2019-12-02
11 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Yesterday we announced that Data Céilí 2020 has been cancelled due to the continuing...
By Steve Jones
I presented a session today at Redgate Streamed and did a number of demos....
Hello, How to delete backups in blob storage from azure sql server VM to...
First time poster...not sure this the correct section to post this question. I have...
I am using this statement: Select @Data = @Data + RIGHT('00000000000' + CAST( (SUBSTRING(STR(@qtramt1),1,11))...
Ask SSC