(Pinal Dave) I wrote a blog earlier about reading data from excel via SQL Server. This was done using ‘OpenRowset. One of my blog readers sent an email to me that they were getting an error.
Community
MySQL Multi Source Replication With GTID and Non-GTID Mode
(Ankit Kumar) During our recent migration we migrated a part of a app to different region with new db.
Customizing the Default Azure Data Studio Dashboards
(Greg Larsen) Azure Data Studio is a cross-platform database tool to allow data professionals a single user interface to work with databases on premise and in the cloud.
The Right Way to Reverse a String in Java
(Jonatan Ivanov) As you probably know, Java uses UTF-16 to represent String. The char data type and the Character class are based on the original Unicode specification, which defined characters as fixed-width 16-bit entities.
Db2 for z/OS Partitioned Table Spaces: How the Number of Partitions can Impact Performance
(Robert Catterall) This past summer, I delivered a couple of presentations at a meeting of a regional Db2 users group in the USA. During the lunch break, I shared a table with a member of the Db2 for z/OS support team at a large financial institution.
Deploy ASP.NET Core Web Applications To Azure In 5 Easy Steps
(Bipin Joshi) In one of my previous articles I discussed how easy it is to deploy an ASP.NET Core web application to IIS. Now a days more and more people are going for cloud platforms for their ting needs.
Using Magic Email Links To Authenticate Users With Firebase 5.7.0 In Angular 7.1.2
(Ben Nadel) The other week, I was talking to Chesley Brown – one of our lead software engineers at InVision – about adding even more security to the Incident Commander app.
Viewing and Sorting XEvents Efficiently (Code Samples) – XEProfiler
(Bob Dorr) I was doing backups and clean-ups and ran across a couple of sample projects for XEvent and event_sequence processing I thought others might find helpful. – Enjoy!
Image Classification Using Keras
(James McCaffrey) Suppose you have a collection of digital photos you took on a trip to a zoo. You want to programmatically classify each photo as one of the 100 different kinds of animals you photographed: “aardvark,” “zebra” and so on.
MySQL Memory Consumption and Open Prepare Statements
(Frederic Descamps) Today I read the nice post of Bhuvanesh on the memory leak issue they experienced with MySQL. In fact when you read the post, you realize that MySQL was just following the parameters that were setup (the default of max_prepare_stmt_count is 16382 even on 5.6).