2013-03-11 (first published: 2013-02-20)
2,153 reads
Scripts
2013-03-08 (first published: 2009-10-02)
3,406 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,065 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,043 reads
2013-02-28 (first published: 2013-02-12)
1,151 reads
ERRORFILE and MAXERRORS option with BULK INSERT
ERRORFILE and MAXERRORS option are rarely used important arguments in BULK INSERT so, I will try to highlight the use of these arguments in this script.
2013-02-27 (first published: 2013-02-14)
6,116 reads
Powershell - Query SQL Servers Operating system details
The script works through the CMS you have set up to manage your environment and gathers various server information.
2013-02-26 (first published: 2013-02-05)
1,672 reads
List Jobs and their respective programming.
List all active Jobs in SQL Server with the details of the schedule.
2013-02-25 (first published: 2013-02-07)
1,310 reads
2013-02-22 (first published: 2013-02-05)
1,791 reads
Script to Rebuild/Reorganise Indexes
A script to get the fragmentation of indexes in a database and then rebuild or reorganise accordingly
2013-02-19 (first published: 2013-01-29)
2,133 reads
Blogs
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Forums
Alamat Kantor BCA KCU Batam Telp:08218200203
Hub Via Wa:628218200203 Alamat: Jl. Dokter Sutomo No.50-50A, Ps. Jambi, Kec. Ps. Jambi, Kota...
Alamat Kantor BCA KCU Kisaran Telp:08218200203
Hub Via Wa:628218200203 Alamat: Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat,...
Alamat BCA KCU Pematang Siantar Tlp:08218200203
Hub Via Wa:628218200203 Alamat: Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar,...
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers