I won’t be at PASS Summit this year, but that doesn’t mean I can’t give advice to those who will be there. I got an email asking for advice for Summit First-Timers, and after sending over the list of tips, I figured I’d write a … [Read More]
During the course of normal processing in a database, blocking happens. Blocking is “by design” because your database is on ACID. In an OLTP database, most of your transactions are short in duration, so we expect blocking to also be short in duration. If blocking … [Read More]
Unfortunately, due to a change in plans, I’m not going to be at PASS Summit this year, so I won’t be hosting this meetup in 2017. Hopefully, next year the event will be back! Still want to meet up? If you’re bummed that this … [Read More]
I often get asked, “Do you have any of your sessions recorded so I can watch them online?” And the answer has always been, “No, you’ll have to come see me in person.” I’m a tad of a perfectionist, so if I was going to … [Read More]
In this post on SQLPerformance.com, I look into a database performance issue with Microsoft Dynamics CRM, and find a fix that speeds up nearly every database call in the application. If you’re familiar with supporting the database behind Microsoft Dynamics CRM, you probably know that … [Read More]
Last week, SentryOne announced their new PAC Community Ambassador program. I’m incredibly excited to be part of this new program. PAC? Huh? SentryOne doesn’t fuel their monitoring software with power-pellets, the PAC is their Product Advisory Council. This is a group of their users and … [Read More]
Writing a good resume is hard. People will tell you lots of rules about what you should always or never do with your resume. Should you follow those rules? Are things different because of your industry/background/geography/niche? Should you be clever or classic? It depends™. There is … [Read More]
This morning, when I logged into Twitter, the tweet at the top of my timeline was from Shane O’Neill (blog|twitter). It was to his blog post, Shane, What’s wrong with DELETE EXISTS?. It’s not that unusual that Shane would talk to himself in the third … [Read More]
The latest malware to make the headlines is really interesting to me. It’s a ransomware worm called Petya. Ransomware is particularly interesting to me as a DBA, because DBAs are responsible for keeping data safe, and ransomware is specifically designed to destroy your data. I’m … [Read More]
UPDATE: Unfortunately, due to a change in plans, I’m not going to be at PASS Summit this year, so I won’t be hosting this meetup in 2017. Check out details here. Last year, I organized an (unofficial) PASS Summit LGBT Meetup. It was a bit … [Read More]
Copyright © 2018 | Andy Mallon | Content of this site is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. 