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
Category: SQL Server 2008 R2
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
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
TechFuse Presentation and Speaker Rankings
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
Free SQL Server Training – Week May 2010
We all like free stuff. Especially when we already know it’s something we love. And if you are reading this blog, you likely love or really like SQL Server. Or just maybe you are paid to like it. What ever the reason, the more you know about it the better you will be in applying … Continue reading Free SQL Server Training – Week May 2010
A Jack Bauer Event In The Making
Sure, you could say that making a Jack Bauer reference for the 24 Hours of PASS event is corny and expected. But then you’d be right and I’d have to actually use my creative juices. So we’ll agree on a détente of sorts and just move ahead. Coming up next month… on May 19 beginning … Continue reading A Jack Bauer Event In The Making
Free eBook – Introducing SQL Server 2008 R2
SQL Server 2008 R2 eBookAs with previous releases of SQL Server versions, Microsoft has released an "introducing" ebook that covers the new features that are a part of SQL Server 2008 R2. If you aren't up to speed with the upcoming release, this is a great resource to give it a once over and understand … Continue reading Free eBook – Introducing SQL Server 2008 R2
Discover SQL Server 2008 R2
It was bound to happen, a launch event for the upcoming release of SQL Server 2008 R2. This is a great thing because it means we’ll be able to play with the cool new toys in production soon and start getting our client’s upgraded. I do wonder though if there are talking dolphins in these … Continue reading Discover SQL Server 2008 R2
Strate SQL 