http://fransiscuss.com My notepad to share knowledge with others Wed, 06 Jan 2010 05:44:12 +0000 http://backend.userland.com/rss092 en Normally, I need to run this script against dev sql server in order for me to free up some space create table #temp_dbs_table ( [db_name] sysname not null primary key, [mod] tinyint not null default 1 ) insert into #temp_dbs_table ([db_name]) select name from master..sysdatabases where dbid > 4 --- skip master, tempdb, model and msdb databases declare @db_name sysname set @db_name = '' while ... http://fransiscuss.com/shrink-all-databases-and-set-it-to-simple-in-sql-server/ Isolated storage in silverlight is used to store information or object therefore we don't need to go to database to get all the information over and over again but again to use isolated storage or not should be based on case by case. Based on the implementation of the code ... http://fransiscuss.com/compression-in-silverlight-isolated-storage/ I found the issue with FormsAuthentication.GetRedirectUrl when it redirects then it redirects with the first querystring that you have while in fact you might have more than one querystring e.g http://localhost/myweb/login.aspx?returnurl=myview.aspx?viewID=123&viewname=abc&viewall=false then the standard FormsAuthentication will redirect to http://localhost/myweb/myview.aspx?viewID=123 but where's the remaining viewname querystring and viewall querystring??to fix this, just use ... http://fransiscuss.com/formsauthenticationgetredirecturl-only-get-the-first-parameter-of-querystring/ I keep getting this message "an activex control on this page might be unsafe to interact with other parts of the page. do you want to allow this interaction" when I try to access a page that use Javascript to access ActiveX Code. I've spent quite sometime to get rid ... http://fransiscuss.com/an-activex-control-on-this-page-might-be-unsafe-to-interact-with-other-parts-of-the-page-do-you-want-to-allow-this-interaction/ This snippet code is credited to Scott's Hanselman, This Resolve URL function is used where you want to implement it on your business layer. Methods: #region "Image URL helpers" public static string ResolveUrl(string originalUrl) ... http://fransiscuss.com/resolve-url-functions/ This code snippet is used to wrap Twitter API to send message. It's not a complete Twitter wrapper but It can send message using Twitter easily. There are two overloaded constructors where both of them requires user name and password to be passed and proxy server is used as the ... http://fransiscuss.com/send-message-in-twitter-using-net/ I've played around with FTP couple of weeks back. My application is required to feed FTP folder with 1000+ files daily. I've been googling around and I found one of the methods is to use WebApplication so I decided to put this WebApplication method to upload while iterating every single files in ... http://fransiscuss.com/upload-multiple-files-to-ftp-in-net/ This feature has been sometime in SQL Server 2005 in SQL Server 2000 you normally use @@TRANCOUNT to detect any exception but now in SQL Server 2005 you can use try catch block. In this snippet, there are 2 INSERT statement and 1 UPDATE statement. I'm expecting when there is any ... http://fransiscuss.com/trycatch-rollback-transaction-in-sql-server-2005/ One biggest advantage of table variable for me is you can't put index on the columns. I was having a problem where doing self join in table variable (it has 1000+ records) is taking really really long time. One way I found to optimize it is to add primary key ... http://fransiscuss.com/index-in-table-variable/ I was having the problem where I tried to change the date and time on my VPC environment, it keeps resetting it back. To resolve the issue, you need to edit the *.VMC file and add the highlighted section below, resave the file and launch your VPC. <integration>     <microsoft>         <mouse>             <allow ... http://fransiscuss.com/disabling-time-synchronization-of-virtual-pc-image/