I’ve been helping troubleshoot a SQL Server 2014 that kind of tips over every hour when a job is run on one of the application servers. All eight cores of the server go through the roof together with the counter for batch requests/sec – and then everything grinds to a halt. This behavior continues for […]
This author has yet to write their bio.Meanwhile lets just say that we are proud alexander contributed a whooping 123 entries.
Entries by alexander
One of the things often overlooked with Azure SQL databases is the fact that they need love in exactly the same way as their on-premises brethren. Sure, Azure will keep an eye out for the most blatant issues, but the old adage “a penny of prevention is worth a pound of cure” still holds water. […]
As you know by now, I do a fair bit of presenting and teaching. One of my primary tools is Powerpoint, and that necessitates a presentation clicker. I’ve been using a Logitech R400 for quite some time, and it does its job admirably. A few weeks ago, a colleague of mine showed me the new […]
Today I hit upon this bug that’s apparently been around for ages. In short, sometimes SQL Server Configuration Manager works as expected when it comes to enabling and disabling specific IP addresses for the instance to listen on, and sometimes you are greeted with a very irritating message telling you that “the specified file is […]
A student of mine had a question about combining data from multiple Excel sheets and doing calculations on the data. I realized I didn’t have a clear-cut answer so I decided to do some digging. The scenario looked like this: I created three excel files, each with a column for name and one for value. […]
On January the 7th I celebrate my 10th anniversary at Atea. I came to be a consultant after 6 years working internal IT at the local university, and let’s just say consulting was a bit of a… change in pace. At the university I was responsible for everything that was spelled Oracle or SQL Server […]
This is my contribution to this month’s T-SQL Tuesday, this time hosted by Andy Yun. I was sitting calmly in a session at PASS Summit 2016 listening with only one ear. I was using only one ear as I was busy contemplating the many ways the speaker’s presentation skills could be improved. Teaching and presentation skills […]
Custom Query Store Performance Dashboard
Who owns your availability groups?
PASS Summit 2016 was a week ago, and I’ve tried (unsuccessfully) to put my thoughts into words. I’ve read many excellent blog posts about the conference and I wholly agree with them all, but I wanted to articulate my feelings in a blog post of my own. PASS Summit 2016 was my third Summit on […]