Error - LoadLibraryFromPath: FQ Dll C:\Windows\oci.dll is not found

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

Solution:

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.
https://support.microsoft.com/en-us/kb/3147071

So, we have to apply the post-fix to fix it. Please follow the link above to solve your problem.

[Windows] 2 TB Portable Detection Slow

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!!

[CDC] SQL 2016 CDC for Oracle could not find sys.sp_cdc_parse_captured_column_list

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.

[CDC] Get Processing Range error Timeout

Get Processing Range error Timeout

Reason:

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

Solution:

DBCC OPENTRAN

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"
Fixed.

CDC for Oracle: Why the component works but I don't get the latest data

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.

[Replication] Error: Microsoft SQL Server Native Client 11.0 : SQL Server Network Interfaces

Check Firewall and DNS.
If DNS can't be modified. Try to modify the "hosts" file.

[Replication] Named Pipes Provider or Cannot initialize the data source object of OLE DB provider "SQLNCLI11" for linked server "repl_distributor"

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". 

[Office] Transfer Capital Letters in Excel

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

                =EXACT(A2,LOWER(A2))

[SCSM] Microsoft System Center SQL Server Permissions

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

[Permission] GRANTED "CREATE" still get "CREATE" WARNING through SSMS GUI

"You are not logged in as the database owner or as a user that is a member of the db_owner role"
Solution:
obviously, you need to grant the account as DB_OWNER. That's only for avoid the annoying GUI warning. Otherwise, "CREATE TABLE" is enough for Creating Tables.