Benchmark IT Consulting Rotating Header Image

Posts under ‘General’

sp_refreshview How Did I Forget You?

So a developer asked me a question about how he added a column to a table and now the view that referenced the table wasn’t showing the column.  I asked the obvious question: “Did you add the column to the view?” to which he replied “The view is doing a SELECT *”

OK it may not [...]

Rebooting a Server Using PowerShell

The more I work with PowerShell the more I love it

So what do you do if you’re in a VM environment and you want/need to reboot your server but you can’t connect via RDP and you can’t connect to the console using the VM Infrastructure Client, and all other attempts to connect just [...]

My 2010 Goals and Themeword

I’ve seen a few of these types of posts over the last week or so and I figured I should publish something on the intertubes that would be something to look back on come next year at this time.  Tom LaRock had a very interesting spin on things (as he always does) and added a [...]

You don’t think of them as human… You don’t think of them at all

OK maybe I’m feeling really good today… maybe it’s because it’s @Peschkaj’s birthday… maybe it’s because I needed to find a way to work some Tina Turner into my next blog post…or maybe it’s because I successfully took care of both kids last night for the first time while wifey started some photography [...]

Database Mail Test Works…SQL Server Agent Notification Doesn’t

So have you ever had one of THOSE days?

So I’m finishing up building a shiney new SQL Server 2005 Instance and I start configuring Database Mail.  Everything is going fine and once it’s setup I do a “Send Test Email”.   I get the email in a couple seconds so for my final test I create [...]

Twitter links powered by Tweet This v1.6, a WordPress plugin for Twitter.