Number 9 of this series moves onto the security and administration side of SQL Server 2022 by introducing the creation of logins. As a database developer, it is crucial to know and understand the ...

Use custom-built .NET Framework 4.0 classes to connect an ASP.NET Web application to a SQL Server 2012 database. In my recent article, I showed how to connect .NET 4.0 C# and Visual Basic applications ...

Number 6(a) of the set moves the user onto the topic of importing flat-file data into SQL Server 2022 – To achieve this, the user will operate with both the SSMS GUI as well as SQL. Modifying columns ...

Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target. Logging is an essential feature for any application, as it is ...