Asst. Commissioner (43 BCS) | Ex Full Stack Dev
What’s the Deal with Dimensional Modeling? Let’s talk about Dimensional Modeling (DM) – the superhero of data storage techniques for data warehouses. You know what makes it special? Its laser focus on getting data out fast, unlike those traditional systems that spend all their time worrying about putting data in. Think about it: while relational … Read more
BuildContext is a handle to the location of a widget in the widget tree. Flutter is a mobile app development framework created by Google. It allows developers to create beautiful and smooth-running apps for Android and iOS devices using a single codebase. One of the key concepts in Flutter is the idea of a “widget.” … Read more
SQL Server In-Memory OLTP (Online Transaction Processing) is a feature that allows for faster performance of certain types of workloads in SQL Server by storing data and indexes in memory rather than on disk. This can significantly improve the speed of transactions, especially for high-concurrency workloads that involve a lot of insert, update, and delete … Read more
Slivers Basics In Flutter, a sliver is a slice of a scrollable area we can use to achieve custom scrolling behaviors. We can use slivers to achieve custom scrolling effects, such as elastic scrolling. To make it easier for users to view a list of items, we might want to hide the app bar as the user … Read more
A SQL Server filegroup is a container for database files. It lets the administrator organize and allocate them to different drives. Filegroups can store tables, indexes, and different types of data. They can be used to manage database growth and improve performance by placing frequently accessed files on faster drives. Filegroups offer flexible and powerful … Read more