June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – CDC and TRUNCATE – Cannot truncate table because it is published for replication or enabled for Change Data Capture

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
CDC, SQL Error Messages, SQL Scripts, SQLAuthority Author Visit
Few days ago, I got the great opportunity to visit Bangalore Infosys. Please read the complete details for the event here: SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore. I mentioned during the session that CDC is asynchronous and it reads the log file to populate its data.…
Read More

SQLAuthority News – Migrating DTS Packages to Integration Services

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Business Intelligence, Data Warehousing, SQL White Papers
Migrating DTS Packages to Integration Services Writer: Brian Knight Published: July 2008 SQL Server Integration Services (SSIS) brings a revolutionary concept of enterprise-class ETL to the masses. The engine is robust enough to handle hundreds of millions of rows with ease, but is simple enough to let both developers and…
Read More

SQL SERVER – Differences in Vulnerability between Oracle and SQL Server

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Business Intelligence, Database, DBA, MySQL, Oracle, SQL Documentation, SQL Download
In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more stable and more secure than SQL Server from Microsoft. This is due to a variety of reasons; but in my opinion, the main ones are listed below: A.…
Read More