Craig Porteous
A SQL Blog
  • Home
  • About Me

Archive for SQL Server 2016

SQL Shack Logo
Posted by Craig 
· 21st November 2017 
· No Comments

How to build a SQL Server Virtual Lab with AutomatedLab in Hyper-V

A few weeks back I wrote an article on SQL Shack on how to build a SQL Virtual Lab using the AutomatedLab module in PowerShell. This is an incredibly powerful module and great for any number of situations. I have primarily used it for creating proof of concept environments, ranging from single SQL servers, testing out version functionality to full domains with multiple servers, desktops etc.

Have a read and let me know what you think or your experiences with PowerShell and AutomatedLab in the comments

 

How to build a SQL Server Virtual Lab with AutomatedLab in Hyper-V

No Comments
Categories : Powershell, SQL Server 2014, SQL Server 2016, SQL Server 2017
Tags : automatedlab, hyper-v, lab, powershell, sql
SQL Shack Logo
Posted by Craig 
· 30th April 2017 
· No Comments

Managing SSRS security using PowerShell automation scripts

SSRS Security ModelTake a look at my post over on SQL Shack about Managing SSRS security using PowerShell automation scripts

No Comments
Categories : Powershell, Scripts, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SSRS
Tags : powershell, Security, ssrs
SSRS Subscription Management
Posted by Craig 
· 13th February 2017 
· No Comments

Managing SQL Reporting Services subscription failures

This is a solution I’ve had to put in place in almost all BI positions in some form or another. Its something that remains a “custom workaround” through all versions of SQL Server Reporting Services, right up to 2016.

I go into a lot of detail in my post on SQL Shack about a simple & effective way to alert on failed subscriptions using a SQL Agent job. Have a look over at SQL Shack:

SSRS Failed Subscription Alerting

No Comments
Categories : SQL Server 2012, SQL Server 2014, SQL Server 2016, SSRS
Tags : alert email, failed subscriptions, sql agent job, ssrs subscriptions
Posted by Craig 
· 23rd January 2017 
· No Comments

Writing for SQL Shack

News!

I’m now splitting my blog posts between here & SQL Shack. You’ll see mostly non-SQL content here. I’m still working with Powershell a lot so Ill post any handy scripts I put together here. All SQL based how-to’s and issues Ill blog about over on SQL Shack though. It’s a great opportunity to contribute to an already active site where the content should get better visibility.

For completeness though, Ill always link to articles from here.

Have a read at my first post on scaling out SSRS & the changes in 2016

Scaling out Reporting Services & changes in SQL Server 2016

Check out my first post over on @SQLShack on Scaling out Reporting Services & changes in SQL Server 2016 https://t.co/KouhSfkUXH

— Craig Porteous (@CPorteous) January 19, 2017

Ta

No Comments
Categories : SQL Server 2012, SQL Server 2014, SQL Server 2016, SSRS
Powershell snippet background
Posted by Craig 
· 8th August 2016 
· No Comments

SSRS Log Monitoring

This is something Ive put together to keep track of errors coming through the SSRS logs.

We capture the majority of priority errors through other methods but I find some still slip through if you’re not checking your log files regularly. It still baffles me that SSRS doesnt have better error monitoring/logging for subscriptions in particular. Even in 2016 we still use a custom SQL job to monitor & alert on failed subscriptions.

Here’s a quick overview of what Im doing with the logs:

Read More →

No Comments
Categories : Powershell, SQL Server 2012, SQL Server 2014, SQL Server 2016, SSRS, TSQL
Tags : error logs, error monitoring, notification, powershell, ssrs errors, ssrs logs
Posted by Craig 
· 26th July 2016 
· No Comments

SSRS 2016 URL Format changes

Mini-Post!

A small change to remember when looking to upgrade to SQL & SSRS 2016 is a change to the Report Manager URL format.

If you have any apps or custom scripts that build or use existing report URLs (for 2014 & below) you should be ok as the old format is still valid (…for now?) & appears to redirect internally, rendering the report with the new URL.

Here’s an example:

2016: http://……/reports/report/FOLDERNAME/REPORT%20NAME

up to 2014: http://……/Reports/Pages/Report.aspx?ItemPath=%2fFOLDERNAME%2fREPORT+NAME&ViewMode=Detail

You may be happy to hear though that the ReportServer URL format remains the same.

PS. As updated in this previous post, this issue/quirk still applies in 2016! http://craigporteous.com/2016/03/ssrs-report-name-case-driven-from-url/

