Pro-Center Video Programming for IT Professionals
Tag: .net
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, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
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, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
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, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
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, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
.NET Development for Free
Pro-Center Video Programming for IT Professionals
What’s New in ASP.NET 4
Pro-Center Video Programming for IT Professionals
Deploying ASP.NET Apps the Easy Way
Pro-Center Video Programming for IT Professionals
ASP.NET Security: It’s the least you can do
Pro-Center Video Programming for IT Professionals
Developing and Deploying an On-Premise .NET Application with Azure Table Storage
Pro-Center Video Programming for IT Professionals