Lincoln Bovee’ – Page 2 – LincolnBlog.net

SQL documentation tools and permissions required

Posted on 01/25/201801/26/2018 by Lincoln Bovee'

Database documentation tools like Devarts’ dbDocumenter will require, at a minimum, VIEW DEFINITION rights to the login:

USE myDatabase
GO

GRANT VIEW DEFINITION TO [DOMAIN\MyADGroup]

USE myDatabase

GRANT VIEW DEFINITION TO [DOMAIN\MyADGroup]

Views – 864

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…

PowerShell Robocopy GUI Tool – PowerCopy

Posted on 05/31/2017 by Lincoln Bovee'

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?

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

…

LincolnBlog.net

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

Author: Lincoln Bovee'

SQL documentation tools and permissions required

Random SQL tips and best practices

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)