Automate Data Purity Investigation
Sometimes running DBCC CHECKDB WITH DATA_PURITY returns thousands of affected columns. This script automates the identification of those columns.
2015-04-13 (first published: 2013-07-04)
2,357 reads
Richard Fryar
Script Login Differences
Compare the logins and users on two instances and generate a TSQL script to make them the same.
2015-02-26 (first published: 2013-11-15)
2,672 reads
Blogs
Azure Platform Series: How to setup Azure Cloud Shell
By HamishWatson
This blog post will be a series on the Azure Platform and some things...
Daily Coping 5 June 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing
I’m working on a project where it’s useful to automate environment setup and teardown...
Forums
Attach and Detach Method vs SQL Manage object method
Hi there, if you want to detach a database you would right click on...
How to generating Excel File with multi sheet by using SQL server 2012?
I need to create stored procedure or query or any thing on SQL server...
performance tuning for a subquery
Hey Guys I have a quick questions regarding a better way to write a...
Ask SSC