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 storeContinue reading “Accessing SQL Database | PowerShell”
Tag Archives: MSSQL
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 updateContinue reading “Quick Tip: OUTPUT clause – Good Policy | SQL”
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, weContinue reading “Indexes | SQL”
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 shouldContinue reading “Simple Extension – Analysis | SQL”
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 endlessContinue reading “Field Sizes | SQL”
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, asContinue reading “Create a table | SQL”
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 communityContinue reading “Welcome | Hello world!”
ToolGBRMaker 