Index Fragmentation Analysis | SQL

Well, we should know, by now, the benefits that Indexes can bring to our daily seeks, however, if no maintenance is guaranteed we may end with the opposite effect from our indexes (starting delivering a very poor performance). You need to revisit the Indexes explanation, click here. This fragmentation may happen more often on tables

Securing Database Objects – Permissions | SQL

Let’s look into how we can secure our database by granting permissions by object and/or by columns of those objects, using commands on a few T-SQL scripts. In this post, we’ll learn how to do it and I’ll also share some examples to understand better how they act in each situation. The commands that we

Table Trigger | SQL

Let’s continue to improve our sample database, now by adding a table trigger on one of our tables. The triggers can be either INSERT, UPDATE or DELETE clause when we speak in terms of Data Manipulation Language. Its execution part usually contains a store procedure or a batch. For demonstration purposes, let’s add two new

Accessing SQL Database | PowerShell

The title couldn’t be more explanatory. During this post, we’ll see how we can access the database, and select data, by PowerShell. Let me try to guess… But why!? Well, besides for pure thirst for knowledge of how we can do fancy things :D, could pass through, by using this way of access, to store

Importing data by CSV | SQL

Let’s continue improving our SampleTest database, today by creating a new table and importing data to it by using a CSV file. The new table will store the country details that we will use to relate with our customer table, already created on the post. Schema creation… Now, that we have our table schema, it’s

Quick Tip: OUTPUT clause – Good Policy | SQL

Let’s check how the OUTPUT clause can save the day if we, after an update, may want to revert what has been updated. Imagine that we have the following output from a customer table on the SQL: And we decided to switch all the customers with the first name “Antonio” to “António”. A simple update

How to foresee potential lockings on your tables | Business Central

What a beautiful code I just finish to create… Let’s skip the tests… Put it in a Prod environment and hope for the best. Booommmmmmmmm! Well, not so frequently nowadays, but, in a rush, is still happening, right!? You don’t need to answer… Even though you tend to say that it’s a lie, it still

Indexes | SQL

Let’s talk a little bit about indexes, their relation with data pages, and their importance in querying data from databases. Database indexes are used to provide faster access to relational data. An index is a separated physical data structure that enables faster access to one or multiple rows to an entity or table. Analogous, we

Simple Extension – Analysis | SQL

Version: SQL Server 2019 Have you ever wondered about what happens on the SQL side when you extend a Business Central table with new fields? If so, during this post I will try to give you a good notion of how Business Central handles this new approach of customizing tables and the concern you should

Field Sizes | SQL

Version: SQL Server 2019 Recently, from a 3rd party software, I got the query of which was the sizes of some of the fields from an entity that they were using to execute some of the integrations. Obviously, they were trying to avoid the loss of data after the integration flow. To avoid an endless