Welcome to our blog! Today, we will be discussing various concepts and ideas related to SQL Server. SQL Server is a powerful relational database management system that is widely used in the industry. Whether you are a beginner or an experienced professional, there is always something new to learn in the world of SQL Server.

2006: A Journey into Blogging

In 2006, our blog journey began. Back then, blogging was a new concept, and we had no idea what it would become. It started as a collection of bookmarks, but over time, it evolved into a platform for sharing our knowledge and experiences in the SQL Server world. Looking back at those early posts, we feel nostalgic and proud of how far we have come both technically and professionally.

2007: Introducing New DataTypes and Mirrored Backup

In 2007, SQL Server 2008 brought some exciting new features. One of the highlights was the introduction of the DATE and TIME data types. This allowed users to store dates and times independently and use them with various operators. Additionally, Mirrored Backup was introduced, providing redundancy and increasing backup reliability. However, despite its benefits, the implementation of this feature has been limited. We would love to hear from you if you have experience with mirrored backup.

2007: TRUNCATE, Quality Assurance vs Quality Control, and Changing SA Login Password

Another interesting topic that sparked conversations in 2007 was the TRUNCATE statement. We discussed how TRUNCATE cannot be rolled back using log files after a transaction session is closed. This led to a deeper understanding of how log files, delete, and truncate operations work in SQL Server.

Furthermore, we explored the difference between Quality Assurance and Quality Control. Quality Assurance focuses on ensuring that the development and maintenance process is adequate to meet system objectives, while Quality Control evaluates the developed work product. Understanding these concepts is crucial for delivering high-quality software solutions.

Lastly, we discussed the importance of the SA login and how to change its password using Management Studio. We also acknowledged a factual error in the original blog post and corrected it promptly. It’s fascinating to see how even small details can generate ongoing discussions and emails.

2008: Security and System Admin Account

In 2008, we shifted our focus to security and the System Admin account. We explored topics such as disabling and enabling the SA user, adding users to sysadmin role, and the importance of keeping your production server up to date with security patches. These topics are still relevant today, as security remains a top priority in the SQL Server community.

2009: ORDER BY Clause, CDC and TRUNCATE, and Temp Table vs Table Variable

In 2009, we delved into the intricacies of the ORDER BY clause. We discussed the difference between using TOP and TOP WITH TIES, highlighting the importance of returning all rows with the same value as the last record in the top results. This knowledge is valuable when working with large datasets and needing precise control over the returned records.

We also explored the relationship between CDC (Change Data Capture) and the TRUNCATE operation. It became clear that CDC does not capture data during a truncate operation, as truncating a table is not logged in the log file. Understanding these limitations helps us make informed decisions when working with CDC-enabled tables.

Additionally, we compared Temp Tables and Table Variables in the context of transactions. While there are numerous articles discussing their performance differences, we focused on their behavior within transactions. This knowledge can help optimize your code and improve overall database performance.

2010: Indexes, Server Side Paging, and Plan Cache

In 2010, we conducted interesting experiments with indexes and views. We explored whether queries on views would utilize the index on the view or the index on the base table. This experiment shed light on the inner workings of SQL Server’s query optimization process.

We also discussed server-side paging in SQL Server 2012, providing a better alternative to traditional client-side paging. This topic generated significant interest, with readers asking if the values for the number of rows and pages could be stored in a table. The answer is yes, and we explained how to achieve this using the new syntax.

Lastly, we explored the Plan Cache and Data Cache in memory. Understanding how to find and analyze these caches can help optimize query performance and identify potential bottlenecks in your SQL Server environment.

2011: Point-in-Time Recovery and Database Backup

In 2011, we focused on disaster recovery and database backup strategies. We discussed point-in-time recovery, a crucial technique for restoring databases to a specific point in time. Documenting scenarios that require database restoration can help prevent future mistakes and ensure data integrity.

We also explored the Target Recovery Time of a Database, an advanced option in SQL Server 2012 related to Indirect Checkpoint. This option remains relatively unknown and underutilized, but understanding its functionality can improve database performance and recovery time.

Lastly, we examined the effect of the Compressed Backup Setting at the server level on database backup. When dealing with large databases, the size of the backup file can become a significant challenge. Understanding the philosophy behind database backup and compression can help overcome these obstacles.

2011: Year-End Brain Teaser

In our year-end brain teaser, we challenged readers with a technical and non-technical question. While the technical question focused on finding “The Hidden Tiger,” the non-technical question encouraged readers to reflect on their own experiences and lessons learned throughout the year.

Thank you for joining us on this journey through the years. We hope you found these articles informative and thought-provoking. Stay tuned for more exciting content as we continue to explore the ever-evolving world of SQL Server!