Question I am having trouble getting a trigger to work. What it needs to do is to prevent any customer with last name Glass from being inserted into the database. This is what I have: The issue is when I add customers with last name … [Read More]
Question This question was attempted twice on experts-exchange with no real answer. I know that I should not shrink the log file – that is not the question. If you feel like answering that one should not do it- that has been confirmed many times … [Read More]
Question I’m creating a query that has a column of dates stored as a VARCHAR in the format DD-MMM-YYYY. Could you tell me how I can convert this into date format please? I don’t want to alter the original table in any way, as it’s … [Read More]
Question One of our SQL Server 2014 database transaction logs is growing very fast and I cannot find the root cause for this. Database in Simple recovery mode. During full backup the log file grows to its limits (800GB) and backup fails. I checked the … [Read More]
Question We have the ApplicationIntent=ReadOnly properly routing our users to the Secondary ReadOnly replica. Is there a way to make this the default behavior? Apparently the default behavior seems to be ReadWrite, and if you don’t specify an ApplicationIntent it will redirect to the Primary … [Read More]
No, seriously. What is a DTU? When you’re deploying any application, one of the first questions that comes up is “What will this cost?” Most of us have gone through this sort of exercise for sizing a SQL Server installation at some point, but what if … [Read More]
As part of my role on the SentryOne Product Advisory Council (PAC), I’m going to occasionally be contributing posts over at SQLPerformance.com. Today, my first post was published: What the heck is a DTU? SQLPerformance.com focuses on providing innovative and practical solutions for improving SQL … [Read More]
Earlier this month, I got an email with the subject line “Congratulations 2017 Microsoft MVP!” I immediately commenced doing a Snoopy happy dance (my dog, Callie, picked up on the excitement and joined in). If you aren’t familiar with the MVP Program, you might be … [Read More]
SQLSaturday Boston was February 25. I was invited into the organizing team in 2015, and this was my third time helping to put together the event. But this time was different. This time, I was running the show. I wanted to do a quick round-up of some … [Read More]
Question In my environment, I have SQL 2014 with Always On Availability Group for databases in asynchronous with manual fail over. We have 1 primary and 2 secondary replicas–secondary1 and sec2. I have to do failover from primary to secondary1. I know some data loss … [Read More]
Copyright © 2025 | Andy Mallon | am2.co