SQL installation

SQL INSTALLATION Step-1 For this Please Install the Version 7.0 or SQL Server 2000 or onwards. Step-2 (Database Creation ) Go to the Start Menu PROGRAMS =>Microsoft SQL Server =>Click on Enterprise Manager =>Click on Microsoft SQL Server plus Icon...

Connecting to Microsoft SQL Server

Connecting to Microsoft SQL Server Overview – What do you have to know… Server Name Security Information Database name Data Interface / API to use Steps to connect… When creating a connection, you can use one of three sources: a...

Building a Data Warehouse with SQL Server

Building a Data Warehouse with SQL Server What is a data warehouse? In its simplest form a Data Warehouse is a way to store data information and facts in an format that is informational.  Hopefully, you were able to pull...

Microsoft SQL Server Administration for SAPSQL Server Architecture

Microsoft SQL Server Administration for SAP SQL Server Architecture INTRODUCTION Database server is the the computer where SQL Server service is running SQL Server runs as a processes in NT More than on SQL Server can run on a single...

SQL Server 2014 – Features Drilldown

SQL Server 2014 – Features Drilldown In-Memory for OLTP New high-performance, memory-optimized OLTP engine integrated into SQL Server and designed for modern hardware trends Integrated into SQL Server relational database Full ACID support Memory-optimized indexes (no B-trees or buffer pools)...

SQL Server 2008 24X7 Maintenance Considerations

SQL Server 2008 24X7 Maintenance Considerations Database Maintenance What is the purpose of database maintenance? To ensure consistent, high performance of databases while protecting the integrity of the schema, end user data, and the SQL Server. Physical Server Physical Disk...

Optimize SQL Server for Private Cloud

Optimize SQL Server for Private Cloud Microsoft Cloud Datacenters Investments $2.3B+ in cloud infrastructure 200+ services, delivered 24x7 Geo-distributed datacenters Rapid modular model 30,000+ engineers involved in cloud-based activities 2,000+ people in cloud infrastructure engineering and operations Operational Excellence 99.9%...

Utiliser mysql en mode batch

Utiliser plus d'une table La table animaux contient la liste des animaux que vous avez. Vous pourriez vouloir enregistrer d'autres informations à leur sujet, telles que des évènements de leur vie, comme les visites chez le vétérinaire, ou les dates...

Oracle PL/SQL

Types prédéfinis Types caractères CHAR[(n)] Chaîne de caractères de longueur fixe avec n compris entre 1 et 32767 (par défaut 1) VARCHAR2(n) Chaîne de caractères de longueur variable avec n compris entre 1 et 32767 Ces types PL/SQL ont une...

Manuel de référence de MySQL

Qu'est ce que MySQL? MySQL est un véritable serveur de base de données SQL multi-utilisateur et multi-threaded. SQL est le plus populaire langage de base de données dans le monde. MySQL est une configuration client/serveur ce qui consiste en un...