(Bruno Zambetti) Google Earth (GE) provides a powerful 3D environment that you can use to provision your application with rich interactive 3D features. You can render points, lines or areas located at any point on earth—using either local, static, or positional data downloaded from the web. Your web
Tag: SharePoint / BI
Working with Time Spans and Durations in SQL Server
(Jeff Smith) What is the best way to return the “duration” of an event in SQL, given the start and end datetime values? How can we add up these durations to return grand totals? What data types should be used to return this data to our clients? How do we handle overflows, such as when hours go over
Security in Oracle ADF and Automatic Page Loading
(Andrejus Baranovskis) In enterprise applications, automatic page loading based on user role is used quite often. Automatic page load is done during user login phase. This means that when user with role A enters into system, page X will be opened for him. And in the same way, when user with role B e
Five common Ajax security challenges and how to address them
(Brian Eastwood) Ajax is not an application vulnerability per se. However, the programming model does make existing vulnerabilities more porous, and JavaScript-powered client-server interactions does enlarge the attack surface. (R)
Bloom Filters
(Greg Rahn) The other day I was reading the 11g Database VLDB and Partitioning Guide and came across the below execution plan for a partial partition-wise join between sales and customers.
Simulating Monolog Conversations with SQL Server 2005 Service Broker
(Vincent-Philippe Lauzon) SQL Server 2005 comes with a new service that is very useful for creating robust Enterprise applications: the Service Broker. Service Broker is useful to implement guaranteed and in-order delivery of messages between two services. This is modeled as a dialog between two ser
Index related DMVs and DMFs – sys.dm_db_index_usage_stats
(Dinesh Priyankara) Examining statistics of indexes is useful for optimizing the performance of queries. Statistics help us determine the usage and worth of indexes. There are many different methods to determine their usability; , which gives core statistics of indexes. The first article in the inde
Office Ribbon Customisation in Visual Studio 2008
(Daniel Moth) Explore Ribbon customisation. If you are a managed developer (e.g. Windows Forms) then you’ll find that you already have the skills for extending Microsoft Office applications with your code. Visual Studio 2008 makes it really easy and that is what I demonstrate in this 20′ video. (vi
Sharepoint Interview questions
(Murali Bejjanki) Adoption of the SharePoint platofrm is growing rapidly and for every new deployment there is a requirement for staff to support and maintain it. Identifying the necessary skills in potential new recruits for individuals who have not had sufficient experience with this relatively ne
Creating a Web service with VB.NET
(Irina Medvinskaya) Web services technology is based on HTTP, Simple Object Access Protocol (SOAP), and XML. Since Web services use open standards, calling Web services is fairly simple.