PowerShell: Working with large files performance comparison

Ever since I started using PowerShell (back in 2012) for automating boring tasks or automating complex tasks, I always thought PowerShell Command-lets provided in powershell were the best to use not only for the ease of use but also for the performance. I always thought PowerShell Cmdlet provide high performance […]

Read more

Creating Memory-Optimized Database And Table

Hello All, I hope you read my previous blog In-Memory OLTP . This is my second blog in In-Memory OLTP Series. As of now, you should have known what Sql Server In-Memory OLTP is. Giving you a quick recap, this new feature of Sql Server allows you to store your data […]

Read more

SQL Server In-Memory OLTP

In my next few blogs, I would attempt to explain you about SQL Server’s In-Memory OLTP (Hekaton). Let me know how am I doing with it by giving your valuable comments. In-Memory OLTP is the new feature introduced with the latest version of Sql Server i.e SQL Server  2014. What is […]

Read more

Introduction to WCF

I planned of learning all about WCF (Windows communication foundation) from last one year and i was never close to manage the time. This time, i think i start and will continue. Throughout the period I am learning it, I will try to write down the basics and my understandings. […]

Read more

Converting Visual Studio 2012 solution to Visual studio 2008/2010

Problem: When we go on web for solution of some problem, and people on internet can provide us with the whole project or solution.  Not every developer uses the same version of Visual studio IDE.  Situation could be something like that, you are using visual studio 2010 and solution provided on web is […]

Read more

View row count of multiple tables with single query

I got myself in the situation, where I needed to find the row count of multiple large tables. Executing count(Fieldname) for these large tables was not a right choice, so I opted to use sysindexes. Then, I came up with the idea of joining sysindexes and sysobjects. Here is the […]

Read more