Pages

▼
Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts
Monday, May 8, 2017

SQL Server: Functions

›
For easy reference, we have provided a list of all SQL Server (Transact-SQL) functions. The list of SQL Server functions is sorted alphabet...
Thursday, May 4, 2017

SQL Server - Joins

›
In Structured Query Language (SQL), a JOIN is a method of linking two data tables in a single query, allowing the database to return a set ...
Monday, May 1, 2017

SQL Server - Restoring Databases

›
Restoring is the process of copying data from a backup and applying logged transactions to the data. Restore is what you do with backups. T...

SQL Server - Monitor Database

›
Monitoring refers to checking database status, settings which can be the owner’s name, file names, file sizes, backup schedules, etc. SQL...

SQL Server - Assign Permissions

›
Permissions refer to the rules governing the levels of access that principals have to securables. You can grant, revoke and deny permission...

SQL Server - Creating Backups

›
Backup is a copy of data/database, etc. Backing up MS SQL Server database is essential for protecting data. MS SQL Server backups are main...

SQL Server - Drop Database

›
To remove your database from MS SQL Server, use drop database command. Following two methods can be used for this purpose. Method 1 – Usi...
Tuesday, April 26, 2011

SQL Server - Summary - XV

›
Congratulations for reaching the end of this SQL Server tutorial! SQL Server is a powerful application, and this tutorial has provided an ...

SQL Server Integration Services (SSIS) - XIV

›
SQL Server Integration Services (SSIS) allows you to integrate smoothly with other applications and data sources. You can use Integration ...

SQL Server - Linked Servers - XIII

›
If you've been navigating around SQL Server Management Studio (SSMS), you may have come across the Linked Servers option. The Linked S...

SQL Server - Database Schemas - XII

›
Ever since SQL Server 2005 was released, each object in a database has belonged to a database schema. SQL Server 2008 has continued with da...
Monday, April 25, 2011

SQL Server - Server Roles - XI

›
When creating a new user login in SQL Server, you get the option of assigning the login one or more server roles. Server roles (not to be ...

SQL Server - User Logins - X

›
SQL Server allows for the creation of user logins. Each individual who needs access to SQL Server can be given their own user account. Whe...

SQL Server - Query Designer VII

›
In the   previous lesson, we created a SQL script using SQL Server Management Studio (SSMS). In this lesson, we will look at how to write SQ...

SQL Server - Views VIII

›
In SQL Server, a  view  is a pre-written query that is stored on the database. A view consists of a SELECT statement, and when you run the v...

SQL Server - Stored Procedures - IX

›
Stored procedures are a powerful part of SQL Server. They can assist programmers and administrators greatly in working with the database co...
Friday, April 22, 2011

SQL Server - Adding Data - VI

›
In the previous lesson, we created a new table in our database. We now have a database table, columns and all, but with no data. Editing Tab...
Thursday, April 21, 2011

SQL Server - Create a Table - V

›
This lesson demonstrates how to create a table in a SQL Server database using SQL Server Management Studio (SSMS).
Monday, April 18, 2011

SQL Server - Create a Database - IV

›
One of the first things we should look at with SQL Server/Management Studio is how to create a database. After all, most of the tasks you pe...
Friday, April 15, 2011

SQL Server Management Studio (SSMS) - III

›
SQL Server Management Studio (SSMS) is the main administration console for SQL Server. SSMS enables you to create database objects (such a...