Recent Blogs and Articles

Welcome to SQL Matters

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 :

Featured Tip

Using Execute As with Stored Procedures and Dynamic SQL

In most situations it is sufficient to grant a user 'EXECUTE' rights to a stored procedure in order to run it, however if the stored procedure contains dynamic SQL an error can occur even if the user has sufficient rights to run the stored procedure. Fortunately we can use "Execute As" to resolve this.

Featured Script

Checking the status of SQL Server Agent jobs

As a DBA it’s important to quickly identify any issues with SQL Server Agent jobs. This article includes a number of scripts which make it easy to identify which jobs have failed and which are still running as well as generating a history of when each job ran.

Quick Quiz : DATALENGTH results

What is the result of the following SQL query ?
SET @MyStr = 'ABC'
Choose one : a) 3    b) 6    c) 50    d) 100