Similarities and Differences among RANK, DENSE_RANK and ROW_NUMBER Functions

Database development, Statements • One Comment

The RANK, DENSE_RANK and ROW_NUMBER functions are used to retrieve an increasing integer value....
Read More

Conditional Split Transformation: Export Data from SQL Server into Oracle and MySQL Databases

Business intelligence, Database administration, SSIS, Work with data

In this article, I have explained how we can divide and export data of SQL Server database table into Oracle and MySQL databases. That...
Read More

Compare Execution Plans in SQL Server

Database administration, Database Optimization & Structure

Database Administrator always makes an effort to tune SQL Server query performance. The first step in tuning query performance is to...
Read More

Fixing Data Loss Using Log Shipping with Delayed Recovery

Database administration, Transaction Log, Troubleshooting Issues

Introduction Transaction Log Shipping is a very well-known technology used in SQL Server to...
Read More

Export data from SQL Server to Excel and Text file via using SSIS package

Business intelligence, Database administration, SSIS, Work with data

While using the SSIS data flow, we can perform ETL task that can be used for data migration, data offloading, design and implementation of...
Read More

Understanding Difference between EXCEPT and NOT IN Operators

Database development, Statements

Both EXCEPT and NOT IN operators are used to filter records from a table based on a specific criterion. In this article, we will look at...
Read More

Structured Query Language – Importance of learning SQL

Database administration, Database development, MySQL, Oracle, PostgreSQL, SQL Server • One Comment

Computer programming language is a set of detailed instructions for computers or machines for...
Read More

SQL Server IntelliSense and Autocomplete

SSMS, Tools & technologies

Starting from SQL Server 2008, Microsoft introduced a new feature in the SQL Server Management Studio that helps the database developers...
Read More

Exporting Oracle Table to Excel Worksheet

Database administration, Database development, Tables, Work with data

In this article, I will explain how we can divide and export data of an Oracle database table into multiple worksheets of an Excel file...
Read More

How SQL Server 2016 Took Azure SQL Data Warehouse to Next Level

Azure, Cloud

Azure SQL DW (SQL Data Warehouse) is a massively parallel, petabyte-scale, cloud solution for data...
Read More
Close