Editorials Grant Fritchey in Editorials Do not be surprised For the first time in eleven years of travel, I became profoundly sick while on the road. No, I’m not... 01 September 2022 2 min read
Editorials Kathi Kellenberger in Editorials One more about Star Trek I can’t move on from editing Simple Talk without one more editorial about Star Trek. There are over 600 hours... 01 June 2022 2 min read
Theory and design Joe Celko in Theory and design The VALUES clause or building tables out of nothing The VALUES clause makes inserting literal values into a table simple and easy. In this article, Joe Celko explains how... 23 May 2022 6 min read
BI Edward Pollack in BI SSRS ReportServer Database: Tables & Queries Explore the SSRS ReportServer database structure - Catalog, ExecutionLog, Subscriptions, and more. Includes ready-to-use SQL queries for report metadata, usage... 11 May 2022 18 min read
Data Science Kumar Abhishek in Data Science Introduction to Artificial Intelligence for Developers A developer's introduction to AI: machine learning, neural networks, NLP, and realworld applications. Learn the key concepts behind AI systems... 10 May 2022 17 min read
Theory and design Joe Celko in Theory and design Combinations, permutations, and derangements Joe Celko explains how several mathematical concepts, combinations, permutations, and derangements, relate to databases.… 03 May 2022 8 min read
T-SQL Programming Edward Pollack in T-SQL Programming Getting results using less T-SQL There is usually more than one way to write a query. In this article, Edward Pollack explains a few ways... 27 April 2022 16 min read
Editorials Devyani Borade in Editorials Mighty Tester: Damned if you do, damned if you don’t … 27 April 2022 1 min read
Learn SQL Server Greg Larsen in Learn SQL Server The ins and outs of joining tables in SQL Server Most database queries require joining tables. In this article, Greg Larsen explains the ins and outs of joining tables in... 21 April 2022 11 min read
BI Dennes Torres in BI How to automate table level refresh in Power BI You can automate Power BI table refreshes using PowerShell, an Automation Account, and Runbook. Dennes Torres explains how in this... 18 April 2022 14 min read
Data Science Naveed Janvekar in Data Science Clustering data for insights Clustering data gives quick insights into large unstructured data. In this article, Naveed Janvekar explains clustering and provides a quick... 11 April 2022 6 min read
BI Sanil Mhatre in BI Finding deeper insights with Topic Modeling Topic modeling can be used to find more detailed insights into text than a word cloud can provide. Sanil Mhatre... 06 April 2022 23 min read
BI Adam Aspin in BI DAX Table Functions in Power BI Paginated Reports: Advanced Patterns and Tips Advanced DAX patterns for Power BI paginated reports: simulate NOT IN, remove filter columns, build complex OR filters across multi-select... 22 March 2022 21 min read
Learn SQL Server Greg Larsen in Learn SQL Server Ordering a result set in SQL Server To guarantee the order of a result set, you must use an ORDER BY clause. In this article, Greg Larsen... 18 March 2022 12 min read
Theory and design Joe Celko in Theory and design The problem with averages Everyone learns to calculate an average in school, but, as Joe Celko shows, there are better ways to summarize data.… 01 March 2022 8 min read
BI Adam Aspin in BI DAX Paginated Reports Part 2: Variables, EXCEPT/UNION, GROUPBY, and CALCULATETABLE DAX for Power BI paginated reports Part 2: scalar and table DAX variables, EXCEPT/UNION/INTERSECT for set operations, GROUPBY and SUMMARIZE,... 15 February 2022 13 min read
Data Science Sanil Mhatre in Data Science Sentiment Analysis with Python Python is a modern general-purpose programming language that's very useful for analytics. Sanil Mhatre demonstrates sentiment analysis with Python.… 03 February 2022 17 min read
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 CHAR vs VARCHAR vs VARCHAR(MAX) in SQL Server Understand when to use CHAR, VARCHAR, or VARCHAR(MAX) in SQL Server. Compares storage behaviour, performance trade-offs, and gives practical data-type... 20 January 2022 15 min read
