Category: tutorial

Posted on

Analyzing iMessage With SQL

558fe5180e0e8fc922d31c23ef84d240

SQLite is an often overlooked flavor of SQL engines. Some have suggested it is the most prolific SQL engine in existence due to its highly flexible nature and ability to run on almost any platform with limited resources. Unlike other SQL engines like MySQL, PostgreSQL, MSSQL, or Oracle, SQLite runs without a server. SQLite does not rely on a data directory or a constantly running daemon: a database is encapsulated in a single file.

SQLite and iMessage

iMessage is one of the most popular messaging platforms today, largely because it is built into iOS and Mac devices. Since its release, it has evolved significantly. But, at its core, it is simply an instant messaging platform. iMessage uses SQLite in the background to store relational data about messages, conversations, and their participants.

Posted on

Hypothetical Indexes in PostgreSQL

Category Image 011

In this blog, we will first cover what are hypothetical indexes and what is needed for these types of indexes. Secondly, we shall see the practical usage of these indexes. 

Need of Hypothetical Indexes:

As the name suggests, these are not real indexes, these are hypothetical indexes i.e. they are virtual indexes that PostgreSQL query planner does not consider when running queries. 

Posted on

HTTP Protocol: Obviously Unobvious

Category Image 011

Hyper Text Transfer Protocol

HTTP protocol nowadays is still one of the most popular protocols used over the internet. But many developers still can't explain clearly what is it. In this article, you will find out what HTTP is practically is. 

Protocol Meaning

But stepping back a little let's remind what is the meaning of Protocol. A protocol can be understood as a contract or agreement between sender and receiver. The HTTP protocol is described in RFC 2616. The main purpose of the HTTP protocol is to send web data to browsers to render it. 

Posted on

Which Configuration Changes in SQL Server Require a Restart?

Category Image 091

SQL Server is a complex beast, with many configuration options that can range from recommended to completely avoided.

Since the release of SQL Server 2016, several options that were recommended post-install have been rolled into the default installation options and no longer need to be done, and similar changes were made with SQL Server 2017. Even so, there are configuration changes we data professionals need to make after installation, during maintenance windows, and sometimes even during operating hours, so here’s a handy list of changes that do and don’t require a restart of your operating system or SQL Server instance.

Posted on

Deploying a LoRaWAN Network Server on Azure

Category Image 011

There is something oddly fascinating about radio waves, radio communications, and the sheer amount of innovations they've enabled since the end of the 19th century.

What I find even more fascinating is that it is now very easy for anyone to get hands-on experience with radio technologies such as LPWAN (Low-Power Wide Area Network, a technology that allows connecting pieces of equipment over a low-power, long-range, secure radio network) in the context of building connected products.

Posted on

The 2 Essential Ingredients of a Brilliant Title

Category Image 051

At WriteOps, we work with companies who are trying to sell their technical product. Almost all of them had a go at their own technical content. Their engineers wrote blogs, spoke at meet ups, and organized webinars. 

And None of Their Efforts Worked. Why?

The success of their marketing efforts wasn’t a function of money spent, nor were they solely about clever placement of paid ads. This is pretty true in general, but it is an absolute axiom when you’re marketing to the technical class.

Posted on

Error Handling in SQL Server

Category Image 011

In this article, we will learn how to handle exceptions in SQL Server and also see how to capture or log the exception in case of any DB Level Exception occurs so that the Developer can refer to that Error log, can check the severity of the Exception, and fix it without wasting too much time in finding the exception causing procedure or function or line which is causing the exception.

Let's Begin

In order to demonstrate how an exception is thrown in the procedure, I have created a Sample Procedure i.e. usp_SampleProcedure as shown below

Posted on

Jenkins Pipeline With Sonarqube and Gitlab

558fe5180e0e8fc922d31c23ef84d240

In this guide, we are going to deploy a continuous integration process between Jenkins, GitLab, and SonarQube.

The end goal will be to review the code quality through SonarQube for GitLab repository using Jenkins. Following is the process flow we need to manage:

Posted on

How a Bot Built in Teneo Can Make Proactive Suggestions and Offers

Category Image 011

Sometimes we want our bot to give some extra information that the user did not explicitly request, such as special deals, promotions, and more. In Teneo, this can be achieved using prompt triggers.

Prompt triggers are tested after the normal flow execution, right before the response is given. If a prompt trigger matches, the flow containing this trigger will be executed and the resulting output will be added to the response. In the example below, the first part of the bot answer comes from the ‘User wants to order coffee’ flow, while the second, highlighted, part comes from a flow that has a prompt trigger:

Posted on

Include With Where Clause

Category Image 011

Ever thought about writing the following query in Entity Framework?

SQL