(Job Oprel) A short post about the ORA-31626 error. Found out a scheduled export- and import- job was broken in an Oracle Database. Error:
For awhile now, things have been getting very stable, very reliable and the workloads of managing data are even beginning to split. Some of the management is being done by outside folks, some by automated processes and, overall, things run extremely well. It’s led to a bit of a strange trend in systems we’ve been reviewing. “Strange” because it seems […]
(blobeater) Have you ever heard of SQL Reserved vCores? Well I never until recently.
(Thomas LaRock) Your database design is awful.
(Pinal Dave) There are many situations where we need to apply filters in ERRORLOG to look at meaningful data. In this blog, we would learn how to search for multiple values in the SQL Server ERRORLOG file.
(Matt Watson) Serilog is a newer logging framework for .NET. It was built with structured logging in mind. It makes it easy to record custom object properties and even output your logs to JSON.
(James Serra) In this blog I want to talk about how Azure SQL Database achieves high availability. One of the major benefits from moving from on-prem SQL Server to Azure SQL Database is how much easier it is to have high availability – no need for creating and managing a SQL Server failover cluster
Flexibility is the name of the game when it comes to DB2 support. If a problem is going to happen you can bet your lunch money on it happening in the middle of the night on a Sunday when your most experienced DB2 DBA is on holiday.
(Joe Pluta) I’ve used various features of SQL for a long time, but the one that has always given me a little trouble is the PREPARE statement.