Thinking outside the box

Patron Saint of Lost Yaks
posts - 203, comments - 734, trackbacks - 4

My Links

Advertisement

News

Archives

Post Categories

March 2010 Blog Posts

How to get current connection settings

SELECT  name AS Setting,         CASE             WHEN @@OPTIONS & number = number THEN 'ON'             ELSE 'OFF'         END AS Value FROM    master..spt_values WHERE   type = 'SOP'         AND number > 0 Or this SELECT  * FROM    sys.dm_exec_sessions WHERE   session_id = @@SPID Or this SELECT  * FROM    sys.dm_exec_request WHERE   session_id = @@SPID

posted @ Saturday, March 20, 2010 9:53 PM | Feedback (6) | Filed Under [ SQL Server 2008 Administration SQL Server 2005 SQL Server 2000 ]

Get client IP address

Up until now, I have used convuluted approaches to get the current user client IP-address. This weekend I browsed Books Online for SQL Server 2008 R2 (November CTP) and found this new cool function! SELECT  CONNECTIONPROPERTY('net_transport') AS net_transport,         CONNECTIONPROPERTY('protocol_type') AS protocol_type,         CONNECTIONPROPERTY('auth_scheme') AS auth_scheme,         CONNECTIONPROPERTY('local_net_address') AS local_net_address,         CONNECTIONPROPERTY('local_tcp_port') AS local_tcp_port,         CONNECTIONPROPERTY('client_net_address') AS client_net_address Or this   SELECT  * FROM    sys.dm_exec_connections WHERE   session_id = @@SPID

posted @ Saturday, March 20, 2010 9:48 PM | Feedback (6) | Filed Under [ SQL Server 2008 Administration ]

My first encounter with SmartAssembly

Let me start by writing I am a supreme VB6 programmer, but I have very little experience with VB.Net, so I think I still need some more time learning SmartAssembly. SmartAssembly make obfuscating and merging dll files a piece of cake! With it's simple, straight forward and clean GUI I did make my tests work. With other obfuscators like Xenocode, Salamander etc which lets you (and in some cases forces you) control more advanced settings, you really have to know what you are doing. Especially when it comes to protecting code that uses external dependencies. My most annoying experience is that if you start checking radio buttons and activating...

posted @ Wednesday, March 03, 2010 11:11 AM | Feedback (2) | Filed Under [ Miscellaneous ]

Powered by:
Powered By Subtext Powered By ASP.NET