.NET Camilo Reyes in .NET Cache strategies in Redis Redis is an in-memory NoSQL data store. Memory is faster than disk, but there are still ways to improve performance.... 25 October 2021 11 min read
Learn SQL Server Greg Larsen in Learn SQL Server Introduction to SQL Server sequence objects SQL Server sequence objects can be used in place of identity columns. In this article, Greg Larsen explains how to... 25 October 2021 15 min read
Azure Dennes Torres in Azure Performance of querying blob storage with SQL It’s possible to query blob storage using SQL, but what about performance? In this article, Dennes Torres compares several query... 21 October 2021 14 min read
Editorials Kathi Kellenberger in Editorials Back in the office Last week, Steve Jones (@way0utwest), Grant Fritchey (@GFritchey), and I spent a few days at the Redgate Headquarters in Cambridge.... 20 October 2021 3 min read
.NET Joydip Kanjilal in .NET Building and consuming GraphQL API in ASP.NET Core 5 GraphQL is a platform-independent, language-neutral query language and may be used to run queries and retrieve data. Joydip Kanjilal explains... 20 October 2021 23 min read
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Data Visualization in Tableau Tableau is a popular visualization tool used by organizations around the world. In this article Sanil Mhatre demonstrates sentiment analysis... 18 October 2021 19 min read
Performance Edward Pollack in Performance Automating Extended Events data collection It’s not difficult to set up an extended event session, but reviewing and saving the data can be complex. In... 04 October 2021 18 min read
Editorials Devyani Borade in Editorials Testing is not a popularity contest … 30 September 2021 1 min read
Security Robert Sheldon in Security Cybersecurity threats Not a week goes by without news of a new cyberattack. In this article, Robert Sheldon explains the cybersecurity threats... 30 September 2021 12 min read
CI/CD Sebastian Meine Liz Baron in CI/CD How to successfully deploy databases with external references Database objects often have references to external databases which makes continuous integration problematic. In this article Liz Baron and Sebastian... 29 September 2021 8 min read
Learn SQL Server Greg Larsen in Learn SQL Server Working with SQL Server identity columns SQL Server identity columns are easy to add to a table, but you must understand how they work to use... 24 September 2021 12 min read
PowerShell Greg Moore in PowerShell Building an ETL with PowerShell There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to... 22 September 2021 11 min read
Editorials Kathi Kellenberger in Editorials The challenges of ever-growing estates Each year Redgate runs a survey to determine the state of database monitoring. This year, instead of one large report,... 21 September 2021 3 min read
Database Administration Edward Pollack in Database Administration Building blocks of Extended Events data collection Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of... 14 September 2021 14 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming How LAG compares to other techniques LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to... 07 September 2021 13 min read
Editorials Devyani Borade in Editorials Lessons learned from achieving a certification I recently became a certified Professional Scrum Product Owner (PSPO). As of today, there are less than 110,400 of us... 03 September 2021 6 min read
Azure Robert Sheldon in Azure The Azure SQL portfolio Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon... 01 September 2021 14 min read
Editorials Kathi Kellenberger in Editorials Machine learning, both exciting and scary The 2002 movie Minority Report is about a police unit called PreCrime, which can predict when people will commit a... 25 August 2021 2 min read
Learn SQL Server Greg Larsen in Learn SQL Server SQL Server identity column The SQL Server identity column is used to populate a column with incrementing numbers on insert. In this article, Greg... 23 August 2021 13 min read
Oracle Jonathan Lewis in Oracle Oracle sequences – 12c features including “identity” Oracle added several enhancements to the sequence object in version 12c, including an “identity” column feature. Jonathan Lewis explains how... 19 August 2021 16 min read
