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

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

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

Create a table | SQL

Version: SQL Server 2019 Here I’ll quickly overview the syntax of how to create a simple table on an MSSQL server database. It’s quite straightforward the table creation, for it, we only have the necessity of using Create Table statement. Afterward, set the columns we aim for and their related types. We may consider, as

Welcome | Hello world!

Hello world and welcome! Why not start with a world programming cliche in a presentation post!? What a lame presentation, you may consider to yourself… but emotional feelings aside, let’s get started! 🙂 This blog aims to share some tips and tricks about my daily challenges and who knows, also build some sort of community