I Wrote a Book on How You Broke Your Database ...
Preface If you are a frequent reader of Simple-Talk, it’s possible that you’ve come across blogs about […]
Preface If you are a frequent reader of Simple-Talk, it’s possible that you’ve come across blogs about […]
Previously, we introduced and discussed the Parquet file format and SQL Server and why it is an […]
I recently had an interesting production SQL Server issue that turned out to be very easy to […]
I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways […]
I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very […]
Happy New Year to all of the Simple talk readers! What a year this has been. I […]
The database is an important part of any application and setting it up correctly is key to […]
This article compares the Frappe and the Laravel frameworks, focusing on key technical differences in customization, database […]
I’ve used both Snowflake views and materialized views with varying degrees of success. Both have their place […]
First off, thank you to Kevin Chant for hosting TSQL Tuesday this month. And equally, thank you […]
In a typical data warehouse project, data is loaded, transformed and stored into a data store using […]
Query Store. This is my choice in relation to “What feature release made you say WOW!”, the […]
Oracle Database, often referred to simply as Oracle, is one of the most powerful and widely used […]
We are becoming used to being a bit lazy when granting permissions to Data Warehouses and lakehouses […]
You probably already realize this, but I work for a company that sponsors conferences. As the editor […]
If you’re a frequent reader of the Simple-Talk blog, you’re no stranger to indexes as we’ve covered […]
In Part I of this series, we explored overlap queries and the problems that accompany them, along […]
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
In today’s data-driven enterprise environment, businesses increasingly rely on Snowflake’s cloud data warehouse for handling large-scale data […]
In this article, I will discuss hiring and motivating technical polyglots. A polyglot is a person who […]
The amount of news brought by Ignite is huge. I was not expecting to find so many […]
When analytic data is stored directly in SQL Server, a clustered columnstore index is an ideal place […]
When you think of how to store data in a database, you think of data types. A […]
When learning something new, we always compare it with what we know. In this case, we end […]
Today’s post is in reply to the invitation post, Josephine Bush asks the question: “How do you […]
Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the […]
Welcome to part 2 of our Demystifying Continuous Integration vs. Continuous Delivery series. In Part 1 of […]
In the previous article (here) touched on the overview of Frappe and ERPNext and how they’re connected. […]
Time to start! Annabel Graham (Head of events at Redgate) comes out on stage Intro Annabel […]
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
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 […]