Though Intellisence is usually a very nice feature to have when working in SQL Server Management Studio (SSMS), it can sometimes get in the way. Here’s how you can disable it if you ever feel the need to: 1. From the Tools menu, select Options. 2. Select the Text Editor option on the … Continue reading How to Disable Intellisence in SSMS
Ever wonder why there are only two options under the INSERT and UPDATE Specification of a foreign key? Why is there no Insert Rule? And to which table in the relationship do these rules apply? Let’s start at the beginning. Relationships in a database are implemented with foreign keys and primary keys. (For a primer … Continue reading Referential Integrity Options (Cascade, Set Null and Set Default)
Contrary to popular belief, prefixing object names isn’t always a good idea and some professionals have dropped the practice entirely. To see why this is, let’s take a look at database object names as an example. Initially, it might seem like a good idea to prefix table names with “tbl,” views with “v,” and so … Continue reading Object Prefixes: Friend or Foe?
Do you need to know how often a report runs, who or what processes run the report, how long it takes to run, statistics on report parameters, which reports are not being used, and so on? SQL Server Reporting Services has built-in audit logging that can give you this type of information pretty easily. Audit … Continue reading How to Audit Report Execution in SSRS
A cover page is simply a page that comes before the report data and that usually contains a report title and other identifying information. It can add clarity to your report and give it a clean, professional look. The cover page usually doesn’t show any data or page numbers, and the first page of data … Continue reading How to Make a Cover Page in SSRS
In the 10777 course on data warehouses, we see how to use an SQL Server technology called Change Data Capture. We see how CDC allows data changes made to a line-of-business database to be captured so that we can incrementally update a data warehouse by applying those captured changes to it. We also learn that, before … Continue reading Which Databases and Tables Did You CDC-Enable?
While SSRS allows drill-down into individual groups in a Tablix, there is no built-in, direct support for an “expand all/collapse all” capability that would allow all groups to be simultaneously expanded or collapsed. No problem. We can create our own pretty easily. Here’s what it will do: The user will interact with two radio buttons. … Continue reading How to Implement Expand All/Collapse All for Drill-Down in SSRS
There are two ways you can format grouped data in a table data region in SSRS: You can use the stepped format or the block format. I’ll show you an example of each, how to create them, and then how to convert a group from one format to the other. I’ll also introduce group columns, … Continue reading Working with Stepped and Block Format with SSRS
Ever get this message in SQL Server Management Studio (SSMS) when you’re certain that the object exists? Then it proves you right when you go ahead and execute the command anyway? Why does SSMS complain that the object doesn’t exist when it obviously does? This happens because SSMS does not monitor database changes made in … Continue reading How to Get SSMS to Recognize an Existing Object (Refreshing Lists in SSMS)
What happens when you use the same scale to compare values that are actually in different scales? Have a look at this chart that was generated using Reporting Services and notice that you can barely see the gold columns for the Average Sales values. The data (see the table next to the chart) tells us … Continue reading Adding a Secondary Axis to a SSRS Chart