training
Missed Deadlines
Looks like I missed my personal deadline to take my 70-433 last month. I let myself get wrapped up in the final phases of development on a conversion I've
training
azure
The Import and Export Data Wizard and SQL Azure
In my previous post I walked through migrating a database from SQL 2008 to SQL Azure. I briefly walked you setting up your account with SQL Azure, creating a
transaction
Return a Success/Failure to a Job based on a SQL query?
Over on Experts Exchange, someone posted a question I felt I could answer. The user posted a question on how to return a failure and not run a job. I
examples
Exception Handling
Learning to handle errors better can be one of the skills that will really set you apart from other SQL Developers. You can do constant unit testing after each
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
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
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
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