PostgreSQL vs. SQL Server Notes
This blog will be where I post my PostgreSQL administration learning and it’s comparison to SQL Server from a SQL Server DBA’s viewpoint.…
Read MoreCategory: Best Practices
Availability Groups: Things to remember
Here are a few things to remember when working with Availability Groups: Backup and Restore NOTE: Using the Recovery Advisor GUI in SSMS…
Read More
Properly Taking a Cluster Offline for Disk Maintenance
I recently needed to replace the older, slower attached disks on our clustered SQL instance offline so as to copy each drive to…
Read More
Some database design guidelines and best practices
Below are some best practices known within the SQL Server database community use when designing tables. 1. All data columns should be properly…
Read More
Random SQL tips and best practices
Kevin Kline posted on wait states here with some valuable insight: TROUBLESHOOTING SQL SERVER WAIT STATS A number of these are from Adam…
Read More