글

Difference between Classic mode and Integrated mode in IIS

Classic mode (the only mode in IIS6 and below) is a mode where IIS only works with ISAPI extensions and ISAPI filters directly. In fact, in this mode, ASP.NET is just an ISAPI extension (aspnet_isapi.dll) and an ISAPI filter (aspnet_filter.dll). IIS just treats ASP.NET as an external plugin implemented in ISAPI and works with it like a black box (and only when it's needs to give out the request to ASP.NET). In this mode, ASP.NET is not much different from PHP or other technologies for IIS. Integrated mode, on the other hand, is a new mode in IIS7 where IIS pipeline is tightly integrated (i.e. is just the same) as ASP.NET request pipeline. ASP.NET can see every request it wants to and manipulate things along the way. ASP.NET is no longer treated as an external plugin. It's completely blended and integrated in IIS. In this mode, ASP.NET HttpModules basically have nearly as much power as an ISAPI filter would have had and ASP.NET HttpHandlers can have nearly equivalent capabilit...

성능 향상을 위한 SQL 작성법

nhn개발자 포럼 http://helloworld.naver.com/helloworld/1155

Find SP with used table name

SELECT distinct so.name FROM syscomments sc INNER JOIN sysobjects so ON sc.id=so.id WHERE sc.TEXT LIKE '%AutoPrintHistory%' SELECT o.name, o.type_desc, p.name, p.type_desc FROM sys.sql_dependencies d INNER JOIN sys.objects o     ON d.object_id = o.object_id INNER JOIN sys.objects p     ON d.referenced_major_id = p.object_id     AND o.name = 'RejectionReason' or SELECT o.name, t.TABLE_NAME, c.text   FROM syscomments c   JOIN sysobjects o     ON c.id = o.id   JOIN INFORMATION_SCHEMA.Tables t     ON  c.text LIKE '%RejectionReason%' or EXEC sp_depends @objname = N'RejectionReason';

MS - SQL 특정날짜 이후 생성된 SP 및 TABLE 조회

MS - SQL 특정날짜 이후 생성된 SP 및 TABLE 조회 SP: SELECT * FROM sys.objects WHERE  (create_date > N'2013-01-01' or modify_date > N'2013-01-01' ) TABLE: SELECT * FROM sys.tables WHERE  (create_date > N'2013-01-01' or modify_date > N'2013-01-01' )

웹캠 캡쳐

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Windows.Forms; using DirectShowLib; using System.Runtime.InteropServices; using System.Runtime.InteropServices.ComTypes; namespace CastCommon {     public class WebCamCapturer     {         // a small enum to record the graph state         enum PlayState         {             Stopped,             Paused,             Running,             Init         };         // Application-defined message to notify app of filtergraph events         public const int WM_GRAPHNOTIFY = 0x8000 + 1;         IVideoWindow videoWindow = null;         IMediaControl mediaControl = null;   ...

precompiled xml serializer

precompiled xml serializer : microsoft 에서 배포한 sgen이라는 툴을 쓰면 된다. http://msdn.microsoft.com/en-us/library/bk3w6240(VS.80).aspx

c# Create Zip File Using 7-zip

d:\s 폴더 안에 있는 모든 파일 (서브디렉토리포함) zip파일 형태로 압축하여 d\s.kmz 파일로 떨군다. Creating "d\s.kmz" file from all files including sub folders in "d\s". 7zip Option : -t[Type] public partial class Form1 : Form     {         public Form1()         {             InitializeComponent();         }         private void button1_Click(object sender, EventArgs e)         {             string directoryName = Path.GetDirectoryName( System.Reflection.Assembly.GetExecutingAssembly().Location);             string processName = Path.Combine( directoryName,"7z.exe");             string argument = " a -tZip \"d:\\s.kmz\" \"d:\\s\\*\"";             Process p = new Process();             p.StartInfo.Arguments = argum...