Dennes Torres in Blogs Fabric Copy Job: What’s new in it At first sight, the new Copy Job may seem only one more redundancy: Why do we need this? We have... 15 January 2025 2 min read
Lukas Vileikis in Blogs I Wrote a Book on How You Broke Your Database – Here’s Why You Should Read It This blog introduces the book "Hacking MySQL: Breaking, Optimizing, and Securing MySQL for Your Use Case" by Lukas Vileikis.… 10 January 2025 7 min read
Microsoft Fabric Dennes Torres in Microsoft Fabric High Concurrency Data Pipelines in Fabric Data Pipelines can orchestrate many activities, creating a flow for data ingestion. One of these activities is the notebook execution... 08 January 2025 2 min read
Ben Johnston in Blogs A Use Case for Memory-Optimized Tempdb Metadata I recently had an interesting production SQL Server issue that turned out to be very easy to fix. The fix... 08 January 2025 10 min read
Dennes Torres in Blogs T-SQL Tuesday #181: Query Store and its evolution Query Store. This is my choice in relation to “What feature release made you say WOW!”, the subject of this... 09 December 2024 4 min read
Dennes Torres in Blogs KQL: The top of a group in an easy way When learning something new, we always compare it with what we know. In this case, we end up comparing KQL... 13 November 2024 3 min read
Dennes Torres in Blogs Analyzing Kusto Query History in Fabric We can consume a Kusto database in Fabric from many different places: Notebooks, semantic models, real time dashboards and more.... 07 November 2024 5 min read
Dennes Torres in Blogs T-SQL Notebooks: Manage Views Source Control and more T-SQL Notebooks is one of the new features announced during FabCon Europe. The most distracted could miss the fact this... 31 October 2024 3 min read
Dennes Torres in Blogs Shortcuts, Capacities and Costs : Some Considerations Edit on 25/10/2024: According to some official documentations, there is an inaccuracy on this blog. The costs involved on data... 23 October 2024 3 min read
Ben Johnston in Blogs Writing an Efficient Query SQL is easy to start writing. The basic syntax to start returning data is very simple. This low threshold for... 19 October 2024 20 min read
Microsoft Fabric Dennes Torres in Microsoft Fabric Using a Service Account in Microsoft Fabric Applications should never depend on user accounts for their own authentication. User accounts have unique security configurations, such as MFA... 16 October 2024 4 min read
Louis Davidson in Blogs Mental Rest The importance of rest of all types can’t be overstated. In today’s world, rest is a rare and valuable commodity.... 15 October 2024 4 min read
Dennes Torres in Blogs Cloud Connections in Microsoft Fabric I wrote about cloud connections when they were in a very early stage. Cloud connections evolved and are now sharable.... 09 October 2024 4 min read
Dennes Torres in Blogs Debugging DAX with DAX Query View DAX Query View was created some time ago and it was a great tool to run DAX inside Power BI... 25 September 2024 3 min read
Dennes Torres in Blogs Infinity Notebook Loop in Fabric using Data Activator Data Activator allow us to make an interesting workaround for infinity notebook executions. Infinity execution loop is interesting for constant... 20 September 2024 4 min read
Lukas Vileikis in Blogs Thoughts Before Covering MariaDB Indexes in the MariaDB Server Fest 2024 This blog outlines why you should be coming to see a talk on MariaDB indexes at the MariaDB Server Fest... 13 September 2024 4 min read
Dennes Torres in Blogs Data Activator: The secrets of monitoring alerts Data Activator supports email and Teams alerts. These are good options when we would like to monitor some information and... 11 September 2024 2 min read
Lukas Vileikis in Blogs Devising the Perfect Index for Your Use Case – MySQL Edition This blog will walk you through how to choose the perfect index for your specific use case. It will also... 11 September 2024 7 min read
Grant Fritchey in Blogs What Did AI Ever Do for Me? Let me start with a simple confession, and I hope it’s not too shocking for anyone; I’m old. When I... 09 September 2024 3 min read
Dennes Torres Microsoft Fabric and PySpark: Coding tricks to improve your solutions PySpark has some unconventional syntaxes which provide power to the development process, making it easier. We talked about loops before. Let’s... 04 September 2024 4 min read
