sql103
SQL103 – Designing Views
One of the next steps, after designing your tables is designing your views. You'll often need to create them so that programmers will have access to the data
Latest
sql103
SQL103 – Prevent Dirty Data
Now that we've built relationships between our tables, we want to take the next step with our design is making sure the data stored in our tables is as clean as
sql103
SQL 103 – Relating Your Tables
Last time we were discussing how to build normalized tables. We designed 3 tables: Customer, Address and PhoneNumber. The Address and PhoneNumber tables are
sql103
SQL 103 – Normalized Table Design
So last time we were discussing the difference between normalized and de-normalized database design. We also discussed our case study, the CRM company. We
sql103
SQL103 – Normalized or Denormalized Design
When you begin designing a database, you start with the tables. You can’t very well start with views or stored procedures, right? What tables would they
sql103
SQL 103 – Introduction to Database Design and Architecture
I’m starting a new blog series to accompany the session I’m presenting at SQL Saturday #87 in Louisville! This session will cover the basics of designing a
SQL201
SQL201 – Stored Procedure Results
I'm working my way through the last of the 201 lessons. Today we're going to dive back into stored procedures. This time I want to cover the three ways you can
career development
Career Advice — Ending The Partnership
If we've ever sat down and discussed how I look at work, career, and professional development in general, you know I see every job as a partnership between two
SQL201
SQL201-On Handling Errors
Let's get back into SQL 200 by learning to deal with errors. Churchill had a great quote that applies to development (database or not) "He who fails to plan is
Results for "raiserror"
Let’s get back into SQL 200 by learning to deal with errors. Churchill had a great quote that applies to development (database or not) “He who fails to plan is planning to fail.” No matter how well you think you’ve planned your code, it’s going tofail. The question is, will...
CREATE TABLE Is a Policy Document: How I Stopped Winging Schema Definitions
A client called me once to look at a performance problem on their data warehouse. The query was slow, the tables were large, and the indexes were wrong. I fixed the indexes. But while I was in there, I noticed something else: every table in the warehouse had a different
microsoft sql
Why I Went with SQL Sentry
In my SQL Saturday #80 Session I spoke about how to get started as a DBA. One of the greatest advantages you can have as a DBA is setting up a fully featured