Category: SQL Server 2012
Reading Time: < 1 minute CodeSnippets #2 This is a query I would run when I needed to quickly make bulk changes to Reporting Services subscriptions. It’s part of an “emergency fix” toolkit. Maybe a DB has went down and I have to quickly suspend...
Reading Time: < 1 minute Take a look at my post over on SQL Shack about Managing SSRS security using PowerShell automation scripts
Reading Time: < 1 minute 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...
Reading Time: < 1 minute 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...
Reading Time: 4 minutes 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...
Reading Time: 2 minutes Im picking this up after almost a year because everything else has always been more important. Its the usual excuse right? My intention was to do all 3 exams (70-461, 462 & 463) to achieve the MCSA: SQL Server 2012/2014 ....