Benjamin Nevarez is a database professional based in Los Angeles, California and author of “Inside the SQL Server Query Optimizer”, published by Red Gate books. He has more than 15 years of experience with relational databases, and has been working with SQL Server since version 6.5. Benjamin has also been the technical editor of the two latest books by Kalen Delaney including “SQL Server 2008 Internals”. He holds a Master’s Degree in Computer Science and has been a speaker at several technology conferences, including the PASS Summit. Benjamin’s blog is at http://www.benjaminnevarez.com and can be reached by e-mail at admin at benjaminnevarez dot com.
Header image: Samalayuca, Chihuahua in northern Mexico. Picture by Felix Garcia.
Hey Benjamin! I am a SQL Server MVP with a specialization in performance analysis and tuning. I LOVE giving presentations and would like to know if I can have your permission to give your Query Optimizer Topics presentation to various SQL Saturday and SQL Server User Group events. I will not submit to events that you might also attend (but this will be rare anyway since we are on opposite sides of the US). I will also give full credit to you for the material and even include a recommendation that attendees purchase your wonderful Query Optimizer book. Thanks in advance if this is acceptable to you, and no worries if it isn’t!
Best,
Kevin G. Boles
SQL Server MVP
Indicium Resources, Inc.
Hi Kevin,
Yes, sure, you can use the material of my Query Optimizer Topics session for your presentations. I am glad you liked it and I hope you like the book too. If possible, please keep me updated on when you are presenting it.
Regards,
Ben
hi ben, busy attending the sqlpass #83. we couldnt finish the presentation via conference; would it be ppossible for you to mail me you presentation along with your sample scripts so i can complete the session. thanks for a very interesting session.
Hi Willem,
Thanks for attending my session. You can download the PowerPoint and script files from this location
http://sqlsaturday.com/viewsession.aspx?sat=83&sessionid=4325
Regards,
Ben
Hi Ben,
I am working on Hospital datawarehouse in Australia, i want to improve the performance, so i purchased your book, i love it.
The issue i have is i can not locate the AdventureWorks sample that you use in the book,
so i am not getting the same query results and names of objects etc are different that your sample exercises show.
I do have AdventureWorksDW2008 and AdventureWorksLT2008.
Could you let me know where i find the database that you are using in your samples.
thanks
Hi David,
Thanks for your comment regarding my book. Regarding your question, when you run the sample databases installer you have the choice to install the following six databases
AdventureWorks OLTP 2008
AdventureWorks Data Warehouse 2008
AdventureWorks LT 2008
AdventureWorks OLTP
AdventureWorks Data Warehouse
AdventureWorks LT
The code on the book uses AdventureWorks OLTP and AdventureWorks Data Warehouse on this list. I hope this answer your question. Feel free to e-mail me at admin at benjaminnevarez dot com if you still have any question.
Regards,
Ben
Hello Benjamin Nevarez, I thinks it not right to post here such text. But I’m Ugently looking for a writer who is an M.Sc software engineer, MCA , or M.Sc computer science expert with solid knowledge in the field of database and experience in coding , Query optimization solutions and implementations. I need urgent 30 pages, 7days.. Details will be given.
=the above is regarding an academic project.
=i need full project starting from proposal, lit.review to end of project
Please Mention the charges also
Mail me at:
engr.saleemmumtaz91@gmail.com