Fix Orphan Users for Instance Migration
Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.
2016-01-04 (first published: 2015-12-17)
1,558 reads
Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.
2016-01-04 (first published: 2015-12-17)
1,558 reads
Script uses undocumented extended stored procedure xp_readerrorlog to find failed logins (grouped) and last successful login
2015-12-30 (first published: 2015-12-15)
1,819 reads
2015-12-29 (first published: 2015-12-09)
1,970 reads
This script adds empty first step for every job for easier job history viewing.
2015-12-28 (first published: 2015-12-10)
1,848 reads
2015-12-25 (first published: 2015-12-17)
1,688 reads
2015-12-23 (first published: 2015-10-19)
2,000 reads
A script to get the user table query ratio and update radio,etc
2015-12-21 (first published: 2015-12-11)
1,756 reads
2015-12-18 (first published: 2015-12-09)
3,971 reads
This script outputs sql server service, start type, status, Service Account, installation location, start up time, uptime of sql server related services along with startup trace flags.
2015-12-17 (first published: 2015-12-09)
1,126 reads
Use this script to set recommended Log files size growth for larger DBs. For more, please refer article: http://sqlmag.com/blog/choosing-default-sizes-your-data-and-log-files
2015-12-15 (first published: 2015-12-07)
1,216 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hello , I'm having an issue with a SQL Server VM that has 30...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers