Tag: .net

Pro Members SQL Server Standard Members

Some tips for using ASP.NET with SQL Server 2017

Some tips for using ASP.NET with SQL Server 2017 If you use ADO to access SQL Server data in your ASP.NET, always create a Connection object explicitly, not implicitly. This can reduce the server overhead and simplify the controlling of a connection. Set the MultipleActiveResultSets (MARS) option in the SQL Server connection string. This option makes it possible to execute…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Tips for using ASP.NET with SQL Server 2016

Tips for using ASP.NET with SQL Server 2016 Set the TrustServerCertificate to False in the SQL Azure connection string. The TrustServerCertificate=False setting is recommended to help protect against man-in-the-middle attacks. Use the SQL Server .NET data provider to access SQL Server 2016 data using ADO.NET. Because using the SQL Server .NET data provider provides better performance in comparison with other…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Some tips for using ASP.NET with SQL Server 2014

Some tips for using ASP.NET with SQL Server 2014 If you use ADO to access SQL Server data in your ASP.NET, avoid creating transactions using ADO methods. Try to create transactions inside a stored procedure on the SQL Server. By doing so, you can reduce network traffic and boost overall ASP.NET performance. When building a web page based on SQL…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2012 CLR Problems

Troubleshooting SQL Server 2012 CLR Problems If you have problems with SQL Server 2012 Common Language Runtime (CLR) objects, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because some SQL Server 2012 CLR bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register