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 MoreThis 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 MoreThis post will demonstrate how to restore a database from a log file up to a certain LSN (typically the one right before…
Read MoreI recently needed to replace the older, slower attached disks on our clustered SQL instance offline so as to copy each drive to…
Read MoreHere are the steps to build at SQL Server 2017 AlwaysOn Availability Group. We will be using Windows 2016 Standard 64-bit for the…
Read MoreBelow are some best practices known within the SQL Server database community use when designing tables. 1. All data columns should be properly…
Read MoreDatabase documentation tools like Devarts’ dbDocumenter will require, at a minimum, VIEW DEFINITION rights to the login:
1 2 3 4 |
USE myDatabase GO GRANT VIEW DEFINITION TO [DOMAIN\MyADGroup] |
Views – 620
Read MoreKevin Kline posted on wait states here with some valuable insight: TROUBLESHOOTING SQL SERVER WAIT STATS A number of these are from Adam…
Read MoreHere is a very cool PowerShell script that creates a Windows form front-end GUI for RoboCopy: PowerShell Robocopy GUI Tool – PowerCopy Views…
Read MoreThe TUF files you see in the ..\DATA folder is a “transaction undo file” which contains modifications to the database that were not…
Read MoreThe easiest way to bulk-copy all SQL Agent jobs to a new server is to follow these steps 1. Load SSMS and connect…
Read More