What I learned at PASS – ETL in Queries.

I attended only a small number of the talks at PASS.  I really enjoyed Bob Ward’s talk on memory and Paul Randal’s talk on DBCC corruption/repair.  Otherwise, I spent a lot of time answering questions from customers.  LOTS of questions.  So many questions I pretty much lost my voice. Overall, I was amazed at how…

1

PASS in Seattle! W00t!

I hope to see folks at PASS – please look for me at the Ask the Experts booth for Query Processing/Performance.  I’m very interested in hearing about what kinds of ways you are using SQL Server and how we can make the product better!  Thanks,  Conor

2

Conor vs. Win2008 Hypervisor

I’ve been building a new machine and I have put Win2K8 Enterprise on it.  While I have no specific reason to enable the hypervisor other than my absolute, unbounded enjoyment at saying the word “hypervisor”, I also was going to try to run a few of the server-like programs that I use at the house (for…

1

The vote is in! (CHECK CONSTRAINTS vs. TRIGGERS vs. STORED PROCEDURE business logic)

Thank you for everyone who “voted” – a great day to talk about the issues of the day :). After much research, I’ve found that we live in a divided country.  Some of us like triggers.  Others wouldn’t be caught dead with a trigger and do lots of business logic validation within stored procedures.  Some…

2