Articles about SQL

Embark on a transformative journey with this course designed to equip you with robust Python and SQL skills. Starting with an introduction to Python, you'll delve into fundamental building blocks, control flow, functions, and object-oriented programming.

As you progress, you'll master data structures, file I/O, exception handling, and the Python Standard Library, ensuring a solid foundation in Python. The course then transitions to SQL, beginning with an introduction and covering basics, and proceeding to advanced querying techniques.

Continue reading →

Data Analytics & Visualization All-in-One For Dummies collects the essential information on mining, organizing, and communicating data, all in one place.

Clocking in at around 850 pages, this tome of a reference delivers eight books in one, so you can build a solid foundation of knowledge in data wrangling. Data analytics professionals are highly sought after these days, and this book will put you on the path to becoming one.

Continue reading →

Data management language SQL (originally published as SEQUEL) first appeared in May 1974, so this month marks its 50th anniversary.

We spoke to Peter Zaitsev, founder at Percona, to find out why SQL has survived for the last 50 years, and is still the third most used language for programmers and software developers according to Stack Overflow.

Continue reading →

When it comes to the type of storage you might use for a cloud-based SQL Server deployment, all the major cloud providers provide a bewildering array of options. Azure offers Standard HDD as well as Standard SSD, Premium SSD as well as Premium SSD v2. Oh, and then there’s Ultra Disk. And AWS? The options are no less eye-glazing: ST1 and Standard, GP2 and GP3, IO1 and IO2.

Even if you could easily differentiate the offerings, what would be your best choice if you plan to configure your infrastructure for high availability (HA) -- by which we mean an infrastructure designed to ensure that your SQL Server database will be available and operating no less than 99.99 percent of the time?

Continue reading →

The popular database MySQL version 5.7 hits end of life status on the 31st of October 2023, just a few months away.

This means organizations that are running MySQL 5.7 will have to plan ahead on their options for the future. Dave Stokes, technology evangelist at Percona, spoke to us about some of the choices that will need to be made as well as how to get started on the process.

Continue reading →

Today's organizations often manage SQL Server databases across various platforms, including physical, virtual, cloud, on-premises, hybrid cloud, and cloud-to-cloud environments. Managing individual instances of SQL Server in these diverse environments is challenging enough. How can you ensure that your key SQL Server databases are highly available -- meaning, accessible 99.99 percent of the time -- when so many platforms are involved?

High availability (HA) in a multi-platform environment depends on multiple factors. You’re going to need at least two systems running SQL Server, but where your primary and secondary systems reside -- on-prem, in the cloud, in multiple clouds, or some combination of these -- really doesn’t matter. What matters is that the data is reliably replicated among the primary and secondary environments. That requires a robust data replication system, seamless communications between the primary and secondary environments, and systems in place to monitor the health of both environments and to manage failover in the event that your primary SQL Server system becomes unavailable.

Continue reading →