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
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
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!
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?
Strate SQL 