PASS SQL Saturday in Parma
This year, 22 November, PASSSQL Saturday will come to Parma, my birth town. I’m proud to be the organizer of that event.Our community,...
2014-07-30
956 reads
This year, 22 November, PASSSQL Saturday will come to Parma, my birth town. I’m proud to be the organizer of that event.Our community,...
2014-07-30
956 reads
I’ve already spoken about source controlling database using Visual Studio Online and Red-Gate SQL Source Control in this post. The described kind...
2014-06-11
1,341 reads
Recently I moved my job on ALM topics, focusing on Source Control Management and Testing, in order to reach Continuous...
2014-03-03
516 reads
You can download the english version of my sessions at SQL Saturdays (on SlideShare):
SQL Saturday 257 in Verona: “Put databases...
2013-12-16
299 reads
“Put databases under source control” slide deck is available here. The SQL Saturday – Verona event was a great success. Now we’re waiting for...
2013-11-18
465 reads
This year I will speak at PASSSQL Saturday in Verona with a session based on database and source control management.
“PASS SQLSaturday’s...
2013-10-28
323 reads
In a previous post we’ve seen how to share the SQL Prompt snippet folder to the development team. We’ve used dropbox for sharing...
2013-07-16
989 reads
Red-Gate SQL Prompt is a plugin for SQL Server Management Studio that makes the developers life easier when writing t-sql....
2013-06-25
1,858 reads
During the last few years I’ve been involved in database source control management and release plans tasks. These are important...
2013-03-14
767 reads
By Rohit Garg
India’s 2025 tax reforms have introduced a bold shift in how income is taxed,...
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
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
Comments posted to this topic are about the item Multiple Monitoring Tools
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