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…
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 or programs. So,…
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…
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…
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…
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,…
If you worked -or still working- with SQL Server 2005 (or even earlier), you must have noticed that when you installed these SQL Server versions, the local Windows group “Built-In\Administrators” was automatically included in the SQL Server instance along with getting the role “SysAdmin” server role. This actually, when it…
I have been writing software since I was 10. I enjoy the challenge of solving different problems with the use of simple, yet powerful software tools. My latest initiative in the last few years was SQLArtBits, and before that, Artemiou Data Tools. Via Artemiou Data Tools and SQLArtBits, I have…
![[Quick Tip] When is TempDB Used?](https://www.sqlnethub.com/wp-content/uploads/2018/02/help-icon-230x160.jpg "[Quick Tip] When is TempDB Used?"){kind=icon}
When is TempDB Used? That’s a very good question! TempDB is one of the system databases of SQL Server. As its name implies, it is being used for holding temporary stuff. However, after different discussions I had with a lot of people, I believe that many people have a misconception…
It is a recommended security best practice, to upgrade to Transport Layer Security (TLS) protocol 1.2 asĀ several known vulnerabilities have been reported against SSL and earlier versions of TLS. Many of us who work with SQL Server, we needed – or will need at a point – to checkĀ SQL Server’s…