Viewing 15 posts - 91 through 105 (of 2,497 total)
Start with the RTO and RPO of the databases. This will guide you on the backup scenario you need. Having the databases in an AG makes no difference to what...
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
September 29, 2023 at 10:09 am
Things are a lot easier with Enterprise Edition. IMHO the HA capabilities of EE make it worth paying the additional price. Trying to roll your own stuff compared to having...
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
September 25, 2023 at 6:12 am
By now I hope you have read about what a CXSYNC_PORT wait is. If not please do so.
The situation described for this wait type did exist in SQL2014, but was...
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
September 1, 2023 at 5:42 am
Removed, 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
August 16, 2023 at 6:35 am
Back in the day (1981) I developed a code generator for the place where I worked, for a mainframe online app.
Simple in some ways but very helpful, it would modify...
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
August 16, 2023 at 6:34 am
It is also worth putting near the start of your documentation a warning sbout risk.
Explicitly say that anyone trying to deal with DR who does not already have practical experience...
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
August 4, 2023 at 10:01 am
I guess your client may be looking at workload and thinking Standard Edition will do.
Both they and you should look at BCO and what SLAs they want for RTO 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
July 19, 2023 at 7:34 am
One of the nice things about replication is that you can turn off just about all errors on a case by case basis. It should therefore be possible 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
July 19, 2023 at 7:27 am
"In theory, theory and practice are the same. In practice they are not" - A Einstein
The biggest issue you will face going forward, as Steve says, is scaling. 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
July 19, 2023 at 7:12 am
Doing things manually may be the way to go. When I first got the dlink over a decade ago it really helped by providing off-box storage. There are so many...
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, 2023 at 2:19 pm
No recommendations on hardware. Maybe you can pick up another dlink box on ebay.
Some years ago I replaced the OS on my dlink box with Alt-f, mainly to get support...
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, 2023 at 6:01 am
As Ant says, this is definitely possible. The process is the same as installing yhe first SQL node on a multi-server cluster.
What problems are you getting?
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
June 30, 2023 at 7:57 am
If a temp table or a CTE or a table variable holds more data than can be held in memory than it will write to tempdb. That is the way...
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
June 28, 2023 at 6:33 am
As everyone else has said, test everything.
Expect to find some breaking changes, be it functionality or performance. It always happens between major releases, so nothing new in this concept. 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
June 23, 2023 at 8:58 am
I am guessing that your users are trying to connect using https://servername...
At my old place we set up a DNS alias for SSRS/PowerBI and got our users to connect simply...
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
June 23, 2023 at 8:37 am
Viewing 15 posts - 91 through 105 (of 2,497 total)