Blogs/Articles

My name is Rakesh. I live in Seattle and lead the Analytics team @ Expedia. I run the analytics and data science teams that build data models and metrics using Hadoop, Teradata, Tableau and other statistical tools. I use this site to publish a variety of misc stuff and videos that I hope people find interesting or useful.

What course should I record next?

READ MORE

Starting a Career in Databases and Analytics

In the Last few weeks, I have received several messages, relating to starting a career in Databases and Analytics. Most of the questions revolved around the below and I have tried to answer all of them here (You can also Join my list to get latest updates on articles and courses)Common...

READ MORE

Local And Special variables

Difference between a Local and Special Variable. A local Variable is often used to declare a parameter. Such parameters will have the @ prefix. An example would be something like : DECLARE @myVariable VARCHAR(20) SET @myVariable = "Hello Word" PRINT @myVariable. Such parameters...

READ MORE

Enabling Filestream On SQL Server

To enable and change FILESTREAM settings Goto Start menu --> All Programs, point to SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager. Right-click SQL Server Services, and then click Open. In the SQL Server Configuration Manager, locate the...

READ MORE

Common Table expressions (CTE)

WITH Statements is like a temporary result set holder. WITH statements need to be followed by SELECT, INSERT, UPDATE or DELETE statements. You use them to break very complex queries. On the other hand, simplifying code makes it easily readable. The generic Syntax of WITH Statement is: ;WITH...

READ MORE

Deleting Tables with Dependencies in SQL Server

Deleting Tables with dependencies in SQL Server. Quite you come across a situation where you cannot drop a table, since it has references to another table. There are many ways to tackle this situation. Method # 1 – Identify all the foreign key relationships. A simple script like the below...

READ MORE

SQL Self-Joins

You must have heard of SQL Joins like left join, Right join, full join. SQL self-joins a type of join in which you join a table to itself. Think of it like joining 2 copies of the same table (remember that the table is not actually copied/duplicated) A general Syntax is: SELECT a.column_name,...

READ MORE

Installing SSIS (SQL Server Integration Services)

Recently I recorded SSIS Tutorials. Below are some installation steps for SSIS with some screenshots SSIS Tutorial : Link SSIS Tutorial: Link In order to install SSIS or SQL server Integration service, you need to purchase Developer, Standard or Enterprise editions. You can also download the...

READ MORE

Working With Excel using TSQL

Many people asked me how to interact with Excel files from SQL Server using basic TSQL code. There are various ways to interact with Excel files. The 2 commonly used methods are: 1. Using a ODBC Driver - OPENROWSET QUERY (I will be discussing this technique in the blog) 2. Creating a custom...

READ MORE