Forum Replies Created

Viewing 15 posts - 16 through 30 (of 2,301 total)

  • Reply To: SQL Server Failover Cluster

    What you want to do is possible with a Windows Stretch Cluster or with two Windows Clusters.

    If you have Enterprise Edition with Software Assurance  you may be able to do...

  • Reply To: HELP!!!

    You sould get a check-list together of the tasks you need to do.  The following is suggested as a starting point, but you are the person who knows your site,...

  • Reply To: SQL Collation to match IBMi

    You will need some form of EBCDIC collation to make SQL sort in the same way as IBM.

    The standard collations used by Windows, Linux, and SQL Server have numbers before...

  • Reply To: SQL Server Hardware Recommendation

    Your server spec looks big for your data volumes.

    You will be moving to latest hardware (or thereabouts) so for 300GB data 4 cores with 64gb memory should be ample.  However,...

  • Reply To: One of six 2017 instances offline - Always On.

    Have you checked the SQL Error Logs for the update and subsequent restart attempts?  If your instance had a problem while in Script Update mode you could get similar symptoms...

  • Reply To: SQL 2017 AGL - only accessible locally

    I have not checked this situation, but a similar situation exists when a SQL Cluster is configured for multi subnets.

    Have you checked the Windows Cluster dependency list for the AG...

  • Reply To: Good Luck is Needed with Old Versions

    Back around 2014, my then employer was putting a case together to move from the last SQL2005 servers.  The thing that clinched it was reliability.

    We worked out we might get...

  • Reply To: Is SSIS really that bad?

    I have hardly ever used SSIS, but have seen it used extensively by others.  Like any tool, if you get to know it then you know what can be done...

  • Reply To: Single Instance vs Multiple Instances

    Personally I think 22 small to medium size databases is not a large number.  220 starts to be a large number, but it all depends on the resources on the...

  • Reply To: The Sequel to SQL

    One of the few things to do with computing that has not seen multiple order-of-magnitude reductions in cost over the past 40 years is application development.  This has always been...

  • Reply To: PowerBI Server

    PowerBI Server on prem is best thought of as a replacement for Reporting Services.  It can replace SSRS on all versions from SQL 2008 onwards.

    The PBI install will give you...

  • Reply To: Cannot upgrade SQL 2008R2 DB Engine

    I know you have a tough job here, but upgrading in place is like playing Russian Roulette.  Eventually you will try an upgrade that corrupts your instance so it won't...

  • Reply To: Software need db owner permission to master database (sql2016)

    If you have not already done so this is something you should escalate to your management.

    If you are based in the EU then this level of access puts you in...

  • Reply To: Remove SQL Server from Failover Cluster

    If you are convinced that one of your cluster nodes is not fit for use, you should look at the safest way to decommission it, and also how you will...

  • 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. ...

Viewing 15 posts - 16 through 30 (of 2,301 total)