Giter Site home page Giter Site logo

sqlauto's Projects

centraldb icon centraldb

SQL Server Inventory and Baseline using Powershell and SQL Reports

cisl icon cisl

Columnstore Indexes Scripts Library

clr-in-database icon clr-in-database

This project makes CLR file which provides making Geocoding requests in database.

common icon common

SQL FineBuild provides 1-click install and best-practice configuration on Windows of SQL Server 2019 through to SQL Server 2005

country-database-multilang icon country-database-multilang

A SQL Server script that creates a table "Country" with all countries in the world, having their names on spanish and english

criminaldatabase icon criminaldatabase

A SQL database system for criminal data utilizing a client/server relationship

customblockedreport icon customblockedreport

Blocked Process Report. Detailed explanation could be found on Red Gates SimpleTalk's link link 'Building a Custom Blocked Process Report' https://www.red-gate.com/simple-talk/sql/database-administration/building-custom-blocked-process-report/

database-design-and-development-project icon database-design-and-development-project

SOUTH DUBLIN HOUSING COUNCIL REPAIRS DATABASE There are seven items in this repository: 1. An export of the South Dublin Housing Council Repairs Database in an sql file which is to be imported into phpMyadmin to be viewed. It is best to view the database on the Apache server. The file is called south_dublin_housing_council_coddsrules.sql. It can be opened with notepad++ to view the database in SQL language. 2. An sql file which has the SQL code which was used to carry out Codd’s Rules in the South Dublin Housing Council Repairs database. This file is called sql_queries_south_dublin_housing_council_coddsrules.sql. It can be viewed in notepad ++. 3. There is also a pdf explaining each of Codd’s Rules and showing how they were proved in the South Dublin Housing Council Repairs database. The pdf file is called CODDS RULES FOR SOUTH DUBLIN HOUSING COUNCIL.pdf. 4. There is also a pdf file showing the database in xml design. The pdf contains a schematic, a DTD, XML file structure and 10 XPATH queries. The pdf is called southdublinxml.pdf. 5. There is also an xml file containing everything from number 4 except the schematic in an xml file. The xml file is called southdublinhousingcouncilxml.xml and can be viewed in notepad++. 6. A readme file in pdf format. 7. A pdf file which contains the design of the database and the website linked to the database. The file is called Database and Website Design.pdf. The differences between the design and the completed database are outlined in the readme file.

databasesbasics-mssqlserver icon databasesbasics-mssqlserver

The course introduces us to one of the most widely used database management systems (DBMS) used in the development of modern information systems - Microsoft SQL Server. The course focuses on relational modeling, data modeling with ER diagrams (tables and relational links) and SQL language (data retrieval, selection, projection, joining, aggregation, grouping, modification, deletion and insertion).

datainsightsasia icon datainsightsasia

A collections of resources, samples, and demos created and used by the Data Insights Asia team

datamigration icon datamigration

Get overview over N SQL Instances databases migrations readiness

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.