(Jesper Krogh) A common problem when you need to set up a new database instance is to import the initial data. This can particularly be an issue, if you are converting an existing database so there is a large amount of data to import.
Community
How to do EXPORT / IMPORT between #Exasol and #Oracle
(Uwe Hesse) The commands IMPORT and EXPORT provide an easy way to transfer data between Exasol and other data sources like an Oracle database. You may at first get this error message: Oracle instant client not available. Please ask your administrator to install it via EXAoperation.
More triggers are better
(Connor McDonald) Yes, you heard me correctly. If you have got one trigger on a table, then you might be surprised to find that perhaps having a second one will be a better option.
Partitioning — 3a : Indexes on a Partitioned Table
(Hemant K Chitale ) Building on the case study of the Range Partitioned Table from the previous Blog Post, here are some Indexes.
SQL Server Reference Data Best Practices – Part 1
(Haroon Ashraf) Reference data is added to the SQL Server database by multiple developers and testers, thereby causing inconsistencies in the database due to reference data updated by one developer getting overwritten by another developer/tester and so on. In this tip we will look at how this can b
Get started with the Java EE 8 Security API, Part 4
(Alex Theedom) The previous article in this series introduced IdentityStore, an abstraction used to setup and configure secure access to user credential data in Java web applications.
How To Setup Angular 6 Development Environment In Visual Studio Code
(Farhan Ahmed) In this article, we are going to learn how to set up an Angular 6 application development environment in the Visual Studio code editor. We will create our first Angular 6 application.
Azure SQL Data Sync – keep your data in sync between Azure Hybrid environment SQL Server and SQL DB
(Manoj) SQL Data Sync is a service built on Azure SQL Database that lets you synchronize the data you select bi-directionally across multiple SQL databases and SQL Server instances.
Processes can dramatically improve your work until they don’t.
(Kenneth Fisher) As always with something like this, I like to start with a definition so we are all starting in the same place. From dictionary.com.
Mining Plans : Not just for the plan cache
(Erin Stellato) When looking at query performance there are a lot of great sources of information within SQL Server, and one of my favorites is the query plan itself. In the last several releases, notably starting with SQL Server 2012, each new version has included more detail in the execution plans