(Jack Vaughan) Despite SOAP and SOA inroads, the vaunted File Transfer Protocol (FTP) continues to flourish in organizations that – not surprisingly – need to transfer files. Finance and banking both represent FTP bastions – although both sectors are also on their way to becoming SOA strongholds of
Other News
Overview of the SSIS MOM
(Ke Yang) The namespace Microsoft.SqlServer.Management.IntegrationServices, contains a rich set of managed APIs that encapsulate most IS Server T-SQL APIs via ADO.NET commands. It’s not a mere T-SQL wrapper; it supports advanced features such as script generation, query via iterators, SQL Powershell
DB2 10 Temporal Tables Improving Performance Again
(Dave Beulke) While talking to friend of mine, I learned that DB2 10 Temporal Tables continue to be a big incentive to migrate as soon as possible to DB2 10 either from DB2 Version 9 or even DB2 Version 8.
Runtime Optimization Hints
(Troy Coleman) In writing about changes to SQL optimization hints, I neglected to note that there are actually two types of statement-level hints. I only covered access-level optimization hints last week. The other type of statement level optimization hint is to set the runtime options for a given S
Connecting to MySQL with Python
(Tony Darnell) Scripting Python to connect to a MySQL database is fairly simple, even if you don’t have any much experience with Python.
SQL Server Log Shipping For Large Databases
(Satnam Singh) Scenario: A couple of days back I was setting up a DR plan for one of our most mission critical DB servers which was hosting around 10 databases having size of 10, 23, 5, 7.4, 1.8, 6.2, 7.9, 5.53, 8.7 and 125 GB respectively.
Free Tools: ASP to Razor Converter
(Peter Vogel) Somehow, in the course of our June Toolapalooza feature (17 Free Tools for Visual Studio), I missed a bunch of freebies from Telerik. Telerik has made well over a dozen free tools available — I lost count — and they all look pretty cool.
Custom SharePoint List Forms
(Mark Nischalke) Out of the box Microsoft SharePoint has a very rich set of features but sometimes you need more, or something a little different, to meet the needs of your project. This article will discuss various methods of presenting the UI for SharePoint List forms, such as the New, Edit and D
The overriddenEndpointURI Property for JAX-RPC and JAX-WS Clients
(Wendy Raschke) The overriddendEndpointURI property provides flexibility to Web service client developers and administrators. The client does not need to be bound to the Web service endpoint URL given in the WSDL file.
Reader Response Null and MOD
Reader Response – Null and MOD Last time I introduced the topic of null from a different light. Usually, those opposed to the use of null, are approaching it from a perspective of “Why store nothing if nothing is what you really have.” I submitted a practical reason; if you allow null in your data, you are required to have […]