Intelligentedu
Καλύτερη νέα ελεύθερη ΤΠ υπολογιστών που εκπαιδεύει τους διδακτικούς πόρους
Translate to EnglishÜbersetzen Sie zum Deutsch/GermanTraduzca al Español/SpanishTraduisez au Français/FrenchTraduca ad Italiano/ItalianTraduza ao Português/Portuguese日本語に翻訳しなさい /Japanese
한국어에게 번역하십시오/Korean中文翻译/Chinese Simplified中文翻译/Chinese Traditionalترجمة الى العربية/ArabicVertaal aan het Nederlands/DutchΜεταφράστε στα ελληνικά/GreekПереведите к русскому/Russian





Ρόλος Blog:


Κορυφαίες συνδέσεις:

6 Σεπτεμβρίου 2006

Κεντρικός υπολογιστής 2005 SQL τεχνικά άρθρα και δείγματα κώδικα

Για εκείνους σας που χρησιμοποιείτε τη Microsoft SQL ο κεντρικός υπολογιστής το 2005, είναι εδώ 63 τεχνικά άρθρα και σεμινάρια από τη Microsoft που θα σας βοηθήσει οργάνωση, θα χρησιμοποιήσει, και θα διαχειριστεί τον κεντρικό υπολογιστή SQL. Αυτά τα άρθρα καλύπτουν πολλούς τομείς της χρησιμοποίησης του κεντρικού υπολογιστή το 2005 SQL σε πληρέστερό του και θα σας διδάξουν τα χαρακτηριστικά γνωρίσματα και τις λειτουργίες του. Έχω περιλάβει επίσης κάτω από τις πληροφορίες για να λάβω μερικά άριστα δείγματα κώδικα για τον κεντρικό υπολογιστή το 2005 SQL.



63 κεντρικός υπολογιστής 2005 SQL τεχνικά άρθρα

