| |   Skin:   
      User: Not logged in 
Newsletter Signup
XSLT Library
Latest XML Blogs
Featured Examples
Featured Articles
Book Chapters
Training Courses
Sign In
My Profile
My Articles
My Examples
My Favorites
My Resources
Add a Resource
About Me
My Blog
HeadGeek Articles
Talking Portfolio
World Trip Pics

Prev Next
1 2
Learn SQL Tutorial
Free online SQL Book.

Type: SQL  #Views: 995  Category: Tutorial    

SQLfX® Beta Transparent Hierarchical XML Integration
Advanced Data Access Technologies, Inc. will be releasing its beta ANSI SQL Transparent Hierarchical XML middleware enabler beta product, SQLfX®, soon for testing. This ANSI SQL driven middleware product sits around your SQL processor and automatically enables it to transparently integrate with XML at a full nonlinear (multi-leg) hierarchical processing level. XML support in your SQL processor is not necessary. SQLfX® is ANSI SQL-92 standard, operates from input to output using principled nonlinear hierarchical processing, and outputs fully structured XML automatically. These are hierarchically accurate and ANSI SQL mathematically sound results. The user does not need to navigate the structure and needs no structure knowledge of the structures involved. With the XML integration operating transparently, the user does not need to know XML or require vendor XML training resulting in a very high ROI, and reduced risk and time to market. Hierarchical structures (XML and relational) can be hierarchical combined using a single simple ANSI SQL join operation. This and all XML operations are supported dynamically and nonprocedurally allowing for practical interactive operation further increasing SQLfX®'s usefulness and ROI. The relational mindset of the SQL industry has kept XML processing limited to linear single path processing that also requires navigation, visit our SQLfX® beta documentation now at to see actual examples of transparent, navigationless XML processing at a powerful nonlinear hierarchical level driven by a standard ANSI SQL processor.

Type: SQL  #Views: 1107  Category: Press Release    

SQL Tutorials - Herong's Tutorial Notes
This tutorial book is a collection of notes and sample codes written by the author while he was learning SQL himself. Topics include CREATE, cursor, data type, DATE, DBD, DBI, DELETE, deadlock, export, FETCH, HAVING, import, INDEX, INSERT, isolation, GROUP BY, language, load data, lock, mSQL, MySQL, online, ORDER BY, Perl, query, RDBMS, SELECT, SQL, SQL-92, TIME, stored procedure, TIMESTAMP, transaction, UPDATE, WHERE, Windows, XML.

Type: SQL  #Views: 1317  Category: Tutorial    

SQL Delta 3.1
SQL Delta is a great value, fast SQL database compare tool used to analyze, compare and synchronize database structures and data. SQL Delta compares all database objects including tables, views, stored procedures as well as permissions, user defined functions and so on. SQL Delta will script the differences between two databases allowing you to synchronize the two with the click of a button. SQL Delta can also perform a data compare between the two selected databases, comparing one or more tables at a time. The combination of schema and data compare allows you to synchronize an entire database at one time with one product. SQL Delta also reports on structures and data including differences and exports reports to HTML and PDF. Version 3.1 of SQL Delta offers the following new features and improvements; command line function, owner mapping, star view, projects, connection manager, snapshots and offline comparisons, database diagram copying, full text catalogues and support for case sensitive structure comparisons and data compare improvements. All new features and productivity improvements are based on customer feedback. The introduction of a command line function provides users with a mechanism for controlling SQL Delta by remote control, allowing databases to be compared and changes scripted without any user intervention. Version 3.1 now provides object ownership mapping. It is now possible to perfrom comparisons between databases with different users and different ownership configurations.

Type: SQL  #Views: 1561  Category: Website    

A Quick Introduction to SQL Server Management Objects (SMO)
Microsoft® SQL Server™ 2000 supports a COM-based object model, called SQL-DMO, which can be used to programmatically manage the SQL Servers. Enterprise Manager uses this API to manage SQL Server. SQL Server 2005 replaces SQL-DMO with two .NET based object libraries: SQL Server Management Objects (SMO) & Replication Management Objects (RMO). In this short tutorial, I'll show you how you can use SMO in your .NET applications.

Type: SQL  #Views: 3779  Category: Article    

SQL Server Yukon and CLR integration
Yukon, code name for the next version of SQL Server, will include several feature enhancements designed to make integration with the .NET Framework more efficient. One way this integration will be achieved is through the Common Language Runtime module.

Type: SQL  #Views: 2604  Category: Article    

Idera Releases SQL Management Suite
Idera today announced the general availability of its SQL Management Suite (SQLsuite™), a comprehensive solution that provides real-time performance monitoring and diagnostics, configuration and change management, Web-based administration and job management functions for Microsoft SQL Server.

Type: SQL  #Views: 1558  Category: Resource    

Reporting Strictly for Developers: Microsoft SQL Server Reporting Services
With the release of SQL Server Reporting Services, Microsoft finally makes a commitment to developer-centric reporting. They've integrated the design-time environment integration with Visual Studio and enabled report delivery through Web browsers, PDFs, Excel, and XML. Learn how to make this tool work for you.

Type: SQL  #Views: 2725  Category: Article    

SQL Server Express: An advanced glimpse at SQL Server 2005 or more?
As others (Tom, Kent) already have blogged about: SQL Server 2005 Express has been released. This is as close as you can get to the beta2 bits for SQL Server. Tom lists many of the included functionality (including the XML support, CLR integration and tool integration).

Type: SQL  #Views: 2791  Category: Tool    

Preventing SQL Injection Attacks
Keep your code secure against intruders. In this article we provide examples of SQL injection attacks and how you can write code to prevent them. Stop people from getting information from your database.

Type: SQL  #Views: 1519  Category: Article    

The AdventuresWorks of Yukon Jack: Schema Separation and the SQL Server 2005 Authorization Model
If you're not starting to get the idea that you and I have a ton of learning in our futures if we expect to be prepared to lead the charge to SQL Server 2005 me thinks you've likely been spending a little too much time out behind the shed with (the other) Yukon Jack. In case you didn't notice, Itzik Ben-Gan's SQL Server "Yukon" Beta 1 Transact-SQL Enhancements white paper in the MSDN Library claims to be a mere 68 pages in length even though it disclaims, "This paper does not cover every new Transact-SQL feature.". And on top of the T-SQL we have to get our brains around the wherefores and whys of managed .Net code within the SQL Sever 2005 memory space as potentially powerful additions to the T-SQL tool set for building stored procedures, functions, and User Defined Data Types, ADO.Net Data Sets, new administrative programmability powers with SMO and WMI, the intrinsic asynchronous message based interoperability of System Broker, a rich new world of XML integration in both the administrative depths and the development interoperability layers, a completely rewritten DTS and the emerging Reporting Services among the other exciting details of a dramatically evolved next generation BI Suite, web services that are truly part of the SQL Server architecture (That's right, IIS not required!), and even some giant and sweeping authorization model changes that are going to render much of our security models obsolete and profoundly vulnerable.

Type: SQL  #Views: 1600  Category: Article    

SQL Server Yukon - Next Generation Information Management System
“Yukon” is a proposed new 32 - bit version of Microsoft SQL Server aka, MS SQL 2000, which is not yet released from Microsoft, which may expect to be release in the year 2004. It contains a lot of additional tools which improves a rich scale of performance, reliability and ease of use for the information management system. Many tools in the old version of SQL Server such as Database Engine, Analysis Services, DTS, Database administration tools, XML support and ADO.NET, have been enhanced in a greater extend.

Type: SQL  #Views: 1488  Category: Article    

Kiss the Middle-tier Goodbye with SQL Server Yukon
Yukon's new XML support features cut out the middleman and allow you to deal with your data directly on the database tier. Learn how to use these features to improve your database app's performance and design.

Type: SQL  #Views: 1463  Category: Article    

Get Ready for Yukon
The next release of SQL Server promises increased developer productivity and reduced DBA workload.

Type: SQL  #Views: 2733  Category: Article    

Evolution of the SQL Server Data Access Model
Get an annotated overview of the data access layers available today that work with SQL Server, including ADO, the XML interface of SQL Server 2000 (SQLXML), ADO.NET, and the upcoming ADO.NET 2.0.

Type: SQL  #Views: 1405  Category: Article    

Delete Tips and Tricks
This week we're going to look at the last of the core SQL statements for changing data -- the DELETE statement. We'll also focus on some practical tips for implementing this most dangerous SQL statement in real-world applications.

Type: SQL  #Views: 1265  Category: TipsAndTricks    

SQL Server Connection Basics
SQL Server 2000 clients connect to SQL Server using a stack of APIs, object libraries, and protocols. Ken Henderson walks through each one and explains how they work and interoperate.

Type: SQL  #Views: 1425  Category: Article    

SQL Tips and Tricks
Sharpen your SQL skills with these tips and tricks.

Type: SQL  #Views: 2110  Category: TipsAndTricks    

A Few Tips About SQL Joins
First of all, let me apologize for being gone for a few days. Things have been hectic at work. We just demoed our new product and the demo went -great-. Today I thought I would write about the various kinds of joins available to programmers using SQL. It's a bit of a beginners blog, really. But an important one if you're not familiar with the details of how joins work.

Type: SQL  #Views: 3006  Category: TipsAndTricks    

Two Ways To Connect To SQL Server 2000 Via ASP
In this article I'm going to show you two different methods that you can use to connect to a Microsoft SQL Server 2000 database: System DSN's and the OLEDB connection string. I will explain the positives and negatives of each method, and I will also provide you with some examples to get you started.

Type: SQL  #Views: 2533  Category: Article    

Prev Next
1 2

Fans of "The Office"
Dwight Bobbleheads are here!
  “It's me! I'm the bobblehead! Yes!”

Advertise on XMLPitstop

Advertise on XMLPitstop

EggHead Cafe
Web Servicee development
it outsourcing
online fax service
UK conference call service
chicago web design
Registro de Dominios
Domain Names
Car News
Prada sunglasses
Video Surveillance
Exchange Hosting

4,136 Total Members
9 members(last 30 days)
1 members(last 7 days)
0 members(today)

1,948 Total Discussions
0 Posts(last 30 days)
0 Posts(last 7 days)
0 Posts(today)

47,487 Total Blog Posts
0 Blogs(last 30 days)
0 Blogs(last 7 days)
0 Blogs(today)

8,699 Newsgroup Posts
0 Posts(last 30 days)
0 Posts(last 7 days)
0 Posts(today)

14,139 Total Resources
1 Resources(last 30 days)
0 Resources(last 7 days)
0 Resources(today)


David Silverlight's| 2801 Florida Ave #225|Miami, FL 33133|Ph:305-447-1139