One of the reasons I was digging around to find out how many reports were being executed for each folder the other day was that there were some subscription issues at the client. The goal was to get a break down of when reports were being executed and generally who’s reports they were. With that … Continue reading Analyzing Report Execution Time
While working with a client a couple weeks back, I was asked to determine the count of reports that were being executed under each folder off the root directory on the Reporting Services instance. Each of the folders off the root directory represented a department at the client. For the output, I decided that I … Continue reading Finding Number of Reports Executed By Folder
This is an amazing technology concept. It is a little ugly at the moment, but I bet that once it hits the design phase it will look pretty cool. Maybe they’ll be able to shrink it into a pair of sunglasses. UPDATE: Amazing to think that about four years later, we're seeing these around as … Continue reading The Sixth Sense
About a year ago I was working on a project that required that data be extracted from one database and inserted into an database. Not the most earth shattering concept. This is done quite often and doesn’t necessarily require a discussion of foreign keys. So why talk about them… well… in this case the source … Continue reading Gotta Stop Violating Foreign Keys
Staying on top of patches for your applications can be important, especially when those patches can fix issues that are currently affecting your environment. I’ve run into this from time to time with where the fix for an issue is related to the current state of updates to the SQL Server instance. If the data … Continue reading Apply Those Updates
One of SQL Server 2008 features I’ve been especially thrilled about is the Management Data Warehouse (MDW). Just recently, Microsoft released a white paper by Kalen Delany that goes into a bit a depth on MDW and covers some best practices and things to watch out for. Happy reading!
Some people have dreams and they talk about them and an entire generation is changed. Things line up and world is a lot different than the day before just because of a little dream. I dream, too. But my dreams aren’t so grand. I tend to dream about SQL Server professionals coming together to network, … Continue reading I Had a Dream, too!
Jobs aren’t a dime a dozen like they used to be during the dot-com bubble. These days the unemployment rate is heading to territory that hasn’t been seen in decades. With some states seeming unemployment rates as high as 15%. It becomes more important with every interview to differentiate yourself from the pack. Differentiate Yourself … Continue reading Moving to the Head of the Line
This week SSWUG is hosting another virtual conference featuring content for SQL, SharePoint, BI, and .NET professionals. There is a lot going on and like their previous conferences you don’t have to leave the comforts of your beach bungalow to participate in the conference. I encourage everyone to check this out… We're excited to … Continue reading Are you busy Wednesday, Thursday, and Friday?
A while back I put together a number of posts around an index analysis query that I had put together to assist when I go out to clients. If you are interested, the background for the query can be found in the following posts: Analyze Your Indexes Part 1 Analyze Your Indexes Part 2 Analyze … Continue reading Analyzing Your Indexes with a Custom Report
Strate SQL 