Hope this helps!

Thanks

 

No Comments
Categories : SQL Server 2016, SSRS
Tags : ssrs, ssrs 2016, url format
Posted by Craig 
· 18th July 2016 
· 4 Comments

SOLVED: SSRS 2016 behind a Network Load Balancer

UPDATE 1 (19/07/2016): After posting this to twitter last night I got some instant help from the Senior Program Manager for SSRS at Microsoft. Thanks to Riccardo Muti for the info. I will update here again when Ive been able to confirm. Ill leave the post intact as Im sure others will go through the same thought process!

@Technitrain @CPorteous @SQLServerBI Nothing to update for RSWebApp itself; it doesn't use https://t.co/LJUEu0UIn0 Web Forms or ViewState.

— Riccardo Muti (@RiccardoMuti) July 18, 2016

 

Having came through very little in the way of teething problems doing an in-place upgrade from SQL & SSRS 2014 Ive now come up against a doozy!

With the new configuration of SSRS there is no Report Manager subfolder. Instead we see this new RSWebApp folder.

SSRS2016_Folders

Read More →

4 Comments
Categories : SQL Server 2016, SSRS
Tags : 2016, machine key, report manager, ssrs, ssrs 2016, viewstate validation, web.config
Posted by Craig 
· 6th May 2016 
· 2 Comments

SSRS 2016 Brand Package breakdown

With SQL Server 2016 you now have the ability to customise the SSRS Report Manager’s look & feel. This comes in the form of applying a “Brand Package”. Its not free reign over the css for the site but its a giant leap in the right direction for the BI platform.

There is a great technet blog post that goes through the customising process & elements but I wanted to go into greater detail and define what every element in the JSON file affects on the page so I painstakingly documented the effects of changing each element & re-uploading to Report Manager.

Ill explain all of the elements found in the JSON file in the table below then present views of Report Manager annotated with these elements to better explain what they affect. Read More →

2 Comments
Categories : SQL Server 2016, SSRS
Tags : brand package, report manager, SQL server 2016, ssrs, ssrs 2016
Microsoft Virtual Labs
Posted by Craig 
· 21st March 2016 
· No Comments

SQL Server 2016 Training Lab

This training lab provided by Microsoft for the new SQL Server 2016 Mobile reporting functionality turned out to be a great tool for pulling together a quick Proof of Concept. I hope this info helps someone with the same task.

When I completed the lab on a local SQL 2016 instance (instead of the Lab VM) I was able to easily demonstrate the new functionality in SSRS through the Report Manager interface & the iOS PowerBI app.

  • The script files can be pulled out of the lab VM by logging into a web email client within the VM (Yes it has full internet access??!!) and mailing them to yourself. Please dont type out all the stored procs like I did with the first few!
  • I picked up a copy of the AdventureWorks DB here. Its the CTP3 version but that seems to be the most recent.
  • The version of SQL 2016  I used is RC0
  • The lab, along with quite a few others, can be found here:
    • Exploring What’s New in SQL Server 2016 Reporting Services for Mobile Reporting

Read More →

No Comments
Categories : PowerBI, SQL Server 2016, SSRS
Tags : adventureworks, lab, mobile reporting, poc, SQL 2016, training

Recent Posts

  • Top 10 things to document in SSRS 27th February 2018
  • I published a PowerShell Module! 16th January 2018
  • Clustering the Power BI Data Gateway for High Availability (and Low visibility?) 4th January 2018
  • Managing Power BI Dataset Refresh Failures 30th November 2017
  • How to build a SQL Server Virtual Lab with AutomatedLab in Hyper-V 21st November 2017

Categories

  • Announcements (4)
  • ASP.NET (1)
  • C# (1)
  • Certifications (1)
  • MySQL (1)
  • PowerBI (5)
  • Powershell (9)
  • Scripts (2)
  • SharePoint 2010 (2)
  • SQL Server 2012 (5)
  • SQL Server 2014 (7)
  • SQL Server 2016 (9)
  • SQL Server 2017 (3)
  • SSAS (1)
  • SSRS (14)
  • T-SQL Tuesday (1)
  • TSQL (1)
  • Uncategorized (1)

Social

  • View cporteous’s profile on Twitter
  • View craigporteous’s profile on LinkedIn
Craig Porteous · Copyright © 2018 All Rights Reserved
iThemes Builder by iThemes · Powered by WordPress & hosted by SiteGround WordPress Hosting