by Ken Haff | Dec 10, 2024 | Blog, SQL Server
EagerZero vs. Quick Format: A Comparison When it comes to formatting drives, there are different methods available, each with its own set of advantages and disadvantages. Two common methods are EagerZero and Quick Format. Here’s how they compare: EagerZero...
by Ken Haff | Sep 24, 2024 | Blog, SQL Server
In SQL Server, the network packet size setting plays a crucial role in determining the data transfer efficiency between the server and clients. This deep dive explores the technical aspects of configuring the network packet size, including how TDS packets are wrapped...
by Ken Haff | Dec 26, 2023 | Blog, Cloud
In this blog post, I will tell you the hilarious story of how XYZ Inc. moved to the cloud without a plan and how it backfired spectacularly. I will also share some tips to avoid making the same mistakes and get the most out of the cloud if you decide to go for it. But...
by Ken Haff | Jun 27, 2023 | Blog, SQL Server
What is the HierarchyID Data Type? Hierarchical data is a common type of data that represents the relationships between entities in a tree-like structure. For example, you may have hierarchical data for your organizational structure, where each employee has a manager...
by Ken Haff | Jun 20, 2023 | Blog, SQL Server
What Are Columnstore Indexes? A columnstore index is a type of index that organizes data by columns instead of rows. This means that each table column is stored separately, and each value in a column is stored next to other values from the same column. This has...
by Ken Haff | Jun 6, 2023 | Blog, SQL Server
What is Indexing? Indexing is a technique to optimize the selection and sorting of data in a database. An index is a data structure that stores a subset of columns from a table or a view, along with pointers to the corresponding rows. The database can use an index to...