Viewing 15 posts - 901 through 915 (of 2,497 total)
FWIW, FineBuild will create a low privilige SQL Login to be the database owner account.
The account is marked as disabled. A job is created to run once...
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 8, 2011 at 4:11 am
Are you sure you are installing the tools for SQL 2005? You mention Powershell and VS2008, which makes me think you are installing tools for SQL 2008. If...
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 7, 2011 at 2:38 am
i'd ask for an install document. no doubt you will need to setup logins, agent jobs, deploy scripts etc...... ?
I completely agree. If you do anything without having read...
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 6, 2011 at 4:09 am
It is bad practice for a SQL Agent proxy account to be a local administrator. The aim should always be to minimise the rights granted to a proxy account.
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
June 6, 2011 at 3:05 am
I do not know if error message 29512 is deliberately displaying the account name in the form account@domain or merely showing the account in the form in which it has...
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 1, 2011 at 6:45 am
I think there are 2 things you should do.
1) Set a maximum memory value for SQL Server. If you do not do this then buffer pool memory can swamp...
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 31, 2011 at 3:48 am
Thanks Gail :cool:. Just after I clicked Post I realised I had got this wrong. I have gone back and fixed my posts.
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 25, 2011 at 2:48 am
didn't want the OP to think RowVersion is a DateTime
Due to a stange decision in the history of SQL Server, the data type known as DateTime Timestamp does not...
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 25, 2011 at 2:40 am
Nice one John!
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 24, 2011 at 8:02 am
To avoid doubt, Agile does not mean deliver whatever state it is in. There is a lot of rigour around Agile so that you only deliver what is working,...
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 24, 2011 at 7:56 am
I have worked in commercial IT since 1974 and have seen many approaches to getting applications delivered. The agile methodology using Scrum (and its variations) is by far 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 24, 2011 at 4:03 am
I have put this information in the FineBuild reference manual. The best download if you just want this information can be found at http://sqlserverfinebuild.codeplex.com/releases/view/65785
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 23, 2011 at 4:57 am
The SQL Server service account never needs to be a local admin. Many people make it a local admin because they don't want to spend the time to look...
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 23, 2011 at 4:15 am
Row versioning and version store are different things.
Row Versioning is what happens to rows. Every change to a row changes the row version Id.
Row versioning has been...
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 23, 2011 at 4:03 am
My approach would be to do a standard side by side build and test of the new server.
When it comes time to put the new server live, go...
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 18, 2011 at 6:45 am
Viewing 15 posts - 901 through 915 (of 2,497 total)