I have worked with SQL Server bit columns for years, yet even so, to my surprise I just learned that you can not only use 1 and 0, you can also use the literals 'true' and 'false'. Note that they are not explicitly bit data types already, but like 1 and 0

many times we need to copy the text of any kind of error/warning message of browser ,development studio or application messages... Previously I was selecting the text and ctrl+'C' to copy the message. sometimes the text was not able to be selected. r

This query comes as an answer to the following tek-tips forum thread http://tek-tips.com/viewthread.cfm?qid=1672424 The task was to extract 7 digit numbers from a string. My solution is a simple straight-forward recursive CTE, although perhaps a bett

When you put script task in foreach loop container and fill DataTable from Recordset it's fill fine for one time.Next time it fills blank. Simple solution is first fill DataTable from Recordset then after convert DataTable to Recordset and assign to vari

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 we

DBA should keep a list of tables which are not being used / referenced by anyone in last few weeks. At times, we come up with a requirement where developer asks, can I have list of unused tables or “Can you tell me the tables which are not being used in l

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 ident

For quickly selecting Dimension columns in the SCD wizard - Select First row and hold "tab". to view screen shot, click on read more:

Recently I got a requirement to display groups along with number of products in the group, where cost of product falls in certain range. Additional requirement is, even if a group doesn’t have any items in the range; still show that group with the Number

I just learned from Jacob sir that one can capture (only) the active window by using ALT + PrtScn command. Previosuly i used for snipping tool for capturing "active windows" but now having learned about ALT + PrtScn would make life easier. It's a nice keyb