On Tuesday March 31st Jeremiah Peschka will be presenting a session for the Application Development SIG titled “Dynamic SQL: What’s All the Fuss About, Anyway?”. The time is set for 1PM EDT (1700UTC). When the livemeeting details are final I will post them here as well.
For a list of other SIG events, visit the SIG [...]
NOCOUNT and User Options
Recently we had a vendor suggest to us that we turn off the option for NOCOUNT on their database. Upon hearing this my first question was, naturally, why? What was the issue such that they would say they wanted this turned off for their database(s)? Those questions were immediately followed by, naturally, how? How do [...]
SQL 2008 Book by Grant Fritchey
Grant Fritchey’s new book is now available on Amazon, you can order it from the link below.
SQL Server 2008 Query Performance Tuning Distilled
I have know Grant for a few years now and have always been impressed with how he able to dissect query plans as well as his overall performance tuning abilities. This is a [...]
Something Old, Something New…
Something smells rotten in Denmark (it’s probably all that cheese).
This past weekend I started thinking about what it really means to have your databases hosted in the cloud. My first thought was that it struck me as being exactly the same as an Application Service Provider. I mean, MS SQL is an application, right? And you [...]
Question For Today
Well, it’s Friday, and time for another question. And yes, I am phoning it in this week, as my question is going to be:
WTF?
I look forward to your replies.
PASS BOD Update
Well, it did not take long for me to screw up on the PASS Board of Directors. I missed my deadline for reporting on my monthly progress. However, I have not been inactive since taking office two months ago. In fact, the PASS SIGs have made some progress over the past eight weeks. A lot of work [...]