Administration – LincolnBlog.net

PostgreSQL vs. SQL Server Notes

Posted on 02/13/201902/19/2019 by Lincoln Bovee'

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.…

Properly Taking a Cluster Offline for Disk Maintenance

Posted on 08/14/201808/14/2018 by Lincoln Bovee'

I recently needed to replace the older, slower attached disks on our clustered SQL instance offline so as to copy each drive to…

Building an AlwaysOn Availability Group SQL Cluster

Posted on 03/07/201801/17/2019 by Lincoln Bovee'

Here are the steps to build at SQL Server 2017 AlwaysOn Availability Group. We will be using Windows 2016 Standard 64-bit for the…

Random SQL tips and best practices

Posted on 06/20/201712/13/2017 by Lincoln Bovee'

Kevin Kline posted on wait states here with some valuable insight: TROUBLESHOOTING SQL SERVER WAIT STATS A number of these are from Adam…

What is a .TUF file in the DATA folder?

Posted on 05/30/2017 by Lincoln Bovee'

The TUF files you see in the ..\DATA folder is a “transaction undo file” which contains modifications to the database that were not…

Bulk-copy SQL Server Agent jobs to new server

Posted on 03/23/201703/23/2017 by Lincoln Bovee'

The easiest way to bulk-copy all SQL Agent jobs to a new server is to follow these steps 1. Load SSMS and connect…

Configuring SQL Database Mail

Posted on 01/19/201706/24/2017 by Lincoln Bovee'

Here is a sample script for configuring database mail in the event you want to automate your SQL installs.

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

EXEC sys.sp_configure 'Advanced options', 1;

RECONFIGURE

EXEC sys.sp_configure;

USE msdb

--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

…

KILL [SPID] WITH STATUSONLY

1	KILL [SPID] WITH STATUSONLY

Views – 1097

LincolnBlog.net

…my observations in the world of SQL Server, PowerShell, .Net etc…

Category: Administration

PostgreSQL vs. SQL Server Notes

Properly Taking a Cluster Offline for Disk Maintenance

Building an AlwaysOn Availability Group SQL Cluster

Random SQL tips and best practices

What is a .TUF file in the DATA folder?

Bulk-copy SQL Server Agent jobs to new server

Configuring SQL Database Mail

Removing TempDB data files from SQL Server

Protected: Installing SQL Server on Linux

Using the KILL command