(Ben Nadel) At InVision, the amount of work that we do in the Application.cfc ColdFusion framework component is a bit staggering. Not only are we setting up all of the Lucee CFML mappings, custom paths, data-sources, SMTP servers, and cache configurations, we’re also defining hundreds of FW/1 routes
Editorials
Complexities of Deep Customer Knowledge
December 13, 2019It’s the dream, really, to know more about your customers. To know how they use your services or goods and how you can better serve them. To [...]How People Use Data, Is Changing Fundamental Tools
December 12, 2019There is a great post by Haroon Choudry on LinkedIn, talking about whether SSRS’s days are numbered. In particular, is the use of PowerBI [...]
Vacation Planning – in just 7 Minutes
December 5, 2019Going on a vacation/holiday, but only have 7 minutes to get some tips to plan? We’ve got you covered. Check it out:... This content is for Pro [...]
- With Privacy Laws Come New and Different Storage Requirements
- Cloud Services… and the bill for them. DBA Opportunity?
- Brings New Meaning to “Show Your Work”
SQL Server
How to Change Your Resume to Get More Interviews
December 13, 2019This question came from a job seeker. I am having a hard time earning job interviews and I think I know why. My resume may give the impression of [...]Exploring OLTP in SQL Server 2019 (Part 2)
December 12, 2019Enabling In-Memory OLTP in new and existing databases To create a new database and enable In-Memory OLTP in it, you can use the following script: [...]Tips for using SQL Server 2019 Reporting Services
December 11, 2019Tips for using SQL Server 2019 Reporting Services SQL Server 2019 Reporting Services (SSRS) is a server-based reporting platform that provides [...]
- Prior to DBMS, Database Approach, Data Model — Part 3
- How Do You Work with Someone Who Expects Flawless Work?
- Exploring OLTP in SQL Server 2019 (Part 1)
Other News
Troubleshoot Slow RDS SQL Servers with Performance Insights
(Sadequl Hussain) Amazon RDS SQL Server now supports Performance Insights. How can we use it to troubleshoot SQL Server performance bottlenecks?
How To Setup Angular 8 App
(Jayakrishnan V B) In this article, you will learn how to setup an Angular 8 app.
The definition of proof
(Connor McDonald) One of the pieces of advice that I often see on the ‘net is that undo space is somehow this incredibly precious thing, and as a consequence, one should always keep the amount of uncommitted changes in the database to a small size.
Using MySQL Galera Cluster Replication to Create a Geo-Distributed Cluster: Part Two
(Krzysztof Ksiazek) In the previous blog in the series we discussed the pros and cons of using Galera Cluster to create geo-distributed cluster.
Complexities of Deep Customer Knowledge
It’s the dream, really, to know more about your customers. To know how they use your services or goods and how you can better serve them. To have some sort of predictive knowledge about what they’ll want and to be able to be right there, right on time, just as they need, so they’ll never stray. This requires information – […]
How to Do Naive Bayes with Numeric Data Using C#
(James McCaffrey) The Naive Bayes technique can be used for binary classification, for example predicting if a person is male or female based on predictors such as age, height, weight, and so on), or for multiclass classification, for example predicting if a person is politically conservative, moder
Announcing Db2 12 function level 506!
(Paul McWilliams) Db2 12 function level 506 is now available. It introduces new alternative spellings for existing SQL built-in functions to improve compatibility with competitive database platforms, the SQL standard, and the Db2 product family.
How to integrate ProxySQL in MySQL InnoDB Cluster
(Frederic Descamps) MySQL InnoDB Cluster is the most easy and integrated High Availability solution for MySQL.
How to hang a server with a single ping, and other fun things we learned in a 18c upgrade
(savvinov) Every upgrade is a bit of a lottery. But for a long running, well established system with a lot of legacy code, it can be more of a Russian roulette.
