Being Careful with Schema Ownership
When you create a schema, you might accidentally make yourself the owner, which can cause issues later. Learn how to ensure that your schemas aren't owned by transient employees.
2018-10-15
14,329 reads
Schema
Renaming a Schema in SQL Server
If you have a schema you want to retire, here's a method for moving all objects inside that schema to a new one.
2018-09-25
48,135 reads
Who Changed My Database Schema?
Have you ever wanted to know who made a schema change to your database? If so, that information is tracked in the default trace - Greg Larsen shows how to view it.
2017-03-28
6,381 reads
List schemas in a database
This is an expansion of the sys.schemas table.
User schemas are sorted to the top, schema type is decoded, schema authorization is included.
2015-07-14 (first published: 2015-06-10)
1,853 reads
Blogs
Azure – HorizonDB
By Vinay Thakur
As Open Source – PostgreSQL and AI is a growing and powerful DB system,...
A New Chapter: Why I Made the Move from Dayforce to ESO
By gbargsley
A New Chapter: Why I Made the Move from Dayforce to ESO Over the...
Lean Six Sigma – Brief
By Vinay Thakur
When you have a project or system, it has to be optimized, tuned, and...
Forums
ALAMAT KANTOR BCA KCU METRO TLP/WA 0817825533
Hub Cs:0817825533 Jl. Jendral Sudirman No.106, Imopuro, Metro, Kota Metro, Lampung 34111
ALAMAT BCA KCU BANDAR LAMPUNG TLP/WA 0817825533
Hub Cs:0817825533 Jl. Yos Sudarso No.100, Bumi Waras, Kec. Bumi Waras, Kota Bandar Lampung,...
ALAMAT KANTOR BCA KCU JAMBI TLP/WA 0817825533
Hub Cs:0817825533 Jl. Dokter Sutomo No.50-50A, Ps. Jambi, Kec. Ps. Jambi, Kota Jambi, Jambi...
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers