Blogs Dennes Torres in Blogs 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 Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Annette Allen in Blogs 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 Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Pramodh Kumar in Blogs 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
Blogs Saikiran Reddy Subbagari in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Louis Davidson in Blogs Visualizing a set of SQL Server Graph tables by generating TGF Format In my last blog, I built some Powershell to take a graph that I had modelled and bring that into... 09 February 2021 7 min read
Blogs Puneet Kakkar in Blogs Extend Oracle ERP to Preview Report Output and enable Email Oracle ERP is the largest selling suite of applications across north America and it is well Integrated with other corporate... 02 February 2021 9 min read
Blogs Binny Joshi in Blogs Deploying a NodeJS application from GitHub to AWS Elastic Beanstalk and creating a CI/CD AWS CodePipeline. Goals In this article I will assist you to deploy a NodeJS application from GitHub into AWS Elastic Beanstalk and... 02 February 2021 11 min read
Blogs Dennes Torres in Blogs Azure SQL and Managed Identity Azure SQL has a close relationship with Azure Storage. Features like Polybase, backups, extended events and more make use of... 01 February 2021 5 min read
Blogs Louis Davidson in Blogs Using a Modeling Tool to Draw and Import a Graph into SQL Server As I am starting to prep for writing about graphs in SQL Server, I have reached the most challenging part... 29 January 2021 11 min read
Blogs Saikiran Reddy Subbagari in Blogs Handling Textual Unstructured Data using DataStage What is Unstructured Data? Structured data is represented by tables, rows, columns, attributes mostly like relational database. Many of us... 26 January 2021 4 min read
