Jul 242017
 

I’ll be speaking at two New England area SQL Server user groups in the next few days! First, tonight I’ll be at the Portsmouth, NH, SQL Server Users Group speaking on the newly announced SQL Server on Linux. It’s going to be a blast showing folks that SQL Server on Linux is a viable alternative for businesses out there.

Next, tomorrow night I’ll be at the downtown Boston SQL Server Users Group tomorrow night for a session on Performance Tuning for SQL Server VMs. This session gets a little free-form, as I encourage all attendees to bring your specific questions, challenges, (mis)conceptions, opinions, etc. to the table and let it all out.

RSVP for these events if you’re in the area, and if not, ping me and let me know if your user group would like a presentation on these topics!

 Posted by at 9:11 am
Jul 232017
 

My slide deck from the recent webinar series 24 Hours of PASS, Summit Preview session, where I presented a session called Virtual CPUs: Right to Ludicrous Speed, are now available for you to view up at SlideShare. Let me know if you have any questions! I hope to see you all at the PASS Summit later this year!

Jun 132017
 

PASS has just announced this year’s precon sessions for the PASS Summit in Seattle this October, and I am humbled to announce that my session, “Virtual SQL Servers – Right to Ludicrous Speed” has been selected for one of the Tuesday precon slots. This topic is near and dear to my heart, and I’m thrilled to be able to present to the group advanced SQL Server VM tuning techniques learned from over 16 years of performance tuning.

If you are less interested in SQL Server infrastructure than other topics, I urge you to check out the other precons being presented at this conference. The topics and presenters are world class, and if I was not presenting this precon on Tuesday, I’d be in one of the other precons!

I hope all of you can attend what I consider the best SQL Server ecosystem conference in the world. I’ll never miss it, and I look forward to meeting you all there!

Session Details:

Join this full-day introduction session focused on managing and boosting the performance of a virtualized SQL Server environment. The focus of the course is to help those new to virtualization, infrastructure, and cloud-based infrastructure-as-a-service concepts to become familiar with the concept and purposes of virtualization and how it can benefit them as data professionals. Participants will gain exposure to all layers of virtualization underneath SQL Server, from storage to hypervisor to the SQL Server instance, no matter if on-premises or in the cloud, and will learn how to construct the entire stack with a strong emphasis on SQL Server performance.

Intended Audience
The intended audience of this course is information workers (both business and IT-centric) involved with architecting a virtualization strategy for SQL Server, or managing business-critical SQL Servers that have already been virtualized.

Course Topics
The following topics will be addressed during the course:
• The Physical Infrastructure Underneath the VM
• Storage and SAN Concepts and Design
• Virtualization and Infrastructure Fundamentals
• The SQL Server Virtual Machine
• Networking, Support, and Licensing
• SQL Server Infrastructure in the Cloud
• High Availability and Disaster Recovery and SQL Server
• Performance Investigation and Tuning of the Entire Stack

A working set of the screens and configuration settings referenced in the session, together with the reference slides and documentation, will be provided to attendees, for strategic reference in working with virtualized SQL Server in their own environments.

Register today! Seats are sure to fill up for these precons!

May 162017
 

 

I am extremely proud to announce that we’re holding the second SQL Server workshop at this year’s VMworld US in Last Vegas on August 27th. If your SQL Servers are running in a VMware environment, this course is critical to your success!

This business critical applications and databases pre-conference workshop will cover all pertinent aspects of best practices for deployments and ongoing management of MS SQL Server running in virtualized infrastructure. This deep-dive full-day workshop will be delivered by VMware technical SQL Server specialists working in concert with world renowned external SQL Server and Virtualization experts, including me! The attendee will experience a workshop rich with technical content to include subjects such as SQL Server availability, performance tuning, disaster recovery, and SQL Server VM construction. The content will be focused on best practices for design, implementation and management augmented with anecdotes of successful customer implementations.

SQL Server professionals, listen up. If your infrastructure admins are attending VMworld this year, please let them know about this course. Training them in the intricacies of the VMware platform as it relates to SQL Server, and having the training come from SQL Server professionals, is going to make your virtualization experience better.

Register for VMworld here! This event is going to sell out, so if you or anyone from your organization are going, register soon!

May 082017
 

Starting this week, I’m introducing a new series of blog posts for the SQL Server DBA on how to properly set up and administer a production SQL Server on the Linux operating system.

As you know, Microsoft is shipping SQL Server 2017 (currently at CTP 2.0) with support for the Linux operating system. You might not think you’ll ever use this in your organization, but you might be quite surprised at the adoption rate I’m already experiencing in the wild. You should prepare yourself as a SQL Server administrator for some key similarities and differences with this new platform for tasks such as server build and construction, operating system basics, installation and patching, backups and recovery, availability, etc.

This blog post series is designed to help ramp you up on these tasks and answer common questions for scenarios that SQL Server DBAs will encounter while running SQL Server on Linux. Stay tuned!

 Posted by at 3:12 pm  Tagged with:
May 052017
 

This past week, I presented a preconference session and regular session at this year’s SQL Nexus conference in Copenhagen, Denmark. I highly recommend this conference!

The preconference session called “The Complete Primer to SQL Server Virtualization was well received! The attendees were well prepared for deep discussions on SQL Server virtualization, infrastructure, and cloud XaaS topics, and the questions were wonderful.

The SQL Server on Linux session was also solid and well attended, as we discussed common administration tasks around tasks that are necessary when making the transition to SQL Server on Linux, such as backing up databases and logs to a file share, and how to configure and mount additional disks for objects such as tempdb, database data, and database log files.

The slides for the SQL Server on Linux session are available for you to download here.

SQL Nexus, thank you for a great time! We really enjoyed our discussions and deep-dives with attendees and other speakers, and would be very happy to return next year to this conference!

 

(@sqlreeves getting into American food in Europe)

More @sqlreeves just chillin’ with the ‘Hoff