Dinesh's Blog :::: Being Compiled ::::

If someone comes and tells; We have a large dataset, let's use Hadoop for processing this. What would be your answer? If you a...

This happens mostly with older version of SQL Server such as 2005. When a SQL file with .sql extension is double-clicked, it opens Managem...

If you have two or more versions of SQL Server installed in your machine, most of the time, when you open a .sql file by double-clicking o...

Here is a basic concept you should know. It is about inserting records, specifically inserting multiple records with a single insert state...

If we are loading a large volume of data into an indexed table, we always drop the index, load the dataset, and re-create indexes assuming...

Once I wrote a post on Incremental ETL  ( Incremental ETL: How to identify changes for fact data when no support from the source ) that di...

One of the sessions we had with SQL Server Sri Lanka User Group Meet-up yesterday was on Change Data Capture which is widely used for capt...

Microsoft has released SSIS Feature pack for Azure that allows us to connect with Azure, transfer data between azure and on-premises data s...

We know that, with the default behavior, records are getting exclusively locked when we perform modifications against data, disallowing ot...

Microsoft SQL Server does not force you with hard rules for naming objects such as tables but some recommendations. Your tables, your proc...

Microsoft SQL Server comes mainly with five system databases: master, model, msdb, tempdb and resources. In addition to that some more dat...

The latest buzzword in IT, or more particularly in data analytic is Big Data . It does not come alone, it always comes with Hadoop  which ...

This is not a new thing but it is a common requirement with many implementations, so making a post on it. Assume that you need to get ...

In recent past......... a casual conversation turned to a technical conversation...... Friend: It is a surprise to see an MVP studyin...

ETLing is the way of getting data from one or more sources into your reporting environment or to a repository that holds enterprise-wide d...

During last 3-4 months, I have been continuously asking this question from many to understand how the fundamentals are known to everyone. ...

When extracting data from one database to another in continuous fashion, two common techniques are used; delete the destination and reload...

If someone wants to manage the SQL Server instance completely and perform any activity in the server, she or he should be a member of sysa...

Have you noticed this? Or have you already experienced this? Are you going to complain on it? Then wait............. Microsoft Azure H...

Once HDInsight cluster is created for Big Data  implementations, navigating the cluster (or Azure Blob Storage) via logical folders and ac...

Just like last Brain Basher, this week one also based on Integration Services. Let's try to understand a very common misconception on ...

We have been using variables inside Integration Services packages for maintaining temporary values for various computations and passing ex...

Are you experiencing the following error with one of your Reporting Services parameters? Specifically with a hidden parameter? To ...