Currently browsing category

My Article’s

Handling Foreign Keys – ETL

Issue: About to delete 1Billion record from the table. Goal is to improve ETL process time. Foreign keys are good way to maintain data integrity , there are occasions like this one where you want to disable foreign keys in-order to avoid data integrity check and improve overall performance. Solution: …

My Ideal SAN

First let me tell you by no means i am a SAN administrator, however i was lucky to work on a project on my new job where we were in search for all flash SAN to replace our FUSION-IO cards, this project involved lot of testing ,analysis and negotiation. During …

Using Microsoft’s Virtual Labs

Like me if you would like to practice for MCTS certification or play with new SQL server features without a hole in your pocket to build your own servers, you can use one of many Microsoft’s virtual lab. These labs come with pre-installed OS and SQL Server versions. Just click …

Execute SQL Queries Across Multiple Servers

Problem: There are times when I have to find a database or a object across thousands of databases spread across hundreds of server? Solution: Using 2008 client you can group the servers and run a single query across many different servers. If you need to find more details on a …