Ever since I started working on projects involving SQL Server Always On Availability Groups back in 2012, the most common issues I’ve come across with have nothing to do with SQL Server. After my presentation on Architecting SQL Server Availability Groups at the Seacoast SQL Server User Group in New Hampshire, someone approached me […]
When asked about best practices on running multiple SQL Server failover clustered instances (FCI) on a multi-node Windows Server Failover Cluster (WSFC,) a common response from SQL Server experts might include the following: – appropriately allocating enough hardware resources on all of the nodes in the WSFC – appropriately configuring maximum server memory settings […]
[callout]Replace SQL Server DBA with your career or role and the lesson will apply regardless.[/callout] We’ve all followed successful people – rockstars, entrepreneurs, public figures, Hollywood actors, even geeks like Bill Gates or Mark Zuckerberg. I’m sure you’re like me, intrigued as to what made them really successful so you can emulate what they did. […]
And the registration is now OPEN! I’m excited to re-open limited-time registration for my online course Windows Server Failover Clustering (WSFC) for the Smart SQL Server DBA course. Head on over to the main site. Registration for this course will only be available from 23-October 10:00 AM Eastern time to 29-October-2017 10:00 PM Eastern time. After that, you […]
While working on the video ad for my SQL Server Always On Availability Group: The Senior DBA’s Ultimate Field Guide training program, I couldn’t help but take stock of the different skills I had acquired throughout my lifetime to come up with the final result. – started playing piano at 5 – learned how to […]
The Windows Server Failover Clustering for the Smart SQL Server DBA course was created in an attempt to help SQL Server DBAs and server administrators responsible for SQL Server Failover Clustered Instances (FCI) become more confident in what they do. This idea dawned on me as I was talking to customers who are unnecessarily spending money on hardware that […]
I’ll never forget a conversation I had with a customer several years ago. I was asked to join a conference call to discuss a new SharePoint 2013 farm deployment. My involvement was limited to designing and deploying a SQL Server 2012 Availability Group for all of their environments – a different vendor was engaged to […]
Are you up to the challenge? Do you have what it takes to design a highly available SQL Server system? If you need help with your SQL Server Always On deployments, reach out and schedule a call with me using my online calendar. Schedule a Call Subscribe to my mailing list. * […]
You know how it feels like to stare at this for a very long time (I ended up having to wear eyeglasses because of it.) Better yet, try it. Just for 5 minutes straight without blinking. But staring at a computer monitor for a long time isn’t the real issue. It’s the confusion of trying to […]
In a previous blog post, I talked about the benefits of using cluster shared volumes (CSVs) for your SQL Server 2014 and higher failover clustered instances (FCIs). It’s also interesting how SQL Server Microsoft Certified Master and Microsoft MVP Argenis Fernandez (blog | Twitter) responded to a Twitter post I shared about the blog post […]
