Viewing 15 posts - 886 through 900 (of 2,497 total)
You will be lucky to get the install running on only 25 GB. And if you do then you have no space available for service packs, windows fixes, etc.
I...
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 18, 2011 at 4:00 am
Your auditors need to be educated that the Guest login is needed for system databases and should result in a red mark if it is NOT present. This may...
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 18, 2011 at 3:54 am
I cannot see anything obvious to me why the install has failed.
There are a number of other products that can install SQL Native Client. Some of them may 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
July 12, 2011 at 4:01 am
The Filestream hotfix is KB937444.
I see you are trying to install SQL Italian language version on to Windows 2003 Italian language version. It is worth looking in the file...
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 11, 2011 at 4:02 am
Sometimes things are not working the way they should and you have to go behind the scenes to fix it. For example fixing satellites[/url]
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 5, 2011 at 9:35 am
There are various ways the the ownership of system databases can be changed away from sa.
The most common is if you move a system database and use 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
July 5, 2011 at 3:41 am
add these 2 accounts in the server local administrator group
There is no need for any SQL Server service accounts to have local administrator authority (unless you are running SQL 2000...
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 5, 2011 at 3:06 am
It is normally a bad idea to move the system databases (apart from tempdb and (maybe) msdb). There are no performance or integrity reasons for moving these DBs, 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 4, 2011 at 6:55 am
You may be interested in SQL FineBuild. This allows you to do an install and best-practice configuration of SQL Server in a single click.
If you are planning to install...
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 4, 2011 at 6:42 am
At my old place they located the UPS in the server room and ran everything via the UPS. One evening one of the battery packs failed and the UPS...
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 4, 2011 at 4:31 am
Your experience in moving Model is one of the reasons why best practice says do not move master, model or system resource DBs. There are NO integrity or performance...
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 4, 2011 at 3:29 am
As some people have already said, not all Countries have the concept of State. San Merino, Vatican, Andorra are all internationally recognised countries, but have a very limited sub-division...
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 14, 2011 at 3:01 am
One of the big lessons of the last 10 years for the traditional database community has been the emergence of the NoSQL movement. Whatever you think caused this 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
June 13, 2011 at 9:11 am
Why are you going for SQL Server 2005, which is now so old it is out of support? It would be better to look at SQL Server 2008 R2,...
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 13, 2011 at 3:18 am
If this is a crucial box then stop treating it as a playground!
You might be doing things with the best intentions, but if you have a crucial box then 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 8, 2011 at 4:17 am
Viewing 15 posts - 886 through 900 (of 2,497 total)