http://w.rkdrm.com/api.php?action=feedcontributions&feedformat=atom&user=Rkdrm
Richard's Wiki - User contributions [en]
2026-09-11T08:23:13Z
User contributions
MediaWiki 1.25.2
http://w.rkdrm.com/index.php?title=SQL_Server&diff=954
SQL Server
2017-05-02T04:30:18Z
<p>Rkdrm: </p>
<hr />
<div>* [http://msdn.microsoft.com/en-us/library/aa302392.aspx Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication]<br />
<br />
=== Count database connections in database ===<br />
SELECT DB_NAME(sP.dbid) AS the_database<br />
, COUNT(sP.spid) AS total_database_connections<br />
FROM sys.sysprocesses sP<br />
GROUP BY DB_NAME(sP.dbid)<br />
ORDER BY 1;<br />
<br />
=== List non-clustered indexes in database ===<br />
<nowiki><br />
select t.name as tablename, i.* <br />
from sys.indexes i, sys.tables t<br />
where i.object_id = t.object_id<br />
and i.type_desc = 'NONCLUSTERED'<br />
</nowiki><br />
<br />
=== List unused indexes in database ===<br />
<nowiki><br />
SELECT DB_NAME() AS DATABASENAME, <br />
OBJECT_NAME(B.OBJECT_ID) AS TABLENAME, <br />
B.NAME AS INDEXNAME, <br />
B.INDEX_ID <br />
FROM SYS.OBJECTS A <br />
INNER JOIN SYS.INDEXES B <br />
ON A.OBJECT_ID = B.OBJECT_ID <br />
WHERE NOT EXISTS (SELECT * <br />
FROM SYS.DM_DB_INDEX_USAGE_STATS C <br />
WHERE B.OBJECT_ID = C.OBJECT_ID <br />
AND B.INDEX_ID = C.INDEX_ID) <br />
AND A.TYPE <> 'S' <br />
ORDER BY 1, 2, 3<br />
</nowiki><br />
<br />
=== Identify 'missing' indexes ===<br />
<nowiki><br />
SELECT<br />
CONVERT(decimal(28, 1), migs.avg_total_user_cost * migs.avg_user_impact *<br />
(migs.user_seeks + migs.user_scans)) AS improvement_measure,<br />
'CREATE INDEX missing_index_' + CONVERT(varchar, mig.index_group_handle) +<br />
'_' + CONVERT(varchar, mid.index_handle) + ' ON ' + mid.statement + ' (' +<br />
ISNULL(mid.equality_columns, '') +<br />
CASE WHEN mid.equality_columns IS NOT NULL AND<br />
mid.inequality_columns IS NOT NULL THEN ','<br />
ELSE ''<br />
END + ISNULL(mid.inequality_columns, '') + ')' + ISNULL(' INCLUDE (' +<br />
mid.included_columns +<br />
')', '') AS create_index_statement,<br />
migs.*,<br />
mid.database_id,<br />
mid.[object_id],<br />
mig.index_group_handle,<br />
mid.index_handle<br />
FROM<br />
sys.dm_db_missing_index_groups mig INNER JOIN <br />
sys.dm_db_missing_index_group_stats migs ON migs.group_handle = mig.index_group_handle INNER JOIN<br />
sys.dm_db_missing_index_details mid ON mig.index_handle = mid.index_handle<br />
WHERE<br />
CONVERT(decimal(28, 1), migs.avg_total_user_cost * migs.avg_user_impact *<br />
(migs.user_seeks + migs.user_scans)) > 10 AND<br />
database_id = DB_ID()<br />
ORDER BY<br />
migs.avg_total_user_cost * migs.avg_user_impact * (migs.user_seeks +<br />
migs.user_scans) DESC<br />
</nowiki><br />
<br />
=== List permissions each table in a database ===<br />
Use the sp_helprotect system stored proc. Run with no arguments it list permissions on all database objects<br />
<br />
=== List all tables in a database ===<br />
Use databasename<br />
SELECT * from sys.tables<br />
<br />
=== Run a command on each table in a database ===<br />
Use the sp_msforeachtable undocumented system stored proc, for example:<br />
<br />
<nowiki><br />
sp_msforeachTable @command1='select count(*) NR from ? <br />
where CreatedBy = ''kurzejar'' or ModifiedBy = ''kurzejar''<br />
'<br />
</nowiki><br />
<br />
To restrict tables to those in the dbo schema, use the @whereAnd parameter:<br />
<br />
<nowiki><br />
sp_msforeachTable @command1='select count(*) NR from ? <br />
where CreatedBy = ''kurzejar'' or ModifiedBy = ''kurzejar''<br />
' ,<br />
@whereAnd = 'and uid = 1'<br />
</nowiki><br />
<br />
=== SQL 2008 - Change sysadmin password on local database ===<br />
<br />
Pre-requisite: Make sure your Domain login is a member of the PC’s local admin group.<br />
<br />
1) Stop SQL Server (either from Management Studio or Services)<br />
<br />
2) Open a cmd prompt at your sql installation folder (C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn) and run: sqlserv.exe –m to put it into single user mode. Leave the command window open.<br />
<br />
3) Open another cmd prompt (pathed) and run sqlcmd –E –S .<br />
CREATE LOGIN [BEACON\myUsername] FROM WINDOWS WITH DEFAULT_DATABASE=[master]<br />
EXEC master..sp_addsrvrolemember @loginame = N'BEACON\myUsername', @rolename = N'sysadmin'<br />
<br />
4) Close the both command windows and restart the SQL Service<br />
<br />
Open SS Management Studio, expand server roles and check you are in the sysadmin role.<br />
<br />
==== Create AdventureWorks Sample Cube for 2008/R2 Analysis Services ====<br />
* [http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Analysis%20Services%20Database Installing Analysis Services Database (CodePlex)]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=SQL_Server&diff=953
SQL Server
2017-05-02T03:46:47Z
<p>Rkdrm: </p>
<hr />
<div>* [http://msdn.microsoft.com/en-us/library/aa302392.aspx Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication]<br />
<br />
=== Count database connections in database ===<br />
SELECT DB_NAME(sP.dbid) AS the_database<br />
, COUNT(sP.spid) AS total_database_connections<br />
FROM sys.sysprocesses sP<br />
GROUP BY DB_NAME(sP.dbid)<br />
ORDER BY 1;<br />
<br />
=== List non-clustered indexes in database ===<br />
<nowiki><br />
select t.name as tablename, i.* <br />
from sys.indexes i, sys.tables t<br />
where i.object_id = t.object_id<br />
and i.type_desc = 'NONCLUSTERED'<br />
</nowiki><br />
<br />
=== Identify 'missing' indexes ===<br />
<nowiki><br />
SELECT<br />
CONVERT(decimal(28, 1), migs.avg_total_user_cost * migs.avg_user_impact *<br />
(migs.user_seeks + migs.user_scans)) AS improvement_measure,<br />
'CREATE INDEX missing_index_' + CONVERT(varchar, mig.index_group_handle) +<br />
'_' + CONVERT(varchar, mid.index_handle) + ' ON ' + mid.statement + ' (' +<br />
ISNULL(mid.equality_columns, '') +<br />
CASE WHEN mid.equality_columns IS NOT NULL AND<br />
mid.inequality_columns IS NOT NULL THEN ','<br />
ELSE ''<br />
END + ISNULL(mid.inequality_columns, '') + ')' + ISNULL(' INCLUDE (' +<br />
mid.included_columns +<br />
')', '') AS create_index_statement,<br />
migs.*,<br />
mid.database_id,<br />
mid.[object_id],<br />
mig.index_group_handle,<br />
mid.index_handle<br />
FROM<br />
sys.dm_db_missing_index_groups mig INNER JOIN <br />
sys.dm_db_missing_index_group_stats migs ON migs.group_handle = mig.index_group_handle INNER JOIN<br />
sys.dm_db_missing_index_details mid ON mig.index_handle = mid.index_handle<br />
WHERE<br />
CONVERT(decimal(28, 1), migs.avg_total_user_cost * migs.avg_user_impact *<br />
(migs.user_seeks + migs.user_scans)) > 10 AND<br />
database_id = DB_ID()<br />
ORDER BY<br />
migs.avg_total_user_cost * migs.avg_user_impact * (migs.user_seeks +<br />
migs.user_scans) DESC<br />
</nowiki><br />
<br />
=== List permissions each table in a database ===<br />
Use the sp_helprotect system stored proc. Run with no arguments it list permissions on all database objects<br />
<br />
=== List all tables in a database ===<br />
Use databasename<br />
SELECT * from sys.tables<br />
<br />
=== Run a command on each table in a database ===<br />
Use the sp_msforeachtable undocumented system stored proc, for example:<br />
<br />
<nowiki><br />
sp_msforeachTable @command1='select count(*) NR from ? <br />
where CreatedBy = ''kurzejar'' or ModifiedBy = ''kurzejar''<br />
'<br />
</nowiki><br />
<br />
To restrict tables to those in the dbo schema, use the @whereAnd parameter:<br />
<br />
<nowiki><br />
sp_msforeachTable @command1='select count(*) NR from ? <br />
where CreatedBy = ''kurzejar'' or ModifiedBy = ''kurzejar''<br />
' ,<br />
@whereAnd = 'and uid = 1'<br />
</nowiki><br />
<br />
=== SQL 2008 - Change sysadmin password on local database ===<br />
<br />
Pre-requisite: Make sure your Domain login is a member of the PC’s local admin group.<br />
<br />
1) Stop SQL Server (either from Management Studio or Services)<br />
<br />
2) Open a cmd prompt at your sql installation folder (C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn) and run: sqlserv.exe –m to put it into single user mode. Leave the command window open.<br />
<br />
3) Open another cmd prompt (pathed) and run sqlcmd –E –S .<br />
CREATE LOGIN [BEACON\myUsername] FROM WINDOWS WITH DEFAULT_DATABASE=[master]<br />
EXEC master..sp_addsrvrolemember @loginame = N'BEACON\myUsername', @rolename = N'sysadmin'<br />
<br />
4) Close the both command windows and restart the SQL Service<br />
<br />
Open SS Management Studio, expand server roles and check you are in the sysadmin role.<br />
<br />
==== Create AdventureWorks Sample Cube for 2008/R2 Analysis Services ====<br />
* [http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Analysis%20Services%20Database Installing Analysis Services Database (CodePlex)]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=SQL_Server&diff=952
SQL Server
2017-05-02T03:44:53Z
<p>Rkdrm: </p>
<hr />
<div>* [http://msdn.microsoft.com/en-us/library/aa302392.aspx Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication]<br />
<br />
=== Count database connections in database ===<br />
SELECT DB_NAME(sP.dbid) AS the_database<br />
, COUNT(sP.spid) AS total_database_connections<br />
FROM sys.sysprocesses sP<br />
GROUP BY DB_NAME(sP.dbid)<br />
ORDER BY 1;<br />
<br />
=== Identify 'missing' indexes ===<br />
<nowiki><br />
SELECT<br />
CONVERT(decimal(28, 1), migs.avg_total_user_cost * migs.avg_user_impact *<br />
(migs.user_seeks + migs.user_scans)) AS improvement_measure,<br />
'CREATE INDEX missing_index_' + CONVERT(varchar, mig.index_group_handle) +<br />
'_' + CONVERT(varchar, mid.index_handle) + ' ON ' + mid.statement + ' (' +<br />
ISNULL(mid.equality_columns, '') +<br />
CASE WHEN mid.equality_columns IS NOT NULL AND<br />
mid.inequality_columns IS NOT NULL THEN ','<br />
ELSE ''<br />
END + ISNULL(mid.inequality_columns, '') + ')' + ISNULL(' INCLUDE (' +<br />
mid.included_columns +<br />
')', '') AS create_index_statement,<br />
migs.*,<br />
mid.database_id,<br />
mid.[object_id],<br />
mig.index_group_handle,<br />
mid.index_handle<br />
FROM<br />
sys.dm_db_missing_index_groups mig INNER JOIN <br />
sys.dm_db_missing_index_group_stats migs ON migs.group_handle = mig.index_group_handle INNER JOIN<br />
sys.dm_db_missing_index_details mid ON mig.index_handle = mid.index_handle<br />
WHERE<br />
CONVERT(decimal(28, 1), migs.avg_total_user_cost * migs.avg_user_impact *<br />
(migs.user_seeks + migs.user_scans)) > 10 AND<br />
database_id = DB_ID()<br />
ORDER BY<br />
migs.avg_total_user_cost * migs.avg_user_impact * (migs.user_seeks +<br />
migs.user_scans) DESC<br />
</nowiki><br />
<br />
=== List permissions each table in a database ===<br />
Use the sp_helprotect system stored proc. Run with no arguments it list permissions on all database objects<br />
<br />
=== List all tables in a database ===<br />
Use databasename<br />
SELECT * from sys.tables<br />
<br />
=== Run a command on each table in a database ===<br />
Use the sp_msforeachtable undocumented system stored proc, for example:<br />
<br />
<nowiki><br />
sp_msforeachTable @command1='select count(*) NR from ? <br />
where CreatedBy = ''kurzejar'' or ModifiedBy = ''kurzejar''<br />
'<br />
</nowiki><br />
<br />
To restrict tables to those in the dbo schema, use the @whereAnd parameter:<br />
<br />
<nowiki><br />
sp_msforeachTable @command1='select count(*) NR from ? <br />
where CreatedBy = ''kurzejar'' or ModifiedBy = ''kurzejar''<br />
' ,<br />
@whereAnd = 'and uid = 1'<br />
</nowiki><br />
<br />
=== SQL 2008 - Change sysadmin password on local database ===<br />
<br />
Pre-requisite: Make sure your Domain login is a member of the PC’s local admin group.<br />
<br />
1) Stop SQL Server (either from Management Studio or Services)<br />
<br />
2) Open a cmd prompt at your sql installation folder (C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn) and run: sqlserv.exe –m to put it into single user mode. Leave the command window open.<br />
<br />
3) Open another cmd prompt (pathed) and run sqlcmd –E –S .<br />
CREATE LOGIN [BEACON\myUsername] FROM WINDOWS WITH DEFAULT_DATABASE=[master]<br />
EXEC master..sp_addsrvrolemember @loginame = N'BEACON\myUsername', @rolename = N'sysadmin'<br />
<br />
4) Close the both command windows and restart the SQL Service<br />
<br />
Open SS Management Studio, expand server roles and check you are in the sysadmin role.<br />
<br />
==== Create AdventureWorks Sample Cube for 2008/R2 Analysis Services ====<br />
* [http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Analysis%20Services%20Database Installing Analysis Services Database (CodePlex)]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=SQL_Server&diff=951
SQL Server
2017-05-02T03:43:44Z
<p>Rkdrm: /* Identify 'missing' indexes */</p>
<hr />
<div>* [http://msdn.microsoft.com/en-us/library/aa302392.aspx Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication]<br />
<br />
=== Count database connections in database ===<br />
SELECT DB_NAME(sP.dbid) AS the_database<br />
, COUNT(sP.spid) AS total_database_connections<br />
FROM sys.sysprocesses sP<br />
GROUP BY DB_NAME(sP.dbid)<br />
ORDER BY 1;<br />
<br />
=== Identify 'missing' indexes ===<br />
<nowiki><br />
SELECT<br />
CONVERT(decimal(28, 1), migs.avg_total_user_cost * migs.avg_user_impact *<br />
(migs.user_seeks + migs.user_scans)) AS improvement_measure,<br />
'CREATE INDEX missing_index_' + CONVERT(varchar, mig.index_group_handle) +<br />
'_' + CONVERT(varchar, mid.index_handle) + ' ON ' + mid.statement + ' (' +<br />
ISNULL(mid.equality_columns, '') +<br />
CASE WHEN mid.equality_columns IS NOT NULL AND<br />
mid.inequality_columns IS NOT NULL THEN ','<br />
ELSE ''<br />
END + ISNULL(mid.inequality_columns, '') + ')' + ISNULL(' INCLUDE (' +<br />
mid.included_columns +<br />
')', '') AS create_index_statement,<br />
migs.*,<br />
mid.database_id,<br />
mid.[object_id],<br />
mig.index_group_handle,<br />
mid.index_handle<br />
FROM<br />
sys.dm_db_missing_index_groups mig INNER JOIN <br />
sys.dm_db_missing_index_group_stats migs ON migs.group_handle = mig.index_group_handle INNER JOIN<br />
sys.dm_db_missing_index_details mid ON mig.index_handle = mid.index_handle<br />
WHERE<br />
CONVERT(decimal(28, 1), migs.avg_total_user_cost * migs.avg_user_impact *<br />
(migs.user_seeks + migs.user_scans)) > 10 AND<br />
database_id = DB_ID()<br />
ORDER BY<br />
migs.avg_total_user_cost * migs.avg_user_impact * (migs.user_seeks +<br />
migs.user_scans) DESC<br />
</nowiki><br />
<br />
=== List permissions each table in a database ===<br />
Use the sp_helprotect system stored proc. Run with no arguments it list permissions on all database objects<br />
<br />
=== List all tables in a database ===<br />
Use databasename<br />
SELECT * from sys.tables<br />
<br />
=== Run a command on each table in a database ===<br />
Use the sp_msforeachtable undocumented system stored proc, for example:<br />
<br />
<nowiki><br />
sp_msforeachTable @command1='select count(*) NR from ? <br />
where CreatedBy = ''kurzejar'' or ModifiedBy = ''kurzejar''<br />
'<br />
</nowiki><br />
<br />
To restrict tables to those in the dbo schema, use the @whereAnd parameter:<br />
<br />
<nowiki><br />
sp_msforeachTable @command1='select count(*) NR from ? <br />
where CreatedBy = ''kurzejar'' or ModifiedBy = ''kurzejar''<br />
' ,<br />
@whereAnd = 'and uid = 1'<br />
</nowiki><br />
<br />
=== SQL 2008 - Change sysadmin password on local database ===<br />
<br />
Pre-requisite: Make sure your Domain login is a member of the PC’s local admin group.<br />
<br />
1) Stop SQL Server (either from Management Studio or Services)<br />
<br />
2) Open a cmd prompt at your sql installation folder (C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn) and run: sqlserv.exe –m to put it into single user mode. Leave the command window open.<br />
<br />
3) Open another cmd prompt (pathed) and run sqlcmd –E –S .<br />
CREATE LOGIN [BEACON\myUsername] FROM WINDOWS WITH DEFAULT_DATABASE=[master]<br />
EXEC master..sp_addsrvrolemember @loginame = N'BEACON\myUsername', @rolename = N'sysadmin'<br />
<br />
4) Close the both command windows and restart the SQL Service<br />
<br />
Open SS Management Studio, expand server roles and check you are in the sysadmin role.<br />
<br />
==== Create AdventureWorks Sample Cube for 2008/R2 Analysis Services ====<br />
* [http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Analysis%20Services%20Database Installing Analysis Services Database (CodePlex)]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=SQL_Server&diff=950
SQL Server
2017-05-02T03:42:13Z
<p>Rkdrm: </p>
<hr />
<div>* [http://msdn.microsoft.com/en-us/library/aa302392.aspx Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication]<br />
<br />
=== Count database connections in database ===<br />
SELECT DB_NAME(sP.dbid) AS the_database<br />
, COUNT(sP.spid) AS total_database_connections<br />
FROM sys.sysprocesses sP<br />
GROUP BY DB_NAME(sP.dbid)<br />
ORDER BY 1;<br />
<br />
=== Identify 'missing' indexes ===<br />
SELECT<br />
CONVERT(decimal(28, 1), migs.avg_total_user_cost * migs.avg_user_impact *<br />
(migs.user_seeks + migs.user_scans)) AS improvement_measure,<br />
'CREATE INDEX missing_index_' + CONVERT(varchar, mig.index_group_handle) +<br />
'_' + CONVERT(varchar, mid.index_handle) + ' ON ' + mid.statement + ' (' +<br />
ISNULL(mid.equality_columns, '') +<br />
CASE WHEN mid.equality_columns IS NOT NULL AND<br />
mid.inequality_columns IS NOT NULL THEN ','<br />
ELSE ''<br />
END + ISNULL(mid.inequality_columns, '') + ')' + ISNULL(' INCLUDE (' +<br />
mid.included_columns +<br />
')', '') AS create_index_statement,<br />
migs.*,<br />
mid.database_id,<br />
mid.[object_id],<br />
mig.index_group_handle,<br />
mid.index_handle<br />
FROM<br />
sys.dm_db_missing_index_groups mig INNER JOIN <br />
sys.dm_db_missing_index_group_stats migs ON migs.group_handle = mig.index_group_handle INNER JOIN<br />
sys.dm_db_missing_index_details mid ON mig.index_handle = mid.index_handle<br />
WHERE<br />
CONVERT(decimal(28, 1), migs.avg_total_user_cost * migs.avg_user_impact *<br />
(migs.user_seeks + migs.user_scans)) > 10 AND<br />
database_id = DB_ID()<br />
ORDER BY<br />
migs.avg_total_user_cost * migs.avg_user_impact * (migs.user_seeks +<br />
migs.user_scans) DESC<br />
<br />
=== List permissions each table in a database ===<br />
Use the sp_helprotect system stored proc. Run with no arguments it list permissions on all database objects<br />
<br />
=== List all tables in a database ===<br />
Use databasename<br />
SELECT * from sys.tables<br />
<br />
=== Run a command on each table in a database ===<br />
Use the sp_msforeachtable undocumented system stored proc, for example:<br />
<br />
<nowiki><br />
sp_msforeachTable @command1='select count(*) NR from ? <br />
where CreatedBy = ''kurzejar'' or ModifiedBy = ''kurzejar''<br />
'<br />
</nowiki><br />
<br />
To restrict tables to those in the dbo schema, use the @whereAnd parameter:<br />
<br />
<nowiki><br />
sp_msforeachTable @command1='select count(*) NR from ? <br />
where CreatedBy = ''kurzejar'' or ModifiedBy = ''kurzejar''<br />
' ,<br />
@whereAnd = 'and uid = 1'<br />
</nowiki><br />
<br />
=== SQL 2008 - Change sysadmin password on local database ===<br />
<br />
Pre-requisite: Make sure your Domain login is a member of the PC’s local admin group.<br />
<br />
1) Stop SQL Server (either from Management Studio or Services)<br />
<br />
2) Open a cmd prompt at your sql installation folder (C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn) and run: sqlserv.exe –m to put it into single user mode. Leave the command window open.<br />
<br />
3) Open another cmd prompt (pathed) and run sqlcmd –E –S .<br />
CREATE LOGIN [BEACON\myUsername] FROM WINDOWS WITH DEFAULT_DATABASE=[master]<br />
EXEC master..sp_addsrvrolemember @loginame = N'BEACON\myUsername', @rolename = N'sysadmin'<br />
<br />
4) Close the both command windows and restart the SQL Service<br />
<br />
Open SS Management Studio, expand server roles and check you are in the sysadmin role.<br />
<br />
==== Create AdventureWorks Sample Cube for 2008/R2 Analysis Services ====<br />
* [http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Analysis%20Services%20Database Installing Analysis Services Database (CodePlex)]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=SQL_Server&diff=949
SQL Server
2017-05-02T03:41:03Z
<p>Rkdrm: </p>
<hr />
<div>* [http://msdn.microsoft.com/en-us/library/aa302392.aspx Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication]<br />
<br />
=== Count database connections in database ===<br />
SELECT DB_NAME(sP.dbid) AS the_database<br />
, COUNT(sP.spid) AS total_database_connections<br />
FROM sys.sysprocesses sP<br />
GROUP BY DB_NAME(sP.dbid)<br />
ORDER BY 1;<br />
<br />
=== List permissions each table in a database ===<br />
Use the sp_helprotect system stored proc. Run with no arguments it list permissions on all database objects<br />
<br />
=== List all tables in a database ===<br />
Use databasename<br />
SELECT * from sys.tables<br />
<br />
=== Run a command on each table in a database ===<br />
Use the sp_msforeachtable undocumented system stored proc, for example:<br />
<br />
<nowiki><br />
sp_msforeachTable @command1='select count(*) NR from ? <br />
where CreatedBy = ''kurzejar'' or ModifiedBy = ''kurzejar''<br />
'<br />
</nowiki><br />
<br />
To restrict tables to those in the dbo schema, use the @whereAnd parameter:<br />
<br />
<nowiki><br />
sp_msforeachTable @command1='select count(*) NR from ? <br />
where CreatedBy = ''kurzejar'' or ModifiedBy = ''kurzejar''<br />
' ,<br />
@whereAnd = 'and uid = 1'<br />
</nowiki><br />
<br />
=== SQL 2008 - Change sysadmin password on local database ===<br />
<br />
Pre-requisite: Make sure your Domain login is a member of the PC’s local admin group.<br />
<br />
1) Stop SQL Server (either from Management Studio or Services)<br />
<br />
2) Open a cmd prompt at your sql installation folder (C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn) and run: sqlserv.exe –m to put it into single user mode. Leave the command window open.<br />
<br />
3) Open another cmd prompt (pathed) and run sqlcmd –E –S .<br />
CREATE LOGIN [BEACON\myUsername] FROM WINDOWS WITH DEFAULT_DATABASE=[master]<br />
EXEC master..sp_addsrvrolemember @loginame = N'BEACON\myUsername', @rolename = N'sysadmin'<br />
<br />
4) Close the both command windows and restart the SQL Service<br />
<br />
Open SS Management Studio, expand server roles and check you are in the sysadmin role.<br />
<br />
==== Create AdventureWorks Sample Cube for 2008/R2 Analysis Services ====<br />
* [http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Analysis%20Services%20Database Installing Analysis Services Database (CodePlex)]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=ASP.NET&diff=948
ASP.NET
2016-11-04T06:16:56Z
<p>Rkdrm: </p>
<hr />
<div>[https://msdn.microsoft.com/en-us/magazine/dn802603.aspx '''MSDN:''' Async Programming : Introduction to Async/Await on ASP.NET]<br />
<br />
[https://www.asp.net/web-forms/overview/performance-and-caching/using-asynchronous-methods-in-aspnet-45 '''www.asp.net:''' Using Asynchronous Methods in ASP.NET 4.5]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=ASP.NET&diff=947
ASP.NET
2016-11-04T06:16:16Z
<p>Rkdrm: </p>
<hr />
<div>[https://msdn.microsoft.com/en-us/magazine/dn802603.aspx MSDN: Async Programming : Introduction to Async/Await on ASP.NET]<br />
<br />
[https://www.asp.net/web-forms/overview/performance-and-caching/using-asynchronous-methods-in-aspnet-45 www.asp.net: Using Asynchronous Methods in ASP.NET 4.5]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=ASP.NET&diff=946
ASP.NET
2016-11-04T06:15:40Z
<p>Rkdrm: </p>
<hr />
<div>[https://msdn.microsoft.com/en-us/magazine/dn802603.aspx Async Programming : Introduction to Async/Await on ASP.NET]<br />
<br />
[https://www.asp.net/web-forms/overview/performance-and-caching/using-asynchronous-methods-in-aspnet-45 Using Asynchronous Methods in ASP.NET 4.5]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=ASP.NET&diff=945
ASP.NET
2016-11-04T06:12:51Z
<p>Rkdrm: Created page with "[https://www.asp.net/web-forms/overview/performance-and-caching/using-asynchronous-methods-in-aspnet-45 Using Asynchronous Methods in ASP.NET 4.5]"</p>
<hr />
<div>[https://www.asp.net/web-forms/overview/performance-and-caching/using-asynchronous-methods-in-aspnet-45 Using Asynchronous Methods in ASP.NET 4.5]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=Software&diff=944
Software
2016-11-04T06:11:32Z
<p>Rkdrm: </p>
<hr />
<div>* [[Active Directory]]<br />
* [[ASP.NET]]<br />
* [[OpenGL]]<br />
* [[SSL Certificates]]<br />
* ESRI<br />
** [[ESRI Silverlight & WPF]]<br />
* GIS<br />
** [http://deepearth.codeplex.com/ DeepEarth -CodePlex Silverlight control] - [http://deepearth.soulsolutions.com.au/nearmap/ Online Demo]<br />
** [http://www.openstreetmap.org/ OpenStreetMap.org]<br />
* [[Google Chrome]]<br />
* [[Log4net]]<br />
* [[Microsoft Windows]]<br />
* [[Windows Server 2008]]<br />
* [[Office 2007]]<br />
** [[OpenXML]]<br />
* [[MOSS 2007]]<br />
* [[SharePoint 2010]]<br />
* [[PerformancePoint 2010]]<br />
* [[InfoPath 2010]]<br />
* [[Microsoft Patterns & Practices]]<br />
** [[CAL]] (Composite Application Library)<br />
* [[DevExpress]]<br />
* [[Microsoft LINQ]]<br />
* [[Entity Framework 4]] (EF)<br />
* [[Microsoft Workflow Foundation]] (WF)<br />
* [[Windows Identity Foundation]] (WIF)<br />
* [[Windows Communication Foundation]] (WCF)<br />
* [[Windows Presentation Foundation]] (WPF)<br />
* [[Windows Management Instrumentation]] (WMI)<br />
* [[Microsoft Remote Desktop]] (RDP)<br />
* [[Windows Phone 7]] (WP7)<br />
* [[Silverlight]]<br />
** Silverlight Desktops:<br />
*** [https://www.wiki-os.org/ https://www.wiki-os.org/]<br />
*** [http://silveos.com/ http://silveos.com/]<br />
* [[.NET]]<br />
* [[.NET AOP]]<br />
* [[.NET & Memory Leaks]]<br />
* [[Oracle]]<br />
* [[Paint.Net]]<br />
* [[Physics Engines]]<br />
* [[Powershell]]<br />
* [[SMO]]<br />
* [[SQL Server]]<br />
* [[SQL Server Analysis Services]]<br />
* [[SQL Server Reporting Services]]<br />
* [[T4]]<br />
* [[Enterprise Architect]]<br />
* [[VS 2008]]<br />
* [[VS 2010]]<br />
** [[C#]]<br />
* [[Microsoft TFS2010]]<br />
<br />
* [[Resharper]]<br />
* [[Security]]<br />
<br />
Mobile<br />
* [[Mono / Xamarin]]<br />
<br />
Linux<br />
* [[Webmin]]<br />
* [[New Linux Disk]]<br />
<br />
Web<br />
* [[Which CMS]]<br />
* [http://arstechnica.com/web/news/2011/02/chrome-takes-10-usage-share-ie-continues-to-haemorrhage.ars Worldwide browser market share: January 2011 (ArsTechnica)]<br />
* [[HTML]]<br />
* [[HTTP]]<br />
* [[Javascript]]<br />
* [[IIS / Web Development]]<br />
* [[Web Video]]<br />
<br />
Standards<br />
* [[UPnP/DNLA]]<br />
<br />
Google<br />
* [[Google Maps]]<br />
<br />
Media Servers<br />
* [[MythTV]]<br />
* [[MediaTomb]]<br />
* [[MiniDLNA]]<br />
<br />
=== UsefulWare ===<br />
* [http://code.msdn.microsoft.com/AddInSpy AddInSpy - provides details of Office 2007 Addins]<br />
* [http://www.cpuid.com/ CPU-Z]<br />
* [[Flash Video Player]] (.flv player - VLC)<br />
* [http://www.getpaint.net/ Paint.Net]<br />
** [http://forums.getpaint.net/index.php?/topic/927-icon-cursor-and-animated-cursor-format-v37-may-2010/?s=ef9afdad1cb4967893e4e9bc1cd6473d .ico and .cur Paint.Net addin]<br />
* [http://ccollomb.free.fr/unlocker/ Unlocker - unlock locked Windows files]<br />
* [http://www.wingrep.com/index.htm Windows Grep]<br />
* [http://www.msfn.org/board/How-to-make-a-7-Zip-Switchless-Installer-t39048.html How to make a 7-Zip Switchless Installer]<br />
* [http://www.ltr-data.se/opencode.html/#ImDisk ImDisk RAMDisk virtual disk driver] Supports 32&64 bit incl Windows 7, GPL open source.<br />
<br />
=== Free Open Source Icons ===<br />
* [http://en.wikipedia.org/wiki/Nuvola Nuvola (Wikipedia)]<br />
* [http://en.wikipedia.org/wiki/Open_Clip_Art_Library Open Clipart Library (Wikipedia)]<br />
* [http://david.bellot.free.fr/svg-cards/ LGPL license playing cards, SVG format]<br />
* [http://www.iconarchive.com/ http://www.iconarchive.com/] - not sure about licensing<br />
<br />
=== Royalty-free Vectors ===<br />
* [http://www.vectorstock.com/free-vectors http://www.vectorstock.com/free-vectors]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=File:PhotosphereNoThreeJs_26Jan2016.zip&diff=943
File:PhotosphereNoThreeJs 26Jan2016.zip
2016-01-26T07:33:55Z
<p>Rkdrm: Handle initial rotation from gpano</p>
<hr />
<div>Handle initial rotation from gpano</div>
Rkdrm
http://w.rkdrm.com/index.php?title=PhotoSphere&diff=942
PhotoSphere
2016-01-26T07:20:27Z
<p>Rkdrm: </p>
<hr />
<div>* [[Media:photosphere9Jan2016.zip]]<br />
* [[Media:photosphere11Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_16Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_18Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_21Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_22Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_26Jan2016.zip]]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=File:PhotosphereNoThreeJs_22Jan2016.zip&diff=941
File:PhotosphereNoThreeJs 22Jan2016.zip
2016-01-22T06:35:20Z
<p>Rkdrm: Handle load texture from list</p>
<hr />
<div>Handle load texture from list</div>
Rkdrm
http://w.rkdrm.com/index.php?title=PhotoSphere&diff=940
PhotoSphere
2016-01-22T06:22:41Z
<p>Rkdrm: </p>
<hr />
<div>* [[Media:photosphere9Jan2016.zip]]<br />
* [[Media:photosphere11Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_16Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_18Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_21Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_22Jan2016.zip]]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=File:PhotosphereNoThreeJs_21Jan2016.zip&diff=939
File:PhotosphereNoThreeJs 21Jan2016.zip
2016-01-21T09:48:07Z
<p>Rkdrm: Got some rotation going</p>
<hr />
<div>Got some rotation going</div>
Rkdrm
http://w.rkdrm.com/index.php?title=PhotoSphere&diff=938
PhotoSphere
2016-01-21T09:35:28Z
<p>Rkdrm: </p>
<hr />
<div>* [[Media:photosphere9Jan2016.zip]]<br />
* [[Media:photosphere11Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_16Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_18Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_21Jan2016.zip]]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=File:PhotosphereNoThreeJs_18Jan2016.zip&diff=937
File:PhotosphereNoThreeJs 18Jan2016.zip
2016-01-18T20:43:52Z
<p>Rkdrm: Displays plain sphere, handles browser resize</p>
<hr />
<div>Displays plain sphere, handles browser resize</div>
Rkdrm
http://w.rkdrm.com/index.php?title=PhotoSphere&diff=936
PhotoSphere
2016-01-18T20:32:18Z
<p>Rkdrm: </p>
<hr />
<div>* [[Media:photosphere9Jan2016.zip]]<br />
* [[Media:photosphere11Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_16Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_18Jan2016.zip]]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=PhotoSphere&diff=935
PhotoSphere
2016-01-18T20:31:56Z
<p>Rkdrm: </p>
<hr />
<div>* [[Media:photosphere9Jan2016.zip]]<br />
* [[Media:photosphere11Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_16Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_16Jan2016.zip]]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=File:PhotosphereNoThreeJs_16Jan2016.zip&diff=934
File:PhotosphereNoThreeJs 16Jan2016.zip
2016-01-16T10:58:11Z
<p>Rkdrm: </p>
<hr />
<div></div>
Rkdrm
http://w.rkdrm.com/index.php?title=PhotoSphere&diff=933
PhotoSphere
2016-01-16T10:46:48Z
<p>Rkdrm: </p>
<hr />
<div>* [[Media:photosphere9Jan2016.zip]]<br />
* [[Media:photosphere11Jan2016.zip]]<br />
* [[Media:photosphereNoThreeJs_16Jan2016.zip]]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=File:Photosphere11Jan2016.zip&diff=932
File:Photosphere11Jan2016.zip
2016-01-12T10:11:45Z
<p>Rkdrm: </p>
<hr />
<div></div>
Rkdrm
http://w.rkdrm.com/index.php?title=PhotoSphere&diff=931
PhotoSphere
2016-01-12T10:00:05Z
<p>Rkdrm: </p>
<hr />
<div>* [[Media:photosphere9Jan2016.zip]]<br />
* [[Media:photosphere11Jan2016.zip]]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=File:Photosphere9Jan2016.zip&diff=930
File:Photosphere9Jan2016.zip
2016-01-09T09:40:59Z
<p>Rkdrm: </p>
<hr />
<div></div>
Rkdrm
http://w.rkdrm.com/index.php?title=PhotoSphere&diff=929
PhotoSphere
2016-01-09T09:29:37Z
<p>Rkdrm: Created page with "* Media:photosphere9Jan2016.zip"</p>
<hr />
<div>* [[Media:photosphere9Jan2016.zip]]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=Main_Page&diff=928
Main Page
2016-01-09T09:27:31Z
<p>Rkdrm: /* Backups */</p>
<hr />
<div>== '''Content''' ==<br />
* [[SMS Links]]<br />
* [[HowTo]]<br />
* [[Shopping List]]<br />
* [[Stereo Pair Images]]<br />
* [[Haiku]]<br />
* [[Architecture]]<br />
* [[Software]]<br />
* [[Hardware]]<br />
* [[XCode]]<br />
* [[Iguassu]]<br />
* [[Bread]]<br />
* [[Photos]]<br />
* [[Places]]<br />
<br />
<!-- * [http://maps.google.com.au/maps/ms?hl=en&ie=UTF8&msa=0&msid=109298058278878788801.000470f7be0dc41e24fec&ll=-33.447507,115.85915&spn=0.004069,0.008256&z=18 David & Denise's House] --><br />
* [http://www.how-to-draw-and-paint.com/learn-to-draw.html Learn to Draw]<br />
<br />
== '''Backups''' ==<br />
* [[TV Guide]]<br />
* [[Source Control]]<br />
* [[Map App]]<br />
* [[Workflow]]<br />
* [[Config]]<br />
* [[Upnp]]<br />
* [[WeatherBrowse]]<br />
* [[RestJsonExample]]<br />
* [[ArcGISPushpinDragNDrop]]<br />
* [[MumsFiles]]<br />
* [[PhotoSphere]]<br />
<br />
{{Help:Contents}}</div>
Rkdrm
http://w.rkdrm.com/index.php?title=C&diff=927
C
2015-10-27T02:21:37Z
<p>Rkdrm: /* TimingScope */</p>
<hr />
<div>* [http://elegantcode.com/2009/07/03/wpf-multithreading-using-the-backgroundworker-and-reporting-the-progress-to-the-ui/ Using the BackgroundWorker and Reporting the Progress to the UI]<br />
<br />
===== Get Property Name via Lambda Expression =====<br />
<br />
To use it do something like this.PropertyName(()=>this.Property);<br />
<br />
<code><br />
using System;<br />
using System.Linq.Expressions;<br />
using System.Reflection;<br />
private string PropertyName<T>(Expression<Func<T>> property)<br />
{<br />
var propertyInfo = (property.Body as MemberExpression).Member as PropertyInfo;<br />
if (propertyInfo == null)<br />
{<br />
throw new ArgumentException("The lambda expression 'property' should point to a valid Property");<br />
}<br />
var propertyName = propertyInfo.Name;<br />
return propertyName;<br />
}<br />
</code><br />
<br />
===== SerializeToXml =====<br />
<br />
using System.IO;<br />
using System.Xml;<br />
/// <summary><br />
/// Serializes to XML.<br />
/// </summary><br />
/// <param name="firstClassElement">The first class element to serialize.</param><br />
/// <returns>The XML string that represents the passed first class element.</returns><br />
public virtual string SerializeToXml(FirstClassElementType firstClassElement)<br />
{<br />
string xmlData;<br />
var memoryStream = new MemoryStream();<br />
XmlTextWriter writer = null;<br />
try<br />
{<br />
writer = new XmlTextWriter(memoryStream, Encoding.Unicode)<br />
{<br />
Formatting = Formatting.Indented,<br />
Indentation = 0<br />
};<br />
var xmlSerializer = new XmlSerializer(typeof (FirstClassElementType));<br />
xmlSerializer.Serialize(writer, firstClassElement);<br />
writer.Flush();<br />
}<br />
finally<br />
{<br />
memoryStream.Seek(0, SeekOrigin.Begin);<br />
var textReader = new StreamReader(memoryStream);<br />
xmlData = textReader.ReadToEnd();<br />
textReader.Close();<br />
if (null != writer)<br />
writer.Close();<br />
}<br />
return xmlData;<br />
}<br />
<br />
===== TimingScope =====<br />
Usage:<br />
<code><br />
using (TimingScope.StartNew(string.Format("Extract Output XML: {0} {1}", foo, bar), Logger)) {<br />
<br />
}<br />
</code><br />
Code:<br />
<code><br />
using System;<br />
using System.Diagnostics;<br />
namespace Common<br />
{<br />
public class TimingScope : IDisposable<br />
{<br />
private readonly log4net.ILog _logger;<br />
private readonly string _name;<br />
private readonly Stopwatch _timer;<br />
<br />
public TimingScope(string name, log4net.ILog logger)<br />
{<br />
_name = name;<br />
_logger = logger;<br />
_timer = new Stopwatch();<br />
}<br />
<br />
public void Start()<br />
{<br />
_logger.DebugFormat("{0} starting", _name);<br />
_timer.Start();<br />
}<br />
<br />
public static TimingScope StartNew(string name, log4net.ILog logger)<br />
{<br />
var scope = new TimingScope(name, logger);<br />
scope.Start();<br />
return scope;<br />
}<br />
<br />
public static TimeSpan Time(string name, log4net.ILog logger, Action operation)<br />
{<br />
using (var timer = StartNew(name, logger))<br />
{<br />
operation();<br />
return timer.Elapsed;<br />
}<br />
}<br />
<br />
public void Stop()<br />
{<br />
_timer.Stop();<br />
_logger.DebugFormat("{0} completed in {1:0.000} s", _name, _timer.ElapsedMilliseconds / 1000.0);<br />
}<br />
<br />
public void Dispose()<br />
{<br />
Stop();<br />
}<br />
<br />
public TimeSpan Elapsed<br />
{<br />
get { return _timer.Elapsed; }<br />
}<br />
}<br />
}<br />
</code></div>
Rkdrm
http://w.rkdrm.com/index.php?title=C&diff=926
C
2015-10-27T02:15:44Z
<p>Rkdrm: /* TimingScope */</p>
<hr />
<div>* [http://elegantcode.com/2009/07/03/wpf-multithreading-using-the-backgroundworker-and-reporting-the-progress-to-the-ui/ Using the BackgroundWorker and Reporting the Progress to the UI]<br />
<br />
===== Get Property Name via Lambda Expression =====<br />
<br />
To use it do something like this.PropertyName(()=>this.Property);<br />
<br />
<code><br />
using System;<br />
using System.Linq.Expressions;<br />
using System.Reflection;<br />
private string PropertyName<T>(Expression<Func<T>> property)<br />
{<br />
var propertyInfo = (property.Body as MemberExpression).Member as PropertyInfo;<br />
if (propertyInfo == null)<br />
{<br />
throw new ArgumentException("The lambda expression 'property' should point to a valid Property");<br />
}<br />
var propertyName = propertyInfo.Name;<br />
return propertyName;<br />
}<br />
</code><br />
<br />
===== SerializeToXml =====<br />
<br />
using System.IO;<br />
using System.Xml;<br />
/// <summary><br />
/// Serializes to XML.<br />
/// </summary><br />
/// <param name="firstClassElement">The first class element to serialize.</param><br />
/// <returns>The XML string that represents the passed first class element.</returns><br />
public virtual string SerializeToXml(FirstClassElementType firstClassElement)<br />
{<br />
string xmlData;<br />
var memoryStream = new MemoryStream();<br />
XmlTextWriter writer = null;<br />
try<br />
{<br />
writer = new XmlTextWriter(memoryStream, Encoding.Unicode)<br />
{<br />
Formatting = Formatting.Indented,<br />
Indentation = 0<br />
};<br />
var xmlSerializer = new XmlSerializer(typeof (FirstClassElementType));<br />
xmlSerializer.Serialize(writer, firstClassElement);<br />
writer.Flush();<br />
}<br />
finally<br />
{<br />
memoryStream.Seek(0, SeekOrigin.Begin);<br />
var textReader = new StreamReader(memoryStream);<br />
xmlData = textReader.ReadToEnd();<br />
textReader.Close();<br />
if (null != writer)<br />
writer.Close();<br />
}<br />
return xmlData;<br />
}<br />
<br />
===== TimingScope =====<br />
<code><br />
using System;<br />
using System.Diagnostics;<br />
namespace Common<br />
{<br />
public class TimingScope : IDisposable<br />
{<br />
private readonly log4net.ILog _logger;<br />
private readonly string _name;<br />
private readonly Stopwatch _timer;<br />
<br />
public TimingScope(string name, log4net.ILog logger)<br />
{<br />
_name = name;<br />
_logger = logger;<br />
_timer = new Stopwatch();<br />
}<br />
<br />
public void Start()<br />
{<br />
_logger.DebugFormat("{0} starting", _name);<br />
_timer.Start();<br />
}<br />
<br />
public static TimingScope StartNew(string name, log4net.ILog logger)<br />
{<br />
var scope = new TimingScope(name, logger);<br />
scope.Start();<br />
return scope;<br />
}<br />
<br />
public static TimeSpan Time(string name, log4net.ILog logger, Action operation)<br />
{<br />
using (var timer = StartNew(name, logger))<br />
{<br />
operation();<br />
return timer.Elapsed;<br />
}<br />
}<br />
<br />
public void Stop()<br />
{<br />
_timer.Stop();<br />
_logger.DebugFormat("{0} completed in {1:0.000} s", _name, _timer.ElapsedMilliseconds / 1000.0);<br />
}<br />
<br />
public void Dispose()<br />
{<br />
Stop();<br />
}<br />
<br />
public TimeSpan Elapsed<br />
{<br />
get { return _timer.Elapsed; }<br />
}<br />
}<br />
}<br />
</code></div>
Rkdrm
http://w.rkdrm.com/index.php?title=C&diff=925
C
2015-10-27T02:15:09Z
<p>Rkdrm: /* TimingScope */</p>
<hr />
<div>* [http://elegantcode.com/2009/07/03/wpf-multithreading-using-the-backgroundworker-and-reporting-the-progress-to-the-ui/ Using the BackgroundWorker and Reporting the Progress to the UI]<br />
<br />
===== Get Property Name via Lambda Expression =====<br />
<br />
To use it do something like this.PropertyName(()=>this.Property);<br />
<br />
<code><br />
using System;<br />
using System.Linq.Expressions;<br />
using System.Reflection;<br />
private string PropertyName<T>(Expression<Func<T>> property)<br />
{<br />
var propertyInfo = (property.Body as MemberExpression).Member as PropertyInfo;<br />
if (propertyInfo == null)<br />
{<br />
throw new ArgumentException("The lambda expression 'property' should point to a valid Property");<br />
}<br />
var propertyName = propertyInfo.Name;<br />
return propertyName;<br />
}<br />
</code><br />
<br />
===== SerializeToXml =====<br />
<br />
using System.IO;<br />
using System.Xml;<br />
/// <summary><br />
/// Serializes to XML.<br />
/// </summary><br />
/// <param name="firstClassElement">The first class element to serialize.</param><br />
/// <returns>The XML string that represents the passed first class element.</returns><br />
public virtual string SerializeToXml(FirstClassElementType firstClassElement)<br />
{<br />
string xmlData;<br />
var memoryStream = new MemoryStream();<br />
XmlTextWriter writer = null;<br />
try<br />
{<br />
writer = new XmlTextWriter(memoryStream, Encoding.Unicode)<br />
{<br />
Formatting = Formatting.Indented,<br />
Indentation = 0<br />
};<br />
var xmlSerializer = new XmlSerializer(typeof (FirstClassElementType));<br />
xmlSerializer.Serialize(writer, firstClassElement);<br />
writer.Flush();<br />
}<br />
finally<br />
{<br />
memoryStream.Seek(0, SeekOrigin.Begin);<br />
var textReader = new StreamReader(memoryStream);<br />
xmlData = textReader.ReadToEnd();<br />
textReader.Close();<br />
if (null != writer)<br />
writer.Close();<br />
}<br />
return xmlData;<br />
}<br />
<br />
===== TimingScope =====<br />
<br />
<code><br />
using System;<br />
using System.Diagnostics;<br />
namespace Common<br />
{<br />
public class TimingScope : IDisposable<br />
{<br />
private readonly log4net.ILog _logger;<br />
private readonly string _name;<br />
private readonly Stopwatch _timer;<br />
<br />
public TimingScope(string name, log4net.ILog logger)<br />
{<br />
_name = name;<br />
_logger = logger;<br />
_timer = new Stopwatch();<br />
}<br />
<br />
public void Start()<br />
{<br />
_logger.DebugFormat("{0} starting", _name);<br />
_timer.Start();<br />
}<br />
<br />
public static TimingScope StartNew(string name, log4net.ILog logger)<br />
{<br />
var scope = new TimingScope(name, logger);<br />
scope.Start();<br />
return scope;<br />
}<br />
<br />
public static TimeSpan Time(string name, log4net.ILog logger, Action operation)<br />
{<br />
using (var timer = StartNew(name, logger))<br />
{<br />
operation();<br />
return timer.Elapsed;<br />
}<br />
}<br />
<br />
public void Stop()<br />
{<br />
_timer.Stop();<br />
_logger.DebugFormat("{0} completed in {1:0.000} s", _name, _timer.ElapsedMilliseconds / 1000.0);<br />
}<br />
<br />
public void Dispose()<br />
{<br />
Stop();<br />
}<br />
<br />
public TimeSpan Elapsed<br />
{<br />
get { return _timer.Elapsed; }<br />
}<br />
}<br />
}<br />
</code></div>
Rkdrm
http://w.rkdrm.com/index.php?title=C&diff=924
C
2015-10-27T02:14:02Z
<p>Rkdrm: /* TimingScope */</p>
<hr />
<div>* [http://elegantcode.com/2009/07/03/wpf-multithreading-using-the-backgroundworker-and-reporting-the-progress-to-the-ui/ Using the BackgroundWorker and Reporting the Progress to the UI]<br />
<br />
===== Get Property Name via Lambda Expression =====<br />
<br />
To use it do something like this.PropertyName(()=>this.Property);<br />
<br />
<code><br />
using System;<br />
using System.Linq.Expressions;<br />
using System.Reflection;<br />
private string PropertyName<T>(Expression<Func<T>> property)<br />
{<br />
var propertyInfo = (property.Body as MemberExpression).Member as PropertyInfo;<br />
if (propertyInfo == null)<br />
{<br />
throw new ArgumentException("The lambda expression 'property' should point to a valid Property");<br />
}<br />
var propertyName = propertyInfo.Name;<br />
return propertyName;<br />
}<br />
</code><br />
<br />
===== SerializeToXml =====<br />
<br />
using System.IO;<br />
using System.Xml;<br />
/// <summary><br />
/// Serializes to XML.<br />
/// </summary><br />
/// <param name="firstClassElement">The first class element to serialize.</param><br />
/// <returns>The XML string that represents the passed first class element.</returns><br />
public virtual string SerializeToXml(FirstClassElementType firstClassElement)<br />
{<br />
string xmlData;<br />
var memoryStream = new MemoryStream();<br />
XmlTextWriter writer = null;<br />
try<br />
{<br />
writer = new XmlTextWriter(memoryStream, Encoding.Unicode)<br />
{<br />
Formatting = Formatting.Indented,<br />
Indentation = 0<br />
};<br />
var xmlSerializer = new XmlSerializer(typeof (FirstClassElementType));<br />
xmlSerializer.Serialize(writer, firstClassElement);<br />
writer.Flush();<br />
}<br />
finally<br />
{<br />
memoryStream.Seek(0, SeekOrigin.Begin);<br />
var textReader = new StreamReader(memoryStream);<br />
xmlData = textReader.ReadToEnd();<br />
textReader.Close();<br />
if (null != writer)<br />
writer.Close();<br />
}<br />
return xmlData;<br />
}<br />
<br />
===== TimingScope =====<br />
<br />
<code><br />
using System;<br />
using System.Diagnostics;<br />
namespace Common<br />
{<br />
public class TimingScope : IDisposable<br />
{<br />
private readonly log4net.ILog _logger;<br />
private readonly string _name;<br />
private readonly Stopwatch _timer;<br />
<br />
public TimingScope(string name, log4net.ILog logger)<br />
{<br />
_name = name;<br />
_logger = logger;<br />
_timer = new Stopwatch();<br />
}<br />
<br />
public void Start()<br />
{<br />
_logger.DebugFormat("{0} starting", _name);<br />
_timer.Start();<br />
}<br />
<br />
public static TimingScope StartNew(string name, log4net.ILog logger)<br />
{<br />
var scope = new TimingScope(name, logger);<br />
scope.Start();<br />
return scope;<br />
}<br />
<br />
public static TimeSpan Time(string name, log4net.ILog logger, Action operation)<br />
{<br />
using (var timer = StartNew(name, logger))<br />
{<br />
operation();<br />
return timer.Elapsed;<br />
}<br />
}<br />
<br />
public void Stop()<br />
{<br />
_timer.Stop();<br />
_logger.DebugFormat("{0} completed in {1:0.000} s", _name, _timer.ElapsedMilliseconds / 1000.0);<br />
}<br />
<br />
public void Dispose()<br />
{<br />
Stop();<br />
}<br />
<br />
public TimeSpan Elapsed<br />
{<br />
get { return _timer.Elapsed; }<br />
}<br />
}<br />
}<br />
</code></div>
Rkdrm
http://w.rkdrm.com/index.php?title=C&diff=923
C
2015-10-27T02:12:32Z
<p>Rkdrm: </p>
<hr />
<div>* [http://elegantcode.com/2009/07/03/wpf-multithreading-using-the-backgroundworker-and-reporting-the-progress-to-the-ui/ Using the BackgroundWorker and Reporting the Progress to the UI]<br />
<br />
===== Get Property Name via Lambda Expression =====<br />
<br />
To use it do something like this.PropertyName(()=>this.Property);<br />
<br />
<code><br />
using System;<br />
using System.Linq.Expressions;<br />
using System.Reflection;<br />
private string PropertyName<T>(Expression<Func<T>> property)<br />
{<br />
var propertyInfo = (property.Body as MemberExpression).Member as PropertyInfo;<br />
if (propertyInfo == null)<br />
{<br />
throw new ArgumentException("The lambda expression 'property' should point to a valid Property");<br />
}<br />
var propertyName = propertyInfo.Name;<br />
return propertyName;<br />
}<br />
</code><br />
<br />
===== SerializeToXml =====<br />
<br />
using System.IO;<br />
using System.Xml;<br />
/// <summary><br />
/// Serializes to XML.<br />
/// </summary><br />
/// <param name="firstClassElement">The first class element to serialize.</param><br />
/// <returns>The XML string that represents the passed first class element.</returns><br />
public virtual string SerializeToXml(FirstClassElementType firstClassElement)<br />
{<br />
string xmlData;<br />
var memoryStream = new MemoryStream();<br />
XmlTextWriter writer = null;<br />
try<br />
{<br />
writer = new XmlTextWriter(memoryStream, Encoding.Unicode)<br />
{<br />
Formatting = Formatting.Indented,<br />
Indentation = 0<br />
};<br />
var xmlSerializer = new XmlSerializer(typeof (FirstClassElementType));<br />
xmlSerializer.Serialize(writer, firstClassElement);<br />
writer.Flush();<br />
}<br />
finally<br />
{<br />
memoryStream.Seek(0, SeekOrigin.Begin);<br />
var textReader = new StreamReader(memoryStream);<br />
xmlData = textReader.ReadToEnd();<br />
textReader.Close();<br />
if (null != writer)<br />
writer.Close();<br />
}<br />
return xmlData;<br />
}<br />
<br />
===== TimingScope =====<br />
<br />
<code><br />
namespace IrisServices.Common<br />
{<br />
public class TimingScope : IDisposable<br />
{<br />
private readonly log4net.ILog _logger;<br />
private readonly string _name;<br />
private readonly Stopwatch _timer;<br />
<br />
public TimingScope(string name, log4net.ILog logger)<br />
{<br />
_name = name;<br />
_logger = logger;<br />
_timer = new Stopwatch();<br />
}<br />
<br />
public void Start()<br />
{<br />
_logger.DebugFormat("{0} starting", _name);<br />
_timer.Start();<br />
}<br />
<br />
public static TimingScope StartNew(string name, log4net.ILog logger)<br />
{<br />
var scope = new TimingScope(name, logger);<br />
scope.Start();<br />
return scope;<br />
}<br />
<br />
public static TimeSpan Time(string name, log4net.ILog logger, Action operation)<br />
{<br />
using (var timer = StartNew(name, logger))<br />
{<br />
operation();<br />
return timer.Elapsed;<br />
}<br />
}<br />
<br />
public void Stop()<br />
{<br />
_timer.Stop();<br />
_logger.DebugFormat("{0} completed in {1:0.000} s", _name, _timer.ElapsedMilliseconds / 1000.0);<br />
}<br />
<br />
public void Dispose()<br />
{<br />
Stop();<br />
}<br />
<br />
public TimeSpan Elapsed<br />
{<br />
get { return _timer.Elapsed; }<br />
}<br />
}<br />
}<br />
</code></div>
Rkdrm
http://w.rkdrm.com/index.php?title=Google_Maps&diff=922
Google Maps
2015-09-04T04:59:29Z
<p>Rkdrm: /* Excellent Google Maps API Links */</p>
<hr />
<div>== Excellent Google Maps API Links ==<br />
* [http://www.mapstylr.com/map-style-editor/ http://www.mapstylr.com/map-style-editor/] MapStylr map style editor<br />
* [http://koti.mbnet.fi/ojalesa/exam/index.html Google Maps API Examples and Test Pages] is probably the definitive set of Maps API examples.<br />
* [http://www.bdcc.co.uk/Gmaps/BdccGmapBits.htm Google Maps Widgets from Bill Chadwick] has interesting overlays.<br />
* [http://econym.org.uk/gmap/gevent.htm Google Maps API Tutorial] has [[a list of the accessible GEvent types]].<br />
<br />
== Show Google Maps Lat/Long ==<br />
<br />
To display the lat/long of the center of a Google Map, put the following into the browser location bar: <br />
<code>javascript:void(prompt("",gApplication.getMap().getCenter()));</code><br />
This can also be bookmarked.</div>
Rkdrm
http://w.rkdrm.com/index.php?title=Google_Maps&diff=921
Google Maps
2015-09-04T04:59:03Z
<p>Rkdrm: </p>
<hr />
<div>== Excellent Google Maps API Links ==<br />
* [http://www.mapstylr.com/map-style-editor/] MapStylr map style editor<br />
* [http://koti.mbnet.fi/ojalesa/exam/index.html Google Maps API Examples and Test Pages] is probably the definitive set of Maps API examples.<br />
* [http://www.bdcc.co.uk/Gmaps/BdccGmapBits.htm Google Maps Widgets from Bill Chadwick] has interesting overlays.<br />
* [http://econym.org.uk/gmap/gevent.htm Google Maps API Tutorial] has [[a list of the accessible GEvent types]].<br />
<br />
== Show Google Maps Lat/Long ==<br />
<br />
To display the lat/long of the center of a Google Map, put the following into the browser location bar: <br />
<code>javascript:void(prompt("",gApplication.getMap().getCenter()));</code><br />
This can also be bookmarked.</div>
Rkdrm
http://w.rkdrm.com/index.php?title=Newertech_Bluetooth_Keyboard&diff=920
Newertech Bluetooth Keyboard
2015-09-03T10:48:33Z
<p>Rkdrm: </p>
<hr />
<div>Newer Tech Bluetooth Keypad for Use on S3P<br />
<br />
By Nick O on August 16, 2015<br />
<br />
Verified Purchase<br />
<br />
I purchased this keypad because I wanted a Bluetooth option rather than a USB connection. The key pad works excellently on my Surface 3 Pro. Its thin perfect angle and the unit is very solid. Have been using heavily the past few days and its worked flawlessly, no lag in numbers being entered on spreadsheet. I had a problem at the beginning. Pairing worked as advertised. The keypad would not work as there is no NUM LOCK on the S3P. I called chatted with the Newer Tech Technical help line, and they told me that the driver was not good on the S3P and it would not work with Windows 10 as they had not tested with it. This consumed a better part of 30 minutes and the tech support in my opinion was far from good. There were long periods of no response to a simple question. I did an internet search and found out that there is a way to have the NUM LOCK set on the S3P.<br />
<br />
WIN + R<br><br />
Type OSK<br><br />
Enter OK<br />
<br />
On the screen will appear an On Screen Keyboard with a Number Key, touch or click the NUM Lock and you are in business. I am not a Techie an if I could spend 20 minutes doing a search the Newer Tech support should have known this right up front.</div>
Rkdrm
http://w.rkdrm.com/index.php?title=Newertech_Bluetooth_Keyboard&diff=919
Newertech Bluetooth Keyboard
2015-09-03T10:47:05Z
<p>Rkdrm: Created page with "Newer Tech Bluetooth Keypad for Use on S3P By Nick O on August 16, 2015 Verified Purchase I purchased this keypad because I wanted a Bluetooth option rather than a USB co..."</p>
<hr />
<div>Newer Tech Bluetooth Keypad for Use on S3P<br />
<br />
By Nick O on August 16, 2015<br />
<br />
Verified Purchase<br />
<br />
I purchased this keypad because I wanted a Bluetooth option rather than a USB connection. The key pad works excellently on my Surface 3 Pro. Its thin perfect angle and the unit is very solid. Have been using heavily the past few days and its worked flawlessly, no lag in numbers being entered on spreadsheet. I had a problem at the beginning. Pairing worked as advertised. The keypad would not work as there is no NUM LOCK on the S3P. I called chatted with the Newer Tech Technical help line, and they told me that the driver was not good on the S3P and it would not work with Windows 10 as they had not tested with it. This consumed a better part of 30 minutes and the tech support in my opinion was far from good. There were long periods of no response to a simple question. I did an internet search and found out that there is a way to have the NUM LOCK set on the S3P.<br />
<br />
WIN + R<br />
Type OSK<br />
Enter OK<br />
<br />
On the screen will appear an On Screen Keyboard with a Number Key, touch or click the NUM Lock and you are in business. I am not a Techie an if I could spend 20 minutes doing a search the Newer Tech support should have known this right up front.</div>
Rkdrm
http://w.rkdrm.com/index.php?title=Hardware&diff=918
Hardware
2015-09-03T10:46:29Z
<p>Rkdrm: </p>
<hr />
<div>'''Bold text'''* [[http://www.videohelp.com/dvdhacks/samsung-bd-e5500/11837 http://www.videohelp.com/dvdhacks/samsung-bd-e5500/11837]] [[Samsung BDE5500 Region code hack]]<br />
* [[HP Proliant Microserver (HP-N36L)]]<br />
* [[iPad]]<br />
* [[http://www.nokia.com.au/A41175727 Nokia e71 phone]] is of interest, uses Symbian OS (9.2), has Bluetooth 2.0, 802.11 b/g<br />
* [[http://www.zdnet.com.au/reviews/hardware/laptops/soa/ASUS-Eee-PC-1000/0,2000065761,339290680,00.htm Asus eeepc 1000]] 10" laptop looks interesting also<br />
* [[Microsoft Digital Media Keyboard]]<br />
* [[Edison Screw (ES) to Bayonet Cap (BC) Converters]]<br />
* [[Newertech Bluetooth Keyboard]]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=Active_Directory&diff=917
Active Directory
2014-12-03T06:36:18Z
<p>Rkdrm: </p>
<hr />
<div>* LinqPad C# script to get detail of your own identity in AD:<br />
<br />
<code><br />
// using System.DirectoryServices;<br />
// using System.DirectoryServices.AccountManagement;<br />
using(PrincipalContext ctx = new PrincipalContext(ContextType.Domain, "apac"))<br />
using(UserPrincipal usr = UserPrincipal.FindByIdentity(ctx, IdentityType.SamAccountName, "kurzejar"))<br />
usr.Dump();<br />
</code><br />
<br />
* LinqPad C# script to get all users and groups in active directory AD:<br />
<br />
<code><br />
//using System.DirectoryServices;<br />
//using System.DirectoryServices.AccountManagement;<br />
void Main()<br />
{<br />
// const string adSearchContainer = "DC=apac,DC=birchmangroup,DC=com,DC=au";<br />
const string adSearchContainer = "DC=mrwa,DC=wa,DC=gov,DC=au";<br />
var users = FetchAllUsersFromActiveDirectory(adSearchContainer);<br />
var groups = FetchAllGroupsFromActiveDirectory(adSearchContainer);<br />
users.Dump("Users", true); // to datagrid<br />
groups.Dump("Groups", true); // to datagrid<br />
}<br />
// Define other methods and classes here<br />
public class User<br />
{<br />
public string Name { get; set; }<br />
public string Login { get; set; }<br />
public string DistinguishedName { get; set; }<br />
}<br />
private static IEnumerable<User> FetchAllUsersFromActiveDirectory(string searchContainer) {<br />
return FetchAllFromActiveDirectory(searchContainer, "(&ObjectCategory=user)");<br />
}<br />
private static IEnumerable<User> FetchAllGroupsFromActiveDirectory(string searchContainer) {<br />
return FetchAllFromActiveDirectory(searchContainer, "(&objectClass=group)");<br />
}<br />
private static IEnumerable<User> FetchAllFromActiveDirectory(string searchContainer, string directorySearcherFilter)<br />
{<br />
try<br />
{<br />
List<User> result = new List<User>();<br />
//using (DirectoryEntry searchRoot = new DirectoryEntry()) // Search from root of current domain<br />
using (DirectoryEntry searchRoot = new DirectoryEntry("LDAP://" + searchContainer))<br />
{<br />
DirectorySearcher ser = new DirectorySearcher(searchRoot)<br />
{<br />
// Filter = "(&ObjectCategory=user)",<br />
// Filter = "(&objectClass=group)",<br />
Filter = directorySearcherFilter,<br />
ReferralChasing = ReferralChasingOption.All,<br />
PageSize = 1000,<br />
};<br />
ser.PropertiesToLoad.Add("Name");<br />
ser.PropertiesToLoad.Add("distinguishedName");<br />
ser.PropertiesToLoad.Add("sAMAccountName");<br />
//ser.PropertiesToLoad.Add("mail");<br />
//ser.PropertiesToLoad.Add("description");<br />
using (SearchResultCollection searchResults = ser.FindAll())<br />
{<br />
int count = searchResults.Count;<br />
for (int i = 0; i < count; i++)<br />
{<br />
SearchResult searchResult = searchResults[i];<br />
string name = GetSearchResultProperty(searchResult, "Name");<br />
string distinguishedName = GetSearchResultProperty(searchResult, "distinguishedName");<br />
string samAccount = GetSearchResultProperty(searchResult, "sAMAccountName");<br />
//var email = GetSearchResultProperty(searchResult, "mail");<br />
//var description = GetSearchResultProperty(searchResult, "description");<br />
result.Add(new User<br />
{<br />
Name = name,<br />
Login = samAccount,<br />
DistinguishedName = distinguishedName,<br />
//Email = email, <br />
//Role = description<br />
});<br />
}<br />
}<br />
ser.Dispose();<br />
}<br />
return result;<br />
}<br />
catch (Exception ex)<br />
{<br />
string message = string.Format("FetchAllUsersFromActiveDirectory() failed");<br />
// Log.Error(message, ex);<br />
throw;<br />
}<br />
}<br />
private static string GetSearchResultProperty(SearchResult result, string name)<br />
{<br />
if (result.Properties.Contains(name))<br />
{<br />
var propertyCollection = result.Properties[name];<br />
if (propertyCollection.Count == 1 && propertyCollection[0] != null)<br />
{<br />
return propertyCollection[0].ToString();<br />
}<br />
}<br />
return string.Empty;<br />
}<br />
</code></div>
Rkdrm
http://w.rkdrm.com/index.php?title=Active_Directory&diff=916
Active Directory
2014-12-03T06:35:47Z
<p>Rkdrm: </p>
<hr />
<div>* LinqPad C# script to get detail of your own identity in AD:<br />
<br />
<code><br />
// using System.DirectoryServices;<br />
// using System.DirectoryServices.AccountManagement;<br />
using(PrincipalContext ctx = new PrincipalContext(ContextType.Domain, "apac"))<br />
using(UserPrincipal usr = UserPrincipal.FindByIdentity(ctx, IdentityType.SamAccountName, "kurzejar"))<br />
usr.Dump();<br />
</code><br />
<br />
* LinqPad C# script to get all users and groups in active directory AD:<br />
<br />
<code><br />
//using System.DirectoryServices;<br />
//using System.DirectoryServices.AccountManagement;<br />
void Main()<br />
{<br />
// const string adSearchContainer = "DC=apac,DC=birchmangroup,DC=com,DC=au";<br />
const string adSearchContainer = "DC=mrwa,DC=wa,DC=gov,DC=au";<br />
var users = FetchAllUsersFromActiveDirectory(adSearchContainer);<br />
var groups = FetchAllGroupsFromActiveDirectory(adSearchContainer);<br />
users.Dump("Users", true); // to datagrid<br />
groups.Dump("Groups", true); // to datagrid<br />
<br />
}<br />
// Define other methods and classes here<br />
public class User<br />
{<br />
public string Name { get; set; }<br />
public string Login { get; set; }<br />
public string DistinguishedName { get; set; }<br />
}<br />
private static IEnumerable<User> FetchAllUsersFromActiveDirectory(string searchContainer) {<br />
return FetchAllFromActiveDirectory(searchContainer, "(&ObjectCategory=user)");<br />
}<br />
private static IEnumerable<User> FetchAllGroupsFromActiveDirectory(string searchContainer) {<br />
return FetchAllFromActiveDirectory(searchContainer, "(&objectClass=group)");<br />
}<br />
private static IEnumerable<User> FetchAllFromActiveDirectory(string searchContainer, string directorySearcherFilter)<br />
{<br />
try<br />
{<br />
List<User> result = new List<User>();<br />
//using (DirectoryEntry searchRoot = new DirectoryEntry()) // Search from root of current domain<br />
using (DirectoryEntry searchRoot = new DirectoryEntry("LDAP://" + searchContainer))<br />
{<br />
DirectorySearcher ser = new DirectorySearcher(searchRoot)<br />
{<br />
// Filter = "(&ObjectCategory=user)",<br />
// Filter = "(&objectClass=group)",<br />
Filter = directorySearcherFilter,<br />
ReferralChasing = ReferralChasingOption.All,<br />
PageSize = 1000,<br />
};<br />
ser.PropertiesToLoad.Add("Name");<br />
ser.PropertiesToLoad.Add("distinguishedName");<br />
ser.PropertiesToLoad.Add("sAMAccountName");<br />
//ser.PropertiesToLoad.Add("mail");<br />
//ser.PropertiesToLoad.Add("description");<br />
using (SearchResultCollection searchResults = ser.FindAll())<br />
{<br />
int count = searchResults.Count;<br />
for (int i = 0; i < count; i++)<br />
{<br />
SearchResult searchResult = searchResults[i];<br />
string name = GetSearchResultProperty(searchResult, "Name");<br />
string distinguishedName = GetSearchResultProperty(searchResult, "distinguishedName");<br />
string samAccount = GetSearchResultProperty(searchResult, "sAMAccountName");<br />
//var email = GetSearchResultProperty(searchResult, "mail");<br />
//var description = GetSearchResultProperty(searchResult, "description");<br />
result.Add(new User<br />
{<br />
Name = name,<br />
Login = samAccount,<br />
DistinguishedName = distinguishedName,<br />
//Email = email, <br />
//Role = description<br />
});<br />
}<br />
}<br />
ser.Dispose();<br />
}<br />
return result;<br />
}<br />
catch (Exception ex)<br />
{<br />
string message = string.Format("FetchAllUsersFromActiveDirectory() failed");<br />
// Log.Error(message, ex);<br />
throw;<br />
}<br />
}<br />
private static string GetSearchResultProperty(SearchResult result, string name)<br />
{<br />
if (result.Properties.Contains(name))<br />
{<br />
var propertyCollection = result.Properties[name];<br />
if (propertyCollection.Count == 1 && propertyCollection[0] != null)<br />
{<br />
return propertyCollection[0].ToString();<br />
}<br />
}<br />
return string.Empty;<br />
}<br />
</code></div>
Rkdrm
http://w.rkdrm.com/index.php?title=Active_Directory&diff=915
Active Directory
2014-12-03T06:34:25Z
<p>Rkdrm: </p>
<hr />
<div>* LinqPad C# script to get detail of your own identity in AD:<br />
<br />
<code><br />
// using System.DirectoryServices;<br />
// using System.DirectoryServices.AccountManagement;<br />
using(PrincipalContext ctx = new PrincipalContext(ContextType.Domain, "apac"))<br />
using(UserPrincipal usr = UserPrincipal.FindByIdentity(ctx, IdentityType.SamAccountName, "kurzejar"))<br />
usr.Dump();<br />
</code><br />
<br />
* LinqPad C# script to get all users and groups in active directory AD:<br />
<br />
<code><br />
//using System.DirectoryServices;<br />
//using System.DirectoryServices.AccountManagement;<br />
void Main()<br />
{<br />
// const string adSearchContainer = "DC=apac,DC=birchmangroup,DC=com,DC=au";<br />
const string adSearchContainer = "DC=mrwa,DC=wa,DC=gov,DC=au";<br />
var users = FetchAllUsersFromActiveDirectory(adSearchContainer);<br />
var groups = FetchAllGroupsFromActiveDirectory(adSearchContainer);<br />
users.Dump("Users", true); // to datagrid<br />
groups.Dump("Groups", true); // to datagrid<br />
<br />
}<br />
// Define other methods and classes here<br />
public class User<br />
{<br />
public string Name { get; set; }<br />
public string Login { get; set; }<br />
public string DistinguishedName { get; set; }<br />
}<br />
private static IEnumerable<User> FetchAllUsersFromActiveDirectory(string searchContainer) {<br />
return FetchAllFromActiveDirectory(searchContainer, "(&ObjectCategory=user)");<br />
}<br />
private static IEnumerable<User> FetchAllGroupsFromActiveDirectory(string searchContainer) {<br />
return FetchAllFromActiveDirectory(searchContainer, "(&objectClass=group)");<br />
}<br />
private static IEnumerable<User> FetchAllFromActiveDirectory(string searchContainer, string directorySearcherFilter)<br />
{<br />
try<br />
{<br />
List<User> result = new List<User>();<br />
//using (DirectoryEntry searchRoot = new DirectoryEntry()) // Search from root of current domain<br />
using (DirectoryEntry searchRoot = new DirectoryEntry("LDAP://" + searchContainer))<br />
{<br />
DirectorySearcher ser = new DirectorySearcher(searchRoot)<br />
{<br />
// Filter = "(&ObjectCategory=user)",<br />
// Filter = "(&objectClass=group)",<br />
Filter = directorySearcherFilter,<br />
ReferralChasing = ReferralChasingOption.All,<br />
PageSize = 1000,<br />
};<br />
ser.PropertiesToLoad.Add("Name");<br />
ser.PropertiesToLoad.Add("distinguishedName");<br />
ser.PropertiesToLoad.Add("sAMAccountName");<br />
//ser.PropertiesToLoad.Add("mail");<br />
//ser.PropertiesToLoad.Add("description");<br />
using (SearchResultCollection searchResults = ser.FindAll())<br />
{<br />
int count = searchResults.Count;<br />
for (int i = 0; i < count; i++)<br />
{<br />
SearchResult searchResult = searchResults[i];<br />
string name = GetSearchResultProperty(searchResult, "Name");<br />
string distinguishedName = GetSearchResultProperty(searchResult, "distinguishedName");<br />
string samAccount = GetSearchResultProperty(searchResult, "sAMAccountName");<br />
//var email = GetSearchResultProperty(searchResult, "mail");<br />
//var description = GetSearchResultProperty(searchResult, "description");<br />
result.Add(new User<br />
{<br />
Name = name,<br />
Login = samAccount,<br />
DistinguishedName = distinguishedName,<br />
//Email = email, <br />
//Role = description<br />
});<br />
}<br />
}<br />
ser.Dispose();<br />
}<br />
return result;<br />
}<br />
catch (Exception ex)<br />
{<br />
string message = string.Format("FetchAllUsersFromActiveDirectory() failed");<br />
// Log.Error(message, ex);<br />
throw;<br />
}<br />
}<br />
private static string GetSearchResultProperty(SearchResult result, string name)<br />
{<br />
if (result.Properties.Contains(name))<br />
{<br />
var propertyCollection = result.Properties[name];<br />
if (propertyCollection.Count == 1 && propertyCollection[0] != null)<br />
{<br />
return propertyCollection[0].ToString();<br />
}<br />
}<br />
return string.Empty;<br />
}<br />
</code></div>
Rkdrm
http://w.rkdrm.com/index.php?title=Active_Directory&diff=914
Active Directory
2014-12-03T06:32:15Z
<p>Rkdrm: </p>
<hr />
<div>* LinqPad C# script to get detail of your own identity in AD:<br />
<br />
<code><br />
// using System.DirectoryServices;<br />
// using System.DirectoryServices.AccountManagement;<br />
using(PrincipalContext ctx = new PrincipalContext(ContextType.Domain, "apac"))<br />
using(UserPrincipal usr = UserPrincipal.FindByIdentity(ctx, IdentityType.SamAccountName, "kurzejar"))<br />
usr.Dump();<br />
</code><br />
<br />
<br />
<br />
* LinqPad C# script to get all users and groups in active directory AD:<br />
<br />
<code><br />
//using System.DirectoryServices;<br />
//using System.DirectoryServices.AccountManagement;<br />
void Main()<br />
{<br />
// const string adSearchContainer = "DC=apac,DC=birchmangroup,DC=com,DC=au";<br />
const string adSearchContainer = "DC=mrwa,DC=wa,DC=gov,DC=au";<br />
<br />
var users = FetchAllUsersFromActiveDirectory(adSearchContainer);<br />
var groups = FetchAllGroupsFromActiveDirectory(adSearchContainer);<br />
users.Dump("Users", true); // to datagrid<br />
groups.Dump("Groups", true); // to datagrid<br />
<br />
}<br />
// Define other methods and classes here<br />
public class User<br />
{<br />
public string Name { get; set; }<br />
public string Login { get; set; }<br />
public string DistinguishedName { get; set; }<br />
}<br />
private static IEnumerable<User> FetchAllUsersFromActiveDirectory(string searchContainer) {<br />
return FetchAllFromActiveDirectory(searchContainer, "(&ObjectCategory=user)");<br />
}<br />
private static IEnumerable<User> FetchAllGroupsFromActiveDirectory(string searchContainer) {<br />
return FetchAllFromActiveDirectory(searchContainer, "(&objectClass=group)");<br />
}<br />
private static IEnumerable<User> FetchAllFromActiveDirectory(string searchContainer, string directorySearcherFilter)<br />
{<br />
try<br />
{<br />
List<User> result = new List<User>();<br />
//using (DirectoryEntry searchRoot = new DirectoryEntry()) // Search from root of current domain<br />
using (DirectoryEntry searchRoot = new DirectoryEntry("LDAP://" + searchContainer))<br />
{<br />
DirectorySearcher ser = new DirectorySearcher(searchRoot)<br />
{<br />
// Filter = "(&ObjectCategory=user)",<br />
// Filter = "(&objectClass=group)",<br />
Filter = directorySearcherFilter,<br />
ReferralChasing = ReferralChasingOption.All,<br />
PageSize = 1000,<br />
};<br />
ser.PropertiesToLoad.Add("Name");<br />
ser.PropertiesToLoad.Add("distinguishedName");<br />
ser.PropertiesToLoad.Add("sAMAccountName");<br />
//ser.PropertiesToLoad.Add("mail");<br />
//ser.PropertiesToLoad.Add("description");<br />
using (SearchResultCollection searchResults = ser.FindAll())<br />
{<br />
int count = searchResults.Count;<br />
for (int i = 0; i < count; i++)<br />
{<br />
SearchResult searchResult = searchResults[i];<br />
string name = GetSearchResultProperty(searchResult, "Name");<br />
string distinguishedName = GetSearchResultProperty(searchResult, "distinguishedName");<br />
string samAccount = GetSearchResultProperty(searchResult, "sAMAccountName");<br />
//var email = GetSearchResultProperty(searchResult, "mail");<br />
//var description = GetSearchResultProperty(searchResult, "description");<br />
result.Add(new User<br />
{<br />
Name = name,<br />
Login = samAccount,<br />
DistinguishedName = distinguishedName,<br />
//Email = email, <br />
//Role = description<br />
});<br />
}<br />
}<br />
ser.Dispose();<br />
}<br />
return result;<br />
}<br />
catch (Exception ex)<br />
{<br />
string message = string.Format("FetchAllUsersFromActiveDirectory() failed");<br />
// Log.Error(message, ex);<br />
throw;<br />
}<br />
}<br />
private static string GetSearchResultProperty(SearchResult result, string name)<br />
{<br />
if (result.Properties.Contains(name))<br />
{<br />
var propertyCollection = result.Properties[name];<br />
if (propertyCollection.Count == 1 && propertyCollection[0] != null)<br />
{<br />
return propertyCollection[0].ToString();<br />
}<br />
}<br />
return string.Empty;<br />
}<br />
</code></div>
Rkdrm
http://w.rkdrm.com/index.php?title=Active_Directory&diff=913
Active Directory
2014-12-03T06:08:30Z
<p>Rkdrm: </p>
<hr />
<div>* LinqPad C# script to get detail of your own identity in AD:<br />
<br />
<code><br />
// using System.DirectoryServices;<br />
// using System.DirectoryServices.AccountManagement;<br />
using(PrincipalContext ctx = new PrincipalContext(ContextType.Domain, "apac"))<br />
using(UserPrincipal usr = UserPrincipal.FindByIdentity(ctx, IdentityType.SamAccountName, "kurzejar"))<br />
usr.Dump();<br />
</code><br />
<br />
<br />
<br />
* LinqPad C# script to get all users in active directory AD:<br />
<br />
<code><br />
//using System.DirectoryServices;<br />
//using System.DirectoryServices.AccountManagement;<br />
void Main()<br />
{<br />
const string allAdUsersSearchContainer = "OU=UsersMarch 2005,OU=Users,OU=Beacon,DC=beacon,DC=com,DC=au";<br />
var users = FetchAllUsersFromActiveDirectory(allAdUsersSearchContainer);<br />
users.Dump();<br />
}<br />
// Define other methods and classes here<br />
public class User<br />
{<br />
public string Name { get; set; }<br />
public string Login { get; set; }<br />
public string DistinguishedName { get; set; }<br />
}<br />
private static IEnumerable<User> FetchAllUsersFromActiveDirectory(string allUsersSearchContainer)<br />
{<br />
try<br />
{<br />
List<User> result = new List<User>();<br />
//using (DirectoryEntry searchRoot = new DirectoryEntry()) // Search from root of current domain<br />
using (DirectoryEntry searchRoot = new DirectoryEntry("LDAP://" + allUsersSearchContainer))<br />
{<br />
DirectorySearcher ser = new DirectorySearcher(searchRoot)<br />
{<br />
Filter = "(&ObjectCategory=user)",<br />
ReferralChasing = ReferralChasingOption.All,<br />
PageSize = 1000,<br />
};<br />
ser.PropertiesToLoad.Add("Name");<br />
ser.PropertiesToLoad.Add("distinguishedName");<br />
ser.PropertiesToLoad.Add("sAMAccountName");<br />
//ser.PropertiesToLoad.Add("mail");<br />
//ser.PropertiesToLoad.Add("description");<br />
using (SearchResultCollection searchResults = ser.FindAll())<br />
{<br />
int count = searchResults.Count;<br />
for (int i = 0; i < count; i++)<br />
{<br />
SearchResult searchResult = searchResults[i];<br />
string name = GetSearchResultProperty(searchResult, "Name");<br />
string distinguishedName = GetSearchResultProperty(searchResult, "distinguishedName");<br />
string samAccount = GetSearchResultProperty(searchResult, "sAMAccountName");<br />
//var email = GetSearchResultProperty(searchResult, "mail");<br />
//var description = GetSearchResultProperty(searchResult, "description");<br />
result.Add(new User<br />
{<br />
Name = name,<br />
Login = samAccount,<br />
DistinguishedName = distinguishedName,<br />
//Email = email, <br />
//Role = description<br />
});<br />
}<br />
}<br />
}<br />
return result;<br />
}<br />
catch (Exception ex)<br />
{<br />
string message = string.Format("FetchAllUsersFromActiveDirectory() failed");<br />
// Log.Error(message, ex);<br />
throw;<br />
}<br />
}<br />
private static string GetSearchResultProperty(SearchResult result, string name)<br />
{<br />
if (result.Properties.Contains(name))<br />
{<br />
var propertyCollection = result.Properties[name];<br />
if (propertyCollection.Count == 1 && propertyCollection[0] != null)<br />
{<br />
return propertyCollection[0].ToString();<br />
}<br />
}<br />
return string.Empty;<br />
}<br />
</code></div>
Rkdrm
http://w.rkdrm.com/index.php?title=Active_Directory&diff=912
Active Directory
2014-12-03T01:23:55Z
<p>Rkdrm: </p>
<hr />
<div>* LinqPad C# script to get detail of your won identity in AD:<br />
<br />
<code><br />
// using System.DirectoryServices;<br />
// using System.DirectoryServices.AccountManagement;<br />
using(PrincipalContext ctx = new PrincipalContext(ContextType.Domain, "apac"))<br />
using(UserPrincipal usr = UserPrincipal.FindByIdentity(ctx, IdentityType.SamAccountName, "kurzejar"))<br />
usr.Dump();<br />
</code><br />
<br />
<br />
<br />
* LinqPad C# script to get all users in active directory AD:<br />
<br />
<code><br />
//using System.DirectoryServices;<br />
//using System.DirectoryServices.AccountManagement;<br />
void Main()<br />
{<br />
const string allAdUsersSearchContainer = "OU=UsersMarch 2005,OU=Users,OU=Beacon,DC=beacon,DC=com,DC=au";<br />
var users = FetchAllUsersFromActiveDirectory(allAdUsersSearchContainer);<br />
users.Dump();<br />
}<br />
// Define other methods and classes here<br />
public class User<br />
{<br />
public string Name { get; set; }<br />
public string Login { get; set; }<br />
public string DistinguishedName { get; set; }<br />
}<br />
private static IEnumerable<User> FetchAllUsersFromActiveDirectory(string allUsersSearchContainer)<br />
{<br />
try<br />
{<br />
List<User> result = new List<User>();<br />
//using (DirectoryEntry searchRoot = new DirectoryEntry()) // Search from root of current domain<br />
using (DirectoryEntry searchRoot = new DirectoryEntry("LDAP://" + allUsersSearchContainer))<br />
{<br />
DirectorySearcher ser = new DirectorySearcher(searchRoot)<br />
{<br />
Filter = "(&ObjectCategory=user)",<br />
ReferralChasing = ReferralChasingOption.All<br />
};<br />
ser.PropertiesToLoad.Add("Name");<br />
ser.PropertiesToLoad.Add("distinguishedName");<br />
ser.PropertiesToLoad.Add("sAMAccountName");<br />
//ser.PropertiesToLoad.Add("mail");<br />
//ser.PropertiesToLoad.Add("description");<br />
using (SearchResultCollection searchResults = ser.FindAll())<br />
{<br />
int count = searchResults.Count;<br />
for (int i = 0; i < count; i++)<br />
{<br />
SearchResult searchResult = searchResults[i];<br />
string name = GetSearchResultProperty(searchResult, "Name");<br />
string distinguishedName = GetSearchResultProperty(searchResult, "distinguishedName");<br />
string samAccount = GetSearchResultProperty(searchResult, "sAMAccountName");<br />
//var email = GetSearchResultProperty(searchResult, "mail");<br />
//var description = GetSearchResultProperty(searchResult, "description");<br />
result.Add(new User<br />
{<br />
Name = name,<br />
Login = samAccount,<br />
DistinguishedName = distinguishedName,<br />
//Email = email, <br />
//Role = description<br />
});<br />
}<br />
}<br />
}<br />
return result;<br />
}<br />
catch (Exception ex)<br />
{<br />
string message = string.Format("FetchAllUsersFromActiveDirectory() failed");<br />
// Log.Error(message, ex);<br />
throw;<br />
}<br />
}<br />
private static string GetSearchResultProperty(SearchResult result, string name)<br />
{<br />
if (result.Properties.Contains(name))<br />
{<br />
var propertyCollection = result.Properties[name];<br />
if (propertyCollection.Count == 1 && propertyCollection[0] != null)<br />
{<br />
return propertyCollection[0].ToString();<br />
}<br />
}<br />
return string.Empty;<br />
}<br />
</code></div>
Rkdrm
http://w.rkdrm.com/index.php?title=Active_Directory&diff=911
Active Directory
2014-12-02T05:14:43Z
<p>Rkdrm: </p>
<hr />
<div>LinqPad C# script to get all users in active directory AD:<br />
<br />
<code><br />
//using System.DirectoryServices;<br />
//using System.DirectoryServices.AccountManagement;<br />
void Main()<br />
{<br />
const string allAdUsersSearchContainer = "OU=UsersMarch 2005,OU=Users,OU=Beacon,DC=beacon,DC=com,DC=au";<br />
var users = FetchAllUsersFromActiveDirectory(allAdUsersSearchContainer);<br />
users.Dump();<br />
}<br />
// Define other methods and classes here<br />
public class User<br />
{<br />
public string Name { get; set; }<br />
public string Login { get; set; }<br />
public string DistinguishedName { get; set; }<br />
}<br />
private static IEnumerable<User> FetchAllUsersFromActiveDirectory(string allUsersSearchContainer)<br />
{<br />
try<br />
{<br />
List<User> result = new List<User>();<br />
//using (DirectoryEntry searchRoot = new DirectoryEntry()) // Search from root of current domain<br />
using (DirectoryEntry searchRoot = new DirectoryEntry("LDAP://" + allUsersSearchContainer))<br />
{<br />
DirectorySearcher ser = new DirectorySearcher(searchRoot)<br />
{<br />
Filter = "(&ObjectCategory=user)",<br />
ReferralChasing = ReferralChasingOption.All<br />
};<br />
ser.PropertiesToLoad.Add("Name");<br />
ser.PropertiesToLoad.Add("distinguishedName");<br />
ser.PropertiesToLoad.Add("sAMAccountName");<br />
//ser.PropertiesToLoad.Add("mail");<br />
//ser.PropertiesToLoad.Add("description");<br />
using (SearchResultCollection searchResults = ser.FindAll())<br />
{<br />
int count = searchResults.Count;<br />
for (int i = 0; i < count; i++)<br />
{<br />
SearchResult searchResult = searchResults[i];<br />
string name = GetSearchResultProperty(searchResult, "Name");<br />
string distinguishedName = GetSearchResultProperty(searchResult, "distinguishedName");<br />
string samAccount = GetSearchResultProperty(searchResult, "sAMAccountName");<br />
//var email = GetSearchResultProperty(searchResult, "mail");<br />
//var description = GetSearchResultProperty(searchResult, "description");<br />
result.Add(new User<br />
{<br />
Name = name,<br />
Login = samAccount,<br />
DistinguishedName = distinguishedName,<br />
//Email = email, <br />
//Role = description<br />
});<br />
}<br />
}<br />
}<br />
return result;<br />
}<br />
catch (Exception ex)<br />
{<br />
string message = string.Format("FetchAllUsersFromActiveDirectory() failed");<br />
// Log.Error(message, ex);<br />
throw;<br />
}<br />
}<br />
private static string GetSearchResultProperty(SearchResult result, string name)<br />
{<br />
if (result.Properties.Contains(name))<br />
{<br />
var propertyCollection = result.Properties[name];<br />
if (propertyCollection.Count == 1 && propertyCollection[0] != null)<br />
{<br />
return propertyCollection[0].ToString();<br />
}<br />
}<br />
return string.Empty;<br />
}<br />
</code></div>
Rkdrm
http://w.rkdrm.com/index.php?title=Active_Directory&diff=910
Active Directory
2014-12-02T05:02:41Z
<p>Rkdrm: </p>
<hr />
<div>LinqPad script to get all users in active directory AD:<br />
<br />
<code><br />
//using System.DirectoryServices;<br />
//using System.DirectoryServices.AccountManagement;<br />
void Main()<br />
{<br />
const string allAdUsersSearchContainer = "OU=UsersMarch 2005,OU=Users,OU=Beacon,DC=beacon,DC=com,DC=au";<br />
var users = FetchAllUsersFromActiveDirectory(allAdUsersSearchContainer);<br />
users.Dump();<br />
}<br />
// Define other methods and classes here<br />
public class User<br />
{<br />
public string Name { get; set; }<br />
public string Login { get; set; }<br />
public string DistinguishedName { get; set; }<br />
}<br />
private static IEnumerable<User> FetchAllUsersFromActiveDirectory(string allUsersSearchContainer)<br />
{<br />
try<br />
{<br />
List<User> result = new List<User>();<br />
//using (DirectoryEntry searchRoot = new DirectoryEntry()) // Search from root of current domain<br />
using (DirectoryEntry searchRoot = new DirectoryEntry("LDAP://" + allUsersSearchContainer))<br />
{<br />
DirectorySearcher ser = new DirectorySearcher(searchRoot)<br />
{<br />
Filter = "(&ObjectCategory=user)",<br />
ReferralChasing = ReferralChasingOption.All<br />
};<br />
ser.PropertiesToLoad.Add("Name");<br />
ser.PropertiesToLoad.Add("distinguishedName");<br />
ser.PropertiesToLoad.Add("sAMAccountName");<br />
//ser.PropertiesToLoad.Add("mail");<br />
//ser.PropertiesToLoad.Add("description");<br />
using (SearchResultCollection searchResults = ser.FindAll())<br />
{<br />
int count = searchResults.Count;<br />
for (int i = 0; i < count; i++)<br />
{<br />
SearchResult searchResult = searchResults[i];<br />
string name = GetSearchResultProperty(searchResult, "Name");<br />
string distinguishedName = GetSearchResultProperty(searchResult, "distinguishedName");<br />
string samAccount = GetSearchResultProperty(searchResult, "sAMAccountName");<br />
//var email = GetSearchResultProperty(searchResult, "mail");<br />
//var description = GetSearchResultProperty(searchResult, "description");<br />
result.Add(new User<br />
{<br />
Name = name,<br />
Login = samAccount,<br />
DistinguishedName = distinguishedName,<br />
//Email = email, <br />
//Role = description<br />
});<br />
}<br />
}<br />
}<br />
return result;<br />
}<br />
catch (Exception ex)<br />
{<br />
string message = string.Format("FetchAllUsersFromActiveDirectory() failed");<br />
// Log.Error(message, ex);<br />
throw;<br />
}<br />
}<br />
private static string GetSearchResultProperty(SearchResult result, string name)<br />
{<br />
if (result.Properties.Contains(name))<br />
{<br />
var propertyCollection = result.Properties[name];<br />
if (propertyCollection.Count == 1 && propertyCollection[0] != null)<br />
{<br />
return propertyCollection[0].ToString();<br />
}<br />
}<br />
return string.Empty;<br />
}<br />
</code></div>
Rkdrm
http://w.rkdrm.com/index.php?title=Active_Directory&diff=909
Active Directory
2014-12-02T05:02:00Z
<p>Rkdrm: Created page with "LinqPad script to get all users in active directory AD: <code> //using System.DirectoryServices; //using System.DirectoryServices.AccountManagement; void Main() { co..."</p>
<hr />
<div>LinqPad script to get all users in active directory AD:<br />
<br />
<code><br />
//using System.DirectoryServices;<br />
//using System.DirectoryServices.AccountManagement;<br />
void Main()<br />
{<br />
const string allAdUsersSearchContainer = "OU=UsersMarch 2005,OU=Users,OU=Beacon,DC=beacon,DC=com,DC=au";<br />
var users = FetchAllUsersFromActiveDirectory(allAdUsersSearchContainer);<br />
users.Dump();<br />
}<br />
// Define other methods and classes here<br />
public class User<br />
{<br />
public string Name { get; set; }<br />
public string Login { get; set; }<br />
public string DistinguishedName { get; set; }<br />
}<br />
private static IEnumerable<User> FetchAllUsersFromActiveDirectory(string allUsersSearchContainer)<br />
{<br />
try<br />
{<br />
List<User> result = new List<User>();<br />
//using (DirectoryEntry searchRoot = new DirectoryEntry()) // Search from root of current domain<br />
using (DirectoryEntry searchRoot = new DirectoryEntry("LDAP://" + allUsersSearchContainer))<br />
{<br />
DirectorySearcher ser = new DirectorySearcher(searchRoot)<br />
{<br />
Filter = "(&ObjectCategory=user)",<br />
ReferralChasing = ReferralChasingOption.All<br />
};<br />
ser.PropertiesToLoad.Add("Name");<br />
ser.PropertiesToLoad.Add("distinguishedName");<br />
ser.PropertiesToLoad.Add("sAMAccountName");<br />
//ser.PropertiesToLoad.Add("mail");<br />
//ser.PropertiesToLoad.Add("description");<br />
using (SearchResultCollection searchResults = ser.FindAll())<br />
{<br />
int count = searchResults.Count;<br />
for (int i = 0; i < count; i++)<br />
{<br />
SearchResult searchResult = searchResults[i];<br />
string name = GetSearchResultProperty(searchResult, "Name");<br />
string distinguishedName = GetSearchResultProperty(searchResult, "distinguishedName");<br />
string samAccount = GetSearchResultProperty(searchResult, "sAMAccountName");<br />
//var email = GetSearchResultProperty(searchResult, "mail");<br />
//var description = GetSearchResultProperty(searchResult, "description");<br />
result.Add(new User<br />
{<br />
Name = name,<br />
Login = samAccount,<br />
DistinguishedName = distinguishedName,<br />
//Email = email, <br />
//Role = description<br />
});<br />
}<br />
}<br />
}<br />
return result;<br />
}<br />
catch (Exception ex)<br />
{<br />
string message = string.Format("FetchAllUsersFromActiveDirectory() failed");<br />
// Log.Error(message, ex);<br />
throw;<br />
}<br />
}<br />
private static string GetSearchResultProperty(SearchResult result, string name)<br />
{<br />
if (result.Properties.Contains(name))<br />
{<br />
var propertyCollection = result.Properties[name];<br />
if (propertyCollection.Count == 1 && propertyCollection[0] != null)<br />
{<br />
return propertyCollection[0].ToString();<br />
}<br />
}<br />
return string.Empty;<br />
}<br />
</code></div>
Rkdrm
http://w.rkdrm.com/index.php?title=Software&diff=908
Software
2014-12-02T04:54:17Z
<p>Rkdrm: </p>
<hr />
<div>* [[Active Directory]]<br />
* [[OpenGL]]<br />
* [[SSL Certificates]]<br />
* ESRI<br />
** [[ESRI Silverlight & WPF]]<br />
* GIS<br />
** [http://deepearth.codeplex.com/ DeepEarth -CodePlex Silverlight control] - [http://deepearth.soulsolutions.com.au/nearmap/ Online Demo]<br />
** [http://www.openstreetmap.org/ OpenStreetMap.org]<br />
* [[Google Chrome]]<br />
* [[Log4net]]<br />
* [[Microsoft Windows]]<br />
* [[Windows Server 2008]]<br />
* [[Office 2007]]<br />
** [[OpenXML]]<br />
* [[MOSS 2007]]<br />
* [[SharePoint 2010]]<br />
* [[PerformancePoint 2010]]<br />
* [[InfoPath 2010]]<br />
* [[Microsoft Patterns & Practices]]<br />
** [[CAL]] (Composite Application Library)<br />
* [[DevExpress]]<br />
* [[Microsoft LINQ]]<br />
* [[Entity Framework 4]] (EF)<br />
* [[Microsoft Workflow Foundation]] (WF)<br />
* [[Windows Identity Foundation]] (WIF)<br />
* [[Windows Communication Foundation]] (WCF)<br />
* [[Windows Presentation Foundation]] (WPF)<br />
* [[Windows Management Instrumentation]] (WMI)<br />
* [[Microsoft Remote Desktop]] (RDP)<br />
* [[Windows Phone 7]] (WP7)<br />
* [[Silverlight]]<br />
** Silverlight Desktops:<br />
*** [https://www.wiki-os.org/ https://www.wiki-os.org/]<br />
*** [http://silveos.com/ http://silveos.com/]<br />
* [[.NET]]<br />
* [[.NET AOP]]<br />
* [[.NET & Memory Leaks]]<br />
* [[Oracle]]<br />
* [[Paint.Net]]<br />
* [[Physics Engines]]<br />
* [[Powershell]]<br />
* [[SMO]]<br />
* [[SQL Server]]<br />
* [[SQL Server Analysis Services]]<br />
* [[SQL Server Reporting Services]]<br />
* [[T4]]<br />
* [[Enterprise Architect]]<br />
* [[VS 2008]]<br />
* [[VS 2010]]<br />
** [[C#]]<br />
* [[Microsoft TFS2010]]<br />
<br />
* [[Resharper]]<br />
* [[Security]]<br />
<br />
Mobile<br />
* [[Mono / Xamarin]]<br />
<br />
Linux<br />
* [[Webmin]]<br />
* [[New Linux Disk]]<br />
<br />
Web<br />
* [[Which CMS]]<br />
* [http://arstechnica.com/web/news/2011/02/chrome-takes-10-usage-share-ie-continues-to-haemorrhage.ars Worldwide browser market share: January 2011 (ArsTechnica)]<br />
* [[HTML]]<br />
* [[HTTP]]<br />
* [[Javascript]]<br />
* [[IIS / Web Development]]<br />
* [[Web Video]]<br />
<br />
Standards<br />
* [[UPnP/DNLA]]<br />
<br />
Google<br />
* [[Google Maps]]<br />
<br />
Media Servers<br />
* [[MythTV]]<br />
* [[MediaTomb]]<br />
* [[MiniDLNA]]<br />
<br />
=== UsefulWare ===<br />
* [http://code.msdn.microsoft.com/AddInSpy AddInSpy - provides details of Office 2007 Addins]<br />
* [http://www.cpuid.com/ CPU-Z]<br />
* [[Flash Video Player]] (.flv player - VLC)<br />
* [http://www.getpaint.net/ Paint.Net]<br />
** [http://forums.getpaint.net/index.php?/topic/927-icon-cursor-and-animated-cursor-format-v37-may-2010/?s=ef9afdad1cb4967893e4e9bc1cd6473d .ico and .cur Paint.Net addin]<br />
* [http://ccollomb.free.fr/unlocker/ Unlocker - unlock locked Windows files]<br />
* [http://www.wingrep.com/index.htm Windows Grep]<br />
* [http://www.msfn.org/board/How-to-make-a-7-Zip-Switchless-Installer-t39048.html How to make a 7-Zip Switchless Installer]<br />
* [http://www.ltr-data.se/opencode.html/#ImDisk ImDisk RAMDisk virtual disk driver] Supports 32&64 bit incl Windows 7, GPL open source.<br />
<br />
=== Free Open Source Icons ===<br />
* [http://en.wikipedia.org/wiki/Nuvola Nuvola (Wikipedia)]<br />
* [http://en.wikipedia.org/wiki/Open_Clip_Art_Library Open Clipart Library (Wikipedia)]<br />
* [http://david.bellot.free.fr/svg-cards/ LGPL license playing cards, SVG format]<br />
* [http://www.iconarchive.com/ http://www.iconarchive.com/] - not sure about licensing<br />
<br />
=== Royalty-free Vectors ===<br />
* [http://www.vectorstock.com/free-vectors http://www.vectorstock.com/free-vectors]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=File:TVGuideBackup24Nov2014.zip&diff=907
File:TVGuideBackup24Nov2014.zip
2014-11-24T12:23:54Z
<p>Rkdrm: Backup of 24 Nov 2014. GetGuides will get guides from a server.</p>
<hr />
<div>Backup of 24 Nov 2014. GetGuides will get guides from a server.</div>
Rkdrm
http://w.rkdrm.com/index.php?title=TV_Guide&diff=906
TV Guide
2014-11-24T12:22:35Z
<p>Rkdrm: Created page with "* Media:TVGuideBackup24Nov2014.zip"</p>
<hr />
<div>* [[Media:TVGuideBackup24Nov2014.zip]]</div>
Rkdrm
http://w.rkdrm.com/index.php?title=Main_Page&diff=905
Main Page
2014-11-24T12:20:15Z
<p>Rkdrm: /* Backups */</p>
<hr />
<div>== '''Content''' ==<br />
* [[SMS Links]]<br />
* [[HowTo]]<br />
* [[Shopping List]]<br />
* [[Stereo Pair Images]]<br />
* [[Haiku]]<br />
* [[Architecture]]<br />
* [[Software]]<br />
* [[Hardware]]<br />
* [[XCode]]<br />
* [[Iguassu]]<br />
* [[Bread]]<br />
* [[Photos]]<br />
* [[Places]]<br />
<br />
<!-- * [http://maps.google.com.au/maps/ms?hl=en&ie=UTF8&msa=0&msid=109298058278878788801.000470f7be0dc41e24fec&ll=-33.447507,115.85915&spn=0.004069,0.008256&z=18 David & Denise's House] --><br />
* [http://www.how-to-draw-and-paint.com/learn-to-draw.html Learn to Draw]<br />
<br />
== '''Backups''' ==<br />
* [[TV Guide]]<br />
* [[Source Control]]<br />
* [[Map App]]<br />
* [[Workflow]]<br />
* [[Config]]<br />
* [[Upnp]]<br />
* [[WeatherBrowse]]<br />
* [[RestJsonExample]]<br />
* [[ArcGISPushpinDragNDrop]]<br />
* [[MumsFiles]]<br />
<br />
{{Help:Contents}}</div>
Rkdrm