The primary difference between UNION and UNION ALL is union operation eliminates the duplicated rows from the result set, but union all returns all rows after.

In this article, you will learn how to import CSV file into SQL server using SQL server management Studio.

As we saw in the previous article the definition and implementation of full load and delta load using different SSIS components, in this article will be presented one of the functionalities of SQL SERVER: CDC (Change Data Capture).

In this article, you will learn how to remove CONVERTS/CASTS from WHERE/JOIN clauses.

In this article, you will learn how to create Database with Pre-Defined Schema like Tables, Stored Procedures, Functions, Views.

Understanding of triggers in SQL Server. Overview of trigger groups, magic tables, DML triggers with the use case, and real examples.A SQL Server trigger is like a stored procedure that executes when a given event happens. There are mainly 3 groups of triggers in the SQL server1. DDL - Data definition language - fires upon when there is a change in structure like creating, modifying, or dropping (CREATE, ALTER, and DROP) a table.2. DML - Data modification/manipulation language - fires when an insert, update or delete statement is executed on a table or a view.3. Logon triggers - fires when the LOGON event happens. This event is raised when a user session is created with an instance of SQL Server. Logon triggers fire after the authentication phase of logging finish, but before the user session is actually established.See the below video to learn DML Triggers which are categorized into two: 1. AFTER trigger 2. Instead of trigger

This session is about “ Bringing DevOps to the Database ” in SQL Server Virtual Conference 2021.

This session is on “How to use Geospatial Data in SQL Server ”in SQL Server Virtual Conference 2021.

This session is about “SQL Server Configuration with dbatools and dbachecks ”in SQL Server Virtual Conference 2021.

This session is about My romantic relation with Powershell generally and DBATools especially in SQL Server Virtual Conference 2021.

The SQL Server team just announced the availability of SQL Server 2014 SP1 via the SQL Server blog.

Microsoft announced general availability for the latest update to Azure SQL Database, new SQL Database security features, more automation for SQL Server in Azure Virtual Machines and SQL Server on G-Series VMs.

SQL Server 2014 CTP1 is available now

"Women in SQL" - SQL Bangalore UG Meet

Need help in creating ssis application

Hi.. I am new in SSIS

I want to create SSIS application that  retrieve data  from 2 different tables(2 separate select query ) and write it to xml file

How can I implement it using ssis application?

In-Memory Computing and in-memory Data: Future of SQL Server

In this Blog we Create Table and stored procedure using scripts

Hi, I want two sql queries build against sql north wind database, for both queries the result should be same

But for one query time taken to execute should be more when compared to the other one

can any one please frame and give me such type of queries atleast one pair or more

Inner joins can happen between two tables which are in different database as well as different servers but the servers should be linked. Inner joins give matching records records from both tables.

I've been fond of ANTS Profiler for years now and I just downloaded SQL Prompt from RedGate Software. I have to admit, this is another tool I am liking a lot.

This shows us how to invoke SSIS packages by clicking a button in windows form.

IT is so much fun. I blink my eye and there are hundered and one things to learn already which makes it all the more interesting. I love exploring new software. Learn new stuff. It is such a humbling experience really. No one in IT can say that she/ he knows everything. Really, there is no end to learning here unlike any other fields.