Tag: SQL

February 5, 2024

NoSQL databases arose in response to the limitations of using SQL (Structured Query Language) for database queries. NoSQL databases store and manage data in ways that enable high operational speed and a level of flexibility not found in traditional relational […]

October 26, 2023

Sure, there are LLM-powered websites you can use for chatbots, querying a document, or turning text into SQL. But there’s nothing like having access to the underlying code. Along with the satisfaction of getting an application up and running, working […]

May 3, 2023

dbForge Studio for PostgreSQL is an advanced integrated development environment (IDE) tailored for PostgreSQL data analysis experts and administrators. It provides an extensive array of features that assist data analysts and developers in enhancing their productivity. Some of the key […]

December 28, 2022

You hear the word AI everywhere you go. It has influenced all spheres of life and all domains of business. No wonder AI is now capable of writing computer code. This is indeed bad news for developers, who may lose […]

October 26, 2022

As enterprises see an unprecedented increase in real-time data analytics, InfluxDB on Wednesday said that it was releasing a next-generation time series engine for its managed database service InfluxDB Cloud. Time series data, according to market research firm IDC, can […]

July 27, 2022

In the last episode we looked at a Steampipe dashboard that joins search results across diverse APIs. That metasearch dashboard is defined entirely in code that blends two languages: SQL to query the APIs, and HCL (HashiCorp Configuration Language) to […]

June 24, 2022

One of the most fundamental choices to make when developing an application is whether to use a SQL or NoSQL database to store the data. Conventional databases, meaning relational databases that use SQL (Structured Query Language) for queries, are the […]

February 1, 2022

Programming languages are one of the most important tools in the DevOps arsenal. Choosing the right programming language or languages for your application is essential for succeeding at DevOps and achieving continuous integration/continuous delivery (CI/CD). Given that there are hundreds […]

December 13, 2021

There are a lot of reasons to take SQL Server monitoring seriously, and it should be a priority for any database administrator. Two of the top contenders in this context are the opportunity to optimize availability and also to get […]

August 24, 2021

Databases are typically classified as relational (SQL) or NoSQL, and transactional (OLTP), analytic (OLAP), or hybrid (HTAP). Departmental and special-purpose databases were initially considered huge improvements to business practices, but later derided as “islands.” Attempts to create unified databases for […]

April 14, 2021

Hope springs eternal in the database business. While we’re still hearing about data warehouses (fast analysis databases, typically featuring in-memory columnar storage) and tools that improve the ETL step (extract, transform, and load), we’re also hearing about improvements in data […]

June 28, 2018

Microsoft has introduced many new features to improve query performance in SQL Server. For example, SQL Server 2017 and Azure SQL Database have Query Store, Adapting Query Processing, Automatic Tuning of SQL Query, etc. to improve the query performance. In […]

June 26, 2018

Hackolade offers an array of Data Modeling tools designed for various NoSQL databases. Their software is user-friendly, while providing powerful graphics. These features, combined with flexible HTML model documentation, provide a visual blueprint for each application. Hackolade’s output is similar […]

March 29, 2018

DataDirect Networks (DDN®) today announced its strategic partnership with SQream to deliver real-time Big Data analytics solutions and to significantly accelerate business decision making. The combination of DDN’s SFA® and IME® NVMe SSD storage platforms with SQream DB’s GPU-based Big […]

January 15, 2018

There are many things to consider when capacity planning for SQL Server. Storage and disk capacity are apparent, but when you want to right-size your database(s) for a new SQL implementation or migration, there is a lot more to think […]

September 5, 2017

Kinetica, provider of the fastest GPU-accelerated database, today announced the availability of native integration with Tableau allowing users to simultaneously ingest, explore, analyze, and visualize data within milliseconds to make critical decisions and find efficiencies, lower cost, generate new revenue, […]

August 31, 2017

Polyglot Persistence is a process for storing data in in the best database available, matter the data model and data storage technology. This process is based on the understanding different data stores will handle certain types of data better than […]

May 24, 2017

IDERA, a provider of database lifecycle management solutions, has enhanced its SQL Secure and SQL Doctor products with new cloud capabilities. The releases help data professionals to adapt to, experiment with and take advantage of expanding cloud strategies, while DBAs […]

May 15, 2017

CockroachDB, an open source, fault-tolerant SQL database with horizontal scaling and strong consistency across nodes—and a name few people will likely forget—is now officially available. Cockroach Labs, the company behind its development, touts CockroachDB as a “cloud native” database solution—a […]

May 10, 2017

MySQL is a bit of an attention hog. With relational databases supposedly put on deathwatch by NoSQL, MySQL should have been edging gracefully to the exit by now (or not so gracefully, like IBM’s DB2). Instead, MySQL remains neck-and-neck with […]