CPU Overcommitment and Its Impact on SQL Server Performance on VMware
In the early days of virtualization, the core focus of virtualization was primarily consolidation. You could achieve quite high consolidation...
2012-12-17
1,781 reads
Technobabble by Klee from @kleegeek
SQL Saturday #173 Washington DC wrap up
Today I spoke at the Washington DC SQL Saturday #173. I first spent some time in the SQL Server Performance...
2012-12-09
734 reads
Speaking at SQLPASS Performance Virtual Chapter Winter 2012 Performance Palooza
I am pleased to announce that I am speaking Thursday, December 6, at the SQLPASS Performance Virtual Chapter Winter 2012...
2012-11-30
1,302 reads
SQLIO Analyzer Latency Divide by Zero Issue Corrected
A special thanks goes to Daniel Angerer (t) for suggesting an improvement that corrected the divide by zero error that one...
2012-11-26
1,224 reads
Getting Nexus 7 Connected To Windows 7
Have trouble getting your new Nexus 7 connected to Windows so you can move some media files over?
Install the drivers...
2012-11-24
773 reads
Speaking at SQL Saturday #173 in Washington DC
I will be speaking at SQL Saturday #173 in Washington DC at the Microsoft MTC in Chevy Chase, MD, to speak on...
2012-11-16
803 reads
Advanced VMware certification study material reference
Gregg Robertson (b | t) has posted a fantastic page that contains a tremendous amount of information for those of you...
2012-11-15
696 reads
SQL PASS Summit 2012 Came and Went – and Changed My Life
I cannot believe how surreal this past SQL PASS Summit was for me. This was the second Summit I have...
2012-11-20 (first published: 2012-11-14)
1,945 reads
Speaking with Kevin Kline at SQL PASS Summit 2012
WOW! I’m absolutely honored to announce that I am speaking with theKevin Kline tomorrow at the SQL PASS Summit 2012....
2012-11-09
676 reads
SQLIO Analyzer now has test timestamps
Yesterday I finally got around to adding a much needed improvement to my SQLIO Analyzer tool. You now get a...
2012-11-01
1,493 reads
Blogs
Heading to SQL Bits 2025
By Steve Jones
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day...
Exploring the Next Gen General Purpose Tier in Azure SQL Managed Instance
By John
In a recent video, I took a hands-on look at the Next Gen General...
Why India’s NEW Tax Regime is a GAME CHANGER for the Job Market
By Rohit Garg
India’s 2025 tax reforms have introduced a bold shift in how income is taxed,...
Forums
SSRS error: The Value for the image 'Image1' has a constant value...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
XML_COMPRESSION for existing tables
We are in the process of upgrading to SQL Server 2022 and would like...
How to Choose the Right Tool for MS SQL to PostgreSQL Migration
Comments posted to this topic are about the item How to Choose the Right...
Question of the Day
Adding Defaults
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers