(David Fitzjarrell) An interesting issue reared its head back in version 9.2 that involves inserting data into multiple tables with a single statement when a foreign key is declared. Regardless of the table order in the insert statement the following error can be thrown:
Other News
MATCH_RECOGNIZE Restrictions
(stewashton) Sometimes we think that certain restrictions are not documented when in fact they are. Where do we forget to look? Database Error Messages
Updating parameter files from REST
(Bobby Curtis) One of the most important and time consuming things to do with Oracle GoldenGate is to build parameter files for the GoldenGate processes.
Create an Azure Function to Connect to a Snowflake Database – Part 1
(Pinal Dave) At our company, we use the cloud Snowflake database to host our data warehouse. We are heavily invested in the Azure data platform and we like to create data pipelines in Azure Data Factory. However, it seems there’s no native connector in Data Factory for Snowflake.
View Encapsulation In Angular
(Roshan Choudhary) This article is all about what view encapsulation (Scoped style) is and how it is achieved in Angular.
Tips for using constraints in SQL Server 2019
Tips for using constraints in SQL Server 2019 Avoid using CHECK_CONSTRAINTS hint with bulk copy program. Using this hint can significantly degrade performance of the bulk copy operation, because for each row loaded the CHECK constraints defined on the destination table will be executed. Without the CHECK_CONSTRAINTS hint, any CHECK constraints will be ignored. Consider using the NOT FOR REPLICATION...
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 Synapse Analytics & Power BI performance
(James Serra) With two new relational database features (Result-set caching and Materialized Views) just GA’d in Azure Synapse Analytics (formally called Azure SQL Data Warehouse), it makes for some very compelling reporting performance options when combined with Power BI.
Inheritance vs Delegation in Java
(Sven Ruppert) Let’s look at the difference between the inheritance and delegation concepts.
Using Windows Forms DataGridView in .NET Core 3.1
(Gunnar Peipman) Windows Forms is coming to .NET Core and last version of Visual Studio 2019 Preview comes with form designer built in.
C# 8 Interfaces: Static Members
(Jeremy Bytes) When taking a closer look at C# 8 interfaces, we have a new capability: interfaces can have static members (including static fields).