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

Microsoft officials are showcasing some of the new fruits of its partnership with Red Hat at this week's Red Hat Summit in San Francisco. On Thursday, Microsoft execs will demonstrate SQL Server on ...

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

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

Drag-and-drop is one of the most productive computer features since the Apple Lisa. You're sure to keep your users happy if you implement drag-and-drop features in your applications. In this article, ...

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

So much of modern programming is about string manipulation. Whether it’s parsing XML content, building HTML for the browser or trying to understand what the user just typed into that text entry field, ...

In November, Microsoft released version 18.4 for the SQL Server Management Studio (SSMS), introducing some key features such as support for materialized view scripts in SQL Data Warehouse. It also ...

A private preview of SQL Server 2025 began in November 2024, followed by a public preview in May 2025. Now, it is time for the natural next step, as the tool has received its first release candidate, ...