SQL201

SELECT CASE

A useful skill to learn in SQL is how to translate a value into a description.  You’ll use it all the time.  Whether you’re turning M|F into Male or

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

t-sql

SQL 201 – Views

Previously I showed you how to create tables.  The normal goal for designing a table is to store data in such a way that each table contains one group of facts

t-sql

SQL 201 — User Defined Functions

Back in SQL 101, I introduced you to some functions, GETDATE(), ISNULL(string1, string2), etc. All of these functions come defined in Microsoft SQL before you

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

t-sql

TOP PERCENT

We have a multi-threaded process that grabs it's fair share records and then processes them. It basically looks at the total number of records to process, and