I’ll be speaking for the SQL PASS Performance Virtual Chapter next week. It’ll be on July 6 at 12 PM Eastern time. The topic will be Performance Impacts Related to Different Function Types. The abstract for the event is the following: User defined functions provide a means to encapsulate business logic in the database tier. … Continue reading Webcast Next Week – Performance Impacts Related to Different Function Types
Semaphore Timeout Did What?
Last week I had a blog about getting better error messages out of SQL Agent Jobs. In that blog I had encountered the following error message: Error: 2010-06-23 19:00:30.68 Code: 0×00000000 Source: Execute SQL Task Description: TCP Provider: The semaphore timeout period has expired. End Error The downside is that I don’t have a good … Continue reading Semaphore Timeout Did What?
Why’d That Job Fail?
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?
Do You Patch SQL Server Regularily?
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?
Index Those Foreign Keys
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
You Thought You Missed 24 Hours of PASS
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
PASS Summit 2010 Submissions
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
And Here You Thought It Just RTM’d
Earlier this month Microsoft launched SQL Server 2008 R2. And then last week Microsoft release Cumulative Update 1 for SQL Server 2008 R2. You might might be getting serious like this baby thinking, “Really, already?!” The reality though is that this deserves a “YES!” Why would a quick Cumulative Update after release be such a … Continue reading And Here You Thought It Just RTM’d
Doing Something About Auto Generated Names
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
Connect Item on Import/Export Wizard
I like using raw files in SQL Server Integration Services (SSIS). They are a quick way to build data repository that will be used else where in a package or for use with a separate package. In a recent project, raw files were used to move client data around in a new import process that consolidated business logic … Continue reading Connect Item on Import/Export Wizard
Strate SQL 