Let’s say you have a C# (or VB.NET) project with namespace “MyProject” and you are trying to serialize a class named “MyClass” and you get the error message: There was an error reflecting type ‘MyProject.MyClass’. The first thing to check, is that the class which you want to serialize (that…
Microsoft Azure has a ton of features and resources to use, which enable you to do just about anything from the computational aspect. However, since you pay for the usage of all these resources, you need to have an efficient cost estimation and monitoring policy in place, in order not…
Enabling auditing in Azure SQL Database is a very good idea, since it allows you get alerts on a variety of actions and behaviors. Since data is the most valuable asset in any organization, it is always a good idea, if not a necessity, not only having your database servers…
Azure Data Lake Analytics, is a powerful on-demand analytics job service on Microsoft Azure. By reading this article, you can learn Azure Data Analytics by Example. The Example Since this is an introductory article on Azure Data Lake Analytics, the example that will be presented, will be a simple one…
We continue our article series dedicated Microsoft Azure. In previous articles, we’ve talked about Azure SQL Database, SQL Server on Azure VMs, Azure Advisor, etc. In this article, we will talk about what Azure Cosmos DB is, as well as see a simple step by step example on how to…
In previous articles, we’ve talked about how you can create your first database in Azure SQL Database, how you can create an Azure SQL Server virtual machine, as well as how to backup a SQL Server database from on-premises to Azure Storage. In this article, we will discuss about what…
In Microsoft Azure, there are two main options for SQL Server services. The first option is Azure SQL Database (PaaS). The second option in SQL Server on Azure (laaS). In a previous article, I explained how you can create a SQL Server instance and database on Azure SQL Database. In…
In a previous article, we discussed how you can create your first database on Azure SQL Database. In this article, we are going to see, how to backup a SQL Server database from on-premises to Azure blob storage. Moreover, we will see how we can restore a database on-premises, based…
A few days ago (end of September 2018, during the MS Ignite Conference), Microsoft announced the Community Technology Preview of SQL Server 2019 (CTP 2.0). This is an exciting new version with a plethora of new features, as well as with enhancements to existing features. Read this article, in order…
In some cases where you might try to launch SQL Server Configuration Manager, you might get the error message: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration…
While developing data processes in SQL Server, under certain circumstances, you might get the error message: error converting varchar to numeric. This error is similar with the conversion error you might get when you are trying to convert a varchar to float, etc. Read on to find out the reason for…
In some cases, while trying to add a database to a SQL Server availability group using the wizard in SQL Server Management Studio, you might get some warnings or errors. There is a chance that these warnings/errors won’t let you continue and add the database. For example, a possible warning…
About the “Microsoft SSIS Service failed to start” Issue It happened at some point to encounter problems with SQL Server Integration Services 11.0 (SSIS) not being able to start. This occurred on a Windows 2008 R2 server that has been regularly patched. After checking in Windows Event Viewer, I found…
Introduction – SQL Server on Linux SQL Server 2017 has been an amazing release of SQL Server. With an obvious decoupling between Windows and SQL Server, now you can run SQL Server on Linux, Docker containers, and even in macOS! This gives you more freedom regarding the platform on which…
C# SqlParameter is a handy feature allows you to safely pass a parameter to a SqlCommand object in .NET. A security best practice when writing .NET data access code, is to always use parameters in SqlCommand objects (whenever parameters are required of course). The reason for this, is that parameters…