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]
In SQL Server Reporting Services (SSRS), you can configure the sender address for email subscriptions at the instance level. This means that every email sent from your SSRS server will come from the same address. (On each subscription, you can optionally supply a Reply-To address, which allows … [Read More]
Copyright © 2024 | Andy Mallon | am2.co