Category Archives: SQL Administration

The SQL Administration section connects articles focused on MS SQL Server, specifically server administration and database…List of Articles in category »

SQL Indexes – Indexing Theory Simply, Balanced Tree, Heaps

Correct table indexing in SQL Server is a base for good database performance during querying. You need to understand how SQL Server stores data into tables/indexes if you want to create appropriate sql indexes. It is also important to know how to approach these data correctly during querying. How Does SQL Server Organize Data Physically?… Read More »

SQL Error: Login Failed for User – What to do?

SQL Error “Login failed for user <user name>. The user is not associated with a trusted SQL Server connection” is quite common. The problem is that SQL Server cannot identify user name. This is how the error message looks like. What are the Most Common Reasons? Incorrect login or authentication type (Windows vs. SQL) Login… Read More »

SQL Error: Saving Changes is Not Permitted – Solution with Example

When working with database objects, we may sometimes get into a situation when we want to change property of an object. For example change of data type in column of a table via table design in SQL Server management studio. If there is data in the table, SQL server should display an error message if… Read More »

SQL Collation – How to Change Collation of Table Column

While installing SQL Server, one of the parameters that is needed to be set during installation is Server collation. It is a parameter influencing the way in which SQL stores non-Unicode data. We may choose SQL Collation CZECH_CI_AS in Czech environments. While starting a database, we can also select collation that can be different to… Read More »

SQL | Triggers in SQL Server – Definition, Types, Syntax and Examples

A trigger is a database object (procedure) that works as a watchdog for certain event. Using database triggers we can catch this event and initiate some additional action – such as logging or rejecting the action. The event that initiates the action may be: INSERT or UPDATE records in the table DELETE records from the… Read More »