Forum Replies Created

Viewing 15 posts - 226 through 240 (of 2,497 total)

  • Reply To: More Linux than Windows

    Ever since SQL on Linux was announced I have thought that Windows is on a declining path.

    The final hurdle for many organisations will be a native Linux version of AD. ...

    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

  • RE: Availability Groups either -- Windows 2016 Failover Cluster vs SQL Server Cluster

    Sync v async...  What do your SLAs say. 

    Is minimising failover time more important than minimising query performance.  Is your network up to supporting sync replication, which 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

  • RE: Availability Groups either -- Windows 2016 Failover Cluster vs SQL Server Cluster

    Each option has advantages and disadvantages, You need to choose what is best for you.

    Both options cost the same.  If you run in A/P mode the licensing 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

  • RE: MIgrating from Failover Cluster to Alwayson

    I think you made the right choice.  Using DNS aliases in the connection string gives stabilityof the connection string wherever the alias is pointing.
    In your situation you obviously have...

    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

  • RE: MIgrating from Failover Cluster to Alwayson

    We did something similar about a year ago.  One of our main objectives was to minimise downtime. 

    The main potential period of downtime is where we migrate databases 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

  • RE: No More Downtime

    I could moan about the addiction Windows has for reboots and remember the many months of uptime commonly seen on MVS/370 where a patch seldom required an outage.  (I think...

    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

  • RE: Running out of space on Server OS drive, where SQL Server app located, what to clear out?

    It won't help your current problem, but you need to get your company rules changed for system drive size.  60GB for Windows and SQL server over a lifetime of 5...

    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

  • RE: Reporting service Edition for 2017

    You need to be aware there are two separate Reporting Services products available for SQL 2017:
    * SQL Server Reporting Services
    * PowerBI Reporting Services

    SQL Server Reporting Services...

    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

  • RE: SQL versus program

    There are two aspects of the OP: 1) Pro and Con of using SPs; 2) Cost of conversion

    For me the main advantage of SPs over code embedded in...

    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

  • RE: SQL Server geo-cluster 2016

    Somehow I didn't get Perry's responses until after I made my last post.  Perry has answered it all I think.

    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

  • RE: SQL Server geo-cluster 2016

    So you have WSFC which provides clustering at the Windows level, and SQL FCI the provides clustering at the SQL Server level.  FCI sits on top of WSFC.

    For...

    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

  • RE: SQL Server geo-cluster 2016

    When you install SQL Serve rit has to either be installed as a SQL Cluster or as a stand-alone instance.  You cannot change a non-clustered SQL install to a 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

  • RE: SQL Server geo-cluster 2016

    I think your consultant is giving you a gold-plated solution.  It undoubtedly has the capability to work but will cost a lot to implement.  

    If you are 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

  • RE: SQL Server geo-cluster 2016

    If you are going for what is called 'Out of Region' second node with SQL Clustering then you will need a mechanism to keep both data stores synchronised.  Windows 2016...

    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

  • RE: SQL Server geo-cluster 2016

    Personally I would look at using Availability Groups instead of clustering SQL Server.  AGs will meet your availability and resilience targets and are a far more strategic direction for SQL...

    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

Viewing 15 posts - 226 through 240 (of 2,497 total)