BI Adam Aspin in BI DAX table functions for paginated reports: Part 1 Several DAX table functions can be used for paginated reports when you want all the data, not a summary. Adam... 21 January 2022 15 min read
Learn SQL Server Greg Larsen in Learn SQL Server When to use CHAR, VARCHAR, or VARCHAR(MAX) It’s important to choose the right datatypes when designing a database. Greg Larsen explains the differences between CHAR, VARCHAR and... 20 January 2022 14 min read
Editorials Kathi Kellenberger in Editorials English language confusion The technology books I’ve written go through a couple of edits, first by someone knowledgeable in the subject area and... 11 January 2022 3 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
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
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
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
.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
.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
.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
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
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
