Not comprehensive, but perhaps useful next time: Verify that the SPN’s are correct for the server that has the Reporting Services database. Many ways to do this, but I like the Kerberos Configuration Manager. The SPN tab should show “Good” for the instance that hosts the database. If not, fix (typically requires domain admin). Don’t […]
Read more "Notes on Setting Up & Troubleshooting Reporting Services Using Kerberos"I ran across a thread about statistics being up to date and part of it was about stats generated by DTA (see the comment by Aaron Bertrand). Easy to identify: select db_name() as dbname, name from sys.stats where name like ‘_dta_stat%’ Are they being used? Drop them? Assuming autostats is on, the only risk would […]
Read more "Stats Generated By Database Tuning Advisor"It’s easy to forget, or not get at all, how intimidating it can be to take the first step into public speaking, and more than that, how devastating it can be if that first effort goes badly. I’ve long been an advocate of providing some coaching or training to first timers. If you’re going to […]
Read more "Growing New Speakers By Sharing The Stage"Don’t Understand? You’re About to Learn Something was published March 9, 2015, and it’s about the mindset of being comfortable with learning, or more accurately, with not understanding. It’s a lesson I’m trying to teach my daughters who are elementary school. Like many beginners they are zoomed in on syntax and details and just trying […]
Read more "SSC Editorial: Don’t Understand? You’re About to Learn Something"Are holidays benefits? If you’re not sure, imagine your reaction when you no longer get paid holidays! Or that first sad day as a consultant when you realize you can’t work Monday because the client’s employees have the day off. They get paid, you get no billable time! One of the comments mentioned being reluctant […]
Read more "SSC Editorial: Holidays as Benefits"Upgrade and Refresh, or Not? was published on Friday and as I write this hasn’t had a lot of comments. Friday blahs? Or bad title? Both perhaps. I definitely wish I had worked on the title more – why is picking a title my least favorite part? In any case, as I wrote about upgrades […]
Read more "SSC Editorial: Upgrade and Refresh, or Not?"This morning I needed to run one of my Azure hosted VM’s for a few minutes to use Visual Studio and found this amusing message: Dividing that by 365.25 days yields a whole lot of years! Yet for all those days, it did require me to refresh the license (by logging in with […]
Read more "A Forever License–Not! Visual Studio 2013"Tim Ford has a post on the PASS blog today about Feedback Requested on SQLSaturday Numbering System that is worth a quick read and comment. Basically the idea is to remove the numbers from the event title to make it easier to reuse marketing materials. My feedback on the change: Joe Healy suggested the numbering […]
Read more "Changes to the SQLSaturday Numbering System"Last year I took on the marketing of SQLSaturday and a good time doing it, with some nice results for the extra effort I invested. As I thought about what I wanted to do this year and what I had time for, I realized I couldn’t make the long commitment marketing requires (months of continuous […]
Read more "My Role at SQLSaturday Orlando This Year"This past weekend in Tampa I spoke with a first time volunteer who had attended the events before (in Tampa and other cities) and he said that he had been really surprised and impressed by the amount of work that the event requires. I think he was disappointed a little that he had not realized […]
Read more "From a SQLSaturday Volunteer: There Was a Lot More To This Than I Ever Knew"
SQLAndy 