Report subscription changes in sql server reporting services 2016

What makes SQL Server 2016 one of my favourite SQL Server release since the release of SQL Server 2012 is the increased number of exciting new features that have been introduced. Data recovery mac hard drive Whilst my article Top 5 New SQL Server 2016 DMVs for DBAs reviewed some of these new features albeit from a DBA point of view, in this article I continue to review SQL Server 2016 but from the perspective of an SSRS administrator in relation to the changes in report subscriptions. One of the first changes you will notice in SQL Server Reporting Services (SSRS) 2016 is the new Subscription Settings property that comes up as one of the new configurable items in Reporting Services Configuration Manager, as highlighted in Figure 1. This new configuration setting enables you to configure a server-wide level file share account that can be used by a Windows file share delivery subscription to upload file artefact onto a given file share.


H2 database tutorial If you recall, in versions prior to SSRS 2016, you had to specify logon credentials every time you setup a Windows file share delivery subscription. Database interview questions In other words, if you had 15 subscriptions that uses the same account to upload files into the same file share – you had to retype the same logon credentials 15 times! As of SSRS 2016, you can configure the file share account once and instead of retyping it for every subscription you just choose the associated radio button option in subscription settings, as shown in Figure 2. Just because it’s been configured doesn’t mean that you always have to use it in your subscription – as shown in Figure 2, you still have the option to manually configure another Windows user credential Likewise, every new feature has its pros and cons and the file share account is no exception. R studio data recovery free download So beware that file share account could introduce a security threat in your environment. Data recovery bad hard drive This is because file share account (like any account used in a Windows share delivery subscription) requires writer permissions which means if the aforementioned 15 subscriptions were actually writing onto 15 different file shares and you intended on using the same file share account for all your 15 report subscriptions then you would need to grant the same account writer access across all 15 Windows locations which could be a security risk. In versions prior to SSRS 2016, data-driven subscription process – for any delivery method – involved a mandatory 6-step process depicted in Figure 3. The annoying part about this process was that some of the steps were irrelevant for some subscriptions. Database field definition For instance, if you were configuring a subscription on a report that didn’t have parameters, you still had to go through Step 5 as per the example shown in Figure 4. In SSRS 2016, unnecessary subscription setting options have been eliminated. Data recovery windows 7 Firstly, < Back and Next > buttons have been removed as all the subscription settings take place within one window. Nexus 4 data recovery Secondly, this single subscription setting window is dynamic in the sense that when the underlying report for the subscription doesn’t contain any parameters then the parameter configuration sub-section is not shown in the subscription setting window. Database version 706 To illustrate this point, Figure 5 shows two screen dumps of subscription setting for a report that doesn’t have parameter and another section with report parameters; you will notice that the next section after the Dataset section for the report without parameters is the Create subscription / Cancel buttons (effectively, the end of the subscription setting) whereas the subscription setting for the report with parameters has a further one more section – the Report parameters section. Another newly introduced data-driven subscription feature in SSRS 2016 is that you can now get a preview of the fields that will be returned by your subscription dataset. Cindia data recovery I hope the listing of dataset fields can deter those people that continues to run a SELECT * T-SQL command in their subscription dataset from retrieving unnecessary fields by rewriting the dataset command with specific fields that they want to retrieve. Although, in versions prior to SSRS 2016, you had multiple ways to get to the subscription page (i.e. Database tutorial click Subscribe from dropdown report menu, click My Subscriptions link etc.) only one of the multiple ways would actually get you to the data-driven subscription creation page. R database packages The correct method was one that was going to lead you to the New Data-driven Subscription button shown in Figure 6 which you could get to by navigating as follows: {Report Name} > Manage> Subscriptions SSRS 2016 continues to support multiple methods of getting to the subscription page, but the New Data-driven Subscription button has been done away with and instead, all multiple methods redirect you to the same subscriptions page wherein you can choose whether you want to proceed to create a standard subscription or data driven subscription as shown in Figure 7. I actually wrote this article whilst on vacation during which I was bombarded by work email subscriptions for one of my company’s sales reports – despite the fact that the sales department was also on Christmas leave. Database disk image is malformed Well, thanks to this new feature I was able to enjoy my holiday by temporarily disabling the subscription. Windows 8 data recovery software I did all of that by just clicking the Disable button on report manager as shown in Figure 8. One of the oldest requested items in Microsoft Connect has finally been actioned and thus as shown in Figure 9, SSRS 2016 enables you to send out subscriptions with PowerPoint formatted attachments. Just bear in mind that most of SSRS controls (i.e. Database naming standards matrix, tablix) get saved as images in the PowerPoint format of the report which means that some of the programmable actions (i.e. Data recovery training online hyperlinks to other resources) that might have been configured in your report could be disabled in the PowerPoint version of the report. When you are looking to edit a subscription that exists in an environment that has several other subscriptions, the description field makes it easier to identifier that particular subscription you are looking for. Database query Unfortunately, prior to SSRS 2016, the description for a standard subscription type was merely a subscription status as the ability to set subscription description was limited to only data driven subscription (which is only available through the enterprise license of SQL Server). Database isolation levels Figure 10 shows an example of an SSRS 2014 standard subscription whose description is just a previous subscription status. Well in SSRS 2016 you no longer have to upgrade your SQL Server license just to have control of your subscription description as you are now given the ability to edit description of standard subscriptions too. Over time, SSRS administrators are bound to come and go from your team at which point you may need to hand over ownership of a subscription into another administrator to look after. Database version control This is where such a feature is most useful. Database record definition Say for example I needed to transfer ownership of the subscription described as rslogsubs2 in Figure 12. Well, all that I would need to do is edit the subscription, navigate to the Owner textbox and provide the domain account that I would want to set as the new owner for this subscription. The only downside to this new subscription feature is that the domain account that you will provide as the new owner of the subscription will only be verified at run time (i.e. Database glossary when you click Apply to commit the change), so if you have mistyped some character or provided a totally fictitious domain account (as shown in Figure 15), you won’t know about it until you apply
your changes in which an error message similar to the one shown in Figure 16 will come up. Unfortunately, not all changes made in this latest version of SSRS are for the betterment of our lives as administrators. Data recovery druid As highlighted in Figure 17, in versions prior to SSRS 2016 you had the ability to sort a subscription list by clicking on field names i.e. Data recovery houston tx Description.

banner