Getting Started with SQL Server
This documentation section presents the topics on SQL Server
User-Defined Functions in SQL Server
User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of. Although they are very useful in many...
MSDB Maintenance: Your Ultimate Guide to SQL Server System Database Management
In the previous articles of the SQL Server System Databases series, we have gone through the System Databases that are installed by default...
GROUP BY in SQL Server: 3 Easy Examples to Group Results
Grouping is an important feature that helps organize and arrange data. There are a lot of ways to...
SQL AS: Usage, Examples, and How it Can Benefit You Best
What is the AS statement in SQL? The AS keyword in SQL is used to create a temporary alias for a table or column. This alias can be used...
How to Change Database Collation in SQL Server: Step-by-Step Guide
When you develop an application or write a code in the SQL database system, it is crucial to understand how data will be sorted and...
10 SP_EXECUTESQL Gotchas to Avoid for Better Dynamic SQL
Do you know how powerful a tool like dynamic SQL can be? Use it the wrong way, and you can allow...
SQL Server Transactional Replication Configuration
Transactional Replication in SQL Server is one of the most commonly used Replication techniques to copy or distribute data across multiple...
A Simple Use Case for Indexes on Primary Keys
Introduction Recently we encountered an interesting performance problem on one of our SQL Server databases that process transactions at a...
Introduction to Synonyms in SQL Server
A synonyms in SQL Server are database objects that give an alternative name to the database objects...
