Setting Database Access Permissions
Server security mainly depends on how correctly you can configure access permissions on objects....
Performance of Table Variables in SQL Server
In this article, we are going to touch upon the topic of performance of table variables. In SQL Server, we can create variables that will...
Understanding Pivot Operator in SQL
The pivot operator in SQL Server converts each row in the aggregated result set into corresponding columns in the output set. The pivot...
Sending a Query to All Databases of All Specified Servers in MS SQL Server and C#.NET
Often, it is necessary to send a query to all databases of all specified servers. Many DML-queries...
How to Analyze Activity of One Database in SQL Server
Using one SQL Server instance for many projects is not unusual. However, defining the most active project may be quite difficult. Today, I...
How Simple Is It to Move Data from Excel to SQL Server?
What could be simpler than to get data from an Excel table in SQL Server? There are many ways to accomplish this task. You can utilize...
Common Mistakes of DBA in MS SQL Server
In this article, we are going to review DBAs mistakes, the consequences of which were quite...
How to Automate Data Collection on the SQL Server Database Growth
Introduction Often, there is a need to control the growth of all tables and files of all databases. In this article, we are going to...
Understanding Transactions in SQL
A transaction in SQL is a unit of execution that groups one or more tasks together. A transaction is considered successful if all the tasks...
Analysis of MS SQL Server for Those Who See It for the First Time
What Problems Will We Consider? If the server notifies “there is no more space on the E...
