Purely Educational
SQL DISTINCT vs. UNIQUE
In Structured Query Language (SQL), the DISTINCT and UNIQUE statements eliminate duplicates but have...
Read PostSQL Server
Purely Technical
How to Create Scalable and Reliable Kubernetes Logging
This article looks at building a scalable and reliable logging solution for a large...
Read Post
Solutions
How to Accelerate MySQL Workloads
This article looks at three common scenarios data and infrastructure professionals often face and...
Read PostPopular Articles
Purely Educational
How to Back Up and Restore Azure SQL Databases
This article walks you through the steps for how to back up and restore...
Read Post
Purely Educational
Relational vs. Non-relational Databases
Relational and non-relational databases rely on fundamentally different ways of storing and retrieving data...
Read Post
Purely Educational
SQL UPDATE vs. INSERT vs. UPSERT
This article looks at three SQL statements: UPDATE, INSERT, and UPSERT. It includes examples...
Read Post
Purely Educational
How to Use the Oracle WITH Statement
The Oracle WITH clause simplifies complex queries so that you can use a single...
Read Post
Purely Educational
SQL DELETE vs. TRUNCATE
The SQL DELETE and TRUNCATE commands provide different functionality and should be used based...
Read Post
Purely Educational
SQL WHERE vs. HAVING
Structured Query Language (SQL) has several clauses to filter results in a data set....
Read Post
Purely Educational
How to Diagram a Data Warehouse
A data warehouse diagram helps organizations make decisions when upgrades are needed or changes...
Read Post
Purely Technical
Decrease Recovery Time for Microsoft SQL Server Disasters with Pure Cloud Block Store in Microsoft Azure
Using Pure Cloud Block Store with Microsoft SQL Server in Microsoft Azure enables you...
Read Post
Perspectives
The Dual Nature of Microsoft SQL Server 2022
At PASS Summit, Microsoft announced the release candidate of Microsoft SQL Server 2022. Learn...
Read Post
Products
How SQL Server 2022 Is Evolving to Make Database Admins More Efficient
Microsoft recently announced a preview of SQL Server 2022. Learn more about the feature...
Read PostCustomers can use Pure1 to assess how to improve power efficiency by metering watts per unit of data on the array that can be read back. This works hand in hand with the energy efficiency SLA.Product Marketing Leader
Perspectives
People of Pure: Meet Melody Zacharias
Pure’s Melody Zacharias is passionate about data and helping others. One of the world’s...
Read Post
Purely Technical
How to Attach/Detach SQL Server Databases with PowerShell
Here are some scripts I developed for the SQL Server 2012 Reference Architecture to...
Read Post
Perspectives
Bringing the Power of FlashBlade S3 to SQL Server 2022 Data Lakes
SQL Server 2022, when used in conjunction with FlashBlade, increases organizations’ return on investment...
Read Post
Products
Using FlashArray Snapshots for SQL Server
As data continues to grow, it becomes challenging to move. FlashArray Snapshots offer a...
Read Post
Perspectives
Modernize Data Protection Outcomes for MariaDB and MySQL
Open source databases like MySQL and MariaDB have grown in popularity, but a more...
Read Post