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 useful articles from the SQLAuthority.com archives.

2007: Stop SQL Server Immediately Using T-SQL

Have you ever wondered how to stop SQL Server using T-SQL? This article provides a simple script that demonstrates how to stop SQL Server using T-SQL. It’s a handy trick to have in your toolbox.

2008: Query to Find Column From All Tables of Database

Searching for a specific column in a database can be a tedious task. This blog post presents a script that allows you to find a table name in the database quickly. It’s a time-saving technique for developers and database administrators.

2009: Forgot the Password of Username SA

Forgetting the password of the SA account can be a nightmare for database administrators. This article provides a simple solution for resetting the password of the SA account. It’s a must-know technique for anyone managing SQL Server instances.

2010: SQL SERVER – Computed Column – PERSISTED and Storage

Computed columns are a powerful feature in SQL Server, but they can consume more storage space than regular columns. This article explains how computed columns are created and why they take more storage space. It’s essential knowledge for optimizing database storage.

2011: Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy

Efficient query writing is crucial for improving the performance of SQL Server databases. This series of articles provides valuable tips and strategies for writing efficient queries. It covers topics such as square brackets usage, finding un-matching records, row constructors, and many more.

2012: Query Hint – Day 1 of 5

Query hints can be used to influence the query optimizer’s behavior and improve query performance. This article explores different query hints and their impact on query execution. It’s a valuable resource for developers and database administrators looking to optimize their queries.

These are just a few examples of the wide range of topics covered in the SQLAuthority.com articles. Whether you are a beginner or an experienced SQL Server professional, there is always something new to learn and explore in the world of SQL Server.

Stay tuned for more informative articles and tutorials on SQL Server concepts and ideas!