SQL Server is one of the most popular relational database management systems (RDBMS) in the world. It has been evolving and improving over the years, adding new features and capabilities to meet the changing needs and expectations of users and businesses. As a result,...
SQL Server Blog Posts
How to Use HierarchyID Data Type in 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...
Best Practices of Setting Up Zero Trust Security with Microsoft SQL Server
In today's constantly evolving threat landscape, traditional security models that rely on perimeter defenses are no longer enough. The zero-trust security model is becoming increasingly popular as it provides a more comprehensive approach to security. This model...
When to Use Columnstore Indexes and When Not to Use Them
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...
SQL Server on Linux
Setting up and optimizing a SQL Server database on a Linux environment is an important task for database administrators. While there are similarities between setting up SQL Server on Windows versus Linux, there are also key differences that need to be considered. In...
A Comprehensive Guide to Migrating to SQL Server: Benefits, Risks, and How XTIVIA’s Services Can Help
Migrating to SQL Server presents businesses with numerous opportunities to streamline operations, improve performance, and enhance data security. However, the migration process can be complex and challenging, especially for companies with limited experience in...
Indexing for Group By and Order By in 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...
When to Use Natively Compiled Stored Procedures in 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...
Microsoft SQL Server: Advantages and Best Practices for Technical Corporate Decision Makers
As a technical corporate decision-maker, choosing the right database management system (DBMS) for your organization is crucial to ensuring efficient and effective data management. Microsoft SQL Server is one of the most popular DBMS options on the market today and for...
Page Splits and How to Optimize Index Space in SQL Server
If you're noticing a significant drop in performance, as well as frequent index fragmentation, you might have an issue with page splits, especially if your fill factor is set to default on all of your indexes. What Are Page Splits? Page splits occur when there is...