Archive for the Category SQL

 
 

SQLite Administrator

SQLite Administrator provides you with powerful and effective tools for SQLite administration and object management. Its Graphical User Interface  allows you to create/edit all SQLite database objects in a most easy and simple way, run SQL scripts, build SQL queries, extract or print metadata, export/import data, edit BLOBs and many more abilities that will make your work with the SQLite as easy as it can be…

SQLite Administrator features: 

  • Create / Modify / Delete Tables by Wizard
  • Create / Modify / Delete Indices by Wizard
  • Create / Modify / Delete Views by Wizard
  • Create / Modify / Delete Triggers by Wizard
  • SQL Code Completion that supports table aliases
  • SQL Code Highlighting
  • SQL Error Locating
  • Import Data from CSV Files
  • Export Data ( XLS / CSV / HTML / XML )
  • Store User Queries into Database
  • Search for User Queries
  • Store Images into Blob Fields ( JPG / BMP )
  • Show SQL of each Database Item
  • Migrate SQLite2 Databases to SQLite3
  • Try to keep Indices and Triggers after modifying a Table

Download SQLite Administrator.

[Via Larkware News]

IntelliSense style word completion for MS Query Analyzer, VS.NET

IntelliSense style word completion for MS Query Analyzer, VS.NET 2003, SQL Server Management Studio and VS 2005. PromptSQL, from Atadore, works with:Microsoft Query Analyzer,SQL Server Management Studio (Microsoft SQL Server 2005 CTP),Visual Studio.NET 2003 Visual Studio 2005 (Beta 2).It adds IntelliSense(r)-like word-completion for you when you are editing SQL using these products.

http://www.promptsql.com

SQL Server 2005 Webcast Series

Covered in this series:

  • .NET Framework Integration: Learn how you can now take full advantage of the Microsoft .NET Framework class library and modern programming languages to implement functionality within the server.
  • Transact-SQL and Managed Code: Find out how to decide between using traditional Transact-SQL or a programming language that is compatible with the .NET Framework, such as Visual Basic .NET or C#. Understand where each method provides benefits and how to design for this in the beginning.
  • Web Services: See how to develop XML Web services in the database tier, making SQL Server an HTTP listener.
  • XML: SQL Server 2005 contains deep native support for XML. Learn how this can significantly help as you develop applications that make use of XML.
  • Data Access: Discover how ADO.NET 2.0 not only supports all of the new SQL Server 2005 features but also enables productivity and performance gains for all developers.

Registration link: http://www.microsoft.com/events/series/msdnsqlserver2005.mspx

[ Via hwhite ]

Are you ready to experience SQL Server 2005?

Announcing the launch of the SQL Server 2005 Virtual Hands on labs. In these labs, you will get to experience many of the new features in SQL Server 2005 including CLR integration, XML support and deep business intelligence integration.

Just follow the link and experience SQL Server 2005 for yourself

Step into the SQL Server 2005 Virtual Lab for Free

It’s simple — no complex setup or installation is required to try out SQL Server 2005 running in the full-featured MSDN Virtual Lab. As part of the MSDN Virtual Lab, you will have full access to SQL Server 2005 through the following modules:

  • SQL Server 2005 Integration Services
  • SQL Server 2005 Introduction to SQL Server Management Studio
  • SQL Server 2005 Reporting Services
  • SQL Server 2005 Server Management Objects
  • SQL Server 2005 SQL CLR Integration
  • SQL Server 2005 SQL Query Tuning
  • SQL Server 2005 SQL Server and ADO.NET (Lab A)
  • SQL Server 2005 SQL Server and ADO.NET (Lab B)
  • SQL Server 2005 T-SQL Enhancements
  • SQL Server 2005 Web Services
  • SQL Server 2005 XML Capabilites

    You get a downloadable manual and a 90-minute block of time for each module. You can sign up for additional 90-minute blocks at any time.

    Registration link:
    http://msdn.demoservers.com/login.aspx?group=sql2005

    [ Via David Crawford's WebLog ]

  • D4MODELIZER

    D4Modelizer is a simple but powerful code generator. It produces C# code from your Database. Each table could be mapped to an object and its fields in properties. D4Modelizer propose a mapping schema between the database structure and the object model.

    Features

    • Map your DataBase to Object Model.
    • Produce secure and optimized C# code.
    • Reduce develop time with integrated persistance methods.
    • Each object could have Add,Delete,Modify,GetData methods corresponding to data source.
    • Works with SQLServer, MSDE, IBM DB/2, Oracle, Sybase, MySQL, Access,Firebird and PostgreSQL.
    • Create directly Project for MS Visual Studio & SharpDevelop.
    • Produce Unit Testing with NUnit framework
    • US,Spain,Italian & French versions.

    D4Modelizer

     

    Download D4MODELIZER


    Page 1 of 212