Paul and I chatted with Hilton Giesenow about SQL Server, Sharepoint and Involuntary DBAs. Paul blogged a bit more details about it in the post titled: Paul and Kimberly interview from MVP Summit. And, you can get the actual interview here: Episode 21 – Diving Into SQL Server With Paul Randal & Kim Tripp Enjoy! kt
Kimberly L. Tripp
Improving my SQL skills through your questions!
The MOSS Show Sharepoint Podcast – Episode 21 is live!
Posted on: April 29, 2010 3:50 am
Clearing the cache – are there other options?
Posted on: April 28, 2010 12:20 pm
OK, I've had a bit of a tangent going on optimizing stored procedures and its all revolved around adhoc plan caching and potentially wasted cache due to the single-use plans created (see the most recent posts titled:Plan cache and optimizing for adhoc workloads and Plan cache, adhoc workloads and clearing the single-use plan cache bloat). To [...]
Plan cache, adhoc workloads and clearing the single-use plan cache bloat
Posted on: April 26, 2010 6:15 am
In my post describing the new SQL Server 2008 configuration option [optimize for adhoc workloads] titled: Plan cache and optimizing for adhoc workloads, I asked for you to send me your plan cache numbers. In addition to the comments on the post, I received a lot of feedback in email (and lots of comments – [...]
Public classes coming up in Dublin (including prior course testimonials)
Posted on: April 23, 2010 1:35 am
Paul and I enjoyed Dublin so much in 2008 and 2009 that we're going back for two weeks this time – and teaching three classes while we're there! We'll be working with our fabulous friends (Carmel, Sandra, and Bob) at Prodata and the event will be hosted by the nice folks at Microsoft Ireland. We'll [...]
Plan cache and optimizing for adhoc workloads
Posted on: April 22, 2010 5:50 pm
I mentioned that servers receiving a lot of dynamic constructs (typically those generated by client SQL generaters/ORM/LINQ, etc.) can start to consume too much plan cache and have problems with "single-use plans" in my last post titled: Statement execution and why you should use stored procedures. I also mentioned that SQL Server 2008 has an [...]
Social networking – how many is too many?
Posted on: April 22, 2010 4:41 pm
Well, back in April of 2009 I blogged Social networking, keeping up with friends/family and getting more tech info! and I essentially said that I was going to limit myself to only Facebook and Twitter. Low and behold, I've succumbed to yet another network – LinkedIn. The SQL Server Community is *incredibly* strong online: in forums, twitter groups (such [...]
SQL Server Magazine’s new column: Kimberly & Paul – Questions Answered
Posted on: April 22, 2010 2:35 pm
In March, Paul and I began blogging in a new column for SQL Server Magazine. This column is solely a Q&A based column… yes, we'll still write feature articles and yes, we'll still be blogging on each of our own blogs (in fact, have you noticed that I've actually blogged more this month than almost [...]
Upcoming User Group Presentations
Posted on: April 22, 2010 2:13 pm
I'm speaking at a few user groups over the next couple of months… are you local? Vienna, Austria – April 29, 2010 Presentation: SQL Server 2005/2008: Index Internals Presenter: Kimberly L. Tripp (yep, just me!) Information/details: Vienna SQL Server User Group Houston, Texas (the Woodlands) – May 18, 2010 Presentation: Essential Database Maintenance Presenters: Paul [...]
Statement execution and why you should use stored procedures
Posted on: April 21, 2010 7:18 pm
OK, so, this is where we're at… When a client application makes a request to SQL Server there are a few ways in which they can do it: Submit an adhoc transact-SQL statement This statement can be parameterized and the parameterized statement can be deemed: Safe: These are statements where the optimizer has evaluated the [...]
Media Alert: Microsoft Announces Conference Call With Senior Vice President Ted Kummert
Posted on: April 20, 2010 2:18 pm
This event is scheduled for TOMORROW (April 21) at 7:30am PDT. So, if you haven't already put this on your schedule – you might want to! And, if you miss it, a replay will be available for 30 days beginning one hour after the end of the call. Here's the official press release. And, here's [...]
Microsoft eLearning Resources – BI and 2008 R2
Posted on: April 20, 2010 1:45 pm
In addition to the SQL Server 2008 Database Infrastructure and Scalability content that Paul and I delivered for SQL Server 2008, and the content that our colleague Bob Beachemin (blog) delivered (Clinic 10164: Essential SQL Server 2008 for Developers), our colleague Stacia Misner (blog|twitter) also delivered content for SQL Server 2008 titled and available as: Clinic [...]
Microsoft eLearning Resources – Developer Content – 2008 & 2008 R2
Posted on: April 20, 2010 1:27 pm
In addition to the SQL Server 2008 Database Infrastructure and Scalability content that Paul and I delivered for SQL Server 2008, our colleague Bob Beachemin (blog) also delivered complementary content under the Developer track. This course is officially titled and available as: Clinic 10164: Essential SQL Server 2008 for Developers. Additionally, this content has been updated [...]
Microsoft eLearning Resources – Clinic 10259 (SQL 2008 DBIS)
Posted on: April 20, 2010 1:11 pm
When SQL Server 2008 was in beta, Paul and I worked on a project to create content that would "jumpstart" folks in learning and working with SQL Server 2008. We delivered these "new features" courses at various locations and finally, we recorded the content. All of this content is now available FOR FREE from Microsoft [...]
SQL Connections Fall 2010 – Call for Abstracts
Posted on: April 19, 2010 11:37 am
Last week we completed another SQL Server Magazine/SQLConnections conference and already, it's time to start planning for the Fall show. Once again, Paul and I will be managing the SQL side of the conference and we'd like to invite you to submit abstracts for sessions at the conference. The Fall 2010 SQL Connections conference will [...]
Using the OPTION (RECOMPILE) option for a statement
Posted on: April 15, 2010 1:28 pm
I started this series with the post titled: Little Bobby Tables, SQL Injection and EXECUTE AS. I then moved to discussing some of the differences with the post titled: EXEC and sp_executesql – how are they different? Today, I want to address a few of the comments as well as continue with a few tips [...]
EXEC and sp_executesql – how are they different?
Posted on: April 5, 2010 9:51 pm
In my last post: Little Bobby Tables, SQL Injection and EXECUTE AS, I wanted to highlight how to avoid SQL Injection when using EXEC. A few people brought up the point that I could have avoided SQL Injection by using sp_executesql. And, while sp_executesql can be used in some cases, it's not always the most ideal from a [...]
Little Bobby Tables, SQL Injection and EXECUTE AS
Posted on: April 4, 2010 4:42 pm
OK, I know many of you have seen this before (an oldie, but a goodie!): (image from xkcd.com, with “copy and share” license described here: License) But, what can you do to prevent this? And, when would this even be possible? This is possible when DSE (dynamic string execution) occurs. There are still some VERY relevant [...]
Backup Resources – Where, oh where, can they be?
Posted on: April 2, 2010 8:48 am
In our Boston SQL Training workshop today, we were discussing disaster recovery and minimizing data loss. One of the key discussions is around backup/restore so we started discussing resources and found that there just isn’t a great single place where a bunch of resources are listed (ok, maybe there is but we didn’t find one) [...]
