SQL Server

SQL Server Database Application performance issues?

• Are customers complaining your system is too slow?
• Are users complaining tasks take too long?
• Are some client applications running slowly or timing out?
• Are some queries/reports taking forever?

Specifying a No Rows Message for an SSRS/Report Builder Report

I’m sure we have all come across a scenario where a parameter report has allowed a user to specify a combination of conditions that results in no matching records for a dataset behind a region in an SSRS report.

If the report has headers, footers or textboxes then there may be some output produced when the report is run to make it obvious that there is no valid data for the report, as in the following example:

If you work with SQL Server based applications then probably quite a few!

Specifying a No Rows Message for an SSRS/Report Builder Report

If the report has headers, footers or textboxes then there may be some output produced when the report is run to make it obvious that there is no valid data for the report, as in the following example:

What Is Report Builder?

Report Builder implements the same Report Designer that is provided by SQL Server Reporting Services (SSRS) and the SQL Server Data Tools (SSDT) development tool.

Monitoring Logical and Physical Reads & Buffer Cache Usage

Many SQL Server performance problems will come down to poor physical disk performance or inadequate memory resource. This article takes a look at the Buffer Cache and some of the tools that we have for troubleshooting poorly performing SQL Server instances and queries.

Throughout this article we will meet a number of Dynamic Management Views, Functions and System Views:

Using a SQL Server SELECT Statement to Query an Excel Workbook

In this article we look at how you can query an Excel workbook as if it were a table in a SQL Server Database.

The SQL Server OPENROWSET function can be used to connect to a variety of data sources by means of a data provider: 

SQL Queries to Check Passwords & Privilege Assignments

Although we can create Linked Tables in Access that pull information from a SQL Server Database there are times when you want to check a value or lookup a value from an underlying SQL Server database directly from an Access Query.

We will look at an example that enables us to lookup a customer’s total revenue value from an Access Query.

Although we can create External Data Sets in Excel that pull information from a SQL Server Database there are times when you want to check a value or lookup a value from an underlying SQL Server database directly from an Excel formula.

We will look at an example that enables us to lookup a customer’s total revenue value from an Excel Formula.