.NET Exception Handling for SQL Server with Try, Catch and Finally
In this tip we will talk about setting up a proper exception handling mechanism for .NET applications that make calls to SQL Server.
In this tip we will talk about setting up a proper exception handling mechanism for .NET applications that make calls to SQL Server.
In previous tips we covered the different types of multithreading options available in .Net and in this tip we look at how to choose the best option.
In this tip we will be examine another .Net multithreading technique the Task Parallel Library.
In this tip we will be examine another .Net multithreading technique the ThreadPool class.
In this tip we look at how to build a multithreaded application using the .NET thread class.
Learn about the need for multithreading in .NET applications, especially for data applications and GUI environments. It is with multithreading that we avoid screen freezes when time-consuming processes are running in the background
As we continue our series of tips on getting started with developing with .NET and SQL Server we look at how to use the data grid view with SQL Server data.
Learn how to write .NET code to work with calling different types of SQL Server functions.
Learn how to build a simple .NET application that uses SQL Server stored procedures to retrieve and update data from a database.
In this tip we look at a few examples of using .NET code to update and select data from SQL Server tables by creating a simple application and connection string to the SQL Server database.
In this tip we look at a simple example to get you started with developing a .NET application that connects to SQL Server.
This tip will help you better understand what connection pooling is and provide knowledge on how to take advantage of the connection pooling mechanism when writing .NET data access code that communicates with SQL Server.
In this tip we will talk about a simple ETL process, see how we can migrate it to In-Memory OLTP processing in SQL Server and check the performance improvement.
Check out the script in this tip on how to manage SQL Server index fragmentation.
In this tip I will present a simple, yet comprehensive example of workload processing that was optimized using SQL Server In-Memory OLTP which led to a performance boost up to 79x times faster processing over disk-based execution.
There are times where you might want to export a table's records, each one into a separate text file. This for example can happen when you have text data in each record and you want to re-create the original files that were initially imported into the tab
Learn how to modify the SQL Server Model system database for customized user databases including autogrowth, AUTO_SHRINK, QUOTED_IDENTIFIER, database owner, etc. settings.
Learn about three techniques to assess the SQL Server In-Memory OLTP performance benefits and workloads that benefit from the technology.