(Alejandro Cobar) SQL Server database backups are one of the most important pillars within our profession. Since they hold the most valuable assets of our customers, their information, we must be able to be certain of their availability in case they are eventually required.
Community
Getting Started With Angular 7.0
(Ankit Sharma) Angular has released its latest version, Angular 7.0. In this article, we will explore the following points –
SQL SERVER – How to Escape a Single Quote in SQL Server?
(Pinal Dave) In my earlier post on “How to Escape a Single Quote in SQL Server? – Interview Question of the Week #192 I showed you a method of escaping a single quote.
Most Popular Node.js Frameworks in 2018
(Sagar Arora) With the introduction of Node.js in 2009, it has become possible to use the JavaScript language while scripting server-side as well as client-side parts of an application or project.
Configuring named options using IConfigureNamedOptions and ConfigureAll
(Andrew Lock) This is a follow on to my previous post on using multiple instances of strongly-typed settings in ASP.NET Core 2.x. At the end of that post I introduced the concept of named options which were added in ASP.NET Core 2.0.
Effective Monitoring of MySQL With SCUMM Dashboards – Part 3
(Paul Namuag) We discussed in our previous blogs about the MySQL-related dashboards. We highlighted the things that a DBA can benefit from by studying the graphs, especially when performing their daily routines from diagnostics, metric reporting, and capacity planning.
The strange place for INHERIT PRIVILEGES
(Connor McDonald) A while back in an Office Hours session, I touched on a relatively new privilege in the database called INHERIT PRIVILEGES which is designed to avoid erroneous privilege escalation via AUTHID CURRENT_USER routines.
What is using my Linux swap space?
(Jack Vamvas) Question: I’m familiar with how to monitor swap space usage for processes. There is more detail about the methods I’ve adopted for using vmstat to check swap in and swap out on Linux swap space and DB2 . How can I check what is currently in the Linux wasp space ?
ColdFusion 2016 Skips Over Undefined Elements With For-In Array Loop
(Ben Nadel) This morning, when I was writing up my post on generating a Java Thread Dump programmatically in ColdFusion, one thing I had to cope with was an Array that may or may not contain undefined elements.
GH-OST for MySQL Schema Change.
Schema change is one of the crucial tasks in MySQL with huge tables. Schema change can cause locks.