Spring DevConnections 2012
Hello Dear Reader, this week finds me in beautiful Miami FL. Next week I’ll be in Vegas, for one night...
2012-03-21
649 reads
SQLBalls
I’m Going to SQL RALLY!
Hello Dear Reader, I’ve just received great news I’M HEADED TO SQL RALLY 2012! But I didn’t get here on...
2012-02-27
757 reads
SQL Rally 2012 Vote For Me!
Hello Dear Reader! Last year I tossed my hat in the ring on the world of Presenting. This was a...
2012-02-06
759 reads
Pragmatic Works Has Balls...SQLBalls
http://www.flickr.com/photos/54296260@N05/6036813377/
That is right Dear Reader, I am making the jump, Starting Monday February 6th I will be a Sr. Consultant...
2012-02-03
911 reads
Thank You & Goodbye Publix
It's been a little quite here at SQLBalls.com Dear Reader, but business is about to pick up. There are a...
2012-02-02
769 reads
Nothing Changes If You Don't Volunteer
http://www.flickr.com/photos/cubagallery/4690390650/
Hello Dear Reader, last time on Day's of Our Lives there was an election, some people resigned, and other's...
2012-01-25
793 reads
You Should Never Use Backup Log Truncate_Only Except...
http://www.flickr.com/photos/paulhagon/369576792/I want to start this blog out with a Warning Dear Reader. The technique that I am going to describe...
2011-12-06
801 reads
What Opportunity Are You Looking For?
http://www.flickr.com/photos/mencho-22/6218974134/
A lot has been happening this year. I decided to throw my hat in the ring at being a blogger...
2011-11-28
737 reads
Presenting on SQL Internals, Recovery Models, & Backups! OH MY Today
Today I’m presenting “SQL Internals, Recovery Model’s, and Backups. OH MY!”, for Pragmatic Works. I did this presentation once before...
2011-11-01
479 reads
Tales from the Query Processor
http://www.flickr.com/photos/socal_jim/2070088596/Hello Dear Reader! I've been a bit behind on the blogging but wanted to give you a bit of a...
2011-10-31
1,489 reads
Blogs
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,...
Build a C++ Pipeline with Docker, GitHub Actions, Azure ACR and Azure App Service
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...
Forums
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...
Adding Defaults
Comments posted to this topic are about the item Adding Defaults
Multiple Monitoring Tools
Comments posted to this topic are about the item Multiple Monitoring Tools
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