SQL Server 2016 Archives - Craig Porteous

Archive for SQL Server 2016

Posted by Craig

· 21st November 2017

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

Posted by Craig

· 30th April 2017

· No Comments

Managing SSRS security using PowerShell automation scripts

Take 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

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

No Comments

Categories : SQL Server 2012, SQL Server 2014, SQL Server 2016, SSRS

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:

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.

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

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

No Comments

Categories : PowerBI, SQL Server 2016, SSRS

Tags : adventureworks, lab, mobile reporting, poc, SQL 2016, training

Archive for SQL Server 2016

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

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

Managing SSRS security using PowerShell automation scripts

Managing SQL Reporting Services subscription failures

Writing for SQL Shack

News!

SSRS Log Monitoring

SSRS 2016 URL Format changes

Mini-Post!

SOLVED: SSRS 2016 behind a Network Load Balancer

SSRS 2016 Brand Package breakdown

SQL Server 2016 Training Lab

Recent Posts

Categories

Social