#SQL

  • Wanted: Up and coming Cyber Security Professionals

    Cyber Security — Identity Management Implementer Secure your identities against the dangers of the Cyber World, automate the repetitive, and empower your users! Let’s Shut the front door on the most obvious  vector for Cyber-attacks Reduce the IT department’s compliance burden (SOX, HIPAA, FERPA, GLBA, ISO etc). Free IT people to do tasks that require […]

    Read More
  • MIM Open Source Schedulers

    Your MIM installation is in, the config is done, programming all set and now to automate the running of the Management Agents. Options? Most people use Windows Task Scheduler with a PowerShell script or VBScript — which works but can get cumbersome to maintain. With my SQL Server background, I often use SQL Server Agent […]

    Read More
  • MIM Join and spaces

    Working on a customer’s lab and look what I found. They had created (through some other process) two user accounts for the same user, and the samAccountName was nearly identical, just a space, ascii 32, appended to the end of one of the samAccountNames differentiates the two. Apparently, AD allows this. The account with the space […]

    Read More
  • SQL Server Management Studio SQL 2016

    So I went to install SQL 2016 on a server (been using it for a while, I get vm’s on CloudShare where SQL is preinstallled, so first time installing it for myself) — no problem. Hey, where is SQL Management Studio (SSMS)? Well it isn’t include in the 2.6  GB SQL Server ISO. You have […]

    Read More
  • Speaking at SQL Saturday Tomorrow

    As most of you know I am regarded as one of the SQL gurus among the Microsoft Identity Management Gurus. For years, in my book and in speaking I have been recommending Ola Hallengren’s SQL Maintenance Solution to help take care of your ILM/FIM/MIM databases. But the SQL Maintenance Plan Wizard has come a long way. […]

    Read More
  • How many attributes can you have in the Metaverse?

    Back in 2013 I published 5 posts about the Secrets of the Metaverse: The third post was about how many attributes you can have in the Metaverse in which I said that the mms_metaverse_lineageguid table limits us to 502 single valued non-reference attributes in the Metaverse. This is still correct but a client told me of […]

    Read More
  • SQL Maintenance for FIM and anything other databases

    An easy way to take care for your FIM databases is to “use Ola Hallengren’s script (http://ola.hallengren.com/scripts/MaintenanceSolution.sql). Download the script, adjust the backup paths and run the script on each instance of SQL Server. It will automatically create several jobs some for maintaining the system databases and some for maintain the user databases. You will need […]

    Read More
  • Mailbag: Learning FIM, SQL and IIS

    Recently, a reader reached out to me for advice on learning FIM, SQL and IIS. As well as guidance on setting up a lab (more advice on that part in a later post). First think for a moment about your best learning styles for technology. Do you need to read the concepts and architecture first […]

    Read More
  • FIM Reporting Craig Martin style

    Craig’s session is on how to get data out from the FIM Service and FIM Sync with PowerShell and displaying it with SSRS, which he has dubbed Scissors! Ok Craig we get it! You have even persuaded me that PowerShell is important! I have started writing scripts. SQL Server of course is still important. Key […]

    Read More
  • FIM DB Sizing Calculator

    FIM has two databases (well three if we count the FIM Certificate Management service): FIMService FIMSynchronizationService Here is a calculator in excel that you can download and use to calculate how big to make your databases. In my experience the FIMService database size depends mostly on how many request objects are in the database. The […]

    Read More
  • Page 1 of 2