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...
by Ken Haff | May 30, 2023 | Blog, SQL Server
What Are Natively Compiled Stored Procedures? These procedures are a new feature introduced in SQL Server 2014 that allows for faster and more efficient execution of queries and business logic that access memory-optimized tables. Memory-optimized tables are tables...
