From a disconnected query window, we can connect back to the SQL Server instance from the **Query > Connection > Connect** menu option. This may sound simple, but I found this interesting. I usually press F5 (or execute button) twice to get connecte...

From a disconnected query window, we can connect back to the SQL Server instance from the **Query > Connection > Connect** menu option. This may sound simple, but I found this interesting. I usually press F5 (or execute button) twice to get connecte...

I support third party software databases at work. During the implementation of the application it needed to create a database to store the data. However the application created a database with a name that does not follow the rules for the format of id...

I support third party software databases at work. During the implementation of the application it needed to create a database to store the data. However the application created a database with a name that does not follow the rules for the format of id...

Though I know viewstate is vulnerable to security as it reveals sensitive information, I always thought that its reasonably difficult to decode. But i found that decoding viewstate is very much simpler. ASP.NET has a class "LosFormatter", by using which...

Though I know viewstate is vulnerable to security as it reveals sensitive information, I always thought that its reasonably difficult to decode. But i found that decoding viewstate is very much simpler. ASP.NET has a class "LosFormatter", by using which...

Often in web applications, while displaying some data, we often pad data with some characters for uniform look. Suppose, to display dates in a combo box, we might want to display them as 00,01,02...30. Similarly in a numeric box with range 1 to 100, we...

Often in web applications, while displaying some data, we often pad data with some characters for uniform look. Suppose, to display dates in a combo box, we might want to display them as 00,01,02...30. Similarly in a numeric box with range 1 to 100, we...

Sometimes while writing a query, we might have the requirement of dynamic sorting, i.e. sorting based on different column based on certain conditions. To do this often developers will use dynamic queries. Without resorting to Dynamic queries, we can w...

Sometimes while writing a query, we might have the requirement of dynamic sorting, i.e. sorting based on different column based on certain conditions. To do this often developers will use dynamic queries. Without resorting to Dynamic queries, we can w...