Platinum Sponsor
Robert_L_Davis.jpg

Robert L Davis

Robert L Davis is a SQL Server 2008 Certified Master and an experienced Database Administrator, SQL Server evangelist, speaker, writer, and trainer. He has worked with SQL Server for more than 13 years, and recently started his own consulting company, SQL DBA Master. He recently served as a Sr. Product Consultant and Chief SQL Server Evangelist for Idera Software. Prior to that he served as Program Manager for the SQL Server Certified Master Program and as a production DBA at Microsoft. Robert helped found the PASS Data Architecture Virtual Chapter, was the primary author of "Pro SQL Server 2008 Mirroring," and was a Charter Member of the Idera ACEs program. He often speaks at SQL Server events and writes articles and product reviews for SQL Server Magazine. Robert is married, has two German Shepherds, and is an avid writer, blogging about SQL Server at http://www.SQLSoldier.com and writing horror fiction. You can find him on Twitter as @SQLSoldier.
http://www.sqldbamaster.com http://feeds.feedburner.com/Sqlsoldier?format=xml

Blog posts RSS

Bug: sys.dm_db_session_space_usage Reporting Extremely High Tempdb Allocations 21 May 2013
A little more than a year ago while working at Idera, I was consulted on reports from a few clients using the Idera monitoring tool SQL diagnostic manager (SQLdm). SQLdm was reporting very high numbers for internal object allocations (internal_objects_alloc_page_count) and very low numbers for ...

T-SQL Tuesday #41 – Presenting Comes Full Circle and I Love It! 09 Apr 2013
It’s time for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday is one of the greatest assemblage of geeks since the Tri-Lambda and Alpha-Mu mixer … this week. T-SQL Tuesday #41, hosted this month by Bob Pusateri (Blog|@SQLBob). You are invited to visit his ...

Network Packet Size: to Fiddle With or Not to Fiddle With 27 Mar 2013
A network pipeline isn’t nearly as pleasant to look at as the oil pipeline (or anything) in Alaska, but it’s something that DBAs should be aware of. There is a server configuration in SQL Server that controls the size of packet in which SQL Server sends out data. This setting is called ...

Day 31 of 31 Days of Disaster Recovery: Backup and Restore of the Resource Database 24 Mar 2013
It has been a long journey to the final day my 31 Days of Disaster Recovery series, but we have finally reached the final post, day 31. My final topic for the series is born out of a conversation I had today with my good friend and fellow DBA, Ed Watson (blog|@SQLGator). today, I want … ...

Day 30 of 31 Days of Disaster Recovery (T-SQL Tuesday #40): Using Partial Availability and Initialize from Backup to Replicate a Partial Database 12 Mar 2013
It’s been a tough and long road to 31 Days of Disaster Recovery. It’s been very difficult coming up with quality topic ideas for the series as we near the end. For day 30 of the series, I am combining a post on performing piecemeal restores with a post on filegroups for T-SQL Tuesday ...