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,797 reads
Function that converts AD UserAccountControl number to details text
2015-07-27 (first published: 2013-05-14)
2,797 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,500 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,130 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)
755 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,862 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)
689 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,496 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
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers