February 2017
• SQL Server TCP Port vs TCP Dynamic Ports
  
January 2017
• Registered Servers vs Central Management Servers
  
November 2016
• Amazon RDS – Creating a native (.bak) Backup of a SQL Server Database in RDS
  
June 2016
• Searching ALL SQL Server Logs using TSQL
  
May 2016
• Best Practices for Transparent Data Encryption (TDE) Part 3 of 3
  
• Setting up Transparent Data Encryption (TDE) Part 2 of 3
  
• Pros and Cons of Transparent Data Encryption (TDE) Part 1 of 3
  
September 2015
• Amazon RDS SQL Server Hosting - Pros and Cons
  
August 2015
• Moving a Table to a Different Filegroup
  
January 2015
• SSRS : Changing how a date and time is displayed to UK
  (dd/mm/yyyy) format
  

SQL Matters is a resource for SQL Server Developers, Architects, DBAs and others interested in SQL Server and related technologies . Our site contains a wide range of articles, tips, blogs, quiz questions and other information about the SQL Server range of products. This includes Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS) and some other products that we feel might be of interest to the SQL Server community such as PowerPivot and Report Builder.

Here are some examples of technical information that you might be interested in :

• Formatting a number with thousand separators
• Splitting the query window in SSMS
• Determining the last time SQL Server was started

Sp_who2 is one of the most useful and widely used stored procedures, along with its predecessor sp_who. However it is also one of the most frustrating as it only takes a single parameter and the results cannot be ordered. For a large server with a lot of connections this can be a real nuisance. This article explains how to sort and filter the results.

The stored procedure xp_readerrorlog (and also sp_readerrorlog) allows searching of the SQL Server error logs. However only one log can be searched at a time. This script searches all available logs, by looping through each log in turn.

What is the result of the following SQL query ?
Choose one : a) 3    b) 6    c) 50    d) 100