Top

Tag: SQL


Computing, Data Management

InfluxDB’s next-gen time-series engine is built on Rust, supports SQL

October 26, 2022

Via: Info World

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 […]


Computing, Data Management

Visualizing the Hacker News API with HCL and SQL

July 27, 2022

Via: Info World

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 […]


Computing, Data Management

What is NoSQL? Databases for a cloud-scale future

June 24, 2022

Via: Info World

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 […]


Computing, Software & Applications

Top 15 DevOps Programming Languages to Learn in 2022

February 1, 2022

Via: Big Data Analytics News

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 […]


Computing, Data Management

Monitor SQL Server for Redundancy Management & Database Sizing

December 13, 2021

Via: Big Data Analytics News

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 […]


Computing, Data Management

What is a data warehouse? The source of business intelligence

August 24, 2021

Via: Info World

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 […]


Computing, Data Management

Ahana Cloud for Presto review: Fast SQL queries against data lakes

April 14, 2021

Via: Info World

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 […]


Online Tools, Performance, security, and availability

Automatic Query Performance Tuning in SQL Server Database

June 28, 2018

Via: Database Journal

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 […]


Online Tools, Performance, security, and availability

Data Modeling and NoSQL: Innovation and Flexibility

June 26, 2018

Via: Dataversity

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 […]


Application areas, Other

DDN and SQream Partner to Deliver the World’s Fastest Big Data Analytics

March 29, 2018

Via: Dataversity

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 […]


Application areas, Other

Capacity Planning Strategies for SQL Server

January 15, 2018

Via: Database Trends and Applications

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 […]


Application areas, Education

Kinetica Brings GPU Acceleration with SQL to Tableau

September 5, 2017

Via: Dataversity

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, […]


Application areas, Other

Utilizing Multiple Data Stores and Data Models: Is Polyglot Persistence Worth It?

August 31, 2017

Via: Dataversity

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 […]


Performance, security, and availability

IDERA Updates SQL Secure and SQL Doctor Cloud

May 24, 2017

Via: Database Trends and Applications

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 […]


Online Tools

Open source SQL database CockroachDB hits 1.0

May 15, 2017

Via: Info World

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 […]


Computing, Data Management

NoSQL, no problem: Why MySQL is still king

May 10, 2017

Via: Info World

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 […]


Application areas, Other

NoSQL, no problem: Why MySQL is still king

May 10, 2017

Via: Info World

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 […]


Application areas, Other

VMware and Oracle Collaborate on Security and Management of Oracle Mobile Enterprise Applications

May 5, 2017

Via: Database Trends and Applications

VMware, a global leader in cloud infrastructure and business mobility and Gold level member of Oracle PartnerNetwork, and Oracle have formed a new relationship to simplify management and enable advanced security features for Oracle’s suite of mobile business applications and […]


Application areas, Other

Light a fire under Cassandra with Apache Ignite

April 28, 2017

Via: Info World

Apache Cassandra is a popular database for several reasons. The open source, distributed, NoSQL database has no single point of failure, so it’s well suited for high-availability applications. It supports multi-datacenter replication, allowing organizations to achieve greater resiliency by, for […]


Performance, security, and availability

Python power comes to SQL Server 2017

April 27, 2017

Via: Info World

Don’t bring the data to your computation if you can help it. Bring your computation to your data. Microsoft has heeded this cardinal rule of information science with the latest Community Technology Preview release of SQL Server 2017. Python can […]