monitor

External Article

Easily manage SQL Server licensing with SQL Monitor 10.1

  • Article

SQL Monitor 10.1 now gives you a comprehensive overview of your SQL Server licensing, so you know which licenses are in use, and which versions are on which servers. This simplifies license auditing and lets you unearth misconfigurations that could potentially cost you money. The new version also integrates with Microsoft Teams and Splunk, and supports complex Active Directory environments.

2020-07-02

External Article

Help us define the state of SQL Server monitoring in 2019

  • Article

Last year we ran the industry’s first ever state of SQL Server monitoring survey, the results not only gave great insight for the community but helped us shape our product development to ensure we were meeting the needs that you were asking for. So what has changed in a year? Tell us for your chance to win a $250 Amazon voucher.

2019-04-03 (first published: )

2,280 reads

External Article

Have your say on the state of SQL Server monitoring

  • Article

In this blog, we review the key insights from last year’s State of SQL Server Monitoring report. One year on, how has this changed? Read the blog to find out how you can help us define the state of 2019 plus a chance to win a $250 Amazon voucher.

2019-04-02 (first published: )

1,864 reads

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