You need to create a SQL Server credential first to restore a database back up from Azure blob storage. A lot of writings can be found around the web on this. Most of them have used Azure Storage Account to create the credential in the first place. In this short post, I will be using … More Restore SQL Server database using SAS from Azure Blob Storage
In one of our projects, we ‘somehow’ decided that every part of the system should be ‘unit test’-ed . It was a classical ETL->DWH->Cube project where web dashboard was built to show BI reports from cube (using MDX as reporting language). Off course, unit testing was nothing new to our web developers. But, our data warehouse developers … More What I have learned in the name of unit testing of ETL, DWH, OLAP Cube and MDX
Try to follow these tips. Each of these topics has been explained in different websites. So, I am not going to explain them here. 1. Design Design your database efficiently (normalization, use of foreign keys, getting rid of unnecessary tables, selecting appropriate data type etc..). Clean up your database before your go LIVE! 2. Estimate Data … More 5 Tips to avoid running out of space in SQL Server Database
Previously, I have posted some SSIS solutions which would handle dynamic column mapping in data loading. This time, I was wondering how to handle dynamic column mapping when the source is an excel file. I was quick to realize that it would be entirely a C# solution and the program should be able to handle … More Load Excel File Dynamically Into Database Using SQLBulkCopy and GetOleDbSchemaTable in C#
Any word or phrase that exactly reproduces the letters in another order is an anagram. For example: “Hamlet” is an anagram of the word “Amleth”. We will show u a query today which can determine if two given words are anagram or not. We have used a Tally table for parsing the given strings. It … More Find out anagram using SQL
Hello everyone, This time my problem was to delay the start of a SQL server job if another job is already running. Obviously, the reason for this is that the jobs use the same database resources. The sysjobhistory table in MSDB database has the job ids and their status stored. First, I selected the job … More Avoid Concurrency problem while running SQL Server Jobs
Recently, I had to find a way to write a trigger in MS Access 2007. My aim was to update a field in one table (let’s say Project Table) based on Insert/Update/Delete operation on another table (Let’s say Investors table). Quickly, I realized that MS Access 2007 does not offer much when it comes to … More Update another table using Data Macro in MS Access 2010
Just use ‘SYSTEM_USER’. Example: Select SYSTEM_USER
Wondering how to know if a temp table already exists in the database. Here is a simple command IF OBJECT_ID(‘tempdb..#temp’) IS NOT NULL DROP TABLE #temp
Recently, I have been working in a project where I had to make an SSIS package to connect to an Oracle server and load data to a SQL server. After searching a lot and getting through a lot, I figured out the best provider and client for a successful connection. Take note from the following … More Oracle and SQL server connection in SSIS: Best provider
Zahid's blog on Data Engineering and BI 