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
microsoft sql
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
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
sql
The DBA’s Rules
I don't know if you're a fan of NCIS, but for those of you who aren't let me give you a little back story. Gibbs is the leader of an investigative team and he
t-sql
Determine the Space Used by Tables
Eventually you'll be faced with running out of space on a SQL server. Usually, before you get more drive space, you're asked to find out if you can get rid of
t-sql
Inter-Database Queries
I've had this question come up a few times now. "How do I copy data from one database to another?" It's after getting a question like that, I explain fully
t-sql
SQL 201 — CREATE PROCEDURE
Now that you have the basics of SQL, I think it's time to learn something a bit more involved. If you need to accomplish a task within SQL you will run a series
microsoft sql
SQL101-Homework Assignment #6 Answer Key
Here are the answers for homework #6. Let me know if you have any questions! USE AdventureWorks GO 1. How many rows are there in Sales.SalesOrderHeader? SELECT