Links

Links at HiTech Coach

Microsoft SQL Server

  • Hits: 2465
    Beginner's Guide to ODBC - UtterAccess
    This is an attempt to equip the developers who want to use Access as a front-end client to any RDBMS (Relational DataBase Management System) backend (ie, SQL Server, DB/2, Oracle, MySQL, PostgreSQL) with the right questions to explore and ask during design and development. As we cannot cover every special case or all the nuisances that each developers must deal with, it is hoped that,by reading over this document, you will be better equipped to find the needed answers for your specific case. The article assumes that you are familiar with developing an Access application, understand the fundamentals of data types used in Jet and VBA and know basic SQL and is familiar with Data Access Objects (DAO) library and/or ActiveX Data Objects (ADO) library, but are otherwise new to working with ODBC data sources. The objective is to provide you with a set of questions about design and development and know how to ask them.
  • Hits: 2152
    Microsoft SQL Server Site - MSDN
    Get all the latest information from Micrsoft
  • Hits: 2246
    SQL SERVER OVERVIEW - UtterAccess WIKI
    SQL Server is Microsoft's Enterprise level server database product. We'll begin our introduction to SQL Server by discussing how the database engine and storage differs from all "Access" implementations, with which you may be familiar.
  • Hits: 4070
    Using DSN-Less Connections
    Typically, linking an Access front-end to tables in some other DBMS involves using a Data Source Name (DSN), usually created through the ODBC Data Source Administrator windo, which is accessible from the Windows Control Panel (or Administrator Tools in Windows 2000). However, this requires that a DSN be created for each workstation that's going to use the front-end application.
  • Hits: 2054
    What are the main differences between Access and SQL Server?
    This article will try to explain some of the differences between Access and SQL Server.
  • Hits: 2127
    SQL Server 2008 R2 Express
    Learn, Develop, and Deploy at No Cost Build and deploy web, desktop, and small server applications for free with Microsoft SQL Server 2008 R2 Express.
  • Hits: 2542
    Microsoft SQL Server Migration Assistant for Access v5.1
    Overview SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Access to SQL Server. SSMA for Access automates conversion of Microsoft Access database objects to SQL Server database objects, loads the objects into SQL Server, and then migrates data from Microsoft Access to SQL Server. SSMA for Access v5.1 is designed to support migration from Microsoft Access 97 and higher to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Code Named "Denali", and SQL Azure.
  • Hits: 2336
    Microsoft SQL Server Migration Assistant for Access v4.2
    Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Access to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
  • Hits: 2686
    Microsoft SQL Server 2008 Management Studio Express

    Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.

  • Hits: 2085
    When to Use SQL Native Client
    When deciding whether to use SQL Native Client as the data access technology of your application, you should consider several factors.
  • Hits: 2131
    Installing and Upgrading to SQL Server 2005 - SQL Sever Central
    Before you go anywhere with SQL 2K5, you must be aware of the many changes and improvements to installing the software, as well as the types of installations used in various scenarios.
  • Hits: 2332
    Installing SQL Server 2005 - MSDN
    The SQL Server 2005 Installation Wizard is Microsoft Windows Installer-based, and provides a single feature tree for installation of all Microsoft SQL Server 2005 components: ...
  • Hits: 2071
    Installing SQL Server 2008 - MSDN
  • Hits: 2276
    How to: Install SQL Server 2008 R2 (Setup) - MSDN
  • Hits: 2163
    Installing SQL Server 2008 (SQL Server Video) - MSDN
  • Hits: 2295
    Security Considerations for a SQL Server Installation - MSDN
    SQL Server 2008 R2 - Security is important for every product and every business. By following simple best practices, you can avoid many security vulnerabilities. This topic discusses some security best practices that you should consider both before you install SQL Server and after you install SQL Server. Security guidance for specific features is included in the reference topics for those features.
  • Hits: 2475
    Planning a SQL Server Installation - MSDN
    SQL Server 2008 R2 - To install SQL Server, follow these steps: Review installation requirements, system configuration checks, and security considerations for a SQL Server installation. Run SQL Server Setup to install or upgrade to a later version. Use SQL Server utilities to configure SQL Server.
  • Hits: 2118
    Quick-Start Installation of SQL Server 2008 R2 - MSDN
  • Hits: 2068
    The Connection String Reference
  • Hits: 2243
    SQL Server Functions - MSDN

Latest News