Redis is an in-memory NoSQL data store. Memory is faster than disk, but there are still ways to improve performance. In this article, Camilo Reyes compares caching strategies.… Read more
SQL Server sequence objects can be used in place of identity columns. In this article, Greg Larsen explains how to set up and use sequence objects.… Read more
It’s possible to query blob storage using SQL, but what about performance? In this article, Dennes Torres compares several query methods to see which one performs the best.… Read more
Last week, Steve Jones (@way0utwest), Grant Fritchey (@GFritchey), and I spent a few days at the Redgate Headquarters in Cambridge. Meeting at the office would not be unusual except for the times that we live in right now, as we typically get there about once a quarter. This is the first time that we’ve all … Read more
GraphQL is a platform-independent, language-neutral query language and may be used to run queries and retrieve data. Joydip Kanjilal explains how to use GaphQI in an ASP.NET Core 5 app.… Read more
Tableau is a popular visualization tool used by organizations around the world. In this article Sanil Mhatre demonstrates sentiment analysis with Tableau and Oracle data. … Read more
It’s not difficult to set up an extended event session, but reviewing and saving the data can be complex. In this article, Edward Pollack demonstrates how to collect extended event data.… Read more
Not a week goes by without news of a new cyberattack. In this article, Robert Sheldon explains the cybersecurity threats in today’s world.… Read more
Database objects often have references to external databases which makes continuous integration problematic. In this article Liz Baron and Sebastian Meine demonstrate a solution.… Read more
SQL Server identity columns are easy to add to a table, but you must understand how they work to use them effectively. In this article, Greg Larsen explains the nuances of SQL Server identity columns.… Read more
There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to get PowerShell to do more of the work.… Read more
Each year Redgate runs a survey to determine the state of database monitoring. This year, instead of one large report, we are publishing four insight reports, each on a different topic. The first came out this month: The real-world challenges of growing server estates. The respondents reported several trends: DBAs are managing more instances than … Read more
Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.… Read more
I recently became a certified Professional Scrum Product Owner (PSPO). As of today, there are less than 110,400 of us in the world. When a colleague asked me what I had learned, I prattled off the usual salient features of what it means to be a PSPO. The same evening, however, the question returned to … Read more
Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon explains the Azure SQL options.… Read more
Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in a table using Oracle Text.… Read more
The 2002 movie Minority Report is about a police unit called PreCrime, which can predict when people will commit a crime so they can be arrested before it happens. Things go awry when a team member played by Tom Cruise is himself “pre-accused.” To make predictions, they use technology and the special abilities of the … Read more
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
