BI Dennes Torres in BI Azure Synapse Link for SQL: From production to a data warehouse in a few clicks Microsoft announced Azure Synapse Link for SQL. In this article, MVP Dennes Torres explains the new feature.… 24 May 2022 18 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
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
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
Security Priyanka Chouhan in Security SQL Server vulnerabilities and assessment SQL Server has many features to keep the database secure, but you must implement them to benefit. In this article,... 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
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
T-SQL Programming Greg Larsen in T-SQL Programming The basic T-SQL SELECT statement The SQL language is used across many relational database platforms. Greg Larsen explains the basics of the SELECT statement for... 22 February 2022 10 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
Azure Dennes Torres in Azure Eight Azure SQL configurations you may have missed Azure SQL Database has been around for over ten years and is constantly evolving with new capabilities and options. Dennes... 07 February 2022 12 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 Compare CHAR, VARCHAR, and VARCHAR(MAX) in SQL Server - when to use each, storage differences, performance impact, and maximum length... 20 January 2022 15 min read
BI Edward Pollack in BI Vertipaq optimization and its impact on columnstore compression Vertipaq optimization is a critical component of the columnstore compression process. Edward Pollack explains how it works and what you... 19 January 2022 21 min read
Learn SQL Server Greg Larsen in Learn SQL Server Replace a SQL Server Identity Column with a Sequence Number: Two Methods Learn how to replace a SQL Server IDENTITY column with a SEQUENCE number using two methods: step-by-step column modification (with... 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 DAX Filtering for Paginated Reports: A Guide Master DAX filtering for paginated reports using SUMMARIZECOLUMNS. Covers basic filters, OR logic, expressions, and rscustomdaxfilter for Power BI Premium... 17 December 2021 14 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
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
