Strange that I’ve never had/wanted to do this before, helping someone do it today and renaming it causes everything to break. The main ReportDB (regardless of what you named it) has hard references to the location to the ReportingTempDB (whatever it was called when you did the install). I found this post from quite a […]
Read more "Renaming The Reporting Services TempDB Database"Yesterday Kendal Van Dyke posted a file to Skydrive with consolidated information from all the events published so far. He built it by grabbing the individual event feeds and I’m guessing some scraping to come up with a file that is useful. Kudos to Kendal for doing this, it fills a gap that has been […]
Read more "See Consolidated Data About SQLSaturday (Events, Sponsors, And Speakers)"Ran across this poster of movie quotes – $20 will get you a copy. Why might you be interested? The visualizations of the quotes!
Read more "Famous Move Quotes–Visualized"If you missed it live you get a second chance! http://www.mssqltips.com/sql-server-video/284/security-compliance-and-sql-server-video/. Had about 300 attend and more questions than we could answer in the time left, will try to do some follow up posts in the next week or so to answer them (and feel free to post questions here as well).
Read more "Security, Compliance, and SQL Server – Recording Now Available"I reviewed my daily report and saw that some jobs failed on six instances overnight, the common factor being that they all used Powershell. None of them had failed recently or been changed recently, and the same code executed fine on many other instances in the same time frame. Here is the error message: A […]
Read more "Uninstalling SSMS on Server Breaks SQL Powershell"Over the past week there has been information finally coming out about how the Target breach occurred. This write up in Wired and another by Brian Krebs point back to a compromise in the Point of Sale (POS) system by malware that does ‘memory scraping’. Interesting. Typically POS devices are assumed and certified to be […]
Read more "More On The Target Breach"I went 30 miles south last night for the first meeting of the year. Extra good night because I was taking someone with me for their first MagicPass meeting! Meeting went well, enjoyed the open floor time and also the idea of having a topic to discuss during the dinner break. Thanks to Bradley Ball […]
Read more "Notes From the January 2014 MagicPass Meeting"Just received an email from my friend Ryan Duclos announcing the South Alabama Day of .Net in Mobile, Alabama, on March 29, 2014. I won’t be able to make the drive up this year, but wanted to share the event in case you’re in the area or looking for a reason to travel and learn. […]
Read more "South Alabama Day of .Net"As required, the Board has posted proposed changes to the bylaws for review by the members. The changes are fairly straight forward, reducing the number of Board seats by 2 – a change driven by CA choosing to relinquish their two seats. I like seeing a small and very specific change made, it’s easier to […]
Read more "Review of Change to PASS Bylaws"I’m a bit late posting this, but it’s worth a couple minutes to check out the Community Choice awards, might see a product that you haven’t tried or haven’t thought about lately, maybe something that will solve a problem or solve it better than you do now.
Read more "SQL Server Pro Community Choice Awards"
SQLAndy 