Viewing 15 posts - 706 through 720 (of 2,497 total)
You do not need any downtime to add a new node into P2P.
I hope you are planning to work out your implementation plan using a non-production system, so that when...
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
October 23, 2012 at 4:13 am
All clustering in SQL Server is inherently Active/Passive. A given database can only be online to a single node at any one time.
People use the term Active/Active to indicate...
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
October 19, 2012 at 3:44 am
My understanding is that for a virtual server, you only need a licence for the number of cores that will be running SQL Server.
By default, SQL Server is set 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
October 16, 2012 at 5:24 am
Use a secure delete program to wipe those files off disk
If you do this, make sure you use a secure delete process that is compatible with the storage you are...
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
October 16, 2012 at 5:08 am
Have you set static ports for your named instances?
The default instance will want to use 1433 unless you tell it to use a different port. But if...
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
October 12, 2012 at 8:08 am
SQL Server will always write to the log. This is needed because if the INSERT command fails, SQL Server needs to put the database back too the state 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
October 12, 2012 at 7:53 am
The /PAE boot switch in Windows enables the code you need. If you have hardware data protection turned on this also enables the PAE functionality so you do 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
October 2, 2012 at 4:29 am
As far as a cluster is concerned, you are limited to Active/Passive for a given database.
If you want to have multiple instances accessing the same database, then the two simplest...
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
October 2, 2012 at 2:32 am
Your Active/Active scenario will not work. There is an inherent restriction with SQL Server that means a given SQL service must have exclusive access to the database file.
If somehow...
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
October 1, 2012 at 5:28 am
There is also the risk of people being added to an AD group and inadvertently being granted access to data they should not have access to.
Security best practice is that...
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 28, 2012 at 8:58 am
There are no performance or integrity advantages in moving the locations of Master, Model, and MSSystemResource databases.
If you make heavy use of msdb then consider moving its files to where...
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 21, 2012 at 6:47 am
You might be interested in SQL FineBuild. This can install SQL standard builds on any OS from XP onwards. It can definitely cope with the differences between W2008...
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, 2012 at 5:39 am
To decrypt your 'encrypted' SPs and views, google 'sql server decrypt stored procedure' and take your pick.
You might want to challenge why the daatbase objects are encrypted. It offers...
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 5, 2012 at 3:02 am
If you have the opportunity to do SQL 2012 BI training then go for it. The BI stack in SQL 2012 is very significantly better than the SQL 2008...
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 4, 2012 at 2:51 am
What security context is running the xp_delete_file? Is the shared drive visible to that security context?
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 28, 2012 at 3:12 am
Viewing 15 posts - 706 through 720 (of 2,497 total)