“Today’s DBAs have responsibilities that go far beyond their traditional role of data custodian.” I was reading the infographic that Idera published about their accidental DBA survey results last week and wasn’t surprised at all by the results. I considered myself an accidental DBA when I was starting out in the industry and can […]
In a previous blog post, I talked about Partition-Level Online Index Operations in SQL Server 2014 and how it affects high availability and disaster recovery. With more features being added in every new version of SQL Server, it’s important to understand how its implementation will affect your overall objectives. One feature that got a lot […]
“Only wimps use tape backup: REAL men just upload their important stuff on ftp, and let the rest of the world mirror it” – Linus Torvalds – I really don’t have a clue whether that quote was intended as a joke or not but that’s beside the point. If you’ve worked in the IT industry for a […]
Failing to plan is planning to fail Designing and deploying high availability solutions takes a lot of preparation and planning. Whenever I do presentations that involve demos of creating SQL Server failover clustered instances (FCIs) and Availability Groups (AGs,) I emphasize that while the demo only takes less than 20 minutes to complete, it takes […]
One of the cool features introduced in SQL Server 2014 was the ability to perform an online index rebuild of a single partition. Prior to SQL Server 2014, the only way to rebuild indexes for a partitioned table was to do it on all of the partitions (or, simply put, rebuild the entire index on […]
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 […]
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.
