Recently, I installed the SQL Server Management Studio 18 (SSMS) and after just one use, it didn't want to start anymore. The SQL Server Management Studio stopped loading after the splash screen showing up for a brief moment and no messages appeared to show me what was wrong, except for Windows playing the default beep sound notifying me of a problem. In this article, I will show you how I solved this issue.
Recently, I was experimenting with Telerik Kendo UI HTML Framework and in particular, I was exploring the PDF Export feature that allows you to convert HTML content into a PDF. I wanted for generated PDF to open in a new browser tab, but all the examples I found on the web worked in such a way that the file was downloaded on your computer. After a little research, I was able to find the solution that makes the PDF open in the browser in a new tab and this is the focus of this tutorial.
SQL Server Express is a free edition of Microsoft SQL Server family that although fully functional, it has some technical limitations like maximum database size per database. It also has some features missing from paid editions. One of those features not available with Express edition is SQL Profiler. In this post I will list the alternative tools for SQL Profiling that can be used with either SQL Server Express or can be used as the SQL Express replacement.
Recently I wanted to save DataTable data into the database. I assumed this would be easy using Entity Framework, but it turns out it is not, since DataTable consists of rows and columns while the Entity Framework deals with objects. Another way is to use ADO.NET by iterating through the rows in the DataTable and inserting each row using SqlCommand and INSERT statement, but there is an easier way to accomplish this and that is by using SqlBulkCopy class, which is the focus of this article.
A while ago I had the task of setting up an old ASP.NET 3.5 application on a shared hosting server and after I was done, the application worked as it should except for one important bit. The application used a Forms Authentication to authenticate users and after users logged in they were getting logging out and redirected to the login page after a really short amount of time, usually only after a few minutes.
In this article, I will show different ways I tried to locate this problem and how I finally managed to fix this issue.
Recently I was going through a database programming tutorial that used Northwind Database in code examples, so I thought "No problem, I'll quickly add that database to my SQL Server 2012". I assumed this would be easy but to my surprise that wasn't the case.
In this post, I will show you what problems I encountered while trying to install the Northwind database and how I finally managed to make it work.
The other day I wanted to learn something new so I decided to try a little Unit Testing using Microsoft .NET. After looking at different Unit Testing Frameworks I chose to use NUnit Framework. I then tried an example found on the web and after the project was built, I loaded NUnit GUI and opened unit test assembly, but to my surprise, the NUnit GUI was giving me Error message. It was telling me that the Test load failed with detailed error: SystemApplicationException: Unable to find test in the assembly.
In the end I found three different ways to make NUnit work and each one will be shown in this article.