15 February 2021
15 February 2021

Custom Binding for Azure Functions

0
2
Azure Functions are a great development tool, allowing us to create serverless software. However, one detail was bothering me when I create a function: The HTTP Trigger receives a HTTPRequest object and we need to extract the parameters from the request. This becomes kind of a low-level code mixed with our business code. It’s like going … Read more
02 February 2021
02 February 2021

Deploying a NodeJS application from GitHub to AWS Elastic Beanstalk and creating a CI/CD AWS CodePipeline.

0
0
Goals In this article I will assist you to deploy a NodeJS application from GitHub into AWS Elastic Beanstalk and Building a CI/CD pipeline. What is Elastic Beanstalk ? Using Elastic Beanstalk you will be able to deploy and manage applications within the AWS Cloud without having knowledge about the infrastructure that execute those applications. … Read more
01 February 2021
01 February 2021

Azure SQL and Managed Identity

0
4
Azure SQL has a close relationship with Azure Storage. Features like Polybase, backups, extended events and more make use of Azure Storage. On Azure SQL Database, probably the most common use is Extended Events. When we create a file target, we need to point to the Azure Storage URL where the file will be stored. … Read more
26 January 2021
26 January 2021

Handling Textual Unstructured Data using DataStage

0
3
What is Unstructured Data? Structured data is represented by tables, rows, columns, attributes mostly like relational database. Many of us might have spent the better part of our careers working on structured data and it is heavily used for analytical purposes. Unstructured data is often best described in contrast to structured data. It is an … Read more
04 January 2021
04 January 2021

PASS is Dead – Long Life to SQLFamily

0
2
This new year start with the death of PASS, the professional association that for so many years supported the SQLFamily around the world and helped so many to achieve their professional goals. You can still read the communication, but PASS is ‘going dark’ on January 15, meaning none of its features and resources will be … Read more
22 December 2020
22 December 2020

Security is hard work

0
1
I was once a database administrator in charge of several SQL Servers hosting the databases of vendor apps. Right after taking the job, I began looking at things like backups and security. I was quite shocked to find that one of the most important SQL Servers in the firm had a blank sa password. I … Read more
03 December 2020
03 December 2020

Why it makes sense to monitor SQL Server deadlocks in their own Extended Events trace

0
4
We recently had customer ask why SQL Monitor creates an Extended Events session to capture deadlock graphs, when SQL Server has a built-in system_health Extended Events trace which also captures deadlock information? There are a couple of reasons why a dedicated trace is desirable for capturing deadlock graphs, whether you are rolling your own monitoring … Read more
19 November 2020
19 November 2020

Database DevOps Considerations for SQL Server Availability Groups

0
10
One question which comes up periodically from our Microsoft Data Platform customers is whether there is anything special that they need to do when implementing version control, continuous integration, and automated deployments for a production database which is a member of a SQL Server Availability Group.  The good news is that deployments are quite straightforward. … Read more
04 November 2020
04 November 2020

Unwrapping JSON to SQL Server Tables

0
8
If you know the structure and contents of a JSON document, then it is possible to turn this into one or more relational tables, but even then I dare to you claim that it is easy to tap in a good OpenJSON SELECT statement to do it. If you don’t know what’s in that JSON … Read more