SQL201

Optimizing Queries

This is the first article in a never ending series of articles on how to optimize your queries. Honestly, this is a topic I'm still learning volumes about. I

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

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