When forced to choose, quality wins out over speed seven out of 10 times according to a survey of over 600 IT professionals conducted by OverOps, a vendor that helps identify and remediate software issues. In the real world, the choice is not stark.
Security, when done right, not only protects your data but improves performance, system stability, and enhances the development life-cycle. Because PostgreSQL security can easily become an all-encompassing activity, we’ll deal with the most common mechanisms.
A hapless IT bod found the Have I Been Pwned service (HIBP) answering its own question in a way he really didn’t want – after a breach report including a SQL string KO’d his company’s helpdesk ticket system.
We are happy to announce that the YugabyteDB Operator is now certified and available as a Beta release on Red Hat OpenShift, a leading enterprise Kubernetes platform for deploying and managing cloud native applications.
Data ingestion and data analysis are the yin and yang of a time series platform. There are many resources to help you ingest data. Typical ingestions are agent-based, imports via CSVs, using client libraries, or via third-party technologies.
First I want to thank everyone who attended my May 21, 2020 webinar “How Safe is Asynchronous Master-Master Setup in MySQL?“. Recording and slides are available on the webinar page. Here are answers to the questions from participants which I was not able to provide during the webinar.
There is no SQL Server Agent for AzureSQL, how can I create scheduled jobs to run on my AzureSQL database? Azure has a service named Logic App that let you to create and schedule tasks to perform actions on other Azure resources, including AzureSQL databases.
Quite recently, I reached a milestone of 10k post views in Dev. Which might seem less to you but a lot to me. You know, it feels good to see people reading your posts(and giving some unicorns 🦄). And I thought it would be a good idea to have a better visualization of the data that dev.
A while ago, I wrote about B-tree improvements in v12. PostgreSQL v13, which will come out later this year, will feature index entry deduplication as an even more impressive improvement. So I thought it was time for a follow-up.
We’re excited to bring to you three new training courses we just published on our GraphAcademy site: Introduction to Neo4j 4.0, Graph Data Modeling for Neo4j and Basic Neo4j 4.0 Administration. This course is an update to the course Introduction to Neo4j 3.
Welcome back to the Maven series. Now that we have covered the basics we're ready to continue the journey. As it happens dependency resolution is one of Apace Maven's greatest assets but also a source of frustration when things do not go as expected.
Liquibase has offered for a very long time, the ability to define changeSets using SQL. In fact, according to their survey, it’s the MOST popular way of developing your schema deployment scripts. And it’s no surprise as to to why.
Hello all! With some extra time on my hands, I'm given the perfect opportunity to perfect the art of technical interviewing before recruitment season. One way I'm bettering my interviewing skills is nailing the fundamentals.
Time to Live (TTL) is a Scylla (and Apache Cassandra) feature that is often used but not always fully understood. Scylla provides the functionality to automatically delete expired data according to TTL. We recently updated our documentation and added a new lesson on this topic to Scylla University.
If constraints in general have caught your interest, our interactive learning portal has a whole section on the use of non-spatial constraints, even a video walkthrough! In our last installment, we covered the use of CHECK constraints to enforce data quality at an object level.
With high availability being paramount in today’s business reality, one of the most common scenarios for users to deal with is how to ensure that the database will always be available for the application.
With shifting priorities and dynamic technology environments, IT security teams are looking for ways to cover the most ground while draining as few resources as possible. Privileged access... As a security professional, you’re busier than ever, juggling work, life and everything in between.
These are my SQL Server Diagnostic Information Queries for June 2020, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a short amount of time.
The leaked data was obtained after the hacker breached DH earlier this year, on March 10, 2020. At the time, DH owner Daniel Winzen told ZDNet the hacker breached his portal, stole its database, and then wiped all servers.
SQL Azure Database by default offers a 99.99% availability SLA across all its service tiers. This means that for any database, the downtime should not exceed 52 minutes per year. Using Zone redundancy increases availability to 99.995% which is about 26 minutes per year.
How might we model graphs beyond the most common use cases, and take a more creative approach to graph modeling? This post introduces the Graph Commons platform and walks through novel graph examples from the community.
Bill Kennedy is no stranger to databases - in fact, he has helped several businesses build applications on databases for years. He began working with SQL before moving on to NoSQL. In 2020, however, Bill started using Dgraph because it provided what he needed but in a new and modern package.