Tag Archives: SQL

New WID support limit in AD FS

Excellent news!  The number of supported federation service (FS) servers in a farm with a Windows Internal Database (WID) backend has increased from 5/10 to 30: A WID farm has a limit of 30 federation servers if you have 100 … Continue reading

Posted in AD FS, Uncategorized | Tagged , , , , , , | 4 Comments

Availability of Release Candidate Connectors for Forefront Identity Manager 2010 R2 (FIM)

More news!  Yesterday, Thursday 13th March 2014, Microsoft made two new Release Candidate Connectors available on connect.microsoft.com. Release Candidate of Generic SQL Connector The Generic SQL Connector will allow you to connect to any database where you have an ODBC … Continue reading

Posted in Connector, FIM, News | Tagged , , , , , , | 2 Comments

sp_executeSQL to the rescue

(a.k.a. my DEFAULT constraints aren’t working –NULL is being written to the DB.  Where are my default values?) I encountered a bug in a stored procedure I’d written that took me a little longer to fix than it should have … Continue reading

Posted in Off-topic, SQL Server, Troubleshooting | Tagged , , , , , , , , | Leave a comment

Invoking (running) SQL Server Agent Jobs using PowerShell

As I navigate the meandering thread of complexities that is the identity management project I inevitably find myself using SQL Server more and more.  Forgone is the text delimited management agent; embraced is the database management agent (specifically, SQL Server).  … Continue reading

Posted in Scripting, SQL Server | Tagged , , , , , , , , | 1 Comment

SQL Server aliases

(a.k.a. Honestly…My top Layer-8 issue of 2010) SQL Server aliases: they need to be created on all clients that use them, not just the SQL Server! How do we create them?  Two primary ways: CLICONFG.EXE (%systemroot%\system32\cliconfg).  Native to Windows, the … Continue reading

Posted in Scripting, SQL Server | Tagged , , , , , , , , , , | 4 Comments

Identifying updates/changes in database delta views with nullable columns

When working with database management agents such as the SQL Server or Oracle MAs there will come a time when you’ll need a delta view. Thus far I’ve been lucky and haven’t had many instances whereby I’ve had to use … Continue reading

Posted in FIM, SQL Server, Troubleshooting | Tagged , , , , , , | 1 Comment

Dropping and recreating the destination table in an SSIS package

As a follow up to my previous post on how one goes about importing data from a flat file data source into a SQL table and being able to have some control over the name of target table it is … Continue reading

Posted in SQL Server | Tagged , , , , , | Leave a comment