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,409 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,802 reads
Blogs
Moving T-SQL Tuesday to Jekyll
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
European Microsoft Fabric Community Conference announcements
By James Serra
A TON of new features announcements at the European Microsoft Fabric Community Conference help...
Forums
An error occurred while skipping data rows
I am trying to build an ETL for an Existing Table. The ETL (SSIS)...
What is causing this error?
(This is probably the wrong forum to be posting this question, so please forgive...
Changetracking disabled in database snapshot, new bug in ms sql 2019 ?
Hi, We are using database snapshot together with changetracking to keep a datawarehouse up...
Question of the Day
Data Migration Assistant Targets
In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?
See possible answers