I saw this post a few weeks back and got around to downloading it myself tonight. If you don’t know what it is. It’s a free SQL Server security book. Best of both Worlds There are two things I like about this e-book. The first, it is free. And the second, it’s a book on … Continue reading Free SQL Server Security Book
In less than a month SSWUG will be hosting the Ultimate Virtual Conference on October 21-24. This is an excellent opportunity to get the benefits of heading to a conference full of Rock Star speakers while be able to view the content from the comforts of home or your desk. Reasons to Attend Some of … Continue reading Check out the Ultimate Virtual Conference from SSWUG
While working on some questions for a project I am working on, I ran into an issue with Report Manager today. I haven’t had the pleasure of running into this issue in a while and thought I would share the issue and the resolution because it affects both Windows 7 and Vista. Between this time … Continue reading Report Manager in Windows 7
Well… until next month of course. If you’re in Minnesota and reading this… and don’t mind sharing some snacks with other like minded SQL professional… then come down and join us for this month’s SQL Server user group meeting. We’ll be in a different location for this month – across the skyway from the normal … Continue reading This Week Only PASSMN Meeting (August 18)
The PASS Summit is coming up in just a few short months. Have you had a chance to make your arrangement? If you are like many, the down economy may be cutting into the budget that typically goes towards these events. If you hadn’t heard, the screaming baby on the side wants you to know … Continue reading Psst… It’s Free!
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
Strate SQL 