Editorials Louis Davidson in Editorials What Counts for a DBA – Deadlines Everyone needs deadlines. Even the beavers. They loaf around all summer, but when they are faced with the winter deadline,... 01 June 2021 4 min read
Other Dennes Torres in Other Using Power BI to Query Log Analytics Log Analytics is a basic tool for the entire Azure environment, I wrote about it before. The possibility to access... 24 May 2021 5 min read
Other Dennes Torres in Other Azure Static Web Apps: Bring Your Own Function (BYOF) Azure technologies evolve so fast sometimes we lose track of what’s happening. One day, a simple technology is created, on... 18 May 2021 4 min read
Other Dennes Torres in Other Power Query: Transforming Desktop Queries in Dataflows .There are some interesting ways to transform queries from Power BI Desktop to Power BI dataflows in the portal. The... 11 May 2021 5 min read
Other Dennes Torres in Other Saving money with Log Analytics Azure Monitor and Log Analytics are a very important part of Azure infrastructure. In my opinion, the adoption of these... 01 May 2021 5 min read
Other Dennes Torres in Other Malta Data Saturday and Our New Era The Malta Data Saturday is finishing. I still need to compile the numbers, but the comments and feedback are great. Let’s... 26 April 2021 13 min read
Other Dennes Torres in Other Denormalization in Production: Common Problem and Solution After a young developer (or database developer) learns about normalization, the quality of his databases increases a lot, there is... 19 April 2021 4 min read
Dennes Torres in Other Data Platform: Links to Study and Learn Last Friday I appeared in the middle of a Brazilian Twitch live made by a friend and while they were... 29 March 2021 4 min read
Other Louis Davidson in Other Determining actions you can take with Edge and Node tables in SQL Server One of the interesting things about working with many-to-many relationships in SQL Server with graph tables instead of a relational... 20 March 2021 9 min read
Other Annette Allen in Other What a year for the Technical Community The last year hasn’t been easy and most of us, especially in the IT world, have learnt to exist inside... 17 March 2021 4 min read
Dennes Torres in Other Count Distinct and Window Functions Or: How to make magic tricks with T-SQL Starting our magic show, let’s first set the stage: Count Distinct doesn’t... 15 March 2021 7 min read
Other Louis Davidson in Other The Issue\Purpose of Multiple Edge Constraint/Conditions Edge constraints were added in SQL Server 2019 to make the node to edge relationship stricter/enforced, and more like typical... 15 March 2021 4 min read
Other Louis Davidson in Other Ways to get and deal with invalid node identifiers in SQL Server Edge references One of the weirder things about graph tables in SQL Server is the mysterious backend implementation. The values you see... 12 March 2021 6 min read
Other Dennes Torres in Other The Game Changed: Power BI Premium per User Until now, one common knowledge about Power BI was how Power BI Premium subscription is expensive. We, regular mortals, could... 08 March 2021 2 min read
Other Louis Davidson in Other Translating Index/Key Errors from Graph Tables in SQL Server As I am working with graph tables, I find some quirks exist that make them interesting to work with. One... 05 March 2021 4 min read
Other Dennes Torres in Other Parameter Sniffing or not sniffing: The Mindset change for new technologies Parameter sniffing is a common challenge for query tuning. The usual solution we recommend is to apply a recompile option,... 01 March 2021 7 min read
Other Pramodh Kumar in Other HOW CAN SQL SERVER DEVELOPERS GET STARTED WITH POSTGRE SQL? WHAT IS SQL SERVER? SQL server is a relational database management system. It is offered by Microsoft and is one... 01 March 2021 9 min read
Other Saikiran Reddy Subbagari in Other Creating Reports using Oracle SQL Commands Reports are widely used by managers, analysts etc., to do data analysis and make business decisions. Report developers mostly use... 22 February 2021 3 min read
Other Louis Davidson in Other Function (and SQL Prompt Snippet) To Get Next Date By Day Name/Offset As I have been building my Twitter management software, I have been doing a lot more ad-hoc, repetitive coding using... 18 February 2021 3 min read
Other Dennes Torres in Other Custom Binding for Azure Functions Azure Functions are a great development tool, allowing us to create serverless software. However, one detail was bothering me when... 15 February 2021 5 min read
