SSIS and incremental load with CDC
These YouTube videos are useful if you want to learn how to use SSIS with SQL Server CDC:
SQL Server
SQL Server Integration Services SSIS 2016 Tutorial
https://www.mssqltips.com/sqlservertutorial/9053/sql-server-integration-services-ssis-2016-tutorial/
Reset the password for sa user in SQL Server
osql -S “SERVER_NAME\INSTANCE_NAME” -E -Q “exec sp_password NULL, ‘NewPassword’,’sa’”
Speeding up database access
This is a very thorough article on ways to speed up a SQL database by Matt Perdeck Speeding up database access – Part 1: Missing indexes
Script to restore SQL Server database
A lot of people know how to restore an SQL Server database using the SQL Server Management Studio. Sometime it will not work if the database is in use. You have to close all active connections or even to take database offline and then online again. It is much easier to restore the database via … Read more
TRUNCATE Log File in SQL Server 2008
USE [TestDb] GO ALTER DATABASE [TestDb] SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE(TestDbLog, 1) ALTER DATABASE [TestDb] SET RECOVERY FULL WITH NO_WAIT GO