Lincoln Bovee’ – LincolnBlog.net

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…

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

…

LincolnBlog.net

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

Author: Lincoln Bovee'

PowerShell Robocopy GUI Tool – PowerCopy

What is a .TUF file in the DATA folder?

Bulk-copy SQL Server Agent jobs to new server

Configuring SQL Database Mail

My Microsoft Code Extensions

Removing TempDB data files from SQL Server

How SQL Server processes a query

10987 Performance Tuning and Optimizing SQL Databases (OLL)

Resize a VirtualBox Linux VDI Disk under Windows Host

Protected: Installing SQL Server on Linux