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!
Tag: SQL Server 2008
Are you busy Wednesday, Thursday, and Friday?
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?
Analyzing Your Indexes with a Custom Report
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
Resource Governor Whitepaper
There were some questions last night at the PASS MN user group meeting last night about the resource governor. There must be some psychics working over at Microsoft because it seems just this morning a whitepaper came out on it. Some highlights from the whitepaper from the whitepaper include (from the download page): How the … Continue reading Resource Governor Whitepaper
What Happened to My Fabulous Beverage!
Everyone likes taking some time to relax. You’re sitting out in the sunshine or on a beach and the waitress is bringing you your favorite beverage. The company and conversation is great and it seems like the perfect day. And then… suddenly without warning… your drink is gone. You were having a great time and … Continue reading What Happened to My Fabulous Beverage!
When Did That File Get So Big?
I haven’t blogged much since getting back from vacation. It seems like a good restart after the two week hiatus would be to address an issue that has arisen countless times. Sudden File Growth In a number of SQL Server environments that I’ve worked in there either isn’t a method for monitoring file size or … Continue reading When Did That File Get So Big?
Really Search Cache for Execution Plans
Today’s stored procedure that you can use in your DBA database is a re-hash of a post I did a couple months ago. The reason for re-hashing the procedure is that when I used it last week I found out there were some serious issues with its results. Some plans were being duplicated and the … Continue reading Really Search Cache for Execution Plans
Oops… A Lot Of Trees… Jobs to Update
Yesterday I posted about having an alert in place to know when SQL Agent jobs don’t have operators setup. I’ve found this alert to be extremely useful, but often when its been shared it just leads to junk e-mail. The reason for this is when the alert is added to 5, 10, or 50 servers … Continue reading Oops… A Lot Of Trees… Jobs to Update
But It Wasn’t My Job To Do The Backups!?
It’s happened a few times, I go out to assist with recovery from some sort of failure and the question of database backups results in an uncomfortable pause. One group thought the other group was taking the backups and the other group didn’t know that the backups needed to be taken. And neither group previously … Continue reading But It Wasn’t My Job To Do The Backups!?
Does A Job Really Fail If Nobody Knows About It?
Have you ever gone out and made a new SQL Agent job and forget to assign notification settings for it? God, I hope I’m not the only one because that would mean I suck. This is a common issue that exists in most environments that I’ve worked in. So I must not suck. Quite often … Continue reading Does A Job Really Fail If Nobody Knows About It?
Strate SQL 