Posts

Showing posts from July, 2012

ADFS and AD User Name Changes

Image
One of our users was recently married, and had her name changed. Two days later she opened a helpdesk ticket indicating one of our claims aware applications denied her access to it's resources. After enabling ADFS debug logging, I discovered that the server was still referencing her old user name . After a few minutes of Googling, I found this article that points to a MS KB article outlining the use of LSA caching user SID's, creating my problem. A quick Powershell script keeps this from happening again after creating the registry key noted in the KB article: $RegKey="HKLM:\System\CurrentControlSet\Control\Lsa" Set-ItemProperty -path $RegKey -name LsaLookupCacheMaxSize -value 0 Set-ItemProperty -path $RegKey -name LsaLookupCacheMaxSize -value 128

Easy CSV import into Oracle

Image
English: The logo of Oracle Corporation de:Bild:Oracle-Logo.svg he:תמונה:Oracle Logo.jpg (Photo credit: Wikipedia ) The easiest way I've found to import text data sources into Oracle have been using the Microsoft SQL Server Import and Export Wizard that comes with Standard, Enterprise or Developer editions of MS SQL Server. Assuming you've got the Oracle database drivers installed, just right click a database from within SQL Server Management Studio, choose Tasks -> Import Data. As your datasource, choose your CSV or text file . After you've configured the specifics of your data source, you'll need to choose a destination. Choose the OLE DB Provider for Oracle, then click Properties. Instead of using your Server Name, enter the database instance name and the credentials.  Click Text Connection to be sure it is correct, and click Allow saving password. Click OK. Click Next. In the next window, choose the destination table you've