cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SQL Server Support
Copied!
Home
Options
485

Creating a database in Azure Blob Storage from SQL Server running on Linux OS may fail with Msg 1802

JAYNAR on 01-10-2020 03:54 PM
Creating a database in Azure Blob Storage from SQL Server running on Linux OS may fail with Msg 1802
1,000

Availability Groups in Big Data Clusters. Two or more replicas in the same node?

FernandoSibaja on 01-06-2020 03:17 PM
Recently we have observed a couple of occurrences where 2 or more AG replicas in a Big Data Cluster deployment are being...
1,229

Polybase for beginners.

FernandoSibaja on 12-19-2019 05:07 PM
In regards to Polybase, I have seen some confusion from customers about what it is, the problems that it solves and when...
762

Applying SQL Server 2017 CU18 on secondary replica running on Linux OS may fail with script failure

JAYNAR on 12-19-2019 04:31 PM
If SQL Server 2017 is running on Linux operating system and if you have databases configured using Always ON feature, po...
792

SQL 2019 PolyBase Error: TCP Provider: An existing connection was forcibly closed by the remote host

Balmukund Lakhani on 12-10-2019 07:34 PM
In this blog we are sharing details about an issue which can be seen while querying external table created in SQL 2019 w...
579

An example of Polybase for Oracle

Liwei on 12-03-2019 09:40 AM
532

How to configure the number of error logs for your SQL Server instance on Linux

Suresh Kandoth on 12-02-2019 02:23 PM
Are you used to too many error logs for SQL Server on Linux? Now we have a mechanism to control this with ease!
1,483

How to fix SQL Patch Error 1648: No valid sequence could be found for the set of updates.

Balmukund Lakhani on 12-01-2019 10:33 PM
In this blog, we would share the steps to resolve error 1648: No valid sequence could be found for the set of updates.
3,284

SQL Server 2019 Installation Error - An error occurred for a dependency of the feature

Balmukund Lakhani on 11-11-2019 01:52 AM
In this blog we would discuss one of the known issue with SQL Server 2019 Setup along with SQL Server Management Studio ...
1,826

When is Spinlock a Significant Driver of CPU utilization in SQL Server?

Joseph Pilov on 05-03-2019 03:02 PM
SQL Server Spinlocks - "How many spins is too many?" The answer: approximately 18,000 - 20,000 or more
1,636

The case of the filter predicate with window functions such as ROW_NUMBER and RANK

Troy Moen on 04-25-2019 02:28 PM
I recently helped troubleshoot a query performance issue that involved the window function "ROW_NUMBER". The running the...
1,143

SSIS - Package Installation Wizard - Next button grayed out

Krishnakumar Rukmangathan on 04-09-2019 12:48 AM
In SSIS - Package Installation wizard, the Next button doesn't come up or it is grayed out.Package Installation Wizard -...
2,719

SSIS – Always on AG (Availability Group) and Error – Please Create a Master Key

Krishnakumar Rukmangathan on 04-09-2019 12:12 AM
Error: Please create a master key in the database or open the master key in the session before performing this operation...
7,359

JDBC Connections fails with "The driver could not establish a secure connection to SQL Server...."

Krishnakumar Rukmangathan on 04-08-2019 11:52 PM
SQL Server JDBC Connectivity Error on JDK 1.7.0: The driver could not establish a secure connection to SQL Server by usi...
6,044

SQL-SQL linked server connections fails after applying latest windows security patches .

Srini Gajjela on 04-03-2019 10:23 AM
SQL-SQL linked server connections and distributed query execution fails due to an error message NT AUTHORITY\ANONOYMOUS ...
4,820

Connectivity Problems Caused by Issues in SQL Server

Joseph Pilov on 02-10-2019 05:25 PM
First published on MSDN on Jan 27, 2019 Very frequently connectivity problems to SQL Server are issues originating from ...
1,247

Generating a SQL Server, SSAS, SSIS, SSRS, SQL Agent Memory Dump via PowerShell script (and SQLDumper.exe)

Joseph Pilov on 02-10-2019 05:25 PM
First published on MSDN on Jun 30, 2018 Recently, we published a PowerShell script to create memory dumps of SQL Server,...
1,618

An internal error happened while generating a new DBTS for database 'Db1'

Joseph Pilov on 02-10-2019 05:24 PM
First published on MSDN on Jun 21, 2018 Recently I worked on an issue that encountered this error and I had to research ...
21.6K

How to install Sql Server Data Tools (SSDT) 2017 Offline (Internal Network installation)

Joseph Pilov on 02-10-2019 05:24 PM
First published on MSDN on Jun 21, 2018 Here is a request that came up recently:"When installing SSDT manually it downlo...
1,266

Deadlock Simulator app for Developers: How to Handle a SQL Deadlock issue in Your App

Joseph Pilov on 02-10-2019 05:24 PM
First published on MSDN on Apr 27, 2018 Recent, I was involved in assisting a deadlock issue and specifically the except...
6,665

Functions like STRING_AGG(), CONCAT_WS(), TRIM() Appear to Break in Visual Studio 2017 Database Projects

Joseph Pilov on 02-10-2019 05:24 PM
First published on MSDN on Mar 05, 2018 The following functions were introduced in SQL Server 2017.
769

Automatically Generating SQL Server Memory Dumps at a Defined Interval

Joseph Pilov on 02-10-2019 05:23 PM
First published on MSDN on Mar 05, 2018 Over the years of troubleshooting SQL Server we have come to see the need for ma...
1,310

OS Hang or Out of Memory due to SQL Ser... No Wait, it's SQL Analysis Services (SSAS)

Joseph Pilov on 02-10-2019 05:23 PM
First published on MSDN on Jan 12, 2018 Recently, we have observed a number of cases where DBAs or application developer...
976

Create a monitoring and notification mechanism for HADR worker thread Pool

Joseph Pilov on 02-10-2019 05:23 PM
First published on MSDN on Dec 07, 2017 A customer approached us asking for help on automatic a monitoring process.
Latest Comments
Halil Mollaoğlu
in SQL Server 2019 Installation Error - An error occurred for a dependency of the feature on 01-14-2020
Thanks. This indeed should converted to a KB article.
0 Likes
佳易 楊
in Create Distributed Availability Group in Sql Server Linux(Redhat) --- step by step on 01-07-2020
Hi Liwei,I configured it with 8 SQL Server 2019 CU1s. Pacemaker recommends a minimum of three SQL Server configurations.The high availability group is divided into two groups of four units.
0 Likes
James van den Berg
in Availability Groups in Big Data Clusters. Two or more replicas in the same node? on 01-06-2020
Thank you Fernando for Sharing this Blogpost with the Community 
0 Likes
Liwei
in Create Distributed Availability Group in Sql Server Linux(Redhat) --- step by step on 01-04-2020
You are welcome:)
0 Likes
佳易 楊
in Create Distributed Availability Group in Sql Server Linux(Redhat) --- step by step on 01-03-2020
Hi LiWeiThe DAG configuration is ready. Thank you very much.
0 Likes