VMware vNUMA and SQL Server
Jonathan Kehayias (b | t ) posted a fantastic write up today on VMware’s vNUMA interactions when the operating system feature ‘CPU...
2013-12-31
1,213 reads
Technobabble by Klee from @kleegeek
2014 Event Kickoff
I know that this coming year, 2014, is going to be my best year yet! I’m starting 2014 off with...
2013-12-17
703 reads
Recent events wrapup
The last two weeks were just incredible! I gave my first SQL Saturday PreCon training session in Washington DC and...
2013-12-15
655 reads
SQL Server Virtual Machine vNUMA Sizing
A wonderful gentleman who attended my SQL PASS Summit session this year recently emailed me and asked me a great...
2013-12-10 (first published: 2013-12-02)
1,931 reads
HammerDB SQL Server Benchmarking Utility
Mike Fal
Everyone here knows how much I enjoy using the DVDstore database benchmarking utility to benchmark a SQL Server instance....
2013-11-26
1,779 reads
Guest blog post at SQLAuthority – How many vCPUs are too many?
Last night my first guest blog pots over at SQLAuthority has gone live! It is the next in the “Notes...
2013-11-27 (first published: 2013-11-21)
1,376 reads
Triangle SQL Server User Group Wrapup
Tonight I had the pleasure of presenting remotely to the Triangle SQL Server Users Group. I presented my session entitled “Squeezing...
2013-11-20
623 reads
Chicago SQL Server Users Group Wrapup
Thursday night I had a great time presenting my session entitled “Squeezing Top Performance from Your Virtualized SQL Server” to...
2013-11-17
703 reads
VMware vCPU Ready Time Equivalent in Hyper-V
Jonathan Keyahias (b | t | l) from SQLskills has released a new blog post outlining the metric that Microsoft’s Hyper-V product...
2013-11-14
997 reads
Testing network throughput with iperf
Have you ever wondered if that black box in your datacenter called the network is performing as well as it...
2013-11-20 (first published: 2013-11-11)
2,100 reads
Blogs
My 2024 in Data: Health and Workouts
By Steve Jones
This is my last week of the year working (I guess I come back...
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...
Forums
Windows could not start the SQL server (SQLEXPRESS) service (macOS)
I have a common problem that I just cannot figure out after scrolling through...
Adventureworks data does not load
Hello, I am a new member here so forgive me if I am not...
Restore Procedure not working
I created a small procedure that reads the backup file and restores the DB...
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