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
21,481 reads
Database objects
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
T-SQL Tuesday #187–Solving Problems
By Steve Jones
This month we have a great invite from Joe Fleming, a first time host...
T-SQL Tuesday #187: It’s Extended Events. It’s Always Extended Events
Joe Fleming wants to know how I solve weird problems. I’m not sure I’m...
Starting Points for Quantum Computing Learning
By Brian Kelley
I didn't have these in my slides for the Techno Security & Digital Forensics...
Forums
How to add metadata for every record in Azure postgres tables
Hi, I have a situation in one of the applications I am working on...
average duration increasing inline with exec counts
As the title says , I've got a handful of stored procs where the...
Window Functions in a View
Is there a trick to get a where clause filter to push into a...
Question of the Day
Adding Lots of Dates
The second parameter for the EOMONTH() function is an integer. In June 2025, if I run this code, what is returned?
DECLARE @d DATE = GETDATE() SELECT EOMONTH(@d, 95695)See possible answers