October 2010 - Posts

• Writing Case Studies to Document Your Impact

  If you don’t know me, or you haven’t followed me for long, you might not know that I am a huge fan of documentation.  I started out in my as a Application and Business Analyst and all I did was document problems, their scope, impact, and resolution.  Read More... Posted Wednesday, October 20, 2010 4:39 AM by Jonathan Kehayias | 2 Comments Filed under: Miscellaneous, Rants and Ramblings

• PASS 2010 Birds of a Feather Lunch

  We are just weeks away from the #SQLPASS North American Summit for 2010 and yesterday. Mike Walsh ( Blog | Twitter ) posted the list of topics for the Birds of a Feather Lunch event that was started last year and has been continued into this year.  Read More... Posted Wednesday, October 13, 2010 10:26 AM by Jonathan Kehayias | 5 Comments Filed under: PASS

• TSQL Tuesday #11 – Misconceptions - The Tempdb Log File and VLF Counts

  This post is part of the monthly community event called T-SQL Tuesday started by Adam Machanic ( blog | twitter ) and hosted by someone else each month. This month the host is Sankar Reddy ( blog | twitter ) and the topic is Misconceptions in SQL Server Read More... Posted Tuesday, October 12, 2010 11:18 PM by Jonathan Kehayias | 2 Comments Filed under: Database Administration, Internals, TSQL2sday

• TSQL Tuesday #11 Misconceptions – Enable AWE on 64bit SQL Servers

  This post is part of the monthly community event called T-SQL Tuesday started by Adam Machanic ( blog | twitter ) and hosted by someone else each month. This month the host is Sankar Reddy ( blog | twitter ) and the topic is Misconceptions in SQL Server Read More... Posted Tuesday, October 12, 2010 1:58 PM by Jonathan Kehayias | 2 Comments Filed under: Configuration, Database Administration, Internals, Memory Allocation, TSQL2sday

• TSQL Tuesday #11 – Physical IO’s Don’t Always Accumulate Wait Times

  It is time again for another TSQL Tuesday, this time hosted by my good friend and fellow MVP, Sankar Reddy ( Blog | Twitter ). This month’s topic is Misconceptions about SQL Server and as Sankar points out in this months, there are so many misconceptions Read More... Posted Tuesday, October 12, 2010 3:13 AM by Jonathan Kehayias | 8 Comments Filed under: Extended Events, SQL Server 2008, TSQL2sday

• Working with the SQL Server Powershell Provider and Central Management Servers from Powershell

  I am a big fan of the Central Management Server setup that exists in SQL Server 2008, as well as how you can leverage this for the Enterprise Policy Management Framework that Laura Rubbelke ( Blog | Twitter ) created on Codeplex.  Today one of my Read More... Posted Saturday, October 09, 2010 12:45 AM by Jonathan Kehayias | 1 Comments Filed under: Powershell, SQL Server 2008, SQL Server 2008 R2

• SQLBits 7 Wrap Up

  Last week I was in Great Britain for SQL Bits 7.  This was the first conference outside of the United States that I have attended, and I was honored to attend SQL Bits 7 as a speaker during Friday’s Sessions.  The city of York is absolutely Read More... Posted Monday, October 04, 2010 1:26 PM by Jonathan Kehayias | 4 Comments Filed under: SQLBits