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 ...

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 ...

I'll soon be developing an application that will be controlled access, but will be visible to the whole Internet. All of the web apps I've developed before have been for internal networks, so I've ...

Microsoft has a guide on naming conventions for C#, etc. Is there something similar for SQL Server?<BR><BR>i.e. names for tables, columns, stored procedures, stored procedure variables, ...

SQL Server Management Studio (SSMS) is the tool of choice for most developers when managing SQL Server and the relational data stored in it. Microsoft recently outlined plans for SSMS 22, currently in ...