Viewing 15 posts - 751 through 765 (of 2,497 total)
If you use Ssyprep for building your OS images then take a look at SQL 2012 Sysprep build. This integrates with the OS sysprep process to allow you 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
April 2, 2012 at 3:34 am
Have another look at Joe Clifford's post. If you do not know your RTO and RPO then you are very unlikely to build a DR solution that matches 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
April 2, 2012 at 3:25 am
The memory counter SQL Server Target Memory shows SQL's assessment of what would be the ideal setting for Max Memory for the given workload.
If the target memory is higher than...
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
March 26, 2012 at 6:32 am
As already said, read the links in the posts. Also check this link http://blogs.technet.com/b/askcore/archive/2009/02/18/how-to-configure-multiple-instances-of-distributed-transaction-coordinator-dtc-on-a-windows-server-failover-cluster-2008.aspx
SQL FineBuild can take a bare metal Windows cluster and install a SQL cluster. 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
March 26, 2012 at 4:11 am
you cant spread out the writes
Not strictly true. You can spread out the writes:
1 By very careful setup and operation of P2P. You need to assign ranges 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
March 26, 2012 at 3:56 am
Budget is the best reason
If your site has Service Assurance, then after your next SA review all your SQL instances will 'benefit' from the SQL 2012 licensing model. 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
March 19, 2012 at 8:54 am
I cannot remember which of these is SQL 2005 and which is SQL 2008...
You can get a record of P2P conflicts to be directed to a table. You can...
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
March 19, 2012 at 8:50 am
A few things about AWE...
The memory allocated as show in Task Manager always relates to memory used beklow the 4GB line. It is not aware of any memory allocated...
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
March 19, 2012 at 7:07 am
Changing a server name after SQL is installed takes time and money. Changing a SQL instance name also takes time and money. If you have already deployed 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
March 19, 2012 at 5:15 am
Having been involved in the SQL 2012 TAP program and tested numerous private and public releases, I am happy that SQL 2012 RTM is ready for Production use.
We...
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
March 19, 2012 at 5:00 am
You should also consider P2P replication.
P2P replication as advertised has a number of restrictions, but these can be overcome by having operational standards.
The main problem highlighted with P2P is...
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
March 19, 2012 at 4:13 am
SQL FineBuild can help you build your SQL Cluster.
As you are new to both FineBuild and clustering, I strongly recommend you get a virtual machine and practice installing SQL non-clustered...
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
March 14, 2012 at 5:01 am
I agree with opc.three.
We have gone through this in the past with Microsoft, and they are happy to consider our Dev cluster as only needing a Dev Edition...
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
March 14, 2012 at 4:32 am
You definitely do not need to give any of the SQL Server service accounts Windows local administrator privilege in order to run SQL Server.
The priviliges you have given the Agent...
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
March 14, 2012 at 4:29 am
You need to set up a Proxy account in order for someone without SQL Sysadmin privileges to use xp_cmdshell. BOL can tell you where this is configured.
All commands run...
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
March 14, 2012 at 4:15 am
Viewing 15 posts - 751 through 765 (of 2,497 total)