Viewing 15 posts - 61 through 75 (of 2,497 total)
I would go with Jeffrey Williams answer.
If you use backup/restore as part of your resyncronisation strategy then you must apply all transaction log backups taken since your original backup when...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
July 24, 2024 at 6:36 am
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...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
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...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
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...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
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...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
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...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
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...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
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...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
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...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
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...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
May 22, 2024 at 5:53 am
Sorry, duplicate post
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
May 10, 2024 at 5:24 am
Sorry, duplicate post
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
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...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
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...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
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...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
December 30, 2023 at 10:35 am
Viewing 15 posts - 61 through 75 (of 2,497 total)