2013-03-15 (first published: 2013-02-21)
7,869 reads
Scripts
2013-03-11 (first published: 2013-02-20)
2,179 reads
2013-03-08 (first published: 2009-10-02)
3,408 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,081 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,056 reads
2013-02-28 (first published: 2013-02-12)
1,155 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,132 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,678 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,312 reads
2013-02-22 (first published: 2013-02-05)
1,803 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers