Database Growth History
This script uses the backup tables to get info on the growth of your database files.
2013-05-07 (first published: 2009-02-03)
15,169 reads
Scripts
Shrink DB and Log
Use this and shrunk a 176GB in under 20 secs to 105 MB. Ensure that you understand the potential issues with the recovery of your database.
2013-05-06 (first published: 2008-07-21)
14,004 reads
PowerShell to search for domain Computer objects
Query Active Directory Computer objects to verify existence
2013-05-01 (first published: 2013-04-16)
1,126 reads
PowerShell to Pre-Create domain objects for SQL Server Cluster
Pre-Create Active Directory Virtual Computer objects to support a new SQL Cluster
2013-04-30 (first published: 2013-04-15)
1,008 reads
Change DB Owner to sa for multiple DB's
Changes DB owner to sa for Online DB's where owner is not sa
2013-04-26 (first published: 2013-04-12)
2,770 reads
String Character Count
A while ago I once attended an interview where I was asked to write a short script that counts each letter of a given string.
2013-04-25 (first published: 2013-04-12)
1,697 reads
fnArabToEnglish(from Arabian number to english)
This function can convert a Arabian number to english,for example,if you input 1234.56, then you'll get 'One thousand two hundred thirty four and cents fifty six'.
2013-04-22 (first published: 2002-08-08)
544 reads
2013-04-18 (first published: 2013-04-05)
1,471 reads
2013-04-17 (first published: 2013-04-03)
1,486 reads
Restore Latest Backup with Powershell
Restores the latest backup of a database to a destination server of your choice, and creates a new backup if needed.
2013-04-16 (first published: 2013-03-30)
1,773 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
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