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
9,823 reads
This article shows how you can find which objects in your database might not be valid after schema changes.
2023-03-13
9,823 reads
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
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
SQL doesn’t really give us too many tools out of the box to allow...
Did you know that you can change the browser used by SQL Server Management...
By DataOnWheels
A few months ago, I wrote a post on how I use voice technology...
Hi All, Our server team is planning to move secondary data centre from one...
Hello everyone, I am importing from a csv file into a table. Everything works...
Hi all, The app server is running on Linux. SQL server is running on...