A data warehouse is a centralized repository where company-wide data is consolidated and stored in a format that enables clear, accurate, and user-friendly reporting in tools such as Excel, Power BI, or other analytical platforms. At some point in every company’s lifecycle, you inevitably realize that you are operating too many business systems and facing… Read More »
Resource Governor is one of the SQL Server enterprise features that are not available in any other edition. If you are interested in various limitations across editions, I have summarized them in the article SQL Server Installation – Planning, HW and SW Requirements. If you are experiencing performance problems and have tried various optimization and… Read More »
As SQL Server administrators, we might want to know what is happening on the server during the day and if any unwanted incidents are occurring. This is where Alerts come into play. If an event occurs that is monitored by a defined alert, a notification will be sent via email to the operator who can… Read More »
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 <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 »
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 »
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 »
I described plus and cons of SQL Server Express edition in the article SQL Server Express for Beginners. If you decided to try Express and you wonder how to install it, go ahead and take a look at this article. If you would like to inspect particular SQL server editions more thoroughly, take a look… Read More »
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. Trigger – event that initiates the action What are triggers used for? Triggers are used mainly for auditing objects… Read More »
In SQL Server administration, there are two terms that can easily be confused: SQL Login and SQL User. In a previous article, we took a closer look at SQL Login, and here we will focus on SQL User. SQL User While SQL Login is used to log in to SQL Server and defines permissions at… Read More »