microsoft sql
Rename a Table or Column
In a previous post, I showed you how to rename a database in Microsoft SQL. If you haven't already been hit with a request to change the name of a table or
dba
SQL102
Renaming a Database
A topic that you'll need sooner or later is how to rename a database. You'll get a request to build a database, and it'll be documented fairly well. You'll be
t-sql
SQL 102 — DROP DATABASE
While deleting a database is a fairly rare occurrence, I'm teaching you now, since it's a pretty easy task to learn. Before teaching you this, you do know rule
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
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. -
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
sql
The DBA’s Rules — Rule #2
Rule #2: Have a tested Backup and Recovery Plan I'm sure no one out there isn't doing a backup on their database server at some interval compatible with the