Set standard database options
Ensure all your databases have standardised options by running this script weekly.
2011-09-19 (first published: 2007-12-17)
2,122 reads
Ed Vassie
Script a Database Role
Script one or all roles in a database. Includes users, obect permissions and column permissions.
2011-09-08 (first published: 2008-01-08)
5,249 reads
Blogs
Daily Coping 24 Sept 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using environment variable files for SQL Server in containers
There are a whole bunch of environment variables that can be used to configure...
How to Design Backups in SQL Server?
By nelsonaloor
The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...
Forums
Need an urgent help with creating a relational database!!
Hi guys, I'm quite new to T-SQL and honestly started to take online classes...
Need to Convert SQL Code Written for Azure SQLDW to SQL Server 2016
Hello Community, The attached SQL Script (Procedure) is compiled / written for Azure SQL...
SQL join based on column value
I am trying to join two tables based on the condition. Table1: ID ...
Ask SSC