Administration – LincolnBlog.net

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…

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…

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…

Configuring SQL Database Mail

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

…

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…

Protected: Installing SQL Server on Linux

There is no excerpt because this is a protected post.

Using the KILL command

You can view the status of a KILL command used to stop an open transaction by typing the following:

KILL [SPID] WITH STATUSONLY

1	KILL [SPID] WITH STATUSONLY

Views – 839

LincolnBlog.net

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

Category: Administration

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

About Replication

Tearing down SQL Server Replication

Manually removing log-shipping