Users , Roles and Logins
Useful script in cases where auditors would like to know roles for each user in each database of an instance as well as the status of associated logins.
2015-02-03 (first published: 2015-01-25)
2,942 reads
Check Table Size and DB Size
Two simple scripts to check table and database sizes. The scripts use temporary tables and the sp_msforeachdb/sp_msforeachtable stored procedures to present the output neatly.
2012-03-07 (first published: 2012-02-19)
2,678 reads
Blogs
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
Forums
Rebuild Index Job on a Large DB
We have a db close to 3 tb and rebuilding/ reorganizing indexes weekly is...
Authentication Error 0x8009030c
Hi, I'm using a small database on SQL Server 2019 on Windows 10 Pro....
how to stop command prompt window from appearing when running PowerShell script?
Hi everyone I have a PowerShell script that is run by Execute Process Task...
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers