With the programming expertise of Xiyuan Shen and our good friend Ian Gilman, I set out to do something about this. I knew from having seen the awesome yet thoroughly creepy Phantom Limb (demo) that it was possible to inject a mouse-marker using a bookmarklet. This would allow us to run our code on almost any webpage, without the author having to include our script on their page. It could be injected on an as-needed basis by the presenter.
Every staging project has two elements: the ETL itself and a staging data structure. So today I’d like to talk about best practices for standing up a staging area using SQL Server Integration Services [ETL] and hosting a staging database in SQL Server 2012 [DB]. The ‘best practices’ are across three areas: Architecture, Development, and Implementation & Maintenance of the solution. Each area represents key patterns and practices (not a comprehensive list) for the ETL component and the data structure of the staging database.
And since I presume readers are looking for best practices silver bullets, that is what I will try to deliver. What you will not find in this post are turnkey ETL performance optimizations.
The Case of the Case-Sensitive CustomFilter Refiner: If you’re setting up FAST Search Server 2010 for SharePoint and need a custom date refiner, you’ll want to read about Tim Larson’s experience before you run into trouble. (Code Thug)
Code Samples from TechGate Conference: In case you attended Steve Michelotti’s Azure presentation at the TechGate conference in Reston last weekend, code samples can be found via his blog. (Steve Michelotti)
The client has a custom solution that they provide as a service: A master document (Microsoft Word) is split into section documents (also Word) by a project manager. Each section is assigned to a person to be modified in Word (the client also provides a Word plug-in for this modification). Once the sections are properly marked up, the master document is recreated from the sections. We were brought in to implement this solution in SharePoint 2010. Read More…
This office reflects the hard work and dedication of all the employees who have built this organization from the ground up, when we started out of a humble business center in January 2008. AIS India has built a successful and scalable business model of delivering high-quality solutions for our customers despite the challenges that arise from working in a global product development model.
(Click “Read More” to see photos of the AIS team enjoying their new digs!)
While developing the Rolling Stone and Vogue Archives, we needed a SSO system that could integrate our ASP.Net based archive with each provider’s existing authentication systems, primarily Apache-based web applications. Our solution was to develop a C# implementation of mod_auth_tkt cookie-and-token based authentication system, which we have since released open source.
As always, though, we’re looking forward. Just this week, AIS attained our fourth AND fifth gold competencies in the Microsoft partner program, in the areas of Business Intelligence and Application Integration.
This achievement is an important benchmark in the competitive world of Microsoft technology partners. Each gold competency requires five customer references, numerous developer exams and other objectives. Joining our other areas of competencies — Software Development, Web Development, Portals and Collaboration (and the sub-category of Cloud Accelerate) — BI and Application Integration give AIS a well-rounded portfolio of expertise and opens new opportunities in the partner channel, including advisory councils and boards within Microsoft.
According to AIS President Tom O’Connell, “This is a testament to the depth and breadth of our experiences. Even though Microsoft dramatically expanded the type and number of certifications and client references, we have quickly reached five gold competencies with our personnel and projects. We applaud Microsoft setting a higher bar so that we can differentiate ourselves.”
Congratulations to the entire AIS team and everyone who helped make these achievements and recognition possible!