PowerShell to search for domain Computer objects
Query Active Directory Computer objects to verify existence
2013-05-01 (first published: 2013-04-16)
1,106 reads
Scripts
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)
971 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,732 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,689 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)
535 reads
2013-04-18 (first published: 2013-04-05)
1,463 reads
2013-04-17 (first published: 2013-04-03)
1,468 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,768 reads
Retrieve SQL Instance Connect Info
This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port
2013-04-11 (first published: 2013-03-24)
1,470 reads
2013-04-05 (first published: 2009-03-27)
4,559 reads
Blogs
T-SQL Tuesday #199 Invitation: Back to on-prem?
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
Error Deploying GraphQL in Fabric: dm_exec_describe_first_result_set
A while ago we suddenly had an error while trying to deploy one Fabric...
Forums
BCA KCP Tumpang Call Center/Telpon 0818-740-011
WhatsApp:0818-740-011 Jl. Raya Tumpang No.1, Ledoksari, Tumpang, Kec. Tumpang, Kabupaten Malang, Jawa Timur 65156
BCA KCP Singosari Call Center/Telpon 0818-740-011
WhatsApp:0818-740-011 Jl. Raya Singosari No.91 A, Losari, Kec. Singosari, Kabupaten Malang, Jawa Timur 65153
BCA KCP Blimbing Call Center/Telpon 0818-740-011
WhatsApp:0818-740-011 Jl. Ahmad Yani No.183, Purwodadi, Kec. Blimbing, Kota Malang, Jawa Timur 65125
Question of the Day
Secure Cached Plans
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers