(Andin Bicknell) As important as adding new features, app developers need to start placing more emphasis on the security aspect of the applications they design.
Other News
Db2 12 for z/OS Buffer Pools – Recommendations for PGSTEAL, PGFIX and FRAMESIZE
(Robert Catterall) Not too long ago, I received a note from the leader of a Db2 for z/OS database administration team, asking for my take on a Db2 12 buffer pool configuration set-up that his team had devised.
How to access Power BI REST APIs programmatically
(Aveek Das) In this article, I am going to explain how to use the Power BI REST API to programmatically access the Power BI Service features. I’ll also discuss the basis of REST API and how to use the APIs using Postman.
More Azure Blob Storage enhancements
(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
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...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Experiences with SQL PL for redesigning a GUI application
(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.
Safer ag-Grid (React) Column Definitions with TypeScript
(morzel) A typo or change in row model in JavaScript will cause an empty column in the grid because an ag-Grid column is bound to a row property by assigning a string to field config.
Cursor in SQL Server
(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.
How to set default values for MySQL JSON columns
(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.
Getting Started with PyTorch 1.5 on Windows
(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.