What’s New in Reporting Services (SSRS) 2017
Check out my article on What’s New in Reporting Services (SSRS) 2017 over on SQL Shack!
Integrating with ASP.NET Part 1: Perforce source control
There are many flavours of version control out there. Github, Bitbucket, Perforce etc. Ranging from publicly free to enterprise level. This project called for an interface with Perforce, which makes this post somewhat niche but similar principals could be applied to other software. Perforce provide a great number of APIs to integrate with their products,…
Considerations for On-premises data in Power BI
Check out my post about Considerations for On-premises data in Power BI over on SQLShack
Dr Greg Low speaking @ Glasgow SQL User Group!
I am excited to announce that Dr Greg Low will be speaking in person at our next Glasgow SQL User Group session on the 23rd May! We had a great remote session with Paul Randal last month with a good turnout too. With new sponsors & another great speaker, this month is sure to be a…
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
Off to SQLBits XVI
Myself and a few colleagues head off to SQLBits XVI in Telford today! I have quite a few sessions in mind. I just hope I can decide between a few conflicts! I highly recommend it, following my first time last year. I met a few people that have helped & inspired me over the last…
How to automate SSAS tabular model processing in SQL Server 2016
Ive written a quick how-to over on SQL Shack on automating SSAS tabular model processing in SQL Server 2016
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…
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…
AD Group Auditing with Powershell
Here’s another handy Powershell script Ive created. It borrows components from another(credited at the bottom of the post) and expands on the repadmin functionality in the Active Directory Powershell module. The main aim of this is to keep track of members being added or removed to Active Directory groups. There is functionality to do this within…