(Flavio Casetta) In case you wonder why you don’t see the time portion when you call the method get_Date() on a JSON object:
Community
Check your hints carefully
(Bobby Durrett) Back in 2017 I wrote about how I had to disable the result cache after upgrading a database to 11.2.0.4.
Backup Archive log files
(Jagruti Jasleniya) We know that archive logs are very important files of a database when it comes to recovery.
SQL SERVER – Global Variable @@DEF_SORTORDER_ID – Old and May be Deprecated
(Pinal Dave) I always blog about things which are new and updated but today we are going to write about something which is very old and it is near deprecated.
Send Method As Parameter Java Vs C#
(Eranda Horanagama) In C# you have delegates, which is pretty straightforward as far as sending a method as parameter in C#. This has not been the case with Java.
Pausing / Resuming Azure SQL DW
(blobeater) Before writing about pausing (and resuming) Azure SQL Data Warehouse (DW) it makes sense to discuss the architecture of this product.
Yes, pulling just the data you need is really important.
(Kenneth Fisher) I was asked the other day why a customer was having performance issues on a table. A simple SELECT that only returns 1134 rows was taking over a minute!
Adapter Design Pattern
(Ram N) Check out this example of the adapter design pattern in Java!
Dealing With MongoDB DateTime In ASP.NET Core
(Bipin Joshi) MongoDB is one of the popular NoSQL databases available today. You can use MongoDB database in your ASP.NET Core applications using MongoDB.Driver NuGet package. I discussed the basics of MongoDB including CRUD operations here and here.
Db2 12 for z/OS Statistics Profiles: Just What the Optimizer Ordered
(Robert Catterall) Here is an interesting story for you: not long ago, an analytics-type query was executed on a Db2 for z/OS system that had recently been migrated to Db2 12. The query was cancelled after it had run for 23 hours.