Author: Database Journal

Feed: Databasejournal.com - Feature Database Articles. Author: . The public cloud increasingly has become the target for workloads which traditionally were considered to be confined to on-premises environments. This trend is particularly evident in the context of deployments of SAP products. In this article, you are provided with an overview of factors that should be taken into account if you are considering hosting SAP HANA in a public cloud. When it comes to SAP HANA deployments, it is fairly easy to recognize the benefits of public cloud because of their extensive resource requirements (in particular, the amount of memory per ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . T-SQL window functions perform calculations over a set of rows (known as a "window") and return a single value for each row from the underlying query. A window (or windowing or windowed) function makes use of the values from the rows in a window to calculate the returned values. A window is defined by using the OVER() clause. The OVER() T-SQL clause has the following functions: It defines window partitions by using the PARTITION BY clause. It orders rows within partitions by using the ORDER BY clause. The OVER() clause can accept ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . An interesting issue reared its head back in version 9.2 of Oracle and, unfortunately, has not been corrected. The problem 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: ORA-02291: integrity constraint (SCOTT.FK1) violated - parent key not found The error is generated because the order of iusert is not determinate. This means that regardless of the order of the tables in the code, inserts are not guaranteed to occur ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Visual Studio 2019 is a massive step forward in the developer spectrum. Not only has it shifted a lot of boundaries, but it has also made it easier to extend its interface.  In this article you will see tools – rather, extensions or add-ons - that can be added to the Visual Studio 2019 IDE to improve your database experience irrespective of what database it is. You should find these quite tools useful. MySQL Editor for Visual Studio Being a part time programming teacher, I always try to have good samples for ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . SQL Server Integration Services (SSIS) was first made available well over a decade ago as part of the release of SQL Server 2005, replacing Data Transformation Services, which had been integrated into the product since SQL Server 7.0. This enduring pedigree has been interrupted by the introduction of Azure SQL Database, which, unlike its on-premises counterparts, restricted its capabilities to those implemented directly by the database engine. Unfortunately this meant that existing SSIS packages could not be used to perform extraction, transformation, and loading (ETL) tasks by relying on computing and storage ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . If you have been a DBA for a while you have probably gone through at least one migration to a new version of SQL Server, or maybe even more than one migration.  One of the pains you might have discovered is migrating all the logins and associated permissions from one instance of SQL Server to another. Microsoft has made it fairly easy to script out the logins by using the sp_help_revlogin stored procedure. Only problem with this stored procedure is it doesn’t generate the permissions associated with each login. If you want ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Posted in an Oracle forum some time back was a question on the latch event: latch: parallel query alloc buffer It was noted by the person posting the question that there's not much, if any, information on the latch event. The question posed in that forum was, essentially, just WHAT is that latch event and why does it occur? To answer this it will be necessary to understand some of the 'ins-and-outs' of parallel processing according to Oracle. Parallel query processing allocates slaves to do the bulk of the work; as a ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Running SQL Server in Azure VMs offers a number of benefits directly associated with the very nature of the Infrastructure-as-a-Service (IaaS) platform, such as simplified scalability, enhanced agility, and the operational cost model. In addition, the use of Azure as the cloud platform presents some additional opportunities that simplify traditional maintenance tasks such as patching or backups. In this article, you will learn backup techniques available exclusively when using Azure VMs to host SQL Server-based workloads. The overview will cover three different backup methods, which are either capable of or specifically intended ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Since late 2016, Db2 V12 for the z/OS platform has been generally available. Along with many new features, V12 was the last version on the z/OS platform to be delivered as a complete software upgrade. Future features will be delivered using a new system called continuous delivery, where subsets of features are delivered as “function levels”. Sites may then choose which features and functions they wish to implement. In this article some of the more useful features of Db2 and SQL that have been delivered as new functionality in the latest releases ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . In the article Introduction to Running SQL Server 2019 on Kubernetes recently published on this forum, the core concepts and basic architecture of implementation of SQL Server 2019 Always On Availability Groups on a Kubernetes cluster are described. In this article, an implementation will be stepped through by leveraging Microsoft Azure-hosted managed Kubernetes service referred to as AKS. AKS considerably simplifies provisioning of Kubernetes clusters by automatically building all underlying infrastructure components, including compute, storage, and networking, as well as a set of highly available master nodes. It also automatically delivers monitoring ... Read More