I've gotten a few data points, but I don't think I've had enough yet to complete my sample. I'm still looking for people willing to describe how and where they implement business logic in their database applications. 1. CHECK CONSTRAINTS 2. TRIGGERS...

I've been having a conversation with a customer about CHECK constraints and TRIGGERs, and I thought it would be good to survey some of our customers about how people use these features. I'm curious how many people encode business logic validation in...

I just got all of my travel arrangements set up for PASS in Seattle. I'm excited to get a chance to go to PASS again. A good number of the product team will be manning various booths, ask the experts sessions, and panels. I'll be working 1-2 ask the experts...

Today's question comes from a friend I have in Brazil. Please, tell-me one thing, is there any improvement in avoid Implicit Conversions forcing one explicit conversion? Or will QP behind the scenes execute the same SQL using the function CONVERT(...