Viewing 15 posts - 16 through 30 (of 2,451 total)
You can use backup and restore to move the SSRS DBs. Each time SSRS starts up it checks a SSRS DB version number against the desired number and automatically upgrades...
July 17, 2024 at 7:05 am
If DC1 is being shut down after the failover (or simulated being down by cutting the network) you will need to remove it from the AG after failover.
Thus is because...
July 17, 2024 at 6:54 am
It can also work the other way round. I am currently helping a vulnerable adult with a financial issue. A few days ago I was copied in an email saying...
July 13, 2024 at 6:52 am
I have worked in computer security in the past, done some computer forensics, and all employers from about year 2000 required me and all other staff to do regular security...
July 13, 2024 at 6:25 am
If you do decide to go to SQL 2022 Std then you will have to do a migration, not an upgrade. There is no capability in SQL Server to upgrade...
July 12, 2024 at 5:50 am
The quickest way to rebuild an index is to not do a rebuild. Zero time.
An index rebuild takes slightly disorganised data and organises it nicely with some free space to...
July 10, 2024 at 6:14 am
I am worried that your admin is suggesting using nolock. It suggests they have a limited understanding of how a relational database works, especially SQL Server.
The posts above give the...
May 27, 2024 at 5:54 am
As Joe said, quoting Brent, what problem are the developers trying to fix.
The first thing in any troubleshooting situation is to articulate the problem in neutral terms. If it is...
May 22, 2024 at 6:26 am
I must have worked in some very strange places. This issue of observability has been buzzing around since at least 2000.
Back then I was at BMC software who sold and...
May 22, 2024 at 5:53 am
Sorry, duplicate post
May 10, 2024 at 5:24 am
Sorry, duplicate post
May 10, 2024 at 5:23 am
Since about 2020 I have used 2 x 4k monitors, each being 28". In theory this gives 4 times the display capability as 2 x 2k monitors, but my eyesight...
May 10, 2024 at 5:22 am
A scripted install of SQL Server is far from easy, particularly when clustering is involved.
SQL FineBuild will do this for you, and do a lot of subsequent configuration if you...
April 17, 2024 at 4:08 pm
At the moment it looks like AW is not doing its job. Instead of alerting you about problems it is just giving errors. You definitely should escalate this to get...
December 30, 2023 at 10:35 am
The text of the original post implies to me that the delivery team are new to the technology and have a very big system to implement.
If so then you need...
December 20, 2023 at 7:09 am
Viewing 15 posts - 16 through 30 (of 2,451 total)