Browse the archive
Question I wrote a script that reads job schedules from msdb.dbo.sysschedules and runs sp_update_schedule to change the active_start_time for a given subset of jobs. In each case, sp_update_schedule fails with the message "The specified @schedule_id('xxx') …
Continue readingIn yesterday’s post, I showed how to configure an availability group (AG) to use the RegisterAllProvidersIP=0 when you can’t get clients to connect using the MultiSubnetFailover=true connection string attribute. I mentioned that you have to make some …
Continue readingAs 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 …
Continue readingAn invitation to Microsoft’s social justice hackathon and ideas for technology projects that can support justice.
Continue readingQuestion i am running sql server 2019 on Linux box and trying to connect using a Windows server 2016 client, how can we enable TLS 1.0 for SQL Server 2019 on the Database/instance level. TIA. Asked2020-09-25byRafay Pervaiz Answer TLDR You don't.
Continue readingQuestion SQL Server was restarted by mistake, when it came online, database came back in "In Recovery" mode. Check from error it says "Recovery of database 'DB1' (5) is 8% complete (approximately 27146 seconds remain). Phase 2 of 3. This is an informational …
Continue readingQuestion I've been handed a graph that comes from SolarWinds showing top wait events broken down by day. The last 2 days there's a part of the daily color coded bar representing a total of 3 hours for ASYNC_NETWORK_IO. Still trying to see if I can get access …
Continue readingOver 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, …
Continue readingQuestion (This is just a "reproducer", not the real code, because that's long and complicated.) The output of SET NOCOUNT ON select @@SERVICENAME select @@version is: ----------------------------------------------------------------------------- MSSQLSERVER …
Continue readingQuestion I'm working on a web app which is using SQL Server Express (Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 6.3 (Build 18362: )).
Continue reading
