View Complete Post
Dynamic data-driven pages have become the basis of many cutting-edge Web sites. Early render systems can provide better performance and maintainability for data-driven Web sites by generating frequently accessed pages that contain less-volatile information ahead of time. We'll show you an example of a server-side solution that uses Extensible Stylesheet Language (XSL) to merge data and layout information into HTML that is compatible with just about any modern Web browser. Using these techniques to render Web pages early can reduce the load on your database back end and increase performance for your users.
MSDN Magazine April 2000
How do I join a SSIS text field type cast from the Derived Column Transformation Editor with a varchar from an SQL data table in a lookup?
Also, is there any reference on which SSIS data flow datatypes can be JOINed to SQL Server datatypes?
Here's the problem: I have records in a flat file. The flat file name contains the data of the records. When importing, I read the flat file name into a data field using SSIS. Then, I use FINDSTRING to create a derived column that
contains just the file date as YYYYMMDD.
There's a SQL Table that contains Currency Rates, indexed by currency code and date, in DD/MM/YYYY format, but it's stored as a VARCHAR
A.) I tried to convert the string, '07302010' into the following formats, without success:
However, none of these can understand the string '20100730' as a date!
B.) Furthermore, if i convert the field into a DTW_STR, it still doesn't match the varchar(50) in my db.
So, basically, despite using all available typecast date formats, and several string formats as well, I can't find a way to
A.) Parse text out of a field
B.) Convert that text to either a DATE format or a TEXT format
C.) Use that resulting field to
Hi, I am using a IIS 7.5 on Windows 7. I have a simple application that uses System.Net.WebRequest to POST data to another URL (in fact, the server side URL is on my local computer and it is hosted in IIS 7.5).
1. The problem is the server does not save data from client although on the client side codes when I debug and I see the OK message return from the code line
response.StatusDescription; // this has value of "OK"
2. How can I debug the server code side where to receive the request from client side who posts the data ?
The following is the codes for client who posts data using System.Net.WebRequest, and codes for server side who received posted data to save to database.
Client side codes: // also run on my local computer
public string PostIntegrationXml(XmlDocument xmlSubmitDoc)
Learn how to use the AtomPub protocol to pump up your blogs. Chris Sells includes a practical demonstration of mapping so you can expose a standard AtomPub service from a Web site and use Windows Live Writer to provide a rich editing experience against the service.
MSDN Magazine August 2010
New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.
MSDN Magazine February 2009
Here we explain how the new hierarchyID data type in SQL Server 2008 helps solve some of the problems in modeling and querying hierarchical information.
MSDN Magazine September 2008
Here the author introduces SQL Server Data Services, which exposes its functionality over standard Web service interfaces.
MSDN Magazine July 2008
SQL Server 2005 gathers a lot of useful data that you can use to identify areas where database performance can be improved. Here's what you need to improve performance.
MSDN Magazine January 2008
SQL Server Management Objects offer developers a robust toolset for backing up and restoring databases, and issuing DDL commands, as John Papa explains.
MSDN Magazine June 2007
Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.
MSDN Magazine February 2007