(David Ramel) Microsoft updated its PowerShell extension for Visual Studio Code, continuing a months-long re-architecture to improve the stability of its editor and debugger, which was identified as the No. 1 user request.
Other News
Migrating a database using continuous rolling forward
(Eddy Coppens) In most traditional migrations towards a new environment, one will most probably come up with the most current ideas to get the job done, but what about migrating a multi-terabyte sized database with a minimal down time?
What to Check if the MySQL I/O Utilisation is High
(Krzysztof Ksiazek) The I/O performance is vital for MySQL databases. Data is read and written to the disk in numerous places. Redo logs, tablespaces, binary and relay logs.
SQL SERVER – Always On Listener Creation Failure – Enabling Object ProdListener Failed With Error 5
(Pinal Dave) In the past, I have written a few blogs where I explained a few issues about the failure of listener creation Failure in a cluster. In this blog, we would see another cause of listener creation failure.
Export Excel File using ExcelJS in Angular Service
(Satheesh Elumalai) Let’s explore exporting an Excel file using Exceljs using Angular service. Basically, there are two open-source libraries available to read/write an Excel in client-side applications include
Tips for using DBCC commands in SQL Server 2019
Tips for using DBCC commands in SQL Server 2019 Try to run the DBCC commands when there are no other disk I/O operations, such as disk backups, replication and so on. Use DBCC CHECKFILEGROUP instead of DBCC CHECKDB, if you need to check only specified filegroup, not entire database. If your database contains several filegroups and you need to check...
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
Azure SQL Managed Instance Performance Considerations
(Tim Radney) Azure SQL Database Managed Instance became generally available in late 2018. Since then, many organizations have started migrating to Managed Instance for the benefits of a managed environment.
Verifying Object Exists and Dropping Object with One Statement
(Gregory Larsen) For years you probably have been writing code similar to the code below to verify an object exist prior to dropping it.
React Hooks With Typescript: Use State and Effect in 2020
(Thomas Wilfred) In this article, we discuss how to use React Hooks with TypeScript to create functional components with the same features of class-based components.
ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes]
(Satishbabu Gunukula) When working with Oracle DB Version 19.5 recently noticed below errors in alert.log file