Function to convert UserAccountControl number to details text
Function that converts AD UserAccountControl number to details text
2015-07-27 (first published: 2013-05-14)
2,798 reads
Function that converts AD UserAccountControl number to details text
2015-07-27 (first published: 2013-05-14)
2,798 reads
This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.
2015-07-23 (first published: 2015-06-23)
1,331 reads
If you want to monitor few specific alerts for SQL Replication (Merge and Transnational), you can may consider adding these 14 alerts.
2015-07-21 (first published: 2015-06-16)
1,501 reads
To monitor SQL service and the host server is up and running, if down send e-mail to DBA
2015-07-16 (first published: 2015-06-15)
2,131 reads
This script simply returns the most recent restore information about databases for a server.
Returns the destination database name, the device used to perform the restore and the restore date.
2015-07-15 (first published: 2015-06-10)
756 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,864 reads
2015-07-10 (first published: 2015-06-11)
1,005 reads
IF you have need to schedule job to cleanup backup files older than N days, you can use my written script.
2015-07-02 (first published: 2015-06-04)
691 reads
This script either generates or execute statements to SQL data and log files from C:\ to D:\
2015-07-01 (first published: 2015-06-03)
2,502 reads
-- Backup Growth Trend Check To Understand how much disk space you need in future
2015-06-23 (first published: 2015-06-02)
1,298 reads
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers