Other Louis Davidson in Other 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
Other Puneet Kakkar in Other 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
Other Binny Joshi in Other 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
Other Dennes Torres in Other 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
Other Louis Davidson in Other 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
Other Saikiran Reddy Subbagari in Other 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
Other Dennes Torres in Other 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
Other Dennes Torres in Other 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
Other Kathi Kellenberger in Other 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
Other Ajay Patel in Other 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
Other Kendra Little in Other 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
Other Kendra Little in Other 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
Other Kendra Little in Other Database DevOps Considerations for SQL Server Availability Groups One question which comes up periodically from our Microsoft Data Platform customers is whether there is anything special that they... 19 November 2020 4 min read
Other Phil Factor in Other Unwrapping JSON to SQL Server Tables If you know the structure and contents of a JSON document, then it is possible to turn this into one... 04 November 2020 10 min read
Other Louis Davidson in Other Ignore the technology for a moment, let’s talk about the problem Twelve and a half years ago I wrote my largest hit count article of my writing career Ten Common Database... 26 October 2020 9 min read
Kendra Little in Other Reordering Deployments in Database DevOps We recently received an interesting question in our Redgate forums from Peter Daniels about altering the order of deployments in... 26 October 2020 17 min read
Other Kathi Kellenberger in Other What you’ll learn at my 2020 PASS Summit presentation T-SQL is my favorite aspect of working with SQL Server. The release of SQL Server 2005 coincided with the beginning... 22 October 2020 3 min read
Other Dennes Torres in Other Connecting to Log Analytics using Azure Data Studio and KQL Azure Data Studio is a great tool and supports way more than only SQL. Recently, Azure Data Studio included the... 20 October 2020 8 min read
Other Kathi Kellenberger in Other US Insurance Industry Data Security Regulations Over the past few years, several new regulations regarding the privacy of data have been enacted. Many of these, such... 19 October 2020 4 min read
Other Dennes Torres in Other Deploy Data Factory from GIT to Azure with ARM Template You may have noticed the export feature on Azure resource groups don’t like too much the Data Factory. We can’t... 12 October 2020 2 min read
