SQLServerCentral Article

More Intelligent Backup and Restore

Backups and restores are two fundamental tasks that a DBA must perform correctly. But remembering the syntax, options, decoding filenames, etc. can often be busy work that leaves a DBA open to mistakes. New author Vince Iacoboni brings us his code and techniques for a set of stored procedures to make handling backups and restores very simple.

Technical Article

Review of AdventNet SwisSQL Sybase to SQL Server Migration Tool 2.1

Now it's time to review yet another migration related product from AdventNet. It is called "AdventNet SwisSQL Sybase to SQL Server Migration Tool 2.1". As the name suggests, this migration product automates the conversion of Sybase ASE (Adaptive Server Enterprise) T-SQL stored procedures, inbuilt functions, triggers, tables, views, and other database objects to Microsoft SQL Server T-SQL.

SQLServerCentral Article

SSIS - Reusable Benchmark Harness

We all know testing is important, but face it, testing is not the highlight of anyone's daily work. And more important than testing your code the first time is regression testing after you have fixed a few bugs. Kristian Wedberg brings us a new article that uses SSIS to build a harness that allows repeatable testing of code and applying benchmarks to be sure that things are working as expected.

Technical Article

SQL Server 2000 SP3 and xp_cmdshell Woes

The problems caused by the SQL Sapphire Worm, also know as the SQL Slammer, have caused many sites to do a quick upgrade to SQL Server 2000 Service Pack 3 (SP3). It includes the fix that prevents infection by the worm. While moving to the latest service pack is usually a good thing, to do so without thorough testing risks breaking a working application. That is exactly what happened to one of my clients over the weekend.

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

XML_COMPRESSION for existing tables

By zoggling

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

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

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