September 2018
• Checking Whether Connections to SQL Server are Encrypted
  
November 2017
• Amazon RDS - Common Issues with native SQL Server backup and restore
  
October 2017
• SQL BITS Conference - London 2018
  
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
• Setting up Transparent Data Encryption (TDE) Part 2 of 3
  
• Best Practices for Transparent Data Encryption (TDE) Part 3 of 3
  
• Pros and Cons of Transparent Data Encryption (TDE) Part 1 of 3
  

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

It can useful to periodically check the amount of disk space used by each database on a server. This tip shows how to do this using sp_spaceused system stored procedure and also by querying the sys.databases and sys.master_files system views.

One thing I like to do occasionally, or when "inheriting" a new SQL server is to check which users have sysadmin privileges. As these users have access to perform any activity in SQL Server it’s important to keep the number of these users to a minimum especially on production systems.

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