SQL Server Architecture Diagram

Why is our SQL Server Application running so slowly?

SQL Server Database Application performance issues?

Do you have SQL Server database applications that seem to be struggling to keep up with user demand or failing to deliver information quickly, but have no idea why?
  • 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?

How Do You Define a Message For An SSRS/ReportBuilder Report With No Rows?

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:

SQL Server SSRS - No Rows Property for Region

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:

What Is Report Builder?

What Is Report Builder?

Report Builder is a report creation tool from Microsoft enabling you to develop simple to complex reports and dashboards based on data from a variety of data sources such as SQL Server, Azure, Oracle, DB2, Teradata databases, SAP, XML,ODBC sources.

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.

SQL Server - Monitoring Logical and Physical Reads & Buffer Cache Usage

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:

SQL Server - Querying an Excel Workbook From an SQL Query

Using a SQL Server SELECT Statement to Query an Excel Workbook

Occasionally you may find that some of the data you need to reference in a SQL Server query is located outside of the database in 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: 

Using Access VBA to Query a SQL Server Database

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.

Using VBA we can do this!

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

 

Using Excel VBA to Query a SQL Server Database

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.

Using VBA we can do this!

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

 

Pages