» Προσθέστε τους αλγορίθμους ανάσυρσης δεδομένων συνήθειας στον κεντρικό υπολογιστή το 2005 SQL
» Αρχιτεκτονική επεξεργασίας υπηρεσιών 2005 ανάλυσης
» Αυτοματοποιήστε τη δοκιμή του αποθηκευμένου Procs σας
» Χτίζοντας μια εντοπισμένη έκθεση σχετικά με έναν κεντρικό υπολογιστή 2005 SQL πηγή στοιχείων κύβων υπηρεσιών ανάλυσης
» Οικοδόμηση των αξιόπιστων, ασύγχρονων εφαρμογών βάσεων δεδομένων που χρησιμοποιούν το μεσίτη υπηρεσιών
» Πρόσβαση στοιχείων που επισημαίνει στον κεντρικό υπολογιστή 2005 SQL
» Επέκταση στοιχείων: Βελτιώστε τη διαδικασία οργάνωσης βάσεων δεδομένων σας με έναν εφαρμοστή συνήθειας
» Λύσεις ολοκλήρωσης στοιχείων για την κύρια διαχείριση στοιχείων
» Ποιοτικές λύσεις στοιχείων
» Ασφάλεια στοιχείων: Επιθέσεις εγχύσεων στάσεων SQL προτού να σας σταματήσουν
» Υπηρεσίες μετασχηματισμού στοιχείων για SQL ερωτήσεις σχεδίου κεντρικών υπολογιστών 2005 τις συχνά
» Ανάπτυξη της ναυσιπλοΐας και Drilldown εκθέσεων
» Κώδικας πραγματοποιώ συναλλαγές-SQL έκδοσης στον κεντρικό υπολογιστή 2005 βήτα 2 SQL
» Enabling Drillthrough in Analysis Services 2005
» Express Editions: Get a Lean, Mean Dev Machine with the Express Editions of Visual Basic and SQL Server 2005
» An Introduction to SQL Server Service Broker
» Fuzzy Lookup and Fuzzy Grouping in Data Transformation Services for SQL Server 2005
» Hackers Beware: Keep Bad Guys at Bay with the Advanced Security Features in SQL Server 2005
» Handling Data Integrity Issues in Analysis Services 2005
» How to Implement an Automatic Sliding Window in a Partitioned Table on SQL 2005
» Integrating Reporting Services into Your Application
» Introduction to the Unified Dimensional Model (UDM)
» Introduction to MDX Scripting in Microsoft SQL Server 2005
» Introduction to SQL Server 2005 Data Mining
» Introduction to XQuery in SQL Server 2005
» Managed Data Access Inside SQL Server with ADO .NET and SQLCLR
» Many-to-Many Dimensions in Analysis Services 2005
» Migrating from Business Objects Crystal Reports to SQL Server 2005 Reporting Services
» Mine Your Business: AMO Lets You Dig Deeper into Your Data from Your Own Applications
» Monitoring Report Execution Performance with Execution Logs
» Multi-User Considerations in Data Synchronization for SQL Server 2005 Mobile Edition 3.0
» Multiple Active Result Sets (MARS) in SQL Server 2005
» Overview of the Analysis Services Development and Management Environments
» Overview of Native XML Web Services for Microsoft SQL Server 2005
» An Overview of SQL Server 2005 for the Database Developer
» Partitioned Tables and Indexes in SQL Server 2005
» Performance Optimizations for the XML Data Type in SQL Server 2005
» Processing XML Showplans Using SQLCLR in SQL Server 2005
» Reporting Services: Deliver SQL Server Reports To SharePoint To Enhance Team Collaboration
» Say What? Make Sense of Your Web Feedback using SQL Server 2005
» SQL Server 2005 Row Versioning-Based Transaction Isolation
» SQL Server 2005 Beta 2 Transact-SQL Enhancements
» SQL Server 2005 Full-Text Search: Internals and Enhancements
» SQL Server 2005: Fuzzy Lookups and Groupings Provide Powerful Data Cleansing Capabilities
» SQL Server 2005 Integration Services, Part 1: Lessons from Project REAL
» SQL Server 2005 Integration Services, Part 2: Developing Custom Components for Project REAL
» SQL Server 2005: Unearth the New Data Mining Features of Analysis Services 2005
» SQL Server Data Mining: Plug-In Algorithms
» SQL Server Data Mining Programmability
» SQL Server Optimization
» A Technical Comparison of Replication and Remote Data Access Features in SQL Server 2005 Mobile Edition 3.0
» Trace and Replay Objects: A New API for SQL Server Tracing and Replay
» A Tutorial for Constructing a Plug-in Algorithm
» A Tutorial for Constructing a Plug-In Viewer
» Usage Scenarios for SQL Server 2005 Native Web Services
» Using CLR Integration in SQL Server 2005
» Using Table Valued Functions in SQL Server 2005 to Implement a Spatial Data Library
» Using XQuery, New Large DataTypes, and More
» What's New in FOR XML in Microsoft SQL Server 2005
» XML Best Practices for Microsoft SQL Server 2005
» XML Indexes in SQL Server 2005
» XML Options in Microsoft SQL Server 2005
» XML Support in Microsoft SQL Server 2005


SQL Server 2005 Code Samples

SQL Server 2005 Samples and Sample Databases (July 2006)

The SQL Server 2005 Samples includes over 100 samples, organized by component:

  • Database Engine, including administration, data access, Full-Text Search, common language runtime (CLR) integration, Server Management Objects (SMO), Service Broker, and XML
  • Analysis Services
  • Integration Services
  • Notification Services
  • Reporting Services
  • Replication

AdventureWorks OLTP Database Diagram
Download a diagram of the AdventureWorks OLTP sample database. The sample data is based on a fictitious company, Adventure Works Cycles, a large, multinational manufacturing company that produces and distributes metal and composite bicycles to North American, European, and Asian commercial markets.

Technorati Tags: , ,

Popularity: 17% [?]

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • blogmarks
  • del.icio.us
  • Furl
  • Reddit
  • Shadows
  • YahooMyWeb
  • StumbleUpon
  • Digg
Related Posts:
  • More Free I.T. Training and Tutorial Resources
  • Free Training for SQL Server 2005
  • 2 Free Book Sites
  • MSDN Library May 2006 Edition
  • Best Free Visual Basic Training Resources from Microsoft

  • Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 5:11 pm


    MSDN Library May 2006 Edition

    The MSDN Library, May 2006 Edition, is available for free download from Microsoft's web site. It contains books, guides, articles, tutorials, SDKs, and sample code for Microsoft technologies. The MSDN Library is an essential resource of information for developers using Microsoft tools, products, and technologies. The total download size is 1729.1 MB, and is in 3 files.



    MSDN Library May 2006 Edition

    MSDN Library provides access to essential programming information, including technical white papers, software development kits and code samples necessary to develop web services and applications. This is an updated version of the MSDN Library for Visual Studio 2005.

    This updated May 2006 Edition includes the following content:
    • Visual Studio 2005 Team Foundation Server
    • SQL Server 2005
    • Microsoft Knowledge Base
    • Internet Information Server SDK
    • Internet Security and Acceleration Server SDK

    File Name:File Size
    Disk1.img639.1 MB
    Disk2.img639.1 MB
    Disk3.img450.9 MB


    Instructions

    Download instructions

    1. Click on the 3 ISO image downloads available on this page and save
    to your hard drive in a temporary directory.
    2. Rename downloaded 3 .img files to .iso and follow the ISO handling instructions below.

    There are 2 options in working with the downloaded ISO image files.

    1. Write the ISO file to CD-R.
    2. Mount ISO files virtually as CD-ROM devices.

    Installation Instructions

    1. In Disk 1, locate Setup.exe and double click to initiate installation.
    2. Follow the Setup Wizard instructions to completion.

    Technorati Tags: , , ,

    Popularity: 18% [?]

    Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
    • blogmarks
    • del.icio.us
    • Furl
    • Reddit
    • Shadows
    • YahooMyWeb
    • StumbleUpon
    • Digg
    Related Posts:
  • 9 Free .NET and Microsoft Technology Books
  • Programming Essentials in Visual Basic .NET
  • Free ASP.NET Book: Improving Web Application Security
  • Linux Study Guide and Text Book
  • SQL Server 2005 Technical Articles and Code Samples

  • Filed under: Free Computer and I.T. Books — computer_teacher @ 6:27 pm


    September 7, 2006

    205 Certification Practice Exams and Study Guides

    ITCertifer.com offers the following 205 freely available Certification Practice Exams and Study Guides covering certification exams for CompTIA, Oracle, Microsoft, Cisco, Adobe, and others. (Note the password needed to open the downloadable files in rar and zip formats.)

    205 Free Certification Practice Exams and Study Guides


    CompTIA Certification Practice Tests - Questions & Answers:

    CompTIA 220-301
    CompTIA 220-302
    CompTIA IK0-002
    CompTIA N10-002
    CompTIA N10-003
    CompTIA PK0-002
    CompTIA SK0-001
    CompTIA SY0-101
    CompTIA XK0-001


    Microsoft MCSE, MCSD Certification Practice Tests - Questions & Answers


    Microsoft 070-086
    Microsoft 070-210
    Microsoft 070-214
    Microsoft 070-215
    Microsoft 070-229
    Microsoft 070-230
    Microsoft 070-232
    Microsoft 070-234
    Microsoft 070-244
    Microsoft 070-270
    Microsoft 070-271
    Microsoft 070-272
    Microsoft 070-282
    Microsoft 070-284
    Microsoft 070-285
    Microsoft 070-290
    Microsoft 070-291
    Microsoft 070-292
    Microsoft 070-293
    Microsoft 070-294
    Microsoft 070-296
    Microsoft 070-297
    Microsoft 070-298
    Microsoft 070-299
    Microsoft 070-300
    Microsoft 070-301
    Microsoft 070-305
    Microsoft 070-306
    Microsoft 070-310
    Microsoft 070-315
    Microsoft 070-316
    Microsoft 070-320
    Microsoft 070-330
    Microsoft 070-340
    Microsoft 070-350
    Microsoft 070-431
    Windows Architecture Training Kit
    XML Programming
    Windows XP Power Toolkit
    A+ Certification Training Kit


    Oracle Certification Exam Practice and Study Guides:

    Oracle9i DBA Fundamentals
    Oracle8 Database Administration
    Enterprise DBA Part 1A Architecture and Administration
    Enterprise DBA Part 1B Backup and Recovery Workshop
    Enterprise DBA Part 2 Performance and Tuning
    Enterprise DBA Part 3 Network Administration
    Oracle 1Z0-0432


    Cisco Certification Practice Tests - Questions & Answers

    Cisco 640-801
    Cisco 640-811
    Cisco 640-821
    Cisco 640-861
    Cisco 642-425
    Cisco 642-432
    Cisco 642-444
    Cisco 642-452
    Cisco 642-501
    Cisco 642-502
    Cisco 642-511
    Cisco 642-521
    Cisco 642-522
    Cisco 642-531
    Cisco 642-532
    Cisco 642-551
    Cisco 642-541
    Cisco 642-577
    Cisco 642-582
    Cisco 642-611
    Cisco 642-642
    Cisco 642-661
    Cisco 642-801
    Cisco 642-811
    Cisco 642-821
    Cisco 642-831
    Cisco 642-871
    Cisco 642-891
    Cisco 646-227
    Cisco 646-391
    Routersim 4 03 (Resister Version)
    Interne Routin Architecture2n Edition
    Cisco Case Study
    Cisco Catalyst LAN Switching
    CCNA 640-607 Certification Guide
    Boson Router EMU
    Routersim


    Adobe Certifications:

    Adobe After Effects 5
    Adobe Acrobat 5
    Adobe FrameMaker 7
    Adobe GoLive 6
    Adobe Illustrator 10


    Other Certifications:

    Sun 310-035 Certified Programmer For Java 2 Platform 1.4
    Check Point 156-110
    Check Point 156-210
    ISC2 Cert-CISSP

    Technorati Tags: , , , , , , , ,

    Popularity: 25% [?]

    Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
    • blogmarks
    • del.icio.us
    • Furl
    • Reddit
    • Shadows
    • YahooMyWeb
    • StumbleUpon
    • Digg
    Related Posts:
  • 18 CompTIA Practice Exams
  • Free I.T. Certification Practice Exams
  • Free A+, Network+ and MCSE Certification Study Guides and Questions-Answers
  • Huge Archive of Certification Practice Exams
  • Free Comptia A+ Certification Exam Preparation and Study Resources

  • Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 8:41 pm


    September 11, 2006

    2 Excellent UML Tutorials

    Here are 2 excellent and well written UML Tutorials, one hosted by Sparxsystems.com.au (UML Tutorial), and the other by Borland.com (Practical UML: A Hands-On Introduction for Developers). These will give anyone unfamiliar with the UML a thorough understanding and kick start to using this modeling language.



    UML Tutorial

    The Unified Modeling Language (UML) has quickly become the de-facto standard for building Object-Oriented software. This tutorial provides a technical overview of the 13 UML. diagrams supported by Enterprise Architect.UML 2 semantics are explained in detail in the new UML 2.0 tutorial.

    But first... What is UML?

    The OMG specification states:

    "The Unified Modeling Language (UML) is a graphical language for visualizing,
    specifying, constructing, and documenting the artifacts of a software-intensive system.
    The UML offers a standard way to write a system's blueprints, including conceptual
    things such as business processes and system functions as well as concrete things such
    as programming language statements, database schemas, and reusable software
    components."

    The important point to note here is that UML is a 'language' for specifying and not a method or procedure. The UML is used to define a software system; to detail the artifacts in the system, to document and construct - it is the language that the blueprint is written in. The UML may be used in a variety of ways to support a software development methodology (such as the Rational Unified Process) - but in itself it does not specify that methodology or process.

    UML defines the notation and semantics for the following domains:

    - The User Interaction or Use Case Model - describes the boundary and interaction between the system and users. Corresponds in some respects to a requirements model.
    - The Interaction or Communication Model - describes how objects in the system will interact with each other to get work done.
    - The State or Dynamic Model - State charts describe the states or conditions that classes assume over time. Activity graphs describe the workflow's the system will implement.
    - The Logical or Class Model - describes the classes and objects that will make up the system.
    - The Physical Component Model - describes the software (and sometimes hardware components) that make up the system.
    - The Physical Deployment Model - describes the physical architecture and the deployment of components on that hardware architecture.

    The UML also defines extension mechanisms for extending the UML to meet specialized needs (for example Business Process Modeling extensions).

    See also Business Process Modeling (pdf) .

    If you have any suggestions or comments on the material here, please forward your thoughts to sparks@sparxsystems.com.au.


    UML Tutorial - Continued - Use the UML to Define and Build Systems

    We have established in Part 1 that the UML is a language for specifying the artifacts and interactions of a software system. We have also seen that it deals with 6 major domains - from Use Case models, through dynamic and logical models to the final physical deployment model - and that extension mechanisms have been included to allow for specialised additions to the model notation.

    So... How do you use the UML?

    The UML is typically used as a part of a software development process, with the support of a suitable CASE tool, to define the requirements, the interactions and the elements of the proposed software system. The exact nature of the process depends on the development methodology used. An example process might look something like the following:

    1. Capture a Business Process Model. This will be used to define the high level business activities and processes that occur in an organization and to provide a foundation for the Use Case model. The Business Process Model will typically capture more than a software system will implement (ie. it includes manual and other processes).
    2. Map a Use Case Model to the Business Process Model to define exactly what functionality you are intending to provide from the business user perspective. As each Use Case is added, create a traceable link from the appropriate business processes to the Use Case (ie. a realisation connection). This mapping clearly states what functionality the new system will provide to meet the business requirements outlined in the process model. It also ensures no Use Cases exist without a purpose.
    3. Refine the Use Cases - include requirements, constraints, complexity rating, notes and scenarios. This information unambiguously describes what the Use Case does, how it is executed and the constraints on its execution. Make sure the Use Case still meets the business process requirements. Include the definition of system tests for each use case to define the aceptance criteria for each use case. Also include some user acceptance test scripts to define how the user will test this functionality and what the acceptance criteria are.
    4. From the inputs and outputs of the Business Process Model and the details of the use cases, begin to construct a domain model (high level business objects), sequence diagrams, collaboration diagrams and user interface models. These describe the 'things' in the new system, the way those things interact and the interface a user will use to execute use case scenarios.
    5. From the domain model, the user interface model and the scenario diagrams create the Class Model. This is a precise specification of the objects in the system, their data or attributes and their behaviour or operations. Domain objects may be abstracted into class hierarchies using inheritance. Scenario diagram messages will typically map to class operations. If an existing framework or design pattern is to be used, it may be possible to import existing model elements for use in the new system. For each class define unit tests and integration tests to thoroughly test i) that the class functions as specified internally and that ii) the class interacts with other related classes and components as expected.
    6. As the Class Model develops it may be broken into discrete packages and components. A component represents a deployable chunk of software that collects the behaviour and data of one or more classes and exposes a strict interface to other consumers of its services. So from the Class Model a Component Model is built to define the logical packaging of classes. For each component define integration tests to confirm that the component's interface meets the specifcation given it in relation to other software elements.
    7. Concurrent with the work you have already done, additional requirements should have been captured and documented. For example - Non Functional requirements, Performance requirements, Security requirements, responsibilities, release plans & etc. Collect these within the model and keep up to date as the model matures.
    8. The Deployment model defines the physical architecture of the system. This work can be begun early to capture the physical deployment characteristics - what hardware, operating systems, network capabilities, interfaces and support software will make up the new system, where it will be deployed and what parameters apply to disaster recovery, reliability, back-ups and support. As the model develops the physical architecture will be updated to reflect the actual system being proposed.
    9. Build the system: Take discrete pieces of the model and assign to one or more developers. In a Use Case driven build this will mean assigning a Use Case to the development team, having them build the screens, business objects, database tables, and related components necessary to execute that Use Case. As each Use Case is built it should be accompanied by completed unit, integration and system tests. A Component driven build may see discrete software components assigned to development teams for construction.
    10. Track defects that emerge in the testing phases against the related model elements - eg. System test defects against Use Cases, Unit Test defects against classes & etc. Track any changes against the related model elements to manage 'scope creep'.
    11. Update and refine the model as work proceeds - always assessing the impact of changes and model refinements on later work. Use an iterative approach to work through the design in discrete chunks, always assessing the current build, the forward requirements and any discoveries that come to light during development.
    12. Deliver the complete and tested software into a test then production environment. If a phased delivery is being undertaken, then this migration of built sofware from test to production may occur several times over the life of the project.

    Note that the above process is necessarily brief in description, leaves much unsaid and may not be how you work or follow the process you have adopted. It is given as an example of how the UML may be used to support a software development project.

    Practical UML: A Hands-On Introduction for Developers

    by Randy Miller
    Abstract: This tutorial provides a quick introduction to the Unified Modeling Language™

    The heart of object-oriented problem solving is the construction of a model. The model abstracts the essential details of the underlying problem from its usually complicated real world. Several modeling tools are wrapped under the heading of the UML™, which stands for Unified Modeling Language™. The purpose of this course is to present important highlights of the UML.

    At the center of the UML are its nine kinds of modeling diagrams, which we describe here.

    Some of the sections of this course contain links to pages with more detailed information. And every section has short questions. Use them to test your understanding of the section topic.

    Why is UML important?

    Let's look at this question from the point of view of the construction trade. Architects design buildings. Builders use the designs to create buildings. The more complicated the building, the more critical the communication between architect and builder. Blueprints are the standard graphical language that both architects and builders must learn as part of their trade.

    Writing software is not unlike constructing a building. The more complicated the underlying system, the more critical the communication among everyone involved in creating and deploying the software. In the past decade, the UML has emerged as the software blueprint language for analysts, designers, and programmers alike. It is now part of the software trade. The UML gives everyone from business analyst to designer to programmer a common vocabulary to talk about software design.

    The UML is applicable to object-oriented problem solving. Anyone interested in learning UML must be familiar with the underlying tenet of object-oriented problem solving -- it all begins with the construction of a model. A model is an abstraction of the underlying problem. The domain is the actual world from which the problem comes.

    Models consist of objects that interact by sending each other messages. Think of an object as "alive." Objects have things they know (attributes) and things they can do (behaviors or operations). The values of an object's attributes determine its state.

    Classes are the "blueprints" for objects. A class wraps attributes (data) and behaviors (methods or functions) into a single distinct entity. Objects are instances of classes.

    Technorati Tags: ,

    Popularity: 20% [?]

    Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
    • blogmarks
    • del.icio.us
    • Furl
    • Reddit
    • Shadows
    • YahooMyWeb
    • StumbleUpon
    • Digg
    Related Posts:
  • Lots of Tutorials and 2 .Net Learning Sites
  • 3 Free Software Development Training and Coaching Sites
  • An Excellent Free Computer Book and Training Link Site
  • Free Training and Books on Java, EJB, .Net, and C# (C Sharp)
  • 2 Excellent Database Learning Sites: 1 Oracle and 1 SQL Server

  • Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 1:10 pm


    September 12, 2006

    Cookbooks for PHP, Python, Text Scripting, Tcl, and XSLT

    Activestate.com hosts these ASPN Cookbooks, which are topically categorized solutions, examples, and short tutorials covering PHP, Python, Text Scripting, Tcl, and XSLT. These recipes highlight programming best practices and can be used directly in day-to-day tasks, as a source of ideas, or as a way to learn more about these languages. Activestate.com invites you to contribute code, comments, and ratings for recipes in these Cookbooks. The cookbooks are freely available for review and use.



    PHP Cookbook

    The PHP Cookbook is a collaborative collection of PHP techniques and short tutorials which will show you how, as a programmer, to be more productive with PHP.
    Python Cookbook


    The Python Cookbook is a collaborative collection of Python programming techniques and tutorials.

    Rx (Text Scripting) Cookbook


    The Rx Cookbook is a collaborative collection of techniques for building, finding, verifying patterns of text. This growing collection demonstrates how programmers can be more productive with one of the most difficult areas of scripting.