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 [...]