SQL Server Professionals: NYC Summer Spectacular! Training & Events

This is a very exciting summer to be in New York City!  We’re not just talking Central Park, the Theatre...

“Green” Database Administration

For the past few years, I have seen tens of sql server boxes added in my work environment every year,...

Jacksonville IT Pro Camp

Join system administrators and IT professionals for the Jacksonville IT Pro Camp on Saturday, June 16th, 2012.
IT Pro Camps are...

SQL Server Service Broker Explained

What is Service Broker?
Service Broker is a native SQL Server implementation of message queues.

What are message queues?
Message queues are a...

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

Investment for DBA Career

As IT professionals, we all will consider and take actions, at some point of time, to “invest” in our careers....

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

Are you ready?

I have talked about wanting a change. I thought I am prepared to embrace that change when it finally comes.
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...

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