Thinking outside the DBA box.
As you may have seen I have joined the team (Andrew Pruski, Mark Wilkinson, and Anthony Nocentino) that pulls together the EightKB conference. This team did a tremendous job during Covid of pulling together a conference that was completely virtual and covered deep technical content. It is a small ...
Availability Groups are awesome but what is not awesome is having to restore all the replicas within an availability group. At minimum you will have to restore two databases instead of one, maybe even more. When you do have to restore an entire availability group, for example when you need to ...
So yes I work for a storage company and I am passionate about latency for databases. Does it fix bad code? No. Is it the be all end all for performance? No. But storage historically has been the biggest infrastructure bottleneck for databases. So ignoring storage from my perspective is a mistake. ...
Well November was very busy and I am behind on some announcements. I was honored this past November when I was asked to become an Idera Ace class of 2020! I tweeted out a congratulations to all of my fellow Aces. So congratulations everyone one more time, I am honored to be with such a great group! ...
So recently while talking at SQL Server Saturday Chicago, I had a discussion with a DBA who was having huge performance issues with his database. The problem? All of the queries were being sent to the database as NVARCHAR and not VARCHAR. What is the issue with this may you ask? Well every single ...
Database statistics is a subject near and dear to my heart. As an Architect and consultant I have come across statistics issues quite often. You may ask why would you come across statisticsstatistics issues? Here is a list of the most frequent reasons.statisticsDatabase statistics is a subject ...