Viewing 15 posts - 1,216 through 1,230 (of 2,497 total)
A bit off-topic, but I am interested in knowing what benefits you see in C2 logging, and who in your organisation is requesting that you do this.
The DOD TCSEC standard...
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 8, 2009 at 5:04 am
You should plan to have an Administration server, that just has the SQL client tools installed. You then register all your SQL instances to SSMS (or other preferred tool)...
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 7, 2009 at 5:27 am
You can get very effective encryption within SQL Server.
You can achieve complete PCI compliance using an in-house application using SQL Server.
You potentially add a very large risk to your organisation's...
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 14, 2009 at 3:31 am
You can also focus on accurracy and consistency.
With multiple people having their own spreadsheet, each person has their own version of the truth. Each person is likely to defend...
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 14, 2009 at 3:17 am
If you want to be pedantic, you can say Yes, multiple instances can all listen on the same port.
But you will only be able to connect to the first instance...
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 14, 2009 at 3:03 am
One problem with any fill factor value is that it is linear and disruptive activity is often skewed.
This means you are inserting an I-O overhead into relatively stable portions of...
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 14, 2009 at 2:56 am
The problem is most likely nothing to do with 32-bit or 64-bit, but wher your data is within the SAN. Each of your servers will have its data located...
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 13, 2009 at 6:34 am
There is a big difference between using the xp_cmdshell proxy and SQL 2005 subsystem proxies.
The xp_cmdshell proxy results in one set of rights for everyone who uses it. It...
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 12, 2009 at 9:40 am
My understanding is that if you need to connect to SQL using the 32-bit JET provider and you are on a 64-bit box, then you are between a rock 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
August 12, 2009 at 6:50 am
I agree with SQLGuru. You should time-box your tuning efforts.
If you have not fixed the problem by then, getting a SQL expert could have the problem fixed...
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 11, 2009 at 9:15 am
You need to create the xp_cmdshell proxy account.
The FineBuild Reference Manual has step-by-step guidence on how to do this, and the security implications involved. You can get FineBuild from...
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 11, 2009 at 5:45 am
Ther are a number of ways you can add the 'Log on as a Service' right, and Service Manager is one of these.
However, if your site is controlling account rights...
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 11, 2009 at 5:39 am
Can you elaborate please?
Sorry, my memory seems to be changing from accessible to random... this applied to a different RDBMS.
TheSQLGuru is right in saying in SQL Server, MAXDOP 0 means...
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 10, 2009 at 6:34 am
MAXDOP 0 is often bad news. This allows SQL Server to produce a plan that does not take into account the resources on the box. I have seen...
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 10, 2009 at 4:37 am
You say you have asked for 7GB AWE memory on a 8GB box. Do you have the message at SQL startup that says you have allocated this memory? ...
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 10, 2009 at 4:07 am
Viewing 15 posts - 1,216 through 1,230 (of 2,497 total)