LincolnBlog.net

Copy Logins to another server with SIDs and passwords

Posted on 02/01/201602/04/2016 by Lincoln Bovee'

I often need to replicate logins to another SQL Server where the SID and password (for SQL login types, not Windows based) need…

Viewing the remaining restore time for rebuilding log-shipping

Posted on 01/25/201601/27/2016 by Lincoln Bovee'

I sometimes need to rebuild the log-shipping for a database and if it is a large database the windows dialogs only display the…

Recycling SQL Server Error Logs without restarting the SQL service

Posted on 01/13/2016 by Lincoln Bovee'

You can recycle the SQL Error Logs without restarting the SQL service by using either of these 2 commands:

USE master;
GO

-- system sproc
EXEC SP_CYCLE_ERRORLOG;

-- or

-- DBCC command
DBCC ERRORLOG;

USE master;

-- system sproc

EXEC SP_CYCLE_ERRORLOG;

-- or

-- DBCC command

DBCC ERRORLOG;

Views – 1794

Exploring WMI Resources and Tools

Posted on 01/05/201601/05/2016 by Lincoln Bovee'

Here are some resources and tools for exploring WMI for PowerShell development: WMI Explorer – SorceForge Views – 1963

Switching from SIMPLE to FULL Recovery Model

Posted on 01/05/2016 by Lincoln Bovee'

Important to note: if you switch from SIMPLE recovery model to FULL, you will need to take a full backup, otherwise you are…

Getting the groups an AD Principal is a member of

Posted on 12/18/201501/18/2016 by Lincoln Bovee'

This query will return, filter and sort the groups an AD account is a member of:

Get-ADPrincipalGroupMembership lboveeadm | select name | sort name

1	Get-ADPrincipalGroupMembership lboveeadm \| select name \| sort name

This query will return the AD…

USE master;
GO

SELECT	name, dbname
	FROM syslogins
	WHERE dbname = 'MyDatabase'
	ORDER BY dbname

SELECT	name AS LoginName, default_database_name
	FROM sys.server_principals
	WHERE default_database_name IS NOT NULL
	ORDER BY default_database_name

USE master;

SELECT name, dbname

FROM syslogins

WHERE dbname = 'MyDatabase'

ORDER BY dbname

SELECT name AS LoginName, default_database_name

FROM sys.server_principals

WHERE default_database_name IS NOT NULL

ORDER BY default_database_name

Views – 2011

SQL Server Page Types Explained

Posted on 11/10/2015 by Lincoln Bovee'

Here is a great blog post explaining the different SQL Server page types and how they work: Understanding Pages and Extents Views –…

…my observations in the world of SQL Server, PowerShell, Linux and PostgreSQL etc…