Breaking: Quest-SolidQ Partnership

The podcast from Brian Moran and Bill Bosworth provides good insight into the the deal. Click here.

Here is an excerpt for the forthcoming press release:

Quest Software is announcing its new partnership with Solid Quality Mentors, a global provider of education and solutions for Microsoft data and development platforms.

This is not a sales reseller relationship, but a true joining of forces to provide new real value to the SQL Server community. Specifically, our plans are to work together in three specific areas: community outreach, product development and professional services.

Community outreach: The companies will work together on joint programs including speaking at Quest and Solid Quality Mentors events, authoring technical briefs and white papers and providing joint webcasts and podcasts for the SQL Server community.

Product development: Quest will collaborate with Solid Quality Mentors on product road maps and feature sets, drawing on their combined experience of real-world SQL Server challenges to provide the best solutions possible for SQL Server DBAs and developers.

Professional services: Quest customers will benefit from consulting services offered by Solid Quality Mentors to help implement tools and manage complex environments.

Peep http://quest.com Monday for more details.

email it! |  |   |   |   |   | 

Permalink     1 Comments

More SQL experts than you can shake a stick at

Wow, there is a great article over on http://odinjobs.com. I would call it a virtual round table. It is basically the same interview with a 8 different SQL Server experts so you get some different and interesting perspectives. It is refreshing format. Definitely read of the month for me. Thanks for the plug, Brent!

The Panel Blogroll

• Brent Ozar (subscribe, twitter)

• Brian Kelly (subscribe, twitter)

• Cristian Lefter (subscribe)

• Andrew Fryer (subscribe)

• Namwar Rizvi (subscribe)

• Denny Cherry (subscribe)

• Chris Shaw (subscribe)

• Pinal Dave (subscribe)

The Articles.

http://www.odinjobs.com/blogs/careers/entry/sql_server_experts_ms_sql1

http://www.odinjobs.com/blogs/careers/entry/sql_server_experts_part_ii

http://www.odinjobs.com/blogs/careers/entry/sql_server_experts_part_iii

email it! |  |   |   |   |   | 

Permalink     2 Comments

You know you are a SQL Wonk when...

You have have a favorite whitepaper... Mine is "Statistics Used by the Query Optimizer in Microsoft SQL Server 2005". Especially the the best practices section. What is yours?

wonk (wongk) noun : An expert who studies a subject or issue thoroughly and excessively.

I qualify. At least for the excessive part.

email it! |  |   |   |   |   | 

Permalink     2 Comments

Stupid XML SSMS Trick

This might be HAWTALTA for some of you. I just thought of doing this today even though I have been using xml showplan since I was knee high to a junebug. You can make query results clickable just by casting them as XML. For example:

select cast('select 1' as xml)

By clicking the resulting "select 1", a new query editor window opens with "select 1" ready to execute. This would be useful for scripts that generate scripts. Here is a practical example. (Forgive the formatting. I cannot get too wide in the post.)

SELECT  sys.objects.name

, (avg_total_user_cost * avg_user_impact) * (user_seeks + user_scans) as Impact

,  cast('CREATE NONCLUSTERED INDEX ~NewNameHere~ ON ' 

+ sys.objects.name + ' ( ' + mid.equality_columns + 

CASE WHEN mid.inequality_columns IS NULL THEN '' 

ELSE CASE WHEN mid.equality_columns IS NULL 

THEN '' ELSE ',' END + mid.inequality_columns END + ' ) ' 

+ CASE WHEN mid.included_columns IS NULL 

THEN '' ELSE 'INCLUDE (' + mid.included_columns + ')' 

END + ';'