Data, AI, intelligent applications. They’re no longer separate topics, or even separate conferences. O’Reilly announced that it is merging its data and AI conferences, saying, “Data feeds AI; AI makes sense of data.” Further, both power applications.
In the spirit of Grant Fritchey's recent rants, and Erin Stellato's efforts since I think before we met, I want to get on the bandwagon to trumpet and promote the idea of ditching trace in favor of Extended Events. When someone says trace, most people immediately think Profiler.
Lot of people does migration from Oracle's PL/SQL to PostgreSQL's PL/pgSQL. One question is how to migrate private functions? There is not a reply. Oracle's PL/SQL is little bit modified language ADA. This language is procedural and modular.
After making its mark in the OLTP world, PostgreSQL is moving towards catering the needs of OLAP environment. Hence, the recent advancements in features like parallel query, declarative partitioning, and partition-wise joins and aggregates, etc. Since the introduction of parallel query in v 9.
Question: How to Join Two Tables Without Using Join Keywords? Answer: In my life, I have attended many interviews as an interviewer. Sometimes the interview panel is asking progressive positive questions and sometimes they ask a question which is regressive.
When choosing a NoSQL database technology important considerations should be taken into account, such as performance, resilience, reliability, and security. These key factors should also be aligned with achieving business goals, at least as far as the database is concerned.
Before this post gets started, let’s get past the title. I know what many of you are thinking: what in the name of Paul Randal would make someone have an EXTRA log file? The short answer is: desperate times.
One of the very popular questions I receive is how to import data from Excel in SQL Server. Let us learn about that in this blog post and we will use SQL Server Management Studio for this exercise. First, create any sample data in Excel. I will be using this sample excel for our example.
The second of three articles focused on building Fullstack React and GraphQL with Express and Couchbase Server. If unfamiliar with GraphQL, take a few minutes to get up to speed using the GraphQL documentation. The following pages should be a good start:
There are a lot of things I love about Prometheus; its data model is fantastic for monitoring applications and PromQL language is often more expressive than SQL for data retrieval needs you have in the observability space.
I will try to make it short and clear: if you are writing SQL queries with “NOT IN” like SELECT … WHERE x NOT IN (SELECT y FROM …) you have to be sure to first understand what happens when “x” or “y” are NULL: it might not be what you want! And if it is not, I will tell you here ho
I decided to write this off the back of a conversation I was having the other day around the SOS_SCHEDULER_YIELD wait type. The conversation went something along the lines of “but David, I’m seeing SOS_SCHEDULER_YIELD, we must have CPU issues”.
In this article, I have explained the step by step process of migrating data from SQL Server to Azure Cosmos database. To perform database migration, we will proceed in the following manner: To understand the data migration process, I have explained it into multiple steps.
PonyORM makes database interactions easy. Developers can query a SQL database in Python syntax, and allow Pony to translate Python queries into SQL and execute them in the most efficient way. But database interactions are only half the battle.
Yes, by default your InnoDB transactions don’t have the Atomicity . But, you can control the atomicity of your InnoDB transaction with the variable innodb_rollback_on_timeout. We had a weird data inconsistency issue within the transaction .
Trends in cloud data storage continue to accelerate at a rapid pace. Now more than ever, organizations must evaluate their current and future data storage needs to find solutions that align with business goals.
When I was first presented with the opportunity to work remotely I was ecstatic. What could be better than no commute and working from the comfort of my own home?! And while both of those things are great perks, learning to love the remote life took some time.
There really are technology stacks and business use cases that should never be moved off of big iron. Then there’s the rest of us. Chances are very high if you’re not already starting to move your data storage to the cloud, it’s being discussed right now in your business.
Look at an intro to the MySQL database (an RDBMS) and go through its architecture and features that make it the best choice for developing web apps or websites. One of the numerous important aspects for the smooth functioning of a website or a web app is the strength of its database.
Some pros and cons of running production databases as containers include databases on demand, high disk usage, automated stateless containers, and more. Containerization has long been transforming the way we develop and deploy apps and microservices now.
As developers should not have access to production data, it’s possible that duplicate values can sneak in during migrations. In this article of the series, Phil Factor demonstrates a way to check for duplicates when unique constraints are disabled.
It is sometimes inevitable to run MySQL database servers on a public or exposed network. This is a common setup in a shared hosting environment, where a server is configured with multiple services and often running within the same server as the database server.