Recent Blogs and Articles

Posted by SQL Enthusiast

Welcome to SQL Matters

Article by our editor

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

Posted by SQL Enthusiast

Searching a string for the last occurrence of a given string

CHARINDEX provides an easy way to search for the first occurrence of a string in another string. By reversing the order of the string it can also provide a straightforward way of finding the last occurrence of a string. This can be used in conjunction with the RIGHT function to extract the part of a string that is after the last occurrence of a given delimiter

Comments (5)  •   Read full article »

Featured Script

Posted by SQL Enthusiast

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.

Comments (32)  •   Read full article »

Quick Quiz : DATALENGTH results

Posted by SQL Enthusiast

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

More SQL questions »