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…
In 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 to learn what’s new in…
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…
This short blog post helps you troubleshoot the below error message in SQL Server Reporting Services (SSRS): An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Get Online Help For more information about this…
The set identity_insert command in SQL Server, as the name implies, allows the user to insert explicit values into the identity column of a table. Now, someone might wonder, “why on Earth would somebody want to do that?!” Oh well, you know, there is always a good reason! 🙂 I can…
The SQL Server Browser Service listens on incoming connections for SQL Server services on SQL Server machines and provides information about SQL Server instances installed on the machine. This article discusses about the SQL Server Browser Service and UDP Port 1434, as well as what its use means throughout a…
The Error Message Under certain circumstances, you might be experiencing problems with the “Net.Tcp Port Sharing” Service on Windows Server, thus giving the error message:Â The Net.Tcp Port Sharing Service service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services…
Among its plethora of available and useful settings, SQL Server has a setting that is called “Maximum number of concurrent connections“. This setting by default is set to 0 (zero), which means “unlimited” concurrent connections and it is generally advised not to change it. In case you changed this setting…
Under certain circumstances, there are cases where you might try to connect to a SQL Server instance and get the error message: “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is…
Transparent Data Encryption known also known as TDE (learn more), encrypts SQL Server, Azure SQL Database and Azure SQL Data Warehouse data and log files on the OS-level. Moreover, a derived benefit is that also SQL Server-based backups of encrypted databases are also encrypted. This type of encryption can be…
