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
Latest
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
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
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
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
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...
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
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
The Network Is No Longer Free: How Cloud Rewired My Coding Assumptions
For twenty years, I wrote code that assumed the network was fast, reliable, and effectively free. Not because I was naive — it was actually true. When your application and its database both live on the LAN, a query round-trip is measured in fractions of a millisecond. Connections are stable
microsoft sql
SQL201–The OUTPUT Clause
Starting with SQL 2005 SQL introduced a new clause for your INSERT, UPDATE, DELETE, and MERGE statements...the OUTPUT clause. If you're not using it yet, it