Browse the archive
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.
Continue readingQuestion 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 …
Continue readingIn this post, I explain Azure SQL Database DTUs (Database Transaction Units) and the differences you might see between the documentation and practical usage.
Continue readingAs part of my role on the SentryOne Product Advisory Council (PAC), I'm going to occasionally be contributing posts over at SQLPerformance.com
Continue readingA recap of SQLSaturday Boston 2017, including the sessions, people, and work behind the event.
Continue readingQuestion 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 …
Continue readingIn 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 …
Continue readingQuestion I've some logs that I want to extract to a report in order to get the SQL_Agent_Jobs status that runs during the night. If the Job fails then I want to receive the Error Log in a table. I am trying to get that information with this query:
Continue readingI hate RSS readers I love my new bot For some reason, about once a year, I go hunting for a new RSS reader so I can keep track of blogs that I like to read. It’s always the same process: Dig through reviews to find an app that I think I will love. Come up with …
Continue readingQuestion In SQL Server, a non-unique nonclustered index on a rowstore table incorporates the base object’s bookmark (RID or clustering key) at all levels of the nonclustered index structure. The bookmark is stored as part of the nonclustered index key at all …
Continue reading
