(Morten Braten) Or how to expose PL/SQL packages as SOAP web services using pure PL/SQL
Other News
Monitor SQL Server Agent Jobs with Policy Based Management
(John Sterrett) I need to monitor all the SQL Agents to find out if a job failed in the last 24 hours. Could this be done with policy based management? If so, can you show me how to create the policy?
Internationalization in SQL Server
More, smaller databases? Manage your checklists, our featured blog of the week for business intelligence…Also, the hotmail outage and SQL Server, 3rd party tools and more. [Watch the Show] Special Fireside Version: SelecTViews – SQL Server 2011 upcoming features, SQL Server tip, recent news and more. [Watch the Show] Devin Knight on the show today talking about dynamic security inside […]
XSL Transformations 1.0
(kolliparachandra) XSL Transformations (XSLT) version 1.0 defines an XML-based programming language for transforming XML documents into other text formats.
Another use for ‘top N records per group’ query
(Shlomi Noach) A few days ago I published SQL: selecting top N records per group. It just dawned on me that the very same query solved another type of problem I was having a couple years ago.
Compiled Queries in LINQ
(Dhananjay Kumar) There may be scenario where we need to execute a particular query many times and repeatedly. LINQ allows us to make this task very easy by enabling us to create a query and make it compiled always. We call this type of query a compiled query.
IBM Cognos Proven Practices: IBM Cookbook for IBM Cognos 10 for use with SAP NetWeaver Business Warehouse
(Daniel Wagemann, Rich Borucki and Pierre Valiquette) This document is intended to provide a single point of reference for techniques and product behaviours when dealing with SAP NetWeaver Business Warehouse (SAP BW) as a data source in IBM Cognos 10.
How to move table containing LONG or LOB columns?
(Anand) Today a friend of mine asked me how to move a table having LONG datatype.As per him, when he fired alter table table_name move tablespace , he got “ORA-00997: illegal use of LONG datatype”.
Replication features in various editions of SQL Server 2005/2008
(Sateesh Yele) The following table lists the features in the Replication area and their presence/absence/limitation in each edition of SQL Server.
ASP.NET – Password Strength Indicator using jQuery and XML
(Bryian Tan) Last week, I had the opportunity to help implement and integrate a strong password policy to the legacy web application developed using ASP technology. The solution I proposed was to use jQuery to display the password strength meter to help users create strong password.