A wise man once said “praise publicly, criticize privately.” This week we saw a handful of blog posts and associated comments regarding the PASS Summit survey results. If you review the posts and comments I think you would find them more along the lines of “criticize publicly, remain silent privately”, because that’s how I feel [...]
Refresh Your Views With sp_refreshview
With SQL Server 2008 R2 having been released it seems like a good time to remind people about the sp_refreshview system stored procedure. How are those two things related? Great question.
When migrating or upgrading to newer versions (such as R2), you need to be aware that a simple restore is not always enough. First, you [...]
Presenting at DBA Virtual Chapter Tomorrow
Tomorrow at Noon EDT I will be presenting on SQL Server 2008 Audit. It will be similar to the talk I gave this past weekend at SQL Saturday #39. I will need to make some changes because it is a much different dynamic to present virtually as opposed to being with a group of people [...]
SQL University – Securing and Auditing Servers
Welcome back to SQL University.For previous SQL University posts please visit http://thomaslarock.com/category/sql-university/.
This week we will be discussing the topic Securing and Auditing Servers. This is a timely topic for me since I recently did a presentation at SQL Saturday #39 on the topic of SQL Server 2008 Audit. So, this topic happens to be something [...]
Canceling a SQL Azure Account
or…not…
I wanted to cancel my account before I got hit up for “hidden charges” or something ridonkulous like that and could not find any way to cancel my subscription short of calling someone on the phone which could be my least favorite thing to do.
From what I could tell, I should be allowed to “opt-out” [...]
SQL Saturday #39 Recap
I had an amazing time at the SQL Saturday event in New York City this past weekend. I learned new things, met new people, and ate an olive wrapped in a piece of bacon. What more could you want from a PASS event?
I arrived on Friday evening and attended the speaker party that night. It [...]