In this post, I want to share a few places where you can keep up with what […]
Although it is probably true to say that “AI is reshaping the landscape of database technology“, it’s […]
T-SQL Notebooks is one of the new features announced during FabCon Europe. The most distracted could miss […]
By now, pretty much everyone has heard the stories about the first computers. They were huge, cost […]
If you’ve been following Simple Talk for a while, you know that we’re fans of databases and […]
In this article, I am going to explain how you can dial your productivity up to 11 […]
SQL is easy to start writing. The basic syntax to start returning data is very simple. This […]
Companies today require database systems that are reliable and capable of efficiently handling large volumes of data […]
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Power BI has been a leading data visualization tool in the market for years. It can be […]
In business operations and management, the integration of large Enterprise Resource Planning (ERP) systems has become paramount. […]
This year at Simple Talk has been exciting, after a slow start with me being more or […]
I would hope by now everybody has figured out when you see a price like $39.99 that […]
Database development has become more complex over the years due to the introduction of new data and […]
Azure Logic Apps are a cloud-based service where you can create low code workflows to automate your […]
SQL’s ability to manipulate data makes it relevant for people creating tools for data analysis. Analysts can […]
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Companies of all sizes and across industries are struggling to cope with an explosion of data never […]
The temporal database is a database that can keep information on time when the facts represented in […]
Introduction If you’ve been following SimpleTalk for a while, you will be aware that I’ve recently blogged […]
If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as […]
Let me start with a simple confession, and I hope it’s not too shocking for anyone; I’m […]
The focus of your backup strategy should not be backups. Instead, you should be focused on restoring […]
All developers hit the problem of how and where to store and set their configuration, profile, or […]
PySpark has some unconventional syntaxes which provide power to the development process, making it easier. We talked […]
Range queries are a very common task in SQL: selecting dates, numbers, or even text values that […]
An entire post on choosing the correct data types either seems like overkill or much needed and […]
Indexes in MySQL are one of the primary ways to enhance query performance and they are especially […]
As you all know about, just a few weeks ago we had the big CrowdStrike global IT […]
Many years ago, my wife and I wrote an article for Datamation, a major trade publication at […]
Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your […]
Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or […]
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level […]
In this article, I will cover a bit about the LIKE operator, including how it works, and […]
Partitioning in PostgreSQL was for many years a feature almost entirely ignored, and even today is often […]
This article offers technical guidance on automating updates and tracking changes of data examples using Snowflake’s CDC […]
Tomorrow, August 15, I have yet another conference where I’ll speak about MySQL’s performance. To be more […]
When I joined a growing startup company as a backend developer, we were at crossroads choosing between […]
In this first entry in a multipart series on indexes, I will cover the most important index […]
I recently had to help support synchronization and distribution of workloads between multiple servers. Some of this […]
Not many data professionals get a personal Learning and Development (L&D) budget that we can use at […]
Welcome to the dog days of summer in the Northern Hemisphere. It is hot, so if you […]
At Microsoft Build 2024, Real-Time Intelligence was announced with the Real-Time hub as its centralized location for […]
I’m not the first person to write about cleaning up unused or redundant indexes. You can read […]
Frappe is a full-stack, battery-included web framework with MariaDB as the database, written in Python and JavaScript. […]
This is the second part of my series on auditing SQL Server. In the first part, I […]
There was a lot of great advice, and I really wonder how much of this I would […]
The temporal database is a database that can keep information on time when the facts represented in […]
