Microsoft is enabling its free SQL CE (SQL Server Compact Edition) database to work within ASP.Net Web applications, thus providing a lightweight database option for ASP.Net Web development, a ...

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

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

The SQL server is on a shared hosting provider, so I suspect I would not be able to attach a profiler to the sql server database (admin rights needed?). I do not have debug access to the sql server ...

I'm trying to left join a bunch of tables in a database, and I want to just spit out all of the data to make sure its working. Is there a way to move across a record set by number rather than typing ...

A dynamic web application needs an admin section for CRUD actions on the records/tables in the database. Wouldn't it be nice to have a database admin, which can be plugged to any web application? Just ...

Amazon Web Services (AWS) launched Amazon Relational Database Services (Amazon RDS) on Monday for Microsoft SQL Server and ASP.NET support for AWS Elastic Beanstalk. SQL support is currently set for ...

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