Troubleshooting Issues Archives - {coding}Sight https://codingsight.com/category/database-administration/troubleshooting-issues/ Blog for SQL Server DBAs and Developers Tue, 10 Oct 2023 17:07:14 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png Troubleshooting Issues Archives - {coding}Sight https://codingsight.com/category/database-administration/troubleshooting-issues/ 32 32 How to Read and Interpret SQL Errors https://codingsight.com/how-to-read-and-interpret-sql-errors/ Fri, 03 Sep 2021 05:30:52 +0000 http://codingsight.com/?p=16608 Error codes in SQL are generated by the server to provide information about what has gone wrong. They have different meanings depending on the SQL version you’re using, but they usually indicate the inability to perform a requested operation. The easiest way to explore it is the simplest programming language called BASIC and its programs …

The post How to Read and Interpret SQL Errors appeared first on {coding}Sight.

]]> SQL Server Transactional Replication Issues https://codingsight.com/sql-server-transactional-replication-issues/ Fri, 16 Jul 2021 08:15:38 +0000 http://codingsight.com/?p=15434 We started talking about SQL Server Transactional Replication issues earlier. Now, we are going to continue with a few more hands-on demos to understand frequently faced Replication performance issues and how to troubleshoot them correctly. We have already discussed such problems as Configuration issues, Permission issues, Connectivity issues, and Data Integrity issues along with troubleshooting …

The post SQL Server Transactional Replication Issues appeared first on {coding}Sight.

]]> SQL Server RAISERROR Statement with Simple Examples https://codingsight.com/sql-raiserror-statement-with-simple-examples/ Wed, 14 Jul 2021 13:11:08 +0000 http://codingsight.com/?p=15299 The SQL RAISERROR statement is used to send a custom message to the client application. It also can be used to debug the application and applies to the error handling mechanism. SQL RAISERROR Statement Syntax and Parameters The syntax of the SQL RAISERROR statement is the following: Below you can see the explanation of the …

The post SQL Server RAISERROR Statement with Simple Examples appeared first on {coding}Sight.

]]> Troubleshooting SQL Server Transactional Replication Issues https://codingsight.com/troubleshooting-sql-server-transactional-replication-issues/ Mon, 05 Jul 2021 10:53:16 +0000 http://codingsight.com/?p=15049 SQL Server Transactional Replication is one of the most common Replication techniques used to copy or distribute data across multiple destinations. In the previous articles, we discussed SQL Server Replication, how it internally works, and how to configure Replication via the Replication Wizard or T-SQL approach. Now, we focus on SQL Replication issues and troubleshooting …

The post Troubleshooting SQL Server Transactional Replication Issues appeared first on {coding}Sight.

]]> How to Protect MySQL Databases from Ransomware Campaigns https://codingsight.com/how-to-protect-mysql-databases-from-ransomware-attacks/ https://codingsight.com/how-to-protect-mysql-databases-from-ransomware-attacks/#comments Tue, 08 Jun 2021 08:04:16 +0000 http://codingsight.com/?p=14501 MySQL is known for being easy to use and highly secure. That’s why it is the number one choice for many organizations, including the biggest brands like Facebook, Google, Uber, and YouTube. Because it’s open-source, it’s free to use and modify even for commercial purposes. But although it can be very secure, the security features …

The post How to Protect MySQL Databases from Ransomware Campaigns appeared first on {coding}Sight.

]]> https://codingsight.com/how-to-protect-mysql-databases-from-ransomware-attacks/feed/ 1 Troubleshooting Issues when Working with Date and Time in SQL Server https://codingsight.com/troubleshooting-issues-when-working-with-date-and-time-in-sql-server/ Wed, 02 Jun 2021 10:26:11 +0000 http://codingsight.com/?p=14418 The Microsoft SQL Server database stores the date and time information in a variety of formats. The most common of them are DateTime, DateTime2, and Date. As it happens with all types of data, issues can take place time after time. In this article, we’ll focus on troubleshooting some of the most common issues that …

The post Troubleshooting Issues when Working with Date and Time in SQL Server appeared first on {coding}Sight.

]]> Implementing Error and Transactions Handling in SQL Server https://codingsight.com/understanding-sql-server-database-errors/ Wed, 05 May 2021 09:12:52 +0000 http://codingsight.com/?p=13366 Introduction No matter how hard we try to design and develop applications, errors will always occur. There are two general categories – syntax or logical errors can be either programmatic errors or consequences of incorrect database design. Otherwise, you might get an error because of the wrong user input. T-SQL (the SQL Server programming language) …

The post Implementing Error and Transactions Handling in SQL Server appeared first on {coding}Sight.

]]> Completing SQL. Stories of Success and Failure https://codingsight.com/completing-sql-part-1-the-difficulties-with-parsing-or-tales-of-polishing-antlr/ Wed, 29 Apr 2020 09:41:30 +0000 https://codingsight.com/?p=8512 I’ve been working for a company that develops IDEs for database interaction for more than five years. Before starting to write this article, I had no idea how many fancy tales would lie ahead.  My team develops and supports IDE language features, and code auto-completion is the major one. I faced many exciting things happening. …

The post Completing SQL. Stories of Success and Failure appeared first on {coding}Sight.

]]> Overview of DBCC SHRINKFILE Command https://codingsight.com/dbcc-shrinkfile-overview/ Thu, 11 Apr 2019 20:39:23 +0000 https://codingsight.com/?p=6668 Running DBCC Shrink commands is quite a controversial issue across the SQL Server community. In this article, we will review details about this command and provide a brief overview of its use and also warn you about the risks of running this command. As DBAs, a number of databases were handed over to from other …

The post Overview of DBCC SHRINKFILE Command appeared first on {coding}Sight.

]]> Replacing SQL Cursors with Alternatives to Avoid Performance Issues https://codingsight.com/replacing-sql-cursors-with-alternatives-to-avoid-performance-issues/ Fri, 22 Mar 2019 14:57:21 +0000 https://codingsight.com/?p=6486 In this article, we’ll look at some alternatives to using SQL cursors which can help avoid performance issues caused by using cursors. Before discussing the alternatives, let’s review the general concept of SQL cursors. Quick Overview of SQL Cursors SQL cursors are primarily used where set-based operations are not applicable and you are required to access data …

The post Replacing SQL Cursors with Alternatives to Avoid Performance Issues appeared first on {coding}Sight.

]]>