Find Invalid Objects in SQL Server
This article shows how you can find which objects in your database might not be valid after schema changes.
2025-10-06
9,019 reads
Database objects
Find Invalid Objects in SQL Server
This article shows how you can find which objects in your database might not be valid after schema changes.
2023-03-13
22,057 reads
Associating Data Directly with SQL Server Database Objects.
It is easy to attach details and documentation to a SQL Server database using extended properties. In fact, you can add a number of items of information to any database objects such as tables, views, procedures or users.
2019-11-19
Painless Refactoring of SQL Server Database Objects
Refactoring a database object can often cause unexpected behavior in the code that accesses that object. In this article, adapted from his excellent book, Defensive Database Programming with SQL Server, Alex Kuznetsov discusses several techniques that will harden your code, so that it will not break, or behave unpredictably, as a result such changes.
2015-04-08
11,414 reads
Blogs
Chatting with Power BI: Who Benefits from This Conversation?
By Rayis Imayev
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Prepping for Certification, Part 2 of ?
By Brian Kelley
The advantage of understanding the make-up of the exam: I can tailor my efforts...
Forums
SQL Server 2025 Build List
Comments posted to this topic are about the item SQL Server 2025 Build List
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers