Macbook Pro 2011 SSD vs HDD Speed Test

I upgraded my mabcbook pro 2011 from HDD (320 GB) to SSH( Samsung Evo 650 500 GB), the result has been amazing. Here are the before and after speeds. and After There is jump form 42MB/sec to 500 MB/sec. Overall the system boots fasters, launches programs faster and wakes up from boot a lot faster. Note that if you connect your SSD via USB, you will get slow speed, that is 30MB/sec which is USB2 max limit.

Read More

How to update Obi200

Obi200 software has been updated in 2016 and because of which your obi will no work, even though there will be dial tone but call will not go through. To update follow the following steps On obi phone dial ***6, it will tell you that software is available, hang up for software update. Simply hang up. Pick up your obi200 phone after some 15 min and it should now work!   To find IP of your obi, dial ***1. Then you can type that IP in browser and enter default password of admin/admin to login into Obi dashboard.  

Read More

Never delete winsxs folder

The winsxs folder in your root windows directory might get quite large. This is normal and there is no need to shrink. In my fresh install its size is 8 GB. AT this point I have install Visual Studio 2013 and SQL Server 2012 + SQL Server Management Studio. This is the second day of my install. I learned the hard way after I forcefully deleted contents of WinSXS folder which lead to windows corruption and all sort of errors. So to be clear, never delete files inside WinSXS file, which can easily lead to software corruption. In my case…

Read More

Drill Down SQL Query

SQL Server does not provide any drill down queries such as Category > Sub Category. There are reporting tools for it but it cannot be done in SQL Query alone without help from theird party software. There is SQL Group By ROLLUP, CUBE and “Group Sets”. It is a way to get rid of UNIONs and give you ‘total’ figures which gives you “some” level of drilldown (rather drill up) and can be very useful when you are interested in find total numbers by other than the group clause but it does not exactly give you drill down that a…

Read More

How to give names to group sets in SQL

You have a group set query in SQL that you are using to give sum total of certain numbers. The problem is where the row calculates the sum total, the cell values in the corresponding colums say ‘NULL’. How to change ‘NULL’ to something more meaninful, that is ‘Total’, ‘Sum’, ‘Sales in United States’, etc It is really easy. Use ISNULL() function.

This query is standard query that will give you No of Leaves by each employee in all months. Now we are also interested in total leave in the year, for that we will use group sets

Read More

The type of column “xxx” conflicts with the type of other columns specified in the UNPIVOT list.

When pivoting data in SQL Server, all columns must be of same time, otherwise you will get this error. You might get this error if you have imperfect case statement or one column is of integer type while the other is of type varchar. Interesting I was getting this error even after casting my columns into varchar(10) but still the error. Turned out just casting wouldn’t fix the problem either. My problem code was

  The above code was giving The type of column “PercentValue” conflicts with the type of other columns specified in the UNPIVOT list becaust i…

Read More

cannot find stored procedure SQL Server

I was creating a stored procedure on my live server and was constantly getting the error message “Cannot find stored procedure” no matter how many times i created the same stored procedure on the server. Worse if I would create the same procedure again, I would get error, the object already exists. Found out that I was not using dbo.StoredProcedure with the stored procedure name, that is schema was missing. So remember on live server, using dbo (schema) can make a big difference esp if your site is being hosted on a shared host like mine. Lesson learned, dbo is…

Read More

Visual Studio 2015 stuck at Windows Update KB2999226

I had installed Visual Studio 2005 community version on a Windows laptop before and it went all good but this time when I installed it on macbook pro (Windows 7), it got stuck the Windows Update KB2999226. I waited for hours but it wont go pass it other. In a previous attempt it gave me a failed messsage on KB2999226 as well. I did some online digging and found this post which solved me problem. It basically says Download KB2999226 from here Install it manually, it might take 10 minute or so Once it is installed start your Visual Studio…

Read More

How to access TableAdaptors in XSD

You have created XSD file that has table and TableAdaptor. Now you want to access data in your C# code. You have to use Table DataSetTableAdapters namespace to access these adaptors. Example

This method works in Visual Studio 2013. In earlier version you have to use their respective namespace. This tip is particularly helpful if you are following this Microsoft Tutorial about DAL which give me trouble because I could not access the XSD file. Turned out the way it is accessed has changed in Visual Studio.

Read More