Ryan Adams

Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.

Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.

All authors

Blog Post

MSDTC Supported Configurations

The MSDTC Configuration Conundrum MSDTC configuration is not as straight forward as you might think.  It’s a different choice if you are using a local MSDTC, clustered MSDTC, on-premises,...

2018-07-06

6 reads

Blog Post

MSDTC Supported Configurations

The MSDTC Configuration Conundrum MSDTC configuration is not as straight forward as you might think.  It’s a different choice if you are using a local […]
The post MSDTC Supported...

2018-07-06

1 reads

All authors

Blogs

Exploring the Next Gen General Purpose Tier in Azure SQL Managed Instance

By

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

India’s 2025 tax reforms have introduced a bold shift in how income is taxed,...

Build a C++ Pipeline with Docker, GitHub Actions, Azure ACR and Azure App Service

By

In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...

Read the latest Blogs

Forums

How to Choose the Right Tool for MS SQL to PostgreSQL Migration

By intellicon

Comments posted to this topic are about the item How to Choose the Right...

Adding Defaults

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding Defaults

Multiple Monitoring Tools

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Monitoring Tools

Visit the forum

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
GO
What happens when I run these two batches?

See possible answers