This past weekend I went to SQL Saturday 50 – this is a day long SQL training event that is put together by community volunteers. I was fortunate enough that I was selected to present at this event. Since others have already shared their experiences at the event I figured I should as well. Some … Continue reading SQL Saturday 50 (#sqlsat50) – A Tale
Here we are with another T-SQL Tuesday and time for my entry into the fray. This month we are talking about indexes. This is great timing because I’ve been meaning to write about indexes for a while. A few months back I had outlined a number of articles I wanted to write and have been … Continue reading An Index on Indexing #TSQL2sDay
It’s been a busy week and I haven’t been able to put the time in to picking the winner for the MSDN Ultimate Subscription contest I was running through July 31st. I know I suck. Tonight during a client’s SQL Server 2008 migration I took a couple minutes to write down the names of each … Continue reading MSDN Ultimate Subscription Winner
I’ll be speaking for the SQL PASS Database Administration Virtual Chapter today at 12 PM Eastern time. The topic will be Using XML to Query Execution Plans. The abstract for the event is the following: SQL Server stores its execution plans as XML in dynamic management views. The execution plans are a gold mine of … Continue reading Webcast Today – Using XML to Query Execution Plans
I’ll be speaking for the SQL PASS Database Administration Virtual Chapter next week. It’ll be on July 28 at 12 PM Eastern time. The topic will be Using XML to Query Execution Plans. The abstract for the event is the following: SQL Server stores its execution plans as XML in dynamic management views. The execution … Continue reading Webcast Next Week – Using XML to Query Execution Plans
I’ll be speaking for the SQL PASS Performance Virtual Chapter later today starting 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. Often the purpose of … Continue reading Webcast Today – Performance Impacts Related to Different Function Types
Along with a number of my MVP peers, I received three (3) MSDN Ultimate subscriptions. These were sent to us with the intention of finding someone that hasn’t had the opportunity to use Visual Studio 2010 and provide them with the opportunity to get in and play with it. MSDN Ultimate Subscription If you aren’t … Continue reading What Would You Build? MSDN Subscription Giveaway
In anticipation of today, earlier this week I had declared today Pancake Day and started the day making pancakes. It was a great way to blow through the first hour without wearing out the F5 key on my laptop. Now the waiting is over and I am happy to say my SQL Server MVP status … Continue reading MVP Status Renewed
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
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?
Strate SQL 