By Michael Otey – One of the most common mistakes in database and software design is thinking and testing too small. So think big to avoid unpleasant and unnecessary application rollout problems.
Hierarchies are sometimes difficult to store in SQL tables…things like trees, threaded forums, org charts and the like…and it’s usually even harder to retrieve the hierarchy once you do store it. Here’s a method that’s easy to understand and maintain, and gives you the full hierarchy (or any pie
By Eric Knorr – For conclusive evidence, look no further than the staid, slow-moving world of relational database management, which is embracing XML as its own.
By Nicholas Chase – XSLT style sheets allow you a great deal of freedom in manipulating the data in your original XML document. There are times, however, when you really want to do actual programming, and the XSLT recommendation is designed to allow that through the use of extensions. These extensio
By Thor Olavsrud – RSA Security (NASDAQ:RSAS), in an effort to clear the way for the widespread adoption of the Security Assertion Markup Language (SAML) specification, announced Monday that it will grant non-exclusive royalty-free license use of two of its patents to companies deploying application
by Bob DuCharme – XSLT is a language for manipulating XML documents, and XML documents are text. When you're manipulating text, functions for searching strings and pulling out substrings are indispensable for rearranging documents to create new documents. The XPath string functions incorporated
Yukon is the version of SQL Server that will bring .NET, the Common Language Runtime environment and XML much deeper into the plumbing of the database engine and build in considerable scale-up engineering. SQL Server 2000 had some native capability for importing XML documents and doing qu
Microsoft® ActiveX® Data Objects (ADO) is a data access interface used to communicate with OLE DB-compliant data sources, such as Microsoft SQL Server™ 2000. Data consumer applications can use ADO to connect to, retrieve, manipulate, and update data from an instance of SQL Server.
In this tutorial you are going to learn everything in detail step by step you’ll ever want to know about inserting binary data ( images, zip files etc ) into database. This is actually first of the three articles I am going to write on manipulating binary data in the database.
by Randy Dyess – This article is the second article in a series to share those stored procedures and methods I have learned with you, in order to help you document and learn a new environment if you move on, or obtain another project at your existing company.