March 2010 Blog Posts
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
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
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...