Tag Archives: sql server

Service Broker – SQL Server Connections

Posted on November 3, 2010 by way0utwest

These are some notes and thoughts from sessions and my time at SQL Server Connections/DevConnections in Nov 2010. Denny Cherry gives a nice warning at the beginning of his sessions. His parents were sailors, so beware of the Service Broker … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Service Broker – SQL Server Connections

T-SQL Tuesday #12 – Why Do You Need a DBA?

Posted on November 2, 2010 by way0utwest

It’s once again time for T-SQL Tuesday, the brainchild of Adam Machanic (Blog|Twitter). It’s a monthly blog party, designed to get bloggers to all write on a single topic on the same day. This month we have the party hosted … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on T-SQL Tuesday #12 – Why Do You Need a DBA?

Common SQL Server Mistakes – Functions in the WHERE Clause

Posted on October 27, 2010 by way0utwest

This continues my series on Common SQL Server mistakes, looking at more T-SQL mistakes. What’s Wrong? If you saw a query like this, would you see a problem? select   o.OrderID   , o.CustomerID   , o.Qty from Orders o where datepart( yyyy, … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Common SQL Server Mistakes – Functions in the WHERE Clause

The SQL Rally Pre Conference Seminars

Posted on October 26, 2010 by way0utwest

There’s a change in how pre-conference seminars are being picked for the SQL Rally event next year in Orlando, FL. You, as the people that may attend, are getting the chance to vote on which sessions you’d like to see. … Continue reading →

Posted in Blog | Tagged , , | Comments Off on The SQL Rally Pre Conference Seminars