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 getting this error message and … Read more…
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 could be the below: This … Read more…
In this article, we will be discussing about the error message: “Microsoft SSIS Service failed to start. Configuration system failed to initialize”. We will talk about what this error message means, as well as, how you can resolve it. About the “Microsoft SSIS Service failed to start” Issue It happened at some point to … Read more…
In this article, we will be discussing about, how you can easily get started with SQL Server on Linux, mainly in terms of installing and managing different SQL Server services on Linux. Introduction – SQL Server on Linux SQL Server 2017 has been an amazing release of SQL Server. With an obvious decoupling between Windows … Read more…
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 help prevent SQL injection attacks. … Read more…
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 error navigate to the report … Read more…
In this article, we will be discussing about the set identity_insert command in SQL Server. About the “set identity_insert” Command in SQL Server 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 … Read more…
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 simple example. What Does … Read more…
This article, discusses the root cause for the error message “The Net.Tcp Port Sharing Service service on Local Computer started and then stopped” and suggests a solution to the issue. The Root Cause for the Error Message Under certain circumstances, you might be experiencing problems with the “Net.Tcp Port Sharing” Service on Windows Server, … Read more…
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 there is the risk to … Read more…
In this article, we will be discussing about a popular error message, that is: “A network-related or instance-specific error occurred while establishing a connection to SQL Server” About the network-related or instance-specific error Under certain circumstances, there are cases where you might try to connect to a SQL Server instance and get the error … Read more…
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 characterized as encrypting data at … Read more…
Microsoft Azure SQL Database is a fully managed cloud database service, provided as part of Microsoft Azure. That means, that via the Microsoft Azure Portal, among other, you can easily create database servers, and thus host your databases. Moreover, you can still continue to use the same SQL tools you used for on-premises SQL Server … Read more…
We have some amazing news about Snippets Generator! We are proudly announcing the general availability of Snippets Generator v3.3! With an a brand new, intuitive GUI, Snippets Generator helps you to easily create T-SQL code snippets for use in SQL Server Management Studio (SSMS). Moreover, you can edit existing T-SQL code snippet files. So, what’s … Read more…
Back in 2008 I started “The SQL Server and .NET Blog” having as a mission to share my knowledge and experiences on SQL Server with you, the SQL Server Community. Throughout all these years, The SQL Server and .NET Blog was constantly evolving with new topics, and the most important, with new types of knowledge … Read more…