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 MoreCategory: Administration
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
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
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
What is a .TUF file in the DATA folder?
The TUF files you see in the ..\DATA folder is a “transaction undo file” which contains modifications to the database that were not…
Read More
Bulk-copy SQL Server Agent jobs to new server
The 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
Configuring SQL Database Mail
Here is a sample script for configuring database mail in the event you want to automate your SQL installs.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
EXEC sys.sp_configure 'Advanced options', 1; RECONFIGURE EXEC sys.sp_configure; USE msdb GO --Step1: Varifying the new profile SELECT * FROM sysmail_profile --Step2: Verifying accounts SELECT * FROM sysmail_account --Step3: To check the accounts of a profile SELECT * FROM sysmail_profileaccount WHERE profile_id = 3 --Step4: To display mail server details SELECT * FROM sysmail_server select * FROM sysmail_allitems |
…
Read More
Removing TempDB data files from SQL Server
I had a situation where a SQL Server 2016 install did not install correctly. The install completed but when I tried to move…
Read More