SQL102
SQL 102 — CREATE DATABASE
The most fundamental task you'll have to learn to do as a Database Administrator is to create a database. Please remember it's probably a good idea to make
SQL102
t-sql
ALTER TABLE
After you've spent time designing the perfect table, someone is going to come along and ask you a question that will lead you to changing your table. It can be
t-sql
SQL 102 – Foreign Keys
In the simplest terms a Foreign Key in one table refers to the Primary Key of another table. Let's go back to our demo tables products and productSales. -
SQL102
SQL 201 – Statistics
Microsoft SQL Servers collect statistical information on indexes and column data stored in each database. These statistics are used by the query optimizer to
SQL102
SQL 102 – Jobs
Now that you're familiar with stored procedures, it's time to introduce you to jobs. Jobs are like stored procedures, in that they are a set of steps performed
microsoft sql
SQL 201 – Indexes
Indexes in Microsoft SQL are just like indexes in a book. They help you jump to the information you want more quickly. In Microsoft SQL you can index one or
SQL102
SQL 102 – GRANT
As an administrator, you can execute the SELECT from the Components table and the v_Components view, and execute the usp_GetBatmobileComponentsList procedure;
t-sql
SQL 102 – Users
Before you got started working with SQL Server, someone had to set up a user account for you. Now that you're learning to become a database administrator you
SQL102
SQL 102 – Primary Keys
In SQL 101, I showed you how to create a table. I want to build on that today by introducing the concept of a primary key. A primary key is a column, or
SQL102
SQL 102 — Introduction to Database Administration
After completing my SQL 101 series, I thought I'd take a shot at writing another series. This time I'll be writing about Database Administration. While
SQL102
A Series for Database Administration
I'm at it again! I'm working on some notes about how to administer a Microsoft Database Server. I'm planning on following the fundamentals you would need
sql
The DBA’s Rules — Rules 3 and 4
In previous posts I shared with you my rules for who does and doesn't have access to sa, and keeping your data safe by having tested backup and restore