Viewing 15 posts - 1,066 through 1,080 (of 2,497 total)
If I was really malicious...
I've worked in places where doing all of that without getting management approval and a second opinion (even in the middle of the night) would 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
February 9, 2010 at 4:42 am
Problem is, they're local admins--they can get round stuff like that!
True for NT4, don't know for Windows 2000, but not true for Windows 2003 and above. There are lots...
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
February 9, 2010 at 3:58 am
I think you are outside of Microsoft license terms, and that you need to use the appropriate edition for your workload.
If you are not sure, speak to whoever manages Microsoft...
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
February 9, 2010 at 3:48 am
I agree with George.
All site requirements (should) exist to improve reliability, availability or performance. Any sensible set of site requirements should include a requirement to leave 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
February 9, 2010 at 3:44 am
Although it is right that people with high-level rights are trusted, it is also important to verify they are not abusing that trust.
In most installations where trust is an important...
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
February 9, 2010 at 3:32 am
I am not sure if the left hand talked to the right hand at Microsoft.
A command line install of a SQL Server service pack is a standard feature....
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
February 8, 2010 at 7:24 am
My understanding of Oracle RAC is that is is a 'Shared data' scaleout. There is nothing equivalent in SQL Server, the closest is the 'shared nothing' scaleout offered by...
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
February 8, 2010 at 6:26 am
To add to Steve's reply, the groups you refer to are created by the SQL Server install process and are part of the standard Microsoft security configuration.
It is technically possible...
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
February 8, 2010 at 4:22 am
What problems and messages do you get when you try to do an unattended SP install? This can be made to work without intervention (see FineBuild 2.1 for an...
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
February 8, 2010 at 2:43 am
As many people have said, it is (probably) not possible to prevent someone with local administrator authority from starting SQL Server in single user mode and then working as a...
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
February 4, 2010 at 3:03 am
You are on the limit of what will work if you have 16GB RAM and /3GB switch in boot.ini
By using the /3GB switch you are restricting Windows to use only...
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
February 2, 2010 at 3:10 am
After you have restarted SQL Server in single user mode (as described above) you can add the login BUILTIN\Administrators to get your access rights back.
It is best practice to set...
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
February 2, 2010 at 2:48 am
I'll second the warning that if D-T is not configured correctly it can be a cause of problems. But I will also say that when it is configured correctly...
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
January 28, 2010 at 7:12 am
Are you saying that when you run from a command prompt the package works correctly about 1900 times and you get the expected data from DB2 then it stops 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
January 26, 2010 at 3:27 am
I would add:
Document the problem you are trying to solve. Then identify which of the HA solutions is the best fit for your problem.
Sometimes Clustering is the right answer,...
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
January 26, 2010 at 3:17 am
Viewing 15 posts - 1,066 through 1,080 (of 2,497 total)