About Availability Groups Database Seeding
This post will serve to describe all things regarding adding databases and trouble-shooting issues with Availability Groups Availability Group Direct Seeding: How to…
Read More
About Collations in SQL Server
This post will be fore the purpose of documenting all my findings regarding Collations in SQL Server, including changing the collation on an…
Read More
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 More
Restoring a database using STOPATMARK
This post will demonstrate how to restore a database from a log file up to a certain LSN (typically the one right before…
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
Building an AlwaysOn Availability Group SQL Cluster
Here are the steps to build at SQL Server 2017 AlwaysOn Availability Group. We will be using Windows 2016 Standard 64-bit for the…
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
SQL documentation tools and permissions required
Database 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 – 666
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
PowerShell Robocopy GUI Tool – PowerCopy
Here is a very cool PowerShell script that creates a Windows form front-end GUI for RoboCopy: PowerShell Robocopy GUI Tool – PowerCopy Views…
Read More