2025-12-29 (first published: 2025-12-25)
410 reads
2025-12-29 (first published: 2025-12-25)
410 reads
This script will save your database permissions into a table.
2025-12-29
301 reads
This script is used to generate the output file as CSV format for list of server.
2025-11-03 (first published: 2025-10-20)
830 reads
The script gets the database health check whether synchronized or not from the primary or secondary. This code needs to scheduled through as a job to get alerts.
2025-10-20 (first published: 2025-10-13)
652 reads
Get a list of all user permissions in a database
2025-10-15 (first published: 2025-10-13)
2,111 reads
Two PowerShell scripts to create backup folders and clean up old files.
2025-08-29 (first published: 2025-08-16)
338 reads
This script will help to find orphan users on all databases and will remove them.
2025-05-20
541 reads
2025-05-06
930 reads
This script runs a SQL server Health check for services, databases, Always On, replication, CDC job status.
2025-05-05
1,177 reads
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Wa:0817819444 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...
Wa:0817819444 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers