I recently had a great question on some of the differences in virtual machine disk presentation from one of our amazing clients, and I thought I’d share the answer here because it’s a common question that I receive.

Some hypervisors (including some hyper-converged compute platform vendors who shall remain nameless) do not give you much flexibility in the way storage is presented to a VM. You pick the VM and click to add drives. That’s it. No knobs to turn, no mess, no fuss. It’s meant to be easy, and for almost all situations, that’s just fine.

But, that might not be the completely optimal way to configure a VM that is hungry for I/O (such as a large SQL Server), if you have the option to configure it a bit more closely.

I’m thrilled to have contributed a blog post on how SQL Servers, VVols, and Pure Storage’s unique implementation of VVols combines to make SQL Server DBA jobs better over at Pure’s blog. Pure’s implementation of VVols is simplifying our world and improving our ability to support our businesses. Read more on it here!

Next in our SQL Server on Linux series is one important question. On Windows, if you’re about to run out of space, you get your VM admin / storage admin to expand one or more of your drives, and you go to Disk Management and expand the drive with no downtime. How do we accomplish this same task on Linux?

I want to wish you a very happy new year! Twenty-seventeen has been an incredible and exciting year for our company, our customers, and ourselves. I had an absolute blast traveling and speaking at a number of different events in 2017, including SQL Nexus, Pure Accelerate, VMworld (USA and EMEA), P21 Connect, PASS Summit, and too many SQL Saturdays and SQL Server User Groups to mention.

We all know that the world continues to change in front of our eyes, especially with the seismic shift from on-prem computing to cloud-based computing, and as it changes, so should we. All of us in the SQL Server community need to start to embrace the cloud, even if our day jobs are not yet ready. As the world shifts to the cloud, our jobs and our roles evolve. Automation, AI, data science, HA/DR – all are critical changes you should re-learn as the database landscape transforms in front of us.

We at Heraflux have set our sights on a new chapter of innovation for 2018, so stay tuned for some exciting announcements over the next few months!

Times are certainly changing with Microsoft’s recent announcement to adopt the Linux operating system with the SQL Server 2017 release, and you should be prepared to support it. But, what is Linux? Why run your critical databases on an unfamiliar operating system? How do I do the basics, such as backing up to a network share or add additional drives for data, logs, and tempdb files? This introductory session will help seasoned SQL Server DBAs understand the basics of Linux and how it differs from Windows, all the way from basic management to performance monitoring. By the end of the session, you will be able to launch your own Linux-based SQL Server instance on a production ready VM.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.