The Difference Between Database Archive & Database Snapshot
Crystal Reports
- .net
- Crystal Report + VB.NET 最基本顯示 (無連結 Database)
- SQLDataReader + Crystal Report + MS SQL
- SQLDataAdapter + Crystal Report + MS SQL
- Crystal Reports for Visual Studio 2010 Licensing
- Crystal Reports for Visual Studio 2013 – Generate PDF Report ( Schedule Job )
- Crystal Reports for Visual Studio 2013 – ASP.NET ( Web Form ) + CrystalReportViewer
- Crystal Reports for Visual Studio 2013 ( ASP.NET Web Form ) – JavaScript runtime error: “bobj" is undefined
- Crystal Reports for Visual Studio 2013 ( ASP.NET Web Form ) – CrystalReportViewer Navigation Button not working
- J2EE
Data Graph
- Sigma ( Web – JavaScript )
- vis.js ( Web – JavaScript )
- vis.js – JavaScript Data Network Graph Drawing ( Project Initialize )
- vis.js – Node Click Event & Get Back Node JSON Object
- vis.js – Present the Node by using a Graphic File
- vis.js – Graph DIV to Canvas
- vis.js + Web API – Prepare JSON from Restful for generating Graph
- vis.js – Click Node & Remove it from the Graph
- vis.js – Graph Load Completed Event
- vis.js + Web API – JSON Object Class Model of Different Type Node
- vis.js – Click Node & ASP.NET MVC Partial View & jQuery UI Dialog Box
- vis.js – Zoom In / Zoom Out / Fit Size of the Graph
- vis.js – Code Development about graph minimap
- yEd
DB2
FireBase
Hadoop
- Centos 6 – Install Java 8 JDK for Hadoop
- Hadoop – NameNode is not formatted
- Hadoop + Redhat Base Linux – Error : Unable to determine address of the host-falling back to “localhost" address
- Hadoop – Executable Environment Variable
MariaDB
- MariaDB + Centos 6 – Install Error : Missing Dependency: krb5-libs = 1.5-26 is needed by package krb5-devel
- MariaDB + Centos 6 – Install Error : libmysqlclient.so.16()(64bit) is needed by postfix-2:2.6.6-8.el6.x86_64
- MariaDB + Centos 6 – Service Start Error : /usr/bin/mysqld_safe_helper: Can’t create/write to file
- MariaDB – Initialize 1st Administration Account on the Centos 6
MS Foxpro 6.0
- Foxpro Application Sample
- Foxpro Application Sample 2
- Check Duplicate – Dedupe
- 常用 Foxpro 6.0 指令集 備忘錄
- 常用 Foxpro 6.0 指令集 備忘錄 2
- 常用 Foxpro 6.0 指令集 備忘錄 3
MS SQL Server
- Administration / Configuration
- Backup / Restore
- SQL Server 備份 及 備份裝置
- Backup MS SQL Server 既 Database 指令
- SQL Server Backup Database Schedule Job
- 以 備份及還原 既 Command 去 複制 MS-SQL Database
- MS SQL Error – Cannot open backup device. Operating system error 5(failed to retrieve text for this error. Reason: 1815). RESTORE HEADERONLY is terminating abnormally.
- MS SQL Error – Open failed: Could not open file DB.mdf for file number 0. OS error: 5( Access is denied. )
- Index / Database Performance
- T-SQL – Clustered Index / non-Clustered Index 建立
- SQL Server – Management Studio 上輸出 Index Performance Result
- SQL Server – ReIndexing Database Table
- T-SQL – Create Index with Error ( Is of a type that is invalid for use as a key column in an index )
- T-SQL – Full Text Search Index on Multiple Field for Keyword Search on Specific Columns
- SQL Profiler
- MS SQL Server Express
- MDS ( Master Data Services )
- Database Snapshot
- SSIS ( Integration Services )
- SQL Server 2008 Integration Services ( SSIS ) + WCF Web Services Task 方法
- SQL Server 2008 Integration Services ( SSIS ) + XML Source + Flat File Destination 方法
- SQL Server 2008 Integration Services ( SSIS ) + ADO NET Source + Conductional Split + Flat File Destination ( Split File ) 方法
- SQL Server 2008 Integration Services ( SSIS ) + WCF Web Services Task + Export CSV 方法
- SQL Server 2008 Integration Services ( SSIS ) – Package Deployment
- SQL Server 2008 Integration Services ( SSIS ) + WCF Web Services Task + Export XML 方法
- SQL Server 2008 Integration Services ( SSIS ) + Execute SQL Task + Script Task 方法
- MS SQL 基於 DateTime 欄位 Archive 所需之 T-SQL Statement
- SSIS Control Flow – Execute SQL Task + Foreach Loop Container
- SQL Server 2008 Integration Services ( SSIS ) + Restful Web Services + Script Task 方法
- SQL Server 2008 Integration Services ( SSIS ) + Lookup + Export CSV 方法
- SQL Server 2008 Integration Services ( SSIS ) – Script Task with Transaction ( Transaction Isolation : Read Committed )
- SQL Server 2016 Integration Services ( SSIS ) – Oracle Data Provider for .NET ( ODAC Connector )
- SQL Server 2012 Integration Services ( SSIS ) – Dynamically Naming Destination Output Files
- SQL Server 2016 Integration Services ( SSIS ) – Deploy SSIS Package Manually
- SSRS ( Reporting Services )
- SQL Server 2008 Reporting Services ( SSRS ) 安裝提示 及 設定
- 出現 Reporting Services Error – The configuration parameter SharePoint Integrated is set to True but Share Point Object Model cannot be loaded.
- 建立 Reports 及 Deploy 至 SQL Server 2008 Reporting Services
- SQL Server 2008 Reporting Services ( SSRS ) URL Parameter
- SQL Server 2008 Reporting Services – 唔同既 Parameter 出現 唔同既 SQL Statement
- SQL Server 2008 Reporting Services – 出現 ( Page 1 of 2? ) / 不能顯示正確 Total Page 解決方法
- SQL Server 2014 Reporting Services ( SSRS ) – SharePoint 2013 List Data Source
- SQL Server 2012 Reporting Services – WCF SOAP Data Source
- ASP.NET – Embedded SSRS Report with Entity Framework Data Source
- SQL Server Reporting Services – One Record per Page ( Page Break Best Practice )
- SQL Server Reporting Services – Performance Concern on using SSRS Sub-Report
- ASP.NET – SSRS SubReport DataSet Handling
- SQL Server Reporting Services – Remove the Unexpected Last Blank Page from the Report
- SSRS – Shared a Value from Expression by using Report Code as a Report Global Variable
- SSRS – How to use a Delimited String in a Multi-valued Parameter ( Where In ( 1, 3, 5, 7, 9 ) )
- SSRS – Error – The report server cannot open a connection to the report server database. The log on failed.
- OLTP
- Power BI
- T-SQL
- SQL Server 中較常使用的 DBCC 指令
- 分頁 (Paging) 用既 T-SQL 指令 及 建立 Procedure
- 部分協助管理 SQL Server 用既指令
- MS SQL T-SQL Transaction Template
- T-SQL 現在時間
- 當 T-SQL 需要 使用 指令保留字串 時
- MS SQL T-SQL (INSERT AUTO INCREMENT)
- MS SQL T-SQL 數字 左手面 補零
- MS SQL T-SQL INSERT UTF8 既 Record
- MS SQL T-SQL Table 加 Column
- T-SQL – FOR XML Clause
- T-SQL – Get NULL Values Criteria
- T-SQL – Get Random Rows from Table
- T-SQL – Alter Table Column Data Type
- T-SQL – Get Auto Increment Value of Last Row at the Insert
- T-SQL – Today’s Date minus 1 Month
- T-SQL – DateTime Add / Minus
- T-SQL – Determine number of days in a month
- T-SQL – Assign Foreign Key on Table Column
- T-SQL – Get List of User Defined Table under Database
- T-SQL – Use Cursor for Drop Table ( with specific Name Pattern )
- 分頁 (Paging) 用既 T-SQL 指令 及 建立 Stored Procedure 2
- T-SQL – Add Column on a Existing Table with Default Value
- T-SQL – Insert Record from Select Statement
- T-SQL – Database / Database Log Physical File Size Log Sample
- T-SQL – Group By Time Interval
- T-SQL – Backup Database & sqlcmd Backup Database
- T-SQL – Create Audit Trigger
- T-SQL – Update Table from Query
- T-SQL – Return If Else Condition Data Value from SQL Query
- T-SQL – Generate Row Sequence Number by SQL Query
- T-SQL – Join Like Wildcard
- T-SQL – JSON Support for SQL Server 2016
- Change Column Type with Identity ( Sequence ) on SQL Server Existing Table
- T-SQL – LEFT JOIN return 1 record 方法
- T-SQL – MERGE INTO
- T-SQL – Assign Log File Size & File Size Limit
- T-SQL – Hash SQL Row by using SHA1
- T-SQL – Shrink Database Log File ( LDF ) with Single User Mode
- T-SQL – Insert Record on Table by SQL Query Result
- T-SQL – About RowVersion
- T-SQL – Use the Trigger to Perform the Record Hash ( SHA1 ) from the SQL Server Table
- T-SQL – Search a Column Name within All tables & All Views from the Database
- T-SQL – Insert When Not Exist
- T-SQL – Sort Null Value to Last
- T-SQL – Select Top 1 and If Not Exist Return Null Row
- T-SQL – Define a 1 To 1 Mapping Foreign Key Constraint
- T-SQL – Partition By ( Group By a Set of Data by a Field and Return First Row )
- T-SQL – Group By ( Parent ID and Child ID with Comma Delimited in a Single Row )
- T-SQL – Use Column Alias on WHERE clause ( COMPUTED_COLUMN )
- JSON Support
- Trigger
- T-SQL – Create Audit Trigger
- SQL Server – Trigger Error ( The partner transaction manager has disabled its support for remote/network transactions. ) 解決方法
- SQL Server – Execution Error about Insert Trigger to Linked Server
- SQL Server – Update Trigger ( Get Original Value )
- T-SQL – Use the Trigger to Perform the Record Hash ( SHA1 ) from the SQL Server Table
- MS SQL Server – Integer Column 轉成 Auto Number
- SQL Server Active Directory Helper 服務錯誤
- SQL Server Import / Export Data 既 Tools – DTS
- 將 MS SQL – Data File 移去另一台 Database Instance
- 當 Web Application 至 IIS 後出現 連接 SQL Server 2005 / 2008 問題
- 當出現 Cannot drop the database <Database Name> because it is currently in use. 錯誤時, 強行刪除 Database 方法
- SQL Server 2008 遠端連線 (Enable Remote Connection)
- SQL Server 2008 建立 Linked Server 方法
- SQL Server – <Table Column> is of a type that is invalid for use as a key column in an index.
- SQL Server – SQLCMD 使用方法
- SQL Server Error – The transaction log for Database “MS SQL Database" is full due to LOG_BACKUP
- SQL Server – Truncate Transaction Log
- SQL Server – Cannot Shrink Log File because of Minimum Log Space Required
- SQL Server – About a Batch Job in Office Hour & Transaction Lock
- Search Engine Design of Information System – BrainStorming
MySQL
- MySQL Remote Administrator Application
- MySQL SELECT Query Condition Case Sensitive
- 如發現 MySQL 無法 使用 innodb Storage Engine 時,
NoSQL
- Cassandra
- Administration
- CQL
- Installation
- Java Driver
- CouchBase
- Hadoop
- MongoDB
- C# Driver
- Console
- Installation
- Java Driver
- MongoDB Java Driver – Add Collection Document
- MongoDB Java Driver – Add Collection Document ( Object )
- MongoDB Java Driver – Get Attribute Value under Collection Document
- MongoDB Java Driver – Get Collection Document in specific Sorting Order
- MongoDB Java Driver – Get Collection Document with specific Filtering Criteria
- MongoDB Java Driver – Add Collection Document ( Complex Structure )
- MongoDB Java Driver – Delete Collection Document
- MongoDB Java Driver – Bulk Update Collection Document
- Redis
- Configuration
- Development
Oracle
- Administrator
- 9i
- 11g
- Oracle Database 11g Express Edition 下載
- Oracle Database 11g Express Edition 安裝方法
- Oracle 11g – 忘記 DBA (SYSTEM) Account Password
- Oracle Graphical Integrated Development Environment – Oracle SQL Developer 下載
- Oracle 11g – 停止輸出 “anonymous block completed" – Message
- Oracle 11g – 輸出 SQL Statement Explain Plan
- Oracle 11g – Transaction 方法
- Oracle 11g – SQL Plus 更改 SYS 密碼
- Oracle 11g – SQL Plus Import / Export Schema
- Oracle 11g – Disable Oracle Password Expiration
- Oracle SQL Plus – Don’t Use Reserve Character on User Name or User Password
- Oracle 11g Enterprise Manager / DBConsole – Drop / Recreate / Recovery / Start / Status
- Oracle 11g – Oracle Developer Commit SQL Statement
- Oracle 11g – Change Default Database Character Set ( AL32UTF8 )
- Oracle 11g – ORA-28001: the password has expired (dbd error ocisessionbegin)
- Oracle.DataAccess.Client – Web Application Deployment
- Oracle 11g – ORA-01031: insufficient privileges by execute “sqlplus / as sysdba"
- Oracle 11g – Create User for Authentication Purpose only
- Oracle 11g / 12c – Install Oracle Client from Windows 7 / Windows 10 with Error ( Hang / Failed to access the temporary location )
- 12c
- Oracle 12c EM Express Configuration
- Oracle 12c JSON Support – Big Data JSON Data Structure
- Oracle 11g / 12c – Install Oracle Client from Windows 7 / Windows 10 with Error ( Hang / Failed to access the temporary location )
- Oracle 12c / 19c – Create User with Quota & Quota is not effective to be validated on tablespace
- 19c
- Oracle 12c / 19c – Create User with Quota & Quota is not effective to be validated on tablespace
- Oracle 19c – Enterprise Manager Express not working ( Oracle 19c under Windows Server )
- Oracle 19c Enterprise Manager Express – Adobe Flash platform / Java JET platform
- Create an Oracle database user by script ( instead of Enterprise Manager )
- PL/SQL
- Oracle Text
- Oracle 11g PL/SQL – Table Column ( Boolean Data Type )
- Oracle 11g PL/SQL – Insert ‘&’ Character
- Oracle 11g PL/SQL – Add Column on a Existing Table with Default Value
- Oracle 11g PL/SQL – Assign Foreign Key on Table Column
- Oracle 11g PL/SQL – Sequence + Auto Increment Column 方法
- Oracle 11g PL/SQL – User Defined Sorting Order
- Oracle 11g PL/SQL – CREATE MATERIALIZED VIEW 及 建立原因
- Oracle 11g PL/SQL – LISTAGG 方法
- Oracle 11g PL/SQL – XMLAGG 方法
- Oracle 11g PL/SQL – TOP 10 Records
- Oracle 12c PL/SQL JSON Support – Big Data JSON Data Structure
- Oracle 11g PL/SQL – CREATE SNAPSHOT
- Oracle 11g PL/SQL – MERGE INTO
- Oracle 11g PL/SQL – LEFT JOIN & ( + )
- Oracle 11g PL/SQL – Compare ANY / IN / WHERE … OR … from SQL Statement
- Oracle 12c PL/SQL – SQL Statement about Group By Year & Month & Count for jQuery Chart
- Oracle 12c PL/SQL – UNION / DISTINCT Handling on CLOB Field
- Oracle PLSQL – About Conventional Syntax and ANSI Syntax
- Oracle PL/SQL – Execute a SQL Statement to get View SQL Query ( from Eclipse with no Database Tools )
- Oracle 12c PL/SQL – PIPELINED
- Oracle 12c PL/SQL – Generate Multiple Sequence NEXTVAL from a Single Query
- Oracle 12c PL/SQL – Get Existing Schema Object
- Oracle 12c PL/SQL – Get Previous Executed SQL Query from Database ( with Replication )
- Oracle 12c PL/SQL – Insert to Clob Column & Error : the string literal is longer than 4000 characters
Oracle Forms & Reports
- Oracle 12c Forms & Reports – Installation Error : “fmcus.msb not found 12c"
- Oracle 11g Fusion Middleware ( Forms & Reports ) – Installation & Configuration
Regular Expression
SQL Statement
- SQL Statement I (SELECT)
- SQL Statement II (CREATE / INSERT / UPDATE / DELETE)
- SQL Statement III (CREATE PROCEDURE / CALL)
- SQL Statement IV (TRIGGER)
- SQL Statement V (SELECT – LEFT JOIN / RIGHT JOIN / FULL JOIN)
- MySQL SELECT Query Condition Case Sensitive
- SQL Statement – IN
- SQL Statement – Column Variable Increment
- MS SQL T-SQL Table 加 Column
- T-SQL – FOR XML Clause
- T-SQL – Get NULL Values Criteria
- T-SQL – Get Random Rows from Table
- T-SQL – Alter Table Column Data Type
- T-SQL – Get Auto Increment Value of Last Row at the Insert
- T-SQL – Today’s Date minus 1 Month
- T-SQL – DateTime Add / Minus
- T-SQL – Determine number of days in a month
- T-SQL – Assign Foreign Key on Table Column
- T-SQL – Get List of User Defined Table under Database
- T-SQL – Use Cursor for Drop Table ( with specific Name Pattern )
馬仔驚自己唔記得要留既notes 