T-SQL Programming Greg Larsen in T-SQL Programming Summarizing data using GROUP BY and HAVING clauses You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows... 27 May 2022 11 min read
MySQL Lukas Vileikis in MySQL Security in MySQL: Part Two There’s more to security in MySQL than user account privileges. In this article, Lukas Vileikis explains the other components of... 27 May 2022 10 min read
BI Dennes Torres in BI Datamarts and exploratory analysis using Power BI During Build 2022, Microsoft announced a new feature, Datamarts for Power BI. MVP Dennes Torres explains this new feature and... 25 May 2022 24 min read
PostgreSQL EzzEddin Abdullah in PostgreSQL How to troubleshoot and fix PostgreSQL performance issues PostgreSQL database performance is critical for application performance. EzzEddin Abdullah shows how to get information about a query’s performance from... 25 May 2022 13 min read
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
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
MySQL Lukas Vileikis in MySQL Security in MySQL: Part One There are several tools available to keep a MySQL database secure. In this article Lukas Vileikis discuses access control and... 20 May 2022 8 min read
BI Edward Pollack in BI Insights from the SSRS database The SSRS database contains a wealth of undocumented information that can help administrators. In this article, Edward Pollack explains how... 11 May 2022 17 min read
MySQL Robert Sheldon in MySQL Working with MySQL stored functions Stored functions in MySQL return a scalar value and can be used in a SQL statement. In this article, Robert... 09 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
MySQL Lukas Vileikis in MySQL Optimizing my.cnf for MySQL performance Database systems often need tuning for best performance. Lukas Vileikis explains to how to optimize my.cnf for MySQL performance.… 02 May 2022 13 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
Oracle Jonathan Lewis in Oracle Oracle optimizer removing or coalescing subqueries The Oracle optimizer often changes the query to get better performance. In this article, Jonathan Lewis explains two more optimizations... 27 April 2022 17 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
MySQL Lukas Vileikis in MySQL The nuances of MySQL indexes Indexes are critical for database performance. In this article, Lukas Vieikis explains the many types of indexes available with MySQL.… 21 April 2022 14 min read
MySQL Rajeshkumar Sasidharan in MySQL A MySQL story: Can system engineers solve database issues using system tools? A story about how a system engineer solved a MySQL performance issue written by Rajeshkumar Sasidharan.… 20 April 2022 14 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
MySQL Robert Sheldon in MySQL Working with MySQL Stored Procedures MySQL stored procedures are objects containing one or more SQL statements for reuse. They often contain business logic. Robert Sheldon... 15 April 2022 19 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
