Configuring SQL Server Reporting Services (SSRS) Users
A few months back, I wrote a post that demonstrated how to access SQL Server Reporting Services (SSRS) reports with the SSRS SDK for PHP. There have been many comments on that post, many of which indicated that people have struggled to get users set up with the correct permissions to access reports. Given the steps that are required to correctly configure users and permissions, I thought video might be a better medium than text for explaining. This video assumes that you’ve gone through the steps in Getting Started with SQL Server Reporting Services to install and configure Reporting Services and to deploy a report. If you’ve done that were then denied access to a report when running your PHP code, this video might help. I’d certainly be interested to if is does help and what other short videos might also be helpful.
This Week’s Link List (November 26, 2010)
I have been a slacker about posting my weekly link list recently…I’ll chalk that to attending conferences in the last couple of weeks, though I know that is a poor excuse. This week, however, I’m back in action and have LOTS to share because I have been collecting links even if I haven’t been publishing them. I’ve tried to limit this post to the best of the best over the last three weeks, but as you can see, that was difficult…
Why Pass Parameters by Reference in the SQLSRV Driver?
Last week at JumpIn Camp we spent quite a bit of time focusing on the SQL Server Driver for PHP. As developers worked to build SQL Server support into their applications, they had lots of questions about how both the SQLSRV and PDO_SQLSRV drivers work under the hood. One of the questions that came up was “When using the SQLSRV driver to execute parameterized queries, why do I have to pass parameters by reference?”
SQL Server Driver for PHP Connection Options: Connection Pooling
I’m back in from conferences in Germany (PHP World Kongress and TechEd) and am now at Jump In! Camp. I’ll echo what I seems to be a common sentiment after the first couple of days: it’s very cool to be surrounded by so many smart folks (and humbling too). It’s been fun having my knowledge of PHP, IIS, and SQL Server tested by folks asking questions that are real problems in real apps. (Hopefully, I’m passing the tests.) One topic that came up yesterday was connection pooling and how much difference using pooled connections makes in app performance, so that’s what I’ll look at in this post. But first, a little background…
Resources from PHP World Kongress Presentation
I’m just posting to share the resources from my presentation today at the PHP World Kongress in Munich, Germany. I’ve attached the slide deck that I used, but I’m not sure how useful it will be since most of my presentation was demos. (I hope to get video versions of the demos posted soon. If the deck doesn’t make sense now on its own, hopefully it will make sense when I get videos posted.) Here’s the links from my “Resources” slide, which is what most folks asked for:
This Week’s Link List (November 5, 2010)
Presenting at conferences is something that is still new to me…I’m amazed at how much time it takes to put a presentation together. I definitely have new found respect for those folks who are good at doing it. I’m sure I’ve spent too much time stressing over my presentations for the PHP World Kongress and TechEd in Germany next week, but I suppose that comes with the territory of being a new presenter (as does a quiet blog). I have, however, managed to keep my eye out for good content this week. Here’s what I found…