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 monitoring solution. I mentioned three different solutions: Redgate Monitor, Confio Ignite, and SQL Sentry Power Suite. I mentioned the pros and cons…
Month: August 2011
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 might be because you’re not sure what you could use it for. Let’s go through a scenario where the OUTPUT clause could save you from doing a RBAR (Row…
SQL 201-Table Variables
It’s been a while since I’ve added to my SQL 201 series, so I thought I’d pick up with table variables. In an earlier post, I covered temp tables. Temp tables are a great place to dump in raw data, then transform it into another form so you can use it in a different way. …