SQL Server

External Article

Tell us about how you monitor your databases

  • Article

The 2021 State of Database Monitoring survey is now open, and we want to know how you’re currently tackling your server, instance, and database monitoring. By taking part, you’ll contribute to the sole industry-wide report on database monitoring, and provide insights into how SQL Server professionals manage their estates and what challenges they face. Plus, you’ll receive an advanced copy of the report and entry to a prize draw to win a $500 Amazon voucher.

2021-04-19

External Article

Checking for Missing Module References in a SQL Server Database Using Flyway

  • Article

There are certain checks that need to be done after a database migration is complete. One good example of this is the check that a migration script, such as one that merges changes from a branch into main, doesn't cause 'invalid objects' (a.k.a. 'missing references') in your databases. I'll show you how to run this check, using sp_RefreshSQLModule, and incorporate it into a Flyway "after" migration script.

2021-03-25

Blogs

The end of an era – why I chose not to renew my MVP

By

Two years ago, two things happened within a few days of each other. I...

PowerShell Strikes Back: A New Script

By

This is it. The final chapter of PowerShell Strikes Back. Over the past four...

Claude Desktop

By

Claude is more than a chat window. The desktop experience includes structured workspaces, generated...

Read the latest Blogs

Forums

Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Unraveling the Mysteries of the...

QUOTENAME Behavior

By Steve Jones - SSC Editor

Comments posted to this topic are about the item QUOTENAME Behavior

Running script without having permission to Function

By Reh23

Good Morning. I have a T-SQL Script which has been developed to execute a...

Visit the forum

Question of the Day

QUOTENAME Behavior

I use QUOTENAME() like this in code?

DECLARE @s VARCHAR(20) = 'Steve Jones'
SELECT QUOTENAME(@s, '>')
What is returned?

See possible answers