(Svetoslav Marinov) I assume that you have configured correctly MS SQL Server 2005 to accept remote connections so we start our short tutorial.
Author: SSWUG Research
XSD Tutorial – Part 1 of 5 – Elements and Attributes
(Simon Sprott) First lets look at what an XML schema is. A schema formally describes what a given XML document contains, in the same way a database schema describes the data that can be contained in a database (table structure, data types). An XML schema describes the coarse shape of the XML documen
Take the control of TIME Part1 (Introduction to Date/Time)
(Coskan Gundogar) In todays world data is controlled by time and if you don’t know how to control the time, you can’t have enough control over your data. Thanks Larry Ellison and his employees for building Oracle with powerful time manipulating functions and datatypes which you have to know to admin
Ruby on Rails and XML
(Daniel Wintschel) You’ve very likely heard of Ruby on Rails. Maybe you’ve actually used it; perhaps it is your new programming mistress. Whatever the case, it looks like Rails is here to stay, and to everyone’s benefit. Ruby plays very nicely with XML — read further for the details. (R)
Quickly find foreign-keys depended tables
(David) Today I needed a quick way to find out all of the tables foreign keys are referencing for a given table. That is, if I have a table named TABLE1 which has a few foreign keys defined on it, I want a list of all the tables these foreign keys are referencing.
Construct your .NET application with MSBuild
(Tony Patton) The arrival of the .NET Framework 2.0 introduced many features, including the new build process driven by the Microsoft Build Engine (MSBuild). This article offers an overview of the tool, along with basic examples.
Partitioned Tables in SQL Server 2005
(Nigel Rivett) Partitioned tables are a new feature available in SQL Server version 2005, aimed mainly at improving the performance of large database systems. The feature is only available for enterprise and developer edition. For other editions you can get a similar functionality with a partitioned
Q&A: Writing stored procedures in SQL Server 2005
(Serdar Yegulalp) In SQL Server 2000, there was really only one way to create a stored procedure: as a T-SQL statement. That was the course to take in every previous edition of SQL Server. But SQL Server 2005 makes it possible to write stored procedures (and functions, triggers and a number of other
Cache invalidation in Oracle Applications
(Sam) With the extended usage of Self Service Web Applications(SSWA) in Oracle Applications, the mechanism of cache invalidation assumes significant importance. In the process of supporting Oracle Application i am sure most of you would have already come across the cache invalidation mechanism and p
CodeSnip: Taming the Page Flash Beast in ASP.NET 2.0
(Shaun Eutsey) Since SmartPageNavigation has gone to the wayside, there has been no real, non-AJAX way of eliminating the flash when a postback occurs. This code snippet will explain how to eliminate the page flash without using AJAX.