But I’ll tell you what hermits realize. If you go off into a far, far forest and get very quiet, you’ll come to understand that you’re connected with everything. – Alan Watts – WARNING: There will be a ton of acronyms in this blog post. Make sure to keep your notebook handy for note-taking […]
I like writing step-by-step guides because they make good documentation for folks like me who keep forgetting how to do things. The guide makes the process repeatable and can easily be shared with junior members of your team. But with the different ways we consume information nowadays, written documentation does not suffice anymore. Besides, providing different […]
This is a question that I regularly ask those attending my high availability and disaster recovery presentations: is your SQL Server Always On Availability Group really highly available? Now, don’t get me wrong. I love the Always On Availability Groups feature in SQL Server (except for the price tag of an Enterprise Edition license.) But […]
I keep highlighting that it is necessary for DBAs to understand the underlying infrastructure as it helps when it comes to resolving issues. I was having connectivity issues with my SQL Server 2019 instance as sqlcmd is throwing this error HResult 0xFFFFFFFF, Level 16, State 1SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].Sqlcmd: Error: […]
This last weekend, I had the opportunity to speak at SharePoint Saturday Montreal – being one of the few English speakers for the event – on the topic of SQL Server high availability and disaster recovery options for SharePoint. After my presentation, one of my SharePoint MVP friends approached me about a database corruption issue that happened on […]
I previously wrote about Data Types and How They Affect Database Performance which was a way to get database developers to think about the small things that affect overall performance. As a high availability and disaster recovery (HA/DR) professional myself, I like to think of how data types affect database availability and recoverability. The fact […]
It is a reality for a lot of customers – they still have SQL Server 2005 in their environments. It is only now that they are planning for upgrading their databases to the latest version of SQL Server. In a previous blog post, I talked about how to integrate Microsoft Product Lifecycle and Support Policies into […]
One of the demos that I show when I talk about AND dependencies in a Windows Server Failover Cluster is moving a SQL Server resource group (or role as of Windows Server 2012 and higher) to a different cluster node. During the failover, I highlight that the SQL Server cluster resource will not come online until […]
While promoting my online virtual class a few days ago, several people asked me about a module that caught their attention – The Lion, The Switch and The Wardrobe. The title of the module was based off of one of the Narnia movies. Since it caught their attention, I started explaining the contents of the module in […]
There are two common types of backups performed on SQL Server databases. The first is the native backup type that is commonly taken using either the out-of-the-box database maintenance plans or a custom backup script. The second type is that which is taken by third-party backup tools – be it an enterprise-wide backup tool or a SQL […]
