Big Data Robert Sheldon in Big Data Data lakes take on big data A data lake is a scalable data storage repository that can ingest large amounts of raw data and make it... 10 January 2022 16 min read
Testing Devyani Borade in Testing Crowdsourcing quality: Can the hive mind/herd mentality help you in software testing? Crowdsourcing is one way to get a job done. In this article, Devyani Borade describes crowdsourcing quality testing of software.… 05 January 2022 8 min read
Learn SQL Server Greg Larsen in Learn SQL Server How to replace an identity column with a sequence number SQL Server provides two ways to include an incrementing number in a table. Greg Larsen explains how to replace an... 04 January 2022 16 min read
Editorials Kathi Kellenberger in Editorials Making predictions Steve Jones (@way0utwest), Grant Fritchey (@GFritchey), and I are often asked to predict trends in technology, especially at the end... 28 December 2021 3 min read
T-SQL Programming Joe Celko in T-SQL Programming Quantifier predicates Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a... 27 December 2021 11 min read
BI Adam Aspin in BI How to filter DAX for paginated reports DAX is unlike SQL when filtering. In this article, Adam Aspin demonstrates how to filter DAX for paginated reports.… 17 December 2021 13 min read
Editorials Kathi Kellenberger in Editorials A momentous year for Redgate Software December is often a time of reflection, and this year has been more unusual than most. It’s been another year... 15 December 2021 3 min read
Azure Mike Wood in Azure Azure Policies and Management Groups You can define policies for your Azure SQL Databases for security and meeting your organization’s standards. Management groups simplify policies... 13 December 2021 11 min read
Learn SQL Server Greg Larsen in Learn SQL Server How to return multiple sequence numbers with sp_sequence_get_range Developers can work with multiple range values at once using sp_sequence_get_range. Greg Larsen explains how to return multiple sequence numbers... 30 November 2021 13 min read
Editorials Kathi Kellenberger in Editorials Revisiting SQL Server certification I first touched a SQL Server instance back in 1998 during a SQL Server 6.5 course. I hadn’t planned to... 30 November 2021 3 min read
Featured Lance Talbert in Featured Unity state machine behaviours Video games would not be much fun without animation. In this article, Lance Talbert demonstrates Unity state machine behaviours to... 29 November 2021 12 min read
PowerShell Greg Moore in PowerShell Working with PowerShell strings Knowing how to manipulate strings is critical in any language. In this article, Greg Moore explains working with PowerShell strings.… 24 November 2021 12 min read
Featured Grant Fritchey in Featured Connecting to PostgreSQL: Learning PostgreSQL with Grant Database professionals often work with more than one database platform. Grant Fritchey explains setting up and connecting to PostgreSQL database.… 23 November 2021 7 min read
.NET Andy Brown in .NET 10 reasons why Python is better than C# (or almost any other programming language) After resisting learning Python for years, assuming it was just another object-oriented programming language, Andy Brown now gets what the... 16 November 2021 11 min read
BI Adam Aspin in BI Introduction to DAX for paginated reports SSRS reports can be built using DAX. In this article, Adam Aspin explains how to get started using DAX to... 15 November 2021 18 min read
T-SQL Programming Joe Celko in T-SQL Programming BETWEEN the two of us BETWEEN can be used in a SQL WHERE clause to filter on a range. Joe Celko explains the history of... 15 November 2021 11 min read
Learn SQL Server Greg Larsen in Learn SQL Server Using SQL Server sequence objects SQL Server sequence objects have several properties that control how they behave. Greg Larson explains the options of using SQL... 15 November 2021 14 min read
Editorials Kathi Kellenberger in Editorials SQL Server 2022 is a game changer Microsoft announced at the Ignite conference that SQL Server 2022 is on the way, and several significant new features should... 03 November 2021 2 min read
Security Robert Sheldon in Security Ransomware: A world under threat Ransomware has threatened many organizations over the past few years. In this article, Robert Sheldon explains the history of ransomware... 01 November 2021 12 min read
