Category: Microsoft SQL Server

Feed: Planet NoSQL. Author: Keshav Murthy. Oracle DBAs work with physical clusters, machines, instances, storage systems, disks, etc. All of Oracles users, developers and their applications work with logical entities: databases, tables, rows, columns, partitions, users, data types.  There are a lot of similarities and some differences.  Let’s compare and contrast how this is done on Couchbase.Here’s the home page for the series: http://blog.planetnosql.com/2022/01/introduction-to-couchbase-for-oracle.htmlORACLE OrganizationFull list of Oracle schema objects are listed here. A database instance can have many databases; A databases many schema; A schema many tables, indexes, functions, etc.COUCHBASE OrganizationA Couchbase instance can have many buckets; A bucket can ... Read More

Feed: Recent Announcements. AWS Migration Hub Strategy Recommendations helps you build a migration and modernization strategy for your applications running on premises or in AWS. Strategy Recommendations automates the manual process of analyzing your servers - and the applications and databases running on those servers - to reduce the time and effort spent on planning application migration and modernization, and accelerate your business transformation on AWS. With the additional recommendation for Babelfish for Aurora PostgreSQL, customers can plan on migrating and replatforming their legacy SQL Server databases on PostgreSQL without needing to make changes to the application itself. With Babelfish ... Read More

Feed: Planet MySQL; Author: Dave Stokes;  MySQL Server version  8.0.28 was launched a few days ago and without a lot a fanfare. Which is a shame and I wish we had more of a splash for every release.  The release notes are available here. I would like to highlight some of the changes.There are over a hundred bug fixes and big thanks to Hope Lee, Casa Zhang, Øystein Grøvlen, Song Zhibai, Facebook, Hobert Lu, Brian Yue, Zhai Weixiang, Murakami Kohei,  Venkatesh Prasad Venugopal, and the Tencent team.The HighlightsThis release does not have a lot of 'wow' new features but shows a lot of solid work in evolving the product. The new audit_log_disable system ... Read More

Feed: Database Journal. Author: Gregory Larsen. Table Variables have been known to run slowly when the table variable contains lots of rows. This is because when a batch is compiled the table variable has yet to be populated with any rows, and therefore the optimizer uses an estimated row count of 1 for table variables. This occurs because table variables don’t have statistics. Having an estimated row count of 1 works well for operators that have small row counts, like a NESTED LOOP operator for a join operation. Operators that perform well for small numbers of rows do not always ... Read More

Feed: Recent Announcements. AWS Launch Wizard now supports SAP S/4HANA 2021, SAP BW/4HANA 2021, SAP HANA SPS06, and SUSE Linux Enterprise Server (SLES)15 SP3. Customers planning to transform their business processes by adopting SAP S/4HANA or SAP BW/4HANA often want to use the latest releases from SAP and operating system (OS) vendors. This launch makes it easy for customers to deploy and scale these applications and OS versions in accordance with AWS, SAP, and SUSE best practices. AWS Launch Wizard offers a guided way of sizing, configuring, and deploying AWS resources for third party applications, such as Microsoft SQL Server ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; A year ago, I blogged about An Unprivileged User can crash your MySQL Server.  At the time, I explained how to protect yourself against this problem.  A few weeks ago, I revisited this vulnerability in a follow-up post in which I explained the fix, claimed that the MySQL 5.7 default configuration for Group Replication is still problematic, and explained a tuning to avoid the vulnerability.  In this last post in the series, I explain how to exploit this vulnerability to crash older version of MySQL (or untuned Group Replication in 5.7), but this needs a ... Read More

Feed: Recent Announcements. New minor versions of Microsoft SQL Server are now available on Amazon RDS for SQL Server, offering performance and security fixes. Amazon RDS for SQL Server supports the new minor versions for Microsoft SQL Server 2019 and 2017 on the Express, Web, Standard, and Enterprise Editions ... Read More

Feed: James Serra's Blog. Author: James Serra. In talking with Microsoft customers, I have found that most are not aware that Microsoft has created industry clouds (see Microsoft Industry Clouds). So I wanted to use this blog to briefly explain what they are and how they may be useful to you. To clear up a lot of confusion, despite the name, these are not clouds they are separate for Azure. Rather, they use the Azure cloud along with existing tools and products customized for a specific industry and placed within the Azure cloud (think “add-ons”). These industry clouds package together ... Read More

Feed: Planet MySQL; Author: Chandan Kumar; Let's walk through on how to migrate sakila database from Azure for MySQL into Oracle Cloud MySQL Database Service(MDS). For the migration ,let's use MySQL Shell Utility features 1.       Dump Schema Utility a.       This will help us to take the backup from Azure for MySQL's database and export  to Oracle Cloud Object Storage. 2.       Load Dump Utility a.       This is help us to Import the schema from Object Storage to MySQL Database Service(MDS) at Oracle Cloud . More info:- https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-dump-instance-schema.html How does Migration Work ? Suppose you wanted to do lift-shift of database called ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; This post is the eight one of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published: As explained in post 1, our component will use libclamav. That’s why we need to link it to our component. The very first thing, we will include clamav.h in our scan.h (line 34): This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more ... Read More