As a DBA, we have the opportunity & responsibility to build highly available database platforms for use by applications & users. Even if you are a DBA at a small company supporting databases for only internal applications, we are usually still responsible for providing databases … [Read More]
Microsoft is going to be running a virtual hackathon, running from October 12 through November 20. The theme of the hack will be to use Microsoft Azure to address some social justice issue. I’m thrilled to be joining the judging panel for this event, which … [Read More]
Earlier this week, I published a post about a proposed Tech Community Equality Index, and used it to grade the largest organization in the data community, PASS. One of the areas where I was critical of PASS is that their Anti-Harassment Policy (AHP) is not … [Read More]
Over the last weeks & months, I’ve had an increasing number of conversations with folks on the topics of diversity, inclusion, equality, and justice. These discussions we have with coworkers, members of the data community, family and friends are all valuable, and help us look … [Read More]
Lots of folks want to be an ally to the LGBTQ community, but don’t know where to start. One great way to be an ally is relatively low-friction. List your pronouns. Everywhere. Put your pronouns in your social media profile & your email signature. Edit … [Read More]
This month’s T-SQL Tuesday is hosted by Kenneth Fisher (blog|twitter). Kenneth asked us to talk about any non-SQL tips and tricks we have. I’m going to take the moment to give some tips on how (and why) you can help fight bigotry, racism, and racial injustice.
Last year was the 50th anniversary of the Stonewall riots, which mark the start of the modern LGBTQ rights movement in the US. In the subsequent half century, the queer community has made significant strides in our march towards equality. Sodomy laws were struck down … [Read More]
SQL Server 2005 introduced Dynamic Management Views(DMVs). Technically, there are both views & functions–DMVs & DMFs, but colloquially they’re often simply referred to as just “DMVs”. DMVs simply return information about the state of the server or database and can be used for monitoring and … [Read More]
We’ve all been there. You’ve got a query where the JOIN or WHERE predicate is not SARGable. You’ve read about how this can be a problem, and how bad it is for performance. Alas, you cannot change the query. Sometimes this reason is political, sometimes … [Read More]
Assume you have configured a transactional replication publisher, which is part of an availability group (AG). Now, you have an asynchronous secondary AG (or mirroring) replica that is offline. Perhaps this is a DR node, and you are doing patching or other planned maintenance on … [Read More]
Copyright © 2023 | Andy Mallon | am2.co