(Pradiptab2) There are some situations where we need to import data from the csv or the xls file. Its quite easy to deal with a csv file, as this is a plain text file.
Other News
Suppressing ADF LOV Like Operator Filtering V2
(Andrejus Baranovskis) I had a post about the solution to suppress ADF LOV Like operator and prevent LOV popup loading when user is typing existing value – Suppressing ADF LOV Like Operator Filtering. Thanks to a blog reader, there was one use case found, when Like operator was not suppressed proper
Resizing the InnoDB Buffer Pool Online
(Yasufumi Kinoshita) As described in the MySQL 5.7 manual here, we can now resize the buffer pool without restarting the mysqld process starting with MySQL 5.7.5.
Connecting to an Availability Group Listener with SQL Server Management Studio
(Derik Hammer) When a cluster has an Availability Group installed on it, there is an optional listener which is used to manage connections through fail-over events. This listener has an IP address assigned to it and, when the Availability Group fails over within the same sub-net, the listener simply
Simple MVVM in WPF
(Peter Shaw) The WPF scene has exploded as the now-dominant desktop application scene for Windows desktop applications. Couple that with the new Windows 8-style store apps and XAML, it looks like it has a very rosy future indeed
Five Data Management Trends for 2015
(Dave Beulke) ‘Tis the holiday season, and I want to thank all my readers for their comments and encouragement. It has been a pleasure and honor working/hearing from all of you. I enjoy the challenges of data management too much, and my curious nature has me continuing to explore and write about a
Export From HTML Table Using jQuery
(Sibeesh Venu) This article shows how to export from an HTML table using jQuery.
Quick Tip: Controlling how PL/SQL Errors are Shown
(Jeff Smith) Remember, you only see the error messages in the log AFTER a compile. If you want to see the list of errors at any time, simply click on the ‘Errors’ page, or try compiling your program again.
Inside Distributed Architectures: Seeing In-Flight Requests And Blockers in Realtime
(Baron Schwartz) VividCortex’s SaaS backend is a service-oriented architecture, which means that in addition to our external APIs that our agents and web UI use, we also have internal APIs. Deploy a bunch of API servers across a cluster of machines, hook everything up and make all the parts talk to
Format Durations in SQL Server Analysis Services
(Koen Verbeeck) I have a fact table in my data warehouse that tracks durations of certain events as the total number of seconds that have passed. When users browse the cube, I’d like to show these durations formatted as time using the hh:mm:ss format (hours:minutes:seconds).