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
Blogs Dennes Torres in Blogs Power BI reading Parquet from a Data Lake Data Lakes are becoming more usual every day and the need for tools to query them also increases. While writing... 18 January 2021 8 min read
Blogs Dennes Torres in Blogs PASS is Dead – Long Life to SQLFamily This new year start with the death of PASS, the professional association that for so many years supported the SQLFamily... 04 January 2021 4 min read
Blogs Kathi Kellenberger in Blogs Security is hard work I was once a database administrator in charge of several SQL Servers hosting the databases of vendor apps. Right after... 22 December 2020 2 min read
Blogs Ajay Patel in Blogs Performing seed data to database from JSON using reflection We can work with two approaches in Asp.Net MVC i.e., DB first approach and Code first approach. Apart from that,... 17 December 2020 6 min read
