In today's fast-paced development environment, efficient and reliable deployment processes are crucial. In my latest video tutorial, I walk you through the steps to deploy database changes from a Visual Studio project to an on-premises SQL Server usi...
My first IT project was a data conversion for Fashion Bug. Since then, I have been on many conversions both as an in-house developer and as a consultant. The last few conversions have been moving Oracle Databases to SQL Server. Here are 10 pitfall mi...
Assuming your table is named error_log and the column containing the JSON string is error_data, and the JSON structure is like this: { "error_code": "some_code", "error_message": ["message1", "message2", ...] } Your SQL Server query would look li...
It is no news that one of the best databases to use for asp.net/.net development is SQL Server because of its smooth integration provided with .net(ASP.NET/UWP/Winforms/Xamarin) applications. Let's get to the process of integrating a local Instance o...
