This past week I had a great Client ask an even greater question, and it got me thinking. The question is straightforward (albeit nerdy, which I love). “We’ve enabled...
2021-05-19 (first published: 2021-05-10)
885 reads
I just found out that VMware has updated their in-guest time synchronization with the 7.0 Update 1 release. Previously, we had to manually disable some of the advanced time...
2021-04-08 (first published: 2021-04-01)
239 reads
I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as much as I am. I was going through the content catalog for this year’s conference...
2021-03-08 (first published: 2021-03-02)
155 reads
After doing some digging today with a Client, we hit a roadblock on something that I need to share with using the NVMe virtual disk controller on the VMware...
2021-03-02 (first published: 2021-02-23)
139 reads
If you have a SQL Server Availability Group (AG) and the VMs are being replicated to a disaster recovery site (cloud or on-prem), chances are the networking topology is...
2021-02-15 (first published: 2021-02-08)
304 reads
I am thrilled to announce the launch of a new education initiative called SQLibrium. For years, I’ve traveled the world educating technical audiences on deep-dive topics around how data and...
2021-02-10 (first published: 2021-02-02)
250 reads
After architecting and migrating some of the world’s largest data platforms, Let’s walk through my top ten must ask questions before migrating to the cloud so that you can save time, money,...
2020-12-07 (first published: 2020-11-23)
689 reads
Whether you caught a single session, took a pre-con, or filled your schedule last week with multiple sessions, l’m going to review last week’s PASS Virtual Summit 2020 conference!
...
2020-11-30 (first published: 2020-11-17)
219 reads
Have you ever cringed when you received your monthly cloud bill? Does it feel like you’re overpaying for your cloud services, but don’t know how to reduce your monthly...
2020-11-27 (first published: 2020-11-16)
416 reads
An attendee at my PASS Summit precon on virtualized SQL Server performance tuning on Monday asked a great question. “Do you have a list of the tools and scripts...
2020-11-12 (first published: 2020-11-11)
278 reads
By Steve Jones
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day...
By John
In a recent video, I took a hands-on look at the Next Gen General...
By Rohit Garg
India’s 2025 tax reforms have introduced a bold shift in how income is taxed,...
We are in the process of upgrading to SQL Server 2022 and would like...
Comments posted to this topic are about the item How to Choose the Right...
Comments posted to this topic are about the item 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