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
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
Using SQL Alerts to Spot Suspicious Activity in SQL
SQL doesn’t really give us too many tools out of the box to allow...
How to Change the Browser Used by SSMS for AAD Auth
Did you know that you can change the browser used by SQL Server Management...
Typing with Your Tongue Part 2: Voice Access
By DataOnWheels
A few months ago, I wrote a post on how I use voice technology...
Forums
DC migration SQL DB suggestion
Hi All, Our server team is planning to move secondary data centre from one...
SSDT import into a table from .csv corruption
Hello everyone, I am importing from a csv file into a table. Everything works...
Login failures while connecting from Linux to SQL on windows
Hi all, The app server is running on Linux. SQL server is running on...
Ask SSC