I was reading SD Times and saw a nice 2 page ad for the Big Data Techcon coming up April 26th in Boston. I did a quick look at the schedule and I don’t see any SQL Server content or speakers from Microsoft. I wonder why not? Too late for me to consider attending it […]
Read more "Big Data Techcon"For once an easy problem to solve! We needed to change the retention values for OperationsManagerDW (SCOM uses OperationsManager as the main store, this is the data warehouse) and it was surprisingly easy using the notes from Understanding and modifying Data Warehouse retention and grooming. Download a utility, unzip (no install), copy/paste the commands into […]
Read more "Setting the Retention Limits for the OperationsManagerDW Database"Mastery – Repetition, Variations, and Depth was published yesterday and as you can surmise is about learning, one of my favorite topics. I’m not sure we teach the realities to those new to our profession. We can’t learn it all, know it all, master it all. We can’t measure our career by what we don’t […]
Read more "SSC Editorial: Mastery – Repetition, Variations, and Depth"Ed Leighton-Dick published a challenge for new bloggers (or those who haven’t blogged in a while) to do one post a week during April. Great post, great reason for it, and I hope that many of you will give it a try. Read his post first! Some thoughts for those of you that are brand […]
Read more "Thoughts on The SQL New Blogger Challenge"Needed a quick fix this week to build on Finding Checked Out Files in TFS. That one line TF.exe call gets the list of all the checked out files. For this task I just needed to find files checked out to a handful of people and generated a file for each, mostly just to do […]
Read more "Splitting Out The List of TFS Checked Out Files"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"Back in September 2012 I ordered an Everki Flight Checkpoint Friendly backpack. I think it was $72 at Amazon at the time. I’ve used it daily since then and been really pleased with it. The orange interior is very nice, I instantly notice the difference when I use a different bag. The zippers are solid, […]
Read more "An Update on My Everki Backpack"
SQLAndy 