I have installed a lab for my SQL environment. After I enabled Bitlocker on it, all of a sudden, the disks turned to be “READ ONLY” status. After navigating some solutions, finally the old way is still working for my situation:

One of our SSIS projects encountered a repeated error regarding the error as subject.


I look at the package. It still uses the old Microsoft OLEDB driver for Oracle. And one of Windows Update was mentioned in the link below has been installed on the server.

So, we have to apply the post-fix to fix it. Please follow the link above to solve your problem.
It took 10 minutes to identify my 2 TB Portable USB. And when I move to the new PC, it became the RAW status

Solution: Partition Redo. Delect Volumn > Make a 50MB Partition > Format > Make the rest of space as another Partition > Format > Unallocate all of two partitions > Format > Done!!

Could not find stored procedure 'sys.sp_cdc_parse_captured_column_list'

SQL version: 2016 RC1
CDC for Oracle: 4.0

Hope Microsoft can fix it when the official release published.
Get Processing Range error Timeout


It's because you have a CDC transaction not committed yet.



Find out the active sessions running the program: MSXDBCDC$OracleCDCService1$xxxxYourCDC Database

Kill the sessions
Rerun the Initial Load for "Mark Initial Load Start" and "Mark initial load end"

The dates are mot Match. Why? I don't know, I just migrated Oracle to another server but kept the same server name and configuration. Only one thing changed was the IP.

Check Firewall and DNS.
If DNS can't be modified. Try to modify the "hosts" file.
The environment for SQL Replication is 3 level:

Multiple Publisher (Changed default port in SQL local and Client)
Remote Distributor (Changed default port in SQL local and Client)
Multiple Subscriber (Changed default port in SQL local and Client)

When I set up Publisher and Distributor as one server (same SQL Instance), then the agent will succeed.
But when I set up Publisher as an Individual SQL Server and a Remote Distributor at the other SQL server. The SQL Replication will fail.

The message I received below:

Message: Named Pipes Provider: Could not open a connection to SQL Server [5]. 
Message: Cannot initialize the data source object of OLE DB provider "SQLNCLI11" for linked server "repl_distributor". 

This could be done through a few code steps. Please follow the instruction below:

Save your Excel File as “Excel Marco-Enabled Workbook (*.xlsm)

·         Add one column to help you to identify which filed has Capital character visibly
·         Type the formula in to the filed (Change your target field, in the case is A2), then apply to the whole column
IF it returns “FALSE”, it means you have UPPER case in the field

After a two-week long time of studying the document and having a lots conversations with the vendor and System admin. I finally figured out the security scope for the SQL DBs on SCSM.

Document download link: http://www.microsoft.com/en-us/download/details.aspx?id=27850

Neither the vendor or the document would cover 100% correct settings on practical environment. At least not mine in my company.

I will list the summary below