SQL Server Blog quarterly review
SQL Server Citation Blog
by Hemantgiri Goswami
4M ago
The last quarter was very good. At least for me, I can say that. Now, why is that so? It is because, I was occupied with technologies other than SQL Server. When I started SQL Server Citation, I thought it will always be about the SQL Server Blog only. However, in recent path I have had chance to work on PostgreSQL and MongoDB both. I am pretty much sure that I will be writing articles here on other technologies and NoSQL etc. but primarily this place will still be SQL Server Blog. In the past couple of month I have written about some tips on SQL Server and PostgreSQL. Basically, this post is ..read more
Visit website
Create failed for Availability Group
SQL Server Citation Blog
by Hemantgiri Goswami
4M ago
Ever since the release of Always On Availability Group (AG or HADR) in SQL Server 2012 the adoption ratio is increasing. A lots of my clients too are adopting this beautiful feature. About a month ago, one of my client’s friend was working on setting up Always On Availability Group, and he has encountered an error Create failed for Availability Group. Since my client is using Always on Availability Group he only recommend his friend to try it. However, he has made a couple of failed attempt creating Always On Availability Group. Finally, it came to me. Here is the error he is receiving while h ..read more
Visit website
PostgreSQL Backup Failure
SQL Server Citation Blog
by Hemantgiri Goswami
4M ago
Microsoft SQL Server is an RDBMS I have always preferred, and loved to work on. All my life, even now-a-days as well. However, past couple of years I have had chance to work on a few more database management systems. Structured and Non-Structured both. Here after, you may see a few more posts for these types of database management systems as well. In this post today, I am going to write about the PostgreSQL backup failure. This very issue I will discussing is really very interesting, at least for me. One of our product is running on PostgreSQL. And, I was working on automating back up. I have ..read more
Visit website
Job Description of a DBA
SQL Server Citation Blog
by Hemantgiri Goswami
5M ago
The day-to-day activities of a Microsoft SQL Server Database Administrator (DBA) can vary depending on the organization’s size, the complexity of the database environment, and specific job responsibilities. I have curated the list of activities of a DBA or one can say Job Description of a DBA. Please keep in mind that these activities can be adjusted based on the specific needs and priorities of the organization and the nature of the applications supported by the databases. Additionally, as technology evolves, DBAs may need to adapt and incorporate new tools and methodologies into their daily ..read more
Visit website
Force parameterization is powerful-feature
SQL Server Citation Blog
by Hemantgiri Goswami
5M ago
Force parameterization in Microsoft SQL Server is a feature designed to optimize query performance by converting literal values in Transact-SQL statements into parameters. This process helps in plan reuse, cache efficiency, and improving overall system performance. Enabling force parameterization instructs SQL Server to attempt parameterization for all queries, even those containing constant literals. This approach has several advantages, making it a valuable tool in certain scenarios. In this article I will discuss why I believe that Force Parameterization is powerful feature in Microsoft SQL ..read more
Visit website
Common Mistakes in SQL Server – Final
SQL Server Citation Blog
by Hemantgiri Goswami
5M ago
The past month has marked a promising beginning. October 2023 has been a successful month, thanks to the heartfelt well-wishes from friends and family. Throughout September and October, I diligently crafted a series of blog posts. In this post, I will summarize the key insights in “Common Mistakes in SQL Server – Final.” Null Value and Their Impact In a previous project, I was tasked with testing and analyzing a database that displayed an alarming growth rate. It seemed like either growth estimations were off or the application was inserting data more frequently than expected. The database had ..read more
Visit website
Common Mistakes in SQL Server – Part 6
SQL Server Citation Blog
by Hemantgiri Goswami
5M ago
Last week in our discussion on Common Mistakes in SQL Server – Part 5 we have discussed that Implicit conversions can indeed lead to suboptimal query performance, so addressing this issue is crucial for optimizing your database operations. Continuing the discussion on Common Mistakes in SQL Server – Part 6 this week I am focusing on discussing importance of recompile. the advantages of recompiling stored procedures and views in SQL Server and underlined the scenarios where recompilation is recommended. Let’s summarize the key points: Caching Execution Plans: Views and stored procedures in SQL ..read more
Visit website
Common Mistakes in SQL Server – Part 5
SQL Server Citation Blog
by Hemantgiri Goswami
5M ago
Last week, in the post Common Mistakes in SQL Server – Part 4 I explained about the Auto Growth configuration in SQL Server and how it can adversely impact. This week, I am going to explain a very important thing that is often skipped. It is a common mistake that can indeed lead to performance problems. Implicit Conversion can cause unexpected performance issues and hinder query optimization. This week in Common Mistakes in SQL Server – Part 5 let’s speak about the Implicit Conversion. And, why implicit conversion is considered bad. What is Implicit Conversion? Implicit Conversion occurs when ..read more
Visit website
Common Mistakes in SQL Server – Part 4
SQL Server Citation Blog
by Hemantgiri Goswami
5M ago
Last week we discussed how Null Values can cause trouble in Common Mistakes in SQL Server – Part 3. This week in this post, Common Mistakes in SQL Server – Part 4 I would like to draw your attention to a database configuration that is often missed. If this value is not configured with care, it can cause I/O and CPU spikes, and can also cause physical fragmentation. In this part of the blog I will shad some lights on Auto Growth configuration for the database. Configuring Auto Growth in fixed MB is important. What is Auto Growth? Auto Growth is a feature that allows database files (primary ..read more
Visit website
Common Mistakes in SQL Server – Part 3
SQL Server Citation Blog
by Hemantgiri Goswami
5M ago
Last week we discussed identity crisis in Common Mistakes in SQL Server – Part 2. This week in this article Common Mistakes in SQL Server – Part 3 I will discuss the Null Value and how it can cause an issue!!. Because it’s common misconception that NULL value do not occupy space, however, the reality is that it does occupy the space. What is NULL? Null is the value which indicates the value is unknown. Null is different than zero or an empty string, as a zero or empty string indicates that the value is known (refer http://en.wikipedia.org/wiki/Null_%28SQL%29 for furthe ..read more
Visit website

Follow SQL Server Citation Blog on FeedSpot

Continue with Google
Continue with Apple
OR