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 Visualize SQL Server Graph Tables: Generate TGF Format Visualize SQL Server graph tables by generating TGF (Trivial Graph Format). Uses PowerShell and dynamic SQL to export node/edge relationships... 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 SQL Server Graph Tables: Drawing Graphs in yEd and Importing Nodes and Edges Design a graph visually in yEd (a free graph modeling tool), export it as Trivial Graph Format, and import the... 29 January 2021 12 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
Blogs Kendra Little in Blogs Predictions for Healthcare and Database Infrastructure in 2021 Grant Fritchey, Kathi Kellenberger, and I recently collected our ideas and predictions about how the healthcare sector will evolve in... 07 December 2020 4 min read
Blogs Kendra Little in Blogs Why it makes sense to monitor SQL Server deadlocks in their own Extended Events trace We recently had customer ask why SQL Monitor creates an Extended Events session to capture deadlock graphs, when SQL Server... 03 December 2020 4 min read
