Web Service (asmx) – Hide Methods
In the web.config add the following lines to system.web. <webServices> <protocols> <remove name=”Documentation” /> </protocols> </webServices> If you want to […]
iOS 7 – Hide Status Bar
Set UIViewControllerBasedStatusBarAppearance to NO in info.plist or “View controller-based status bar appearance” and set it to NO Recommend on Facebook […]
Accumulative counts based on Date
declare @tmpTbl table(d int primary key, c int, cr int) insert into @tmpTbl select MONTH(<datecol>), ,count(userid),0 FROM <table_name> WHERE group […]
Regular Expressions
Remove all attributes from HTML tags using TextWranlger: <tr(.|\n)*?> Change the <tr> to something else and it will look only […]
SQL – SSIS Get FileName from Multi-Flat-File Import
SUBSTRING(FileName,LEN(FileName) – FINDSTRING(REVERSE(FileName),”\\”,1) + 2,LEN(RIGHT(FileName,FINDSTRING(REVERSE(FileName),”\\”,1) – 1))) Recommend on Facebook share via Reddit Share with Stumblers Tweet about it
Scroll to end to enable checkbox
With this function you can enable the “Agree” checkbox at the end of the page only if the user scrolls […]
Truncate Logs
alter database <mydb> set recovery simple go checkpoint go alter database <mydb> set recovery full go backup database pubs to […]
SQL – Find Space Used, Row Count of all tables in a database
SET NOCOUNT ON DBCC UPDATEUSAGE(0) — DB size. EXEC sp_spaceused — Table row counts and sizes. CREATE TABLE #t ( […]
Visual Studio – Delete blank lines
Visual Studio has ability to delete empty lines in replace operation using regular expressions. 1.Click Ctrl-H (quick replace) 2. Tick “Use Regular […]
New Office Documents appearing as zip in IE
Add the following lines to the .htaccess file: AddType application/vnd.ms-word.document.macroEnabled.12 .docm AddType application/vnd.openxmlformats-officedocument.wordprocessingml.document docx AddType application/vnd.openxmlformats-officedocument.wordprocessingml.template dotx AddType application/vnd.ms-powerpoint.template.macroEnabled.12 potm […]
