Nitesh Kejriwal

15/12/2012 by Nitesh

How to Retrieve the File Size used by a SQL Server Database on Hard Disk

Friends, We all work with databases and while working with databases, we all have most probably SQL Server one version or the another. Today, in this post we will see how to retrieve the size of data files of all databases present in SQL Server and the actual amount used in these files. As you…

10/12/2012 by Nitesh

Fix: Black Screen after upgrading to Windows 8 on Dell Vostro

Friends, I upgraded my Windows 7 running on Dell Vostro 3550 today using the Microsoft Windows 8 upgrade and everything was smooth until when Windows 8 was getting my devices ready. The installation process ran till 79% of preparing the devices and then ran into a black screen. Although, I created repair disks prior to…

29/11/2012 by Nitesh

How to Execute a Query Stored in a variable in Stored Procedure

Friends, Today, I was working with SQL Server and found an interesting situation where I wanted to store my query in a variable in stored procedure and after preparing the query based on parameters, execute the query at the last. I came up with an interesting solution for this. Let us consider the below stored…

29/11/2012 by Nitesh

Contributed to Galaxy Note-II Art Piece World Record

Dear Friends, I contributed to the Galaxy Note-II Art Piece world record and got the below certificate from Samsung as a participant.

27/11/2012 by Nitesh

How to transform text from one case to another using javascript

Friends, This post will describe converting text from one case to another using javascript. In general programming, we need to convert a text to the following cases – Lower Case Upper Case Title Case We will see the conversion one by one below – To convert a text into lowercase using Javascript function toLowerCase(str) {…