Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: March 2011

Do You Enable “Lock Pages in Memory”?

Lock Pages in Memory is a setting that can be set on 64-bit operating systems that essentially tell Windows not to swap out SQL Server memory to disk. By default, this setting is turned off on 64-bit systems, and depending on the circumstances, the following conditions could occur when… Read more

5 comments, 1,481 reads

Posted in SQL Aloha on 10 March 2011

Interview with SQL Server MVP Joe Webb

Joe Webb will be speaking at the SQLServerCentral.com track at SQL Server Connections, March 27-30, in Orlando, FL.

Tell us a little about yourself.

For the past 16 years, I’ve been self-employed as a database consultant and I regularly work with clients in the areas of business process analysis… Read more

0 comments, 370 reads

Posted in SQL Aloha on 10 March 2011

Attending SQLskills Immersion Event on Performance Tuning Next Week

After attending the SQLskills Immersion Event on Internals and Performance in Dallas two weeks ago, I am fortunate enough to be flying back to Dallas next week to attend the Immersion Event on Performance Tuning.  The first week was a whirlwind, and I imagine the second week will be one… Read more

0 comments, 303 reads

Posted in SQL Aloha on 10 March 2011

Interview with DBA Brian Kelley

Brian Kelley will be speaking at the SQLServerCentral.com track at SQL Server Connections, March 27-30, in Orlando, FL.

Tell us a little about yourself.

I’m currently working as a SQL Server DBA and architect for a financial institution. Previously, I’ve been an infrastructure and security architect. I’ve also… Read more

0 comments, 346 reads

Posted in SQL Aloha on 10 March 2011

SQL Server Connections Discount Code

If you are thinking about attending SQL Server Connections (a part of DevConnections) in Orlando this March 27-30, take advantage of the “DevCon1” discount code to save you $200 off the registration.

SQLServerCentral.com will be offering their own SQL Server track, with speakers Joe Webb, Jonathan Kehayias, Brian Kelley and… Read more

0 comments, 357 reads

Posted in SQL Aloha on 10 March 2011

SQLServerCentral Best Practices Clinic

I have just begun a new article series at SQLServerCentral.com called the SQLServerCentral.com Best Practices Clinic. What is this series all about? Our goal is to experiment with getting community feedback on different ways that the two node cluster that is running the backend databases for SQLServerCentral.com and Simple-Talk.com… Read more

0 comments, 281 reads

Posted in SQL Aloha on 7 March 2011

March Question: What’s Your Biggest SQL Server Performance Headache?

As DBAs, we have all received a phone call from a database user, asking why the database is so slow. Based on most DBA’s experience, performance is the number one problem users complain about. So for this month’s question, “What’s your biggest SQL Server Performance headache?”, share with us the… Read more

1 comments, 200 reads

Posted in SQL Aloha on 1 March 2011