2022-09-02 (first published: 2022-08-23)
2,052 reads
2022-09-02 (first published: 2022-08-23)
2,052 reads
2020-01-03
783 reads
2019-12-13
608 reads
2019-12-06
726 reads
2019-11-29
597 reads
2019-08-13
1,137 reads
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
10,944 reads
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
36,243 reads
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
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,748 reads
This is part of a series of new job blog posts. You can find...
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Back in December 2019, I started presenting my session on mental health with lots...
I am having Below Table i want to get Result as shown in the...
what I want is to apply some filter patterns to search the data. For...
Hi All, Using Tsql query I want to know currently running sql agent jobs...