Sometimes when I get pulled in to look at a database, I’ll sit down with the developers or database administrators working on the database and get some background on the database. This usually includes pointing on the important tables, an explanation of why some design decisions were made, and some pre-conceived notions about where to … Continue reading To Be Or Not To Be In the Memory Buffer
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)
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
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!
Strate SQL 