LincolnBlog.net

Restoring a database using STOPATMARK

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

This post will demonstrate how to restore a database from a log file up to a certain LSN (typically the one right before…

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…

Some database design guidelines and best practices

Posted on 01/29/201803/12/2018 by Lincoln Bovee'

Below are some best practices known within the SQL Server database community use when designing tables. 1. All data columns should be properly…

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

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

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

Restoring a database using STOPATMARK

Properly Taking a Cluster Offline for Disk Maintenance

Some database design guidelines and best practices

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