Max Server Memory

Sakthivel Chidambaram recently created a calculator which can find out the max server memory value based on the input.
http://blogs.msdn.com/b/sqlsakthi/archive/2012/05/19/cool-now-we-have-a-calculator-for-finding-out-a-max-server-memory-value.aspx

you can...

Are you ready?

I have talked about wanting a change. I thought I am prepared to embrace that change when it finally comes.
I...

I’m Going on Tour

I’ve done quite a bit of speaking over the last few years, which has required a lot of travel. I...

June Question: Which DMV(s) do you most often use when managing your SQL Server instances, and why?

Dynamic Management Objects (DMVs and DMFs) are some of the most useful tools for the DBA. So this month’s question...

Ottawa In the Summer Time

I wrote a post earlier this week telling you all about my trip to Ottawa last week, during my trip...

Setup windows firewall for SQL Server

On Windows 2008 R2, the windows firewall will turn on by default which causes connection issure for the remote client, here...

SQL Server 2008 Security Best Practices

If you are working as a DBA for a financial organisation where sensitive financial data is stored in your databases...

The SQL in the City US Tour

If you haven’t heard yet, Red Gate Software is sponsoring a six city tour of the United States of its...

The Standing Desk – Week 1

I finally got my standing desk working last weekend and started on Tuesday (after Memorial Day) working at it on...

A new neat feature in SQL Server 2012 is THROW

In SQL Server 2005 we got the TRY…CATCH construct which was a big help for developers to effectively handle errors...