(Ben Nadel) I’ve never been shy about how much I enjoy ColdFusion. So many wonderful things in my life have sprung from the fact that I happened to get an internship under Glen Lipka 20-years ago; and, that his company happened to be using ColdFusion 4.5.
Other News
Backup Oracle To Amazon AWS S3 – Part 1
(Jared Still) Oracle has the ability to backup directly to Amazon S3 buckets.
How to upgrade APEX from version 19.2 to version 20.1 on Oracle Database 18c XE
(Matthias Hoys) APEX 20.1 is out! Oracle released it yesterday, and you can download it here. Check the Release Notes, the Installation Guide and the overview of Known Issues.
Creating a Public Accessible 20c Database VM on Oracle Cloud
(Liron Amitzi) Lately I started playing with Oracle 20c and the cloud. I had a few issues with configuring the DB VM and accessing it from home, so here is a short guide.
How to Create a CSS-Tricks Custom Scrollbar
(David Walsh) Chris Coyier of CSS-Tricks is an amazing engineer and blogger. He’s not only creative but has always had the drive to put his thoughts to work, no matter how large.
SQL 101: Using ILE RPG Programs and Procedures as SQL Stored Procedures, Part 2
(Rafael Victoria-Pereira) In the previous TechTip, I (very briefly) introduced Persistent Storage Modules and explained the differences between stored procedures (SPs), user-defined functions (UDFs), and triggers.
Bandwidth-friendly Query Profiling for Azure SQL Database
(Greg Gonzalez) SQL Server has always provided the ability to capture live queries on an ad hoc basis in an easily-consumable rowset format – first with legacy SQL Server Profiler, later via Extended Events in SSMS.
Accessing Azure Blob Storage from Azure Databricks
(Gauri Mahajan) We introduced Azure Databricks, how it is created and some of its important components in my previous article here. We will look at how we can work with Azure Blob Storage in Azure Databricks in this article.
Tips for using ASP.NET with SQL Server 2019
Tips for using ASP.NET with SQL Server 2019 Use the SQL Server .NET data provider to access SQL Server 2019 data using ADO.NET. Because using the SQL Server .NET data provider provides better performance in comparison with other providers, you should use the SQL Server .NET data provider whenever possible. Try to avoid synchronous calling when developing ASP.NET applications. Synchronous...
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
How to Compute Simple Moving Averages with Time Series Data in SQL Server
(Rick Dobson) Demonstrate techniques for use of SQL Server Windows functions to compute simple moving averages. More specifically, highlight the use of the Windows aggregate avg function for computing simple moving averages for one entity at a time or concurrently for multiple entities.