Viewing 15 posts - 406 through 420 (of 2,497 total)
You need to talk to your license reseller.
You will then get the price that actually applies to your organisation. If you have an EAP it can be expensive 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
July 15, 2014 at 9:28 am
If you want to script the entire cluster install process, then SQL FineBuild can help you.
Details of how FineBuild deals with clusters is given at http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20Cluster%20Install
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 14, 2014 at 4:19 am
The first option is to try doing more frequent log backups. If this does not keep the log size under control then you have to accept that a larger...
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 14, 2014 at 3:46 am
I think that when you use an Access FE with a SQL Server BE, then Access will use 'pass-through' queries to get the data. The entire query text 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
July 14, 2014 at 3:40 am
I know that Microsoft made some improvements to the patching process in SQK 2008, but this is so long ago I cannot remember the exact details.
It is always worth taking...
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 14, 2014 at 3:18 am
So what is important to your organisation - beating the completion or complying with process?
It sounds like you have a lot of managers who do not understand what is needed...
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 7, 2014 at 5:15 am
This link shows how to create a loopback linked server http://www.kodyaz.com/sql-server-2012/create-local-linked-server-in-sql-server.aspx
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 1, 2014 at 6:57 am
Thanks Perry, I stand corrected and have learned something new.
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 30, 2014 at 5:24 am
As Paul and Grant say, check what you actually downloaded. You are being asked to install Windows 2008 Sp2, not SQL 2008 SP2.
Service Pack 2 for Windows 2008 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
June 30, 2014 at 4:06 am
How about SSIS 2012, where everything in the project deployment model is stored inside the SSISDB database? Can SSIS be clustered in that case?
If you are certain that there will...
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 30, 2014 at 3:58 am
If you can be certain that you will only ever have one SQL instance on your Windows cluster then it can be safe to cluster SSIS in the way referred...
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 30, 2014 at 3:44 am
If you switch to Simple recovery mode then you break the log chain. The only way forward for your log shipping is to switch back to Full and send...
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 30, 2014 at 3:28 am
You should not restore system databases across different versions of SQL Server.
Each version of SQL Server has version-specific information in master, resource, and msdb. If you do...
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 30, 2014 at 3:22 am
As you say, you can not install SQL 2012 or above on Windows 2003. You need Windows 2008 or above to install these versions of SQL Server.
I have some...
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 30, 2014 at 3:18 am
It is also worth looking at SQL FineBuild. This helps you produce standardised and repeatable installations of SQL Server, which can aid in your documentation process.
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 30, 2014 at 2:55 am
Viewing 15 posts - 406 through 420 (of 2,497 total)