Powershell - Document your environment
This script is an improvement from my original script entitled "Powershell - Query SQL Servers Operating system details".
2013-03-22 (first published: 2013-02-27)
2,415 reads
Scripts
2013-03-21 (first published: 2013-02-27)
1,273 reads
2013-03-19 (first published: 2013-03-01)
1,070 reads
Script to get max dates on tables that contain a certain column.
This script will allow you to get maximum date associated with tables that contain a certain column.
2013-03-18 (first published: 2013-02-22)
1,181 reads
2013-03-15 (first published: 2013-02-21)
7,883 reads
2013-03-11 (first published: 2013-02-20)
2,190 reads
2013-03-08 (first published: 2009-10-02)
3,410 reads
SQL 2012 Always On Status Report
This script will produce a report on the status of the Always On replication.
2013-03-05 (first published: 2013-02-08)
4,091 reads
Copy Triggers from One DB to Another
A simple script that transfers triggers from one database to another.
2013-03-04 (first published: 2013-02-12)
4,057 reads
2013-02-28 (first published: 2013-02-12)
1,166 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Alamat Kantor BCA KCP Talavera Telp/Wa:0821-8200-233
CSO 08218200233 Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec....
Alamat BCA KCP Mega Kuningan Telp/Wa:0821-8200-203
CSO 08218200203 Lingkar Mega Kuningan No.Blok E 4, RT.5/RW.2, Kuningan, Kuningan Tim., Kecamatan Setiabudi,...
Alamat BCA KCP Wisma Mulia Telp/Wa:0821-8200-174
CSO 08218200174 Jl. Gatot Subroto No.42 Suite G02, RT.3/RW.2, Kuningan Bar., Kec. Mampang Prpt.,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers