Viewing 15 posts - 841 through 855 (of 2,497 total)
In general Microsoft support using SSMS on downlevel version only for those versions that it supports an upgrade from. Typically this is the -1 and -2 versions, which for...
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
October 18, 2011 at 4:07 am
I would caution aabout signing about data integrity. Unless some mechanism in place that can affirm that the data you retrieve today is exactly the same as the data...
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
October 17, 2011 at 6:56 am
If you are new to clustering, take a look at SQL FineBuild. This can install SQL Server as clustered or unclustered. For a cluster install it can also...
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
October 12, 2011 at 7:53 am
Be aware that revoking Public access to all objects may break SQL Server and take you outside of Microsoft support.
The DoD documentation makes it clear that you should not just...
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
October 12, 2011 at 7:45 am
Full text indexing has some built-in word breaking features that you cannot override. For example, the string 'BigImage+16:9+FP' is broken down into the tokens: bigimage, 16, nn16, 9, nn9,...
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
October 11, 2011 at 2:55 am
Where does your company want to spend its money? On isolating the impact of SharePoint in its own Windows instance or in the extra admin cost of running everything...
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
October 11, 2011 at 2:38 am
SQL Server uses what is called a 'shared nothing' approach to clustering. If you have Instance 1 running on node A then it has exclusive use of the databases...
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
October 4, 2011 at 4:31 am
If you aer getting a 'developed world' level salary, then probably the best GBP £200 you can spend is on a TechNet subscription. This provides you with all 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
October 4, 2011 at 4:13 am
The security permissions documented in the FineBuild reference manual will cover the OS side of your requirements. One of the principals used in FineBuild is that nothing should need...
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 28, 2011 at 3:38 am
If you have multiple instances of SQL Server, then you need a <ServerName> node that describes each instance. I am not sure the question makes this clear.
If you use...
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 28, 2011 at 3:17 am
I have found problems when I install a SQL 2008 R2 cluster followed by applying SP1. What I always do now is build a slipstreamed install media set containing...
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 27, 2011 at 4:50 am
It is now considered best practice on W2008 and W2008 R2 to have a separate instance of MSDTC for each node that will be active in a cluster. This...
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 26, 2011 at 6:57 am
The SQL Agent account is the first account checked by the SQL install process.
If there are any issues in performing authentication with Active Directory, then this will be...
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 26, 2011 at 6:20 am
All SQL instances will have their own master and resource databases. Both databases are updated when you apply a SP or CU, and need to be at the same...
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 26, 2011 at 5:33 am
My advice: Put Master back to its original location and leave it there.
There are no data integrity or performance advantages in moving master or modfel DBs. All you do...
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 26, 2011 at 5:17 am
Viewing 15 posts - 841 through 855 (of 2,497 total)