Lincoln Bovee’ – Page 2 – LincolnBlog.net

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

…

My Microsoft Code Extensions

Posted on 01/11/201701/11/2019 by Lincoln Bovee'

Here are the current set of MS Code extensions I use on a daily basis. Views – 1182

Removing TempDB data files from SQL Server

Posted on 01/05/201701/05/2017 by Lincoln Bovee'

I had a situation where a SQL Server 2016 install did not install correctly. The install completed but when I tried to move…

How SQL Server processes a query

Posted on 12/14/201612/14/2016 by Lincoln Bovee'

The logical order in which SQL Server parses a query and generates an execution plan: 1. FROM [left_table] 2. ON [join_condition] 3. [join_type]…

10987 Performance Tuning and Optimizing SQL Databases (OLL)

Posted on 12/12/201601/10/2017 by Lincoln Bovee'

10987B – Performance Tuning and Optimizing SQL Databases Trainer: Bill Chapman Download Companion Content for Microsoft Official Courseware (MOC) Online Syllabus for Course…