(James Serra) I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob storage. Now there are more new features for blog storage that I will talk about.
Tips for using table hints in SQL Server 2019 If your query is very slow, try the following before using table hints: – rebuild indexes used in the query (or defragment them using the DBCC INDEXDEFRAG command), – update statistics on the relevant tables, – consider creating new indexes for this query, – rewrite your query to provide better execution…...
(Peter Vanroose) For our course administration we use (already for several decades now) an application which was developed in-house, combined with a 45-table database on Db2 for z/OS.
(Jeremy Kadlec) In my T-SQL code, I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing.
(Shahryar Ghazi) MySQL has been making huge progress on the JSON/NoSQL front as well ie. supporting many of the JSON access and manipulation features and operations.
(James McCaffrey) Although it’s possible to create a neural network using raw code, in most cases a better approach is to use a neural network code library. One of the most widely used neural code libraries is PyTorch.
In this article, we’re going to cover how to set up and manage multiple environments in ASP.NET Core. If we expect our project to become large and complex, it is a good idea for us to separate our environments.
(Mike Brind) Tabbed interfaces are a great way for managing the presentation of large amounts of information into separate panels, where each panel’s data makes sense on its own, and only one panel is viewable at a time.
(Syed Jaffar Hussain) In part III article series of Migration methods to Autonomous Database we will see how to migrate or load data into ADB using SQL Developer.