Have you ever had a SQL Agent Job fail? Of course, just like myself, you have had this happen. When SQL Agent jobs fail, you will want to know why it failed. The problem is that knowing why a SQL Server Agent job has failed can sometimes be a tricky bit of business. The typical … Continue reading Why’d That Job Fail?
Microsoft has released a few new Cumulaive Update for SQL Server. There is an update for each of the supported releases of SQL Server: Cumulative update package 10 for SQL Server 2005 Service Pack 3 Cumulative update package 8 for SQL Server 2008 Service Pack 1 Cumulative Update package 2 for SQL Server 2008 R2 … Continue reading Do You Patch SQL Server Regularily?
Today started with some quality time getting to know a deadlock that had occurred. While working through the deadlock, I noticed that there were a number of foreign key relationships that weren't indexed on the parent side of the relationship. I am going to skip over the why to index foreign keys and save that … Continue reading Index Those Foreign Keys
Go get the popcorn and let's get ready to watch some PASS sessions! Last month PASS hosted an event called 24 Hours of PASS. In this event, there were 24 back to back webcasts that focused on SQL Server and more specifically SQL Server 2008 R2. As if that weren't awesome enough, you can now … Continue reading You Thought You Missed 24 Hours of PASS
I was a little slow at submitting this year, but this afternoon I submitted my ideas for sessions for PASS Summit 2010. If you aren’t aware of this conference – it’s probably the best way out there to learn a ton about SQL Server while networking with the people that use it daily and helped … Continue reading PASS Summit 2010 Submissions
I like my name. It provides a point of reference to who I am. If I am at work and someone calls for “Jason Strate”… that’s me. If I am at home, the same thing can happen and I still know that it’s me. I know that no matter where I am, my name will … Continue reading Doing Something About Auto Generated Names
Last week I spoke at TechFuse 2010 and my topic was Getting to Know Your Indexes. I thought I’d throw up a link to the presentation materials from the event. TechFuse was a lot of fun and I got to spend some time chatting with Dan English (twitter | blog) and Lara Rubbelke (twitter | … Continue reading TechFuse Presentation and Speaker Rankings
A peer the other day was having some trouble storing some some Chinese characters in a database. Every time he would insert the data into his table, the results would look similar to the following. The phrase he was adding was similar to the following: 烟肉独角兽彩虹乳酪 The T-SQL he was using was forwarded to me … Continue reading The Power of N
A while back I decided I need to get down to brass tacks and figure out SQL Server CLR. I'd looked at examples and seen some pretty cool stuff being done with it. Unfortuantely, I hadn't taken the time to become acquianted enough to know enough about the unknown. This limited my ability to be able … Continue reading FileSystemHelper SQL Server CLR – Codeplex
I’ve been meaning to join in on the T-SQL Tuesday event for the last couple months and let the time opportunity slip by. This month’s topic is reporting and its seems like a good time to get in on the event. The great thing about reporting is that for the past few months I’ve been … Continue reading TSQL Tuesday #005 – Wait Stat Report – #TSQL2sDay
Strate SQL 