Budget several SQL Server instances on one Windows host, inventory services, assign memory and ports, and monitor shared resource pressure.
SQL SERVER – How to Invoke SSMS Help From Command Prompt?
A workshop attendee asked how to invoke SSMS help from Command Prompt. Here is how to open SSMS from the command line and list all of its parameters.
SQL SERVER – Windows Authentication or System Admin Account (SA)
Windows Authentication or the SA account? A client asked me in a Health Check, and here is why my advice is Windows Authentication wherever you can.
PostgreSQL – Storing Unicode Characters is Easy
PostgreSQL varchar can store Unicode with suitable database and client encodings. My example stores ЯНВАРЬ, the Russian word for January.
Tracking Backup Throughput and Duration From msdb History
Track backup throughput and duration from msdb history, compare recent trends, and keep striped devices from duplicating backup totals.
SQL SERVER – New Parallel Operation Cannot be Started Due to Too Many Parallel Operations Executing at this Time
A client’s ERRORLOG said: New parallel operation cannot be started due to too many parallel operations executing at this time. Here is what I found behind it.
Scheduling Recurring Events: Every Second Tuesday in T-SQL
Generate recurring events with stable weekday arithmetic, monthly ranking, and anchored fourteen-day rules instead of endless date rows.