(Bobby Curtis) Security is always a big deal. In setting up Oracle GoldenGate the capture (extract) and apply (replicat) parameter files need to be configured to log in to the database which they will perform operations. In order to do this the Oracle GoldenGate User name and password need to be p
Other News
Experimenting with the new Data Dictionary Labs Release
(Morgan Tocker) Labs releases are intended to provide early access to new features. As Gopal notes in his recent blog post About the Data Dictionary Labs Release, there is a notable restriction where upgrading from any previous MySQL database version is not supported.
StatsPack and AWR Reports — Bits and Pieces — 3
(Hemant K Chitale) This is the third post in this series.
Building Real-time Mobile Solutions with MQTT and IBM MessageSight
(Bryan Boyd, Joel Gauci, Michael P Robertson, Nguyen Van Duy, Rahul Gupta, Vasfi Gucer and Vladimir Kislicins) Message Queuing Telemetry Transport (MQTT) is a messaging protocol designed for the Internet of Things (IoT). It is lightweight enough to be supported by the smallest devices, yet robust en
Updating Assembly Redirects with NuGet
(Rick Strahl) Here’s a little NuGet gem that I didn’t know and just found out about today: You can get NuGet to explicitly re-write your reassembly redirects in your .config files based on the installed NuGet Packages in the project.
Implicit Conversions Can Be An Unseen Danger
(Shaun J Stuart) I got an email from one of my developers regarding a process they had developed in-house. The process has been taking longer and longer to run and it had reached the point where the application was timing out while waiting for a response from the database. Some investigating reveale
My DTS Package won’t load with the error ‘here were errors loading package’
(Kenneth Fisher) You are trying to open a DTS package (yes some people still use DTS packages) and receive the following error:
SQL Server Table Partition Example
(Derek Wilson) Data warehouses and data repositories often have tables that store millions of records and each day adding thousands more. As the data ages, the older records generally require fewer updates. If all of these records are kept in a single physical table. Queries and maintenance on th
Support Updates in a Page with TypeScript and Backbone
(Peter Vogel) In last month’s column, “Responding to Events with TypeScript and Backbone,” I added event handling to my single-page application. With those changes, a user can select a customer from a dropdown list on my page and the page will display the related customer information.
Windows Forms – Harnessing the ProcessCmdKey Function
(Ged Mead) In this earlier post, I followed up on a reader’s question about how to take user text box input as the start of a string and then use those characters to identify an item in a list box.