SQL Server and VMware Resource Pools
Resource pools are used to hierarchically partition available CPU and memory resources, and are available for use at the VMware host cluster layer. To better prioritize certain VMs over...
2020-04-06
57 reads
Technobabble by Klee from @kleegeek
SQL Server on Linux? Start on Azure
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
116 reads
DRS Cluster Load Balancing Improvement for SQL Server on VMware
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)
341 reads
Improved VMware vCenter Performance Metric Logging
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)
270 reads
VMware vExpert 2020
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
5 reads
Speaking for Omaha Azure User Group Wednesday
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
6 reads
Tell Me About Your Worst Database Code Offenders
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)
770 reads
Interesting Note in SQL Server 2019 Release Notes
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)
843 reads
PASS HA/DR Open Q&A Extravaganza Dec 10
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
40 reads
Better, faster, cheaper: SQL Server on Azure IaaS
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)
720 reads
Blogs
My 2024 in Data: Reading
By Steve Jones
This is my last week of the year working (I guess I come back...
Book Review – Agile Data Warehouse Design
I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...
My 2024 in Data: Speaking
By Steve Jones
This is my last week of the year working (I guess I come back...
Forums
Need ADF pipeline suggestion to copy 1 million files
I have an ADF pipeline that copies Files from source to destination. Both Source...
Function Defaults
Comments posted to this topic are about the item Function Defaults
Question of the Day
Function Defaults
I have created this function in SQL Server 2022:
CREATE FUNCTION dbo.AddInt (@one INT, @two INT = 1) RETURNS INT
AS
BEGIN
RETURN @one + @two
END
How can I call this and invoke the default value for @two? See possible answers