(Federico Razzoli) The standard way to concatenate strings in MySQL is:
Other News
Did You Know #29 – Who is Executing Jobs?
(amitzil) When you create a job using DBMS_SCHEDULER.CREATE_JOB you can specify a schema for the job (job_name => ‘my_schema.my_job’). What does it mean?
dbca now makes it easy to configure OMF on file systems
(Martin Bach) Up until – and including – Oracle 12.1 I always found it not-quite-so-straight-forward to create a new database using Database Creation Assistant (dbca) and configure it with Oracle Managed Files (OMF) on a file system in silent mode.
ORDS: Empty JSON or 404 for No Records?
(Jeff Smith) It’s all in the P_SOURCE_TYPE!
Troubleshooting problems with SQL Server 2017 triggers
Troubleshooting problems with SQL Server 2017 triggers If you have problems with SQL Server 2017 triggers, review this troubleshooting checklist to find potential solutions. 1. Access violation occurs when a DDL trigger is raised by the CREATE EXTERNAL TABLE command. Additionally, you may receive the following error messages: “Cannot continue the execution because the session is in the kill state.”...
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
SQL Server T-SQL Alerts for Standard and Custom Errors
(Tim Smith) Our support engineers and junior DBAs are currently overwhelmed by a volume of alerts from errors each day. Most of these errors are not something they can take action on immediately and some require further analysis as to whether the error is something we expect, or something that may b
How Can PHP Import Excel to MySQL using a PHP XLSX Reader and Excel XLSX Converter
(Haseeb A. Basil) XLSX is a file format used to create an Excel spreadsheet. It was first intruduced by Microsoft in Excel 2007. It is XML-based, which makes it easier to transfer data between applications.
The Difference Between SQL’s JOIN .. ON Clause and the Where Clause
(lukaseder) A question that is frequently occurring among my SQL training‘s participants is:
Compressed Microsoft SQL Server Backups by Default
(Greg Larsen) If you compress your database backups you can save a ton of disk space. But by default compressed backups are not created.
It’s a multicloud world, so we’re bringing Db2 to your AWS data
(Kevin Oliver) If your business hasn’t already embraced a multiple-cloud strategy, it’s likely that one is in your near future. Recent research shows that 85 percent of companies already operate in multicloud environments, and 98 percent of companies plan to be multicloud by 2021.