t-sql
SQL 201-SELECT INTO
I've already shown you how to create a table, and how to INSERT data into that table. But did you know you can do both in one statement? The SELECT INTO
sql
microsoft sql
SQL 201 – Locking Hints
If you've spent any time looking at another programmers code, I'm sure you've see something like this: SELECT columnName FROM tableName (NOLOCK) I'm sure you
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. -
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
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
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