In an earlier article we saw how we create an Extended Event to see queries with a long duration. In this article we will build Extended Event that records deadlocks. All we need to do is create it with a T-SQL command. After… read more
How can we from SQL Server read Excel / CSV / TXT and insert the records into a table
SQL Server allows us to read and import files at will without the use of SSIS (Integration Services) and Wizard packages. This process is done using the OPENROWSET function and the BULK INSERT. We can… read more
How to improve a previously run query on an Oracle database (SQL Tuning Advisor with AWR Snapshots)
In a previous article we analyzed how to improve a query in Oracle using the SQL Tuning Advisor. But in order to run the SQL Tuning Advisor, the query must still be in the Shared Pool, i.e. in memory... read more
What is collation and how it changes in SQL Server
In one sentence, collation is the way characters are encoded in a database. That is, you define whether they will be case sensitive (uppercase, lowercase), in which language the varchar and text fields are. Fields like nvarchar which are in unicode format are not affected… read more
How to improve the performance of a query running on an Oracle database (SQL Tuning Advisor)
Many times we will happen to hear that suddenly a query that was going fast suddenly started to slow down or that a query goes unreasonably very slowly. The easiest way to find out what's wrong and fix it is by… read more
What are triggers?
Do they have overhead? Where is their utility? and finally how are they made? There are 3 different types: DDL triggers for CREATE / DROP actions, AFTER LOGON triggers for when a user logs in, DML triggers for UPDATE, Insert, DELETE actions. In the article… read more
How can we bulk backup/restore databases in SQL Server
Many times we may need to backup several small databases and transfer them to another system or restore them to the same one. The backup/restore process of each database one by one will be time-consuming and... read more
How do we transfer server configurations from one SQL Server Instance to another
In the article we will see an easy way to transfer the configuration of one SQL Server instance to another. Parameters such as max memory, max degree of parallelism, cost of threshold for parallelism... All that will be needed... read more
How we collect blocking queries via Extended Event and how we read its data
In an earlier article we saw how we create an Extended Event to see queries with a long duration. In this article we will create an Extended Event that records blockings. All we need to do is create it… read more
