SQL Server is a powerful relational database management system that is widely used in the industry. Over the years, SQLAuthority.com has published numerous articles covering various aspects of SQL Server. In this blog post, we will highlight some of the most interesting and informative articles from the SQLAuthority.com archives.

1. FQL – Facebook Query Language

Facebook introduced FQL as a way to query their data using a condensed XML format. This article discusses the advantages of FQL, such as reducing bandwidth and parsing costs, and providing a unified interface for data retrieval.

2. UDF – Get the Day of the Week Function

Learn how to retrieve the day of the week in SQL Server using the DatePart function. This article provides a code example and explains how to convert the numeric value returned by the function into a string representing the day of the week.

3. Function to Get Previous And Next Work Day – Exclude Saturday and Sunday

Discover a useful function that excludes weekends (Saturday and Sunday) and retrieves the previous and next work day. This article explains the function and its implementation, which can be handy for various business scenarios.

4. Introduction to Log Viewer

Explore the log viewer feature in SQL Server, which allows you to view all the windows event logs and SQL Server logs in one place. This article explains how to launch the log viewer, export logs, and apply filters for better analysis.

5. Maximizing View of SQL Server Management Studio – Full Screen

Learn two methods to enhance your experience with SQL Server Management Studio. The first method opens query results in a separate tab, while the second method maximizes SSMS to full screen. These techniques can improve productivity and performance.

6. Puzzle – Write Script to Generate Primary Key and Foreign Key

Discover a solution to script all the keys in SQL Server Management Studio. This article addresses the challenge of manually scripting each key and provides a script to generate primary and foreign keys for multiple tables.

7. Computed Columns – PERSISTED and Storage

Understand how computed columns are created in SQL Server and why they may consume more storage space. This article discusses the difference between persisted and non-persisted columns and their impact on storage requirements.

8. Interview Questions and Answers – Data Warehousing Concepts

Explore a comprehensive series of interview questions and answers related to data warehousing. This article covers topics such as dimensional modeling, fact tables, ETL, OLTP vs. OLAP, and more. It provides a valuable resource for anyone preparing for a data warehousing interview.

9. Azure Interview Questions and Answers

Get insights into SQL Azure with a collection of interview questions and answers. This article covers various aspects of SQL Azure, including its differences from SQL Server, migration, security, pricing, limitations, and performance optimization.

10. Observation of Top with Index and Order of Resultset

Learn about the nuances of using the TOP keyword in SQL Server queries. This article discusses how the order of the result set and the presence of an index can affect the behavior of the TOP clause. Understanding these observations can help optimize query performance.

These are just a few examples of the diverse range of topics covered in the SQLAuthority.com articles. Whether you are a beginner or an experienced SQL Server professional, exploring these articles can enhance your knowledge and skills in SQL Server.

Which of these articles caught your interest? Let us know in the comments below!