Ran in to a project today where I had to revisit the old LDAP query.

ADUC Advanced Custom Search Results

Here are some useful links:

LDAP Query Basics


· Doing a Search Using Active Directory Users and Computers

Search Filter Syntax

Famous LDAP Filters for Active Directory Environments


How to search and find user accounts in Active Directory


Using Ldp.exe to Find Data in the Active Directory


How to Create Custom Active Directory LDAP Searches




How Can I Get a List of All the Users Whose Passwords Never Expire with PowerShell?


LDAP/AD Claims Provider For SharePoint 2013


Tags: | Categories: Database | Tips and tricks

The SharePoint Config log DB can grow quite large!

The following way can help you shrink the config databases. But do only use these in test or development enviroments!

SharePoint 2010 on SQL 2008 R2

  1. Right click on you DB -> Properties
  2. Select Options
  3. Change the Recovery Model to SIMPLE and Click Ok
Once that is done ,
-Right click on DB -> Tasks - > Shrink -> Files
- In File type select log and click OK
Note : Simple recovery model is not suggested for Production Systems

SharePoint 2007 on SQL 2005

Make two new Queries

USE [SharePoint_Config]

DBCC SHRINKFILE (N’SharePoint_Config_log’ , 50)

Tags: , , | Categories: Database | SharePoint Development
To create the asp.net membership database, please follow the steps below.
  1. Find the setup file aspnet_regsql.exe located at either of the following locations depending upon your OS:
  2. When the ASP.NET SQL Server Setup Wizard appears, select “Configure SQL Server for application services”, then click Next
  3. Enter the SQL Server and Database name.
  4. Click Next and Finish

  To run the command line version of aspnet_regsql.exe, you need to open a command prompt and run this command, which will create the proper database tables for the membership database.
-- To use SQL Server credentials (a UserID and Password), use:

aspnet_regsql.exe -S <server> -U <login id> -P <password> -d <database> -A all
Tags: , , | Categories: Database | Tips and tricks | Web development