Trebizond

Thoughts on Life, History, Classics, Computers, Games, and Debian Linux

Name:
Location: Massachusetts, United States

Monday, November 19, 2007

Har Har

Another important advantage that SQL Server 2005 Express has over MSDE is that it does not have the MSDE workload governor. The MSDE query governor is a widely misunderstood MSDE feature that was intended to limit the type of workloads that MSDE could be used for. The MSDE query governor throttles performance by stalling a user connection for a few milliseconds each time the connection requests a read or write operation on a database when there are more than eight concurrent connections.

Har Har :-)

Friday, November 16, 2007

Return an Active Directory (AD) User from SQL Server Query

select suser_sname()

and if it's just a SQL login:
select user_name()

Wednesday, November 14, 2007

It's a shell, which is Powerful

http://www.microsoft.com/windowsserver2003/technologies/management/powershell/download.mspx

How to find a User's OU in Powershell...

(1) Get Powershell on the machine
a. Open up Powershell
(2) Type in these commands:
a. $searcher=New-Object DirectoryServices.DirectorySearcher
b. $searcher.Filter="(&(objectcategory=person)(objectclass=user)(sAMAccountname=Dapostola))
c. $results=$searcher.FindOne()
d. $results.path
(3) You should see a display of the LDAP path.