(Pinal Dave) As soon as a new version of SQL Server is announced, I always try to find new things and update my old post with new information or write a new post.
Community
Understanding the Whys, Whats, and Whens of ValueTask
(Stephen Toub) The .NET Framework 4 saw the introduction of the System.Threading.Tasks namespace, and with it the Task class.
Processing Every Request and Response in ASP.NET
(Peter Vogel) Every once in a while, I have some function that I want performed by several different Action methods.
Monitoring Processes with Percona Monitoring and Management
(Peter Zaitsev) A few months ago I wrote a blog post on How to Capture Per Process Metrics in PMM. Since that time, Nick Cabatoff has made a lot of improvements to Process Exporter and I’ve improved the Grafana Dashboard to match.
Deploy ORDS on tomcat in a subdirectory
(Peter Raganitsch) Usually ORDS is deployed on Tomcat simply as /ords, right?
Modifying a datafile within Amazon AWS
(John Hallas) Amazon restrict access to the SYS user within AWS instances for safety and security reasons – the safety aspect being that users cannot be trusted to not cause self-harm!
Yes, SQL*Loader is Faster at Loading Records
(Jeff Smith) Someone asked on StackOverflow how to get loading a 1,000,000 records to be faster in SQL Developer.
PDF Document Display and File Downloads with Angular, AngularJS, and Web API
(Shenwei Liu) A sample web application and discussions on creating, displaying, and downloading PDF documents with Web API data sources, client Angular CLI or AngularJS Components, and also presenting resolutions for web browser compatibilities to handle PDF documents.
Cannot Use the Special Principal – Back to Basics
(Jason Brimhall) I recently had a client call me out of the blue because he happened to be getting an error while trying to add a user to a database role. The error he was getting was “Cannot use the special principal ‘dbo’.”
When Should We Load Relational Data to a Data Lake?
(Melissa Coates) This is a question I get fairly regularly these days: Should we extract relational data and load it to a data lake?