External Article

Do You Have REFERENCES?

The logic for referential integrity can be implemented in application code, but to make sure that it is enforced, include foreign key constraints in the database design instead. In this article, Joe Celko talks about the history of references in SQL and the options available today.

SQLServerCentral Article

SSISDB Catalog Defaults Best Practices

Introduction The SSISDB database (a.k.a. the SSISDB catalog) was introduced back in SQL Server 2012 to de-clutter the MSDB database and provide an in-house logging and reporting infrastructure. In a nutshell, SSISDB is an SSIS framework making SQL Server Integration Services more robust and enterprise-friendly by providing the following features: Database backup Database encryption Support […]

Blogs

Advice I Like: Failure

By

If it fails where you thought it would fail that is not a failure....

Data Conferences – Worth Every Dollar

By

Some of the best career enhancers you can buy.   Why I Go to...

SQL Server 2025 RegEx and AI

By

One of the language changes in SQL Server 2025 that I’ve seen a lot...

Read the latest Blogs

Forums

SQL 2022 stuck on xp_delete_file

By PJ_SQL

SQL 2022 hangs on xp_delete_file, it works for a while when sever is rebooted...

Select @ for different fields

By bswhipp

I have a need where I need to pass a field name to a...

Getting the Object Code

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the Object Code

Visit the forum

Question of the Day

Getting the Object Code

What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database? 

SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; 
GO

See possible answers