| |   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
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: 452  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: 465  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: 1088  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: 554  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: 558  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: 525  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: 642  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: 538  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: 592  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: 524  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: 478  Category: Article    

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

Type: SQL  #Views: 446  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: 436  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: 431  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: 445  Category: Article    

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

Type: SQL  #Views: 536  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: 801  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: 1008  Category: Article    

Real Life SQL and .NET
Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be required for survival in today’s world of relational database and data management.

Type: SQL  #Views: 517  Category: Article    

SharpHSQL - An SQL engine written in C#
Presenting a high performance SQL engine ported to C# from Java.

Type: SQL  #Views: 758  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
Buy text ads here!
secure online backup
Color Laser Printer
Marc jacobs sunglasses
Skype vs. sipcall
VoIP Internettelefonie
Buy text ads here!

Interested in Text ads?
2,222 Total Members
35 members(last 30 days)
7 members(last 7 days)
1 members(today)

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

17,169 Total Blog Posts
1,748 Blogs(last 30 days)
251 Blogs(last 7 days)
0 Blogs(today)

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

13,786 Total Resources
5 Resources(last 30 days)
1 Resources(last 7 days)
0 Resources(today)


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