PowerShell to search for domain Computer objects
Query Active Directory Computer objects to verify existence
2013-05-01 (first published: 2013-04-16)
1,109 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)
975 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,739 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,691 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)
536 reads
2013-04-18 (first published: 2013-04-05)
1,464 reads
2013-04-17 (first published: 2013-04-03)
1,469 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,571 reads
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat kantor BCA KCU WISMA ASIA Telp:(0817)866887
??/WA:0817866887 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel., Kec....
Alamat kantor BCA KCU PONDOK INDAH ??/WA:(0817)866887
WA:0817866887 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec....
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers