SQLServerPedia SQL Server Training http://sqlserverpedia.com/blog The Microsoft SQL Server authority. Thu, 11 Mar 2010 23:14:48 +0000 http://wordpress.org/?v=2.8.6 en hourly 1 SQL Server training, presentations, news and screencasts from database experts - people with 10 or more years doing SQL Server work. We teach you how to do performance tuning, disaster recovery, monitoring and T-SQL coding. The Microsoft SQL Server authority. Brent Ozar http://sqlserverpedia.com/badges/SQLServerPedia_Badge_Podcast.jpgSQLServerPedia SQL Server Traininghttp://sqlserverpedia.com/blog sqlserver, sql server, sql, mssql, dba, database, database administration no Andy Grant andy.grant@quest.com The Basics of SQL Server Profiler http://sqlserverpedia.com/blog/sql-server-performance-tuning/the-basics-of-sql-server-profiler/ http://sqlserverpedia.com/blog/sql-server-performance-tuning/the-basics-of-sql-server-profiler/#comments Thu, 19 Feb 2009 13:15:21 +0000 Brent Ozar http://sqlserverpedia.com/blog/?p=2176 SQL Server’s Profiler utility helps you trace slow queries to find performance bottlenecks. In this ten minute video, Brent explains the basics of how to get started tracing your server with Profiler.

The scripts and related links for this podcast are:

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

Digg del.icio.us DZone DotNetKicks Google Bookmarks Ping.fm Reddit StumbleUpon TwitThis

]]> http://sqlserverpedia.com/blog/sql-server-performance-tuning/the-basics-of-sql-server-profiler/feed/ 0 <p>SQL Server’s Profiler utility helps you trace slow queries to find performance bottlenecks. In this ten minute video, Brent explains the basics of how to get started tracing your server with Profiler.</p> <p>The scripts and related links for this podcast are:</p> <ul> <li><a href="http://sqlserverpedia.com/wiki/SQL_Server_Profiler">SQL Server Profiler</a> – the wiki article here about how to use Profiler.</li> <li><a href="http://sqlserverpedia.com/wiki/Writing_a_SQL_Server_Performance_Report">Writing a Performance Report</a> – how to use Profiler and Perfmon to write a management report for SQL Server.</li> <li><a href="http://sqlserverpedia.com/wiki/Index_Related_DMV_Queries">Index Performance Tuning Scripts</a> – sample scripts that show you how to find missing indexes, indexes that aren’t being used, and more.</li> </ul> <p>If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:</p> <ul> <li><a href="http://feeds.feedburner.com/SqlserverpediaSqlServerTutorialPodcastMP4">MP4 (Apple) Video Feed</a></li> <li><a href="http://feeds.feedburner.com/SqlserverpediaSqlServerTutorialPodcastWMV">WMV (Microsoft) Video Feed</a></li> <li><a href="http://feeds.feedburner.com/SqlserverpediaSqlServerTutorialPodcastMP3">MP3 Audio-Only Feed</a></li> <li><a href="zune://subscribe/?SQLServerPedia%20Video=http://feeds.feedburner.com/SqlserverpediaSqlServerTutorialPodcastMP4">Zune One-Click Subscribe for Video</a></li> <li><a href="zune://subscribe/?SQLServerPedia%20Audio=http://feeds.feedburner.com/SqlserverpediaSqlServerTutorialPodcastMP3">Zune One-Click Subscribe for MP3</a></li> </ul> <p>You can also download this video to watch it later:</p> <ul> <li><a href="http://podcasts.brentozar.com/SQLServerPedia-20090219-Profiler.mp4">MP4 (Apple) Video Download</a></li> <li><a href="http://podcasts.brentozar.com/SQLServerPedia-20090219-Profiler.wmv">WMV (Microsoft) Video Download</a></li> <li><a href="http://podcasts.brentozar.com/SQLServerPedia-20090219-Profiler.mp3">MP3 Audio-Only Download</a></li> </ul> <a rel="nofollow" href="http://digg.com/submit?phase=2&url=http%3A%2F%2Fsqlserverpedia.com%2Fblog%2Fsql-server-performance-tuning%2Fthe-basics-of-sql-server-profiler%2F&title=The%20Basics%20of%20SQL%20Server%20Profiler&bodytext=SQL%20Server%27s%20Profiler%20utility%20helps%20you%20trace%20slow%20queries%20to%20find%20performance%20bottlenecks.%20%20In%20this%20ten%20minute%20video%2C%20Brent%20explains%20the%20basics%20of%20how%20to%20get%20started%20tracing%20your%20server%20with%20Profiler.%0D%0A%0D%0A%0D%0AThe%20scripts%20and%20related%20links%20for%20this%20podc" title="Digg"><img src="http://sqlserverpedia.com/blog/wp-content/plugins/sociable/images/digg.png" title="Digg" alt="Digg" class="sociable-hovers" /></a> <a rel="nofollow" [...] SQL Server’s Profiler utility helps you trace slow queries to find performance bottlenecks. In this ten minute video, Brent explains the basics of how to get started tracing your server with Profiler. The scripts and related links for this [...] 00:10:14 Writing a SQL Server Performance Report – Part 2 http://sqlserverpedia.com/blog/sql-server-performance-tuning/writing-a-sql-server-performance-report-part-2/ http://sqlserverpedia.com/blog/sql-server-performance-tuning/writing-a-sql-server-performance-report-part-2/#comments Thu, 22 Jan 2009 14:00:16 +0000 Brent Ozar http://sqlserverpedia.com/blog/?p=708 When an application is having performance problems, managers want to see a clear, objective report that summarizes what’s wrong and how to fix it. In today’s podcast, Brent explains how to mitigate the issues we discovered in part 1, and then how to document those mitigations in a way managers will appreciate.

The nine minute video talks about these wiki sections:

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

Digg del.icio.us DZone DotNetKicks Google Bookmarks Ping.fm Reddit StumbleUpon TwitThis

]]> http://sqlserverpedia.com/blog/sql-server-performance-tuning/writing-a-sql-server-performance-report-part-2/feed/ 4 <p>When an application is having performance problems, managers want to see a clear, objective report that summarizes what’s wrong and how to fix it. In today’s podcast, Brent explains how to mitigate the issues we discovered in <a href="http://sqlserverpedia.com/blog/sql-server-performance-tuning/writing-a-sql-server-performance-report-part-1/">part 1</a>, and then how to document those mitigations in a way managers will appreciate.</p> <p>The nine minute video talks about these wiki sections:</p> <ul> <li><a href="http://sqlserverpedia.com/wiki/Performance_Monitor">Performance Monitor</a> – Perfmon helps you find your SQL Server bottlenecks like CPU, memory, disk and network.</li> <li><a href="http://sqlserverpedia.com/wiki/SQL_Server_Profiler">Profiler</a> – helps you trace SQL activity on a server.</li> <li><a href="http://sqlserverpedia.com/wiki/Writing_a_SQL_Server_Performance_Report">Writing a SQL Server Performance Report</a> – explains what the video covers.</li> </ul> <p>If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:</p> <ul> <li><a href="http://feeds.feedburner.com/SqlserverpediaSqlServerTutorialPodcastMP4">MP4 (Apple) Video Feed</a></li> <li><a href="http://feeds.feedburner.com/SqlserverpediaSqlServerTutorialPodcastWMV">WMV (Microsoft) Video Feed</a></li> <li><a href="http://feeds.feedburner.com/SqlserverpediaSqlServerTutorialPodcastMP3">MP3 Audio-Only Feed</a></li> <li><a href="zune://subscribe/?SQLServerPedia%20Video=http://feeds.feedburner.com/SqlserverpediaSqlServerTutorialPodcastMP4">Zune One-Click Subscribe for Video</a></li> <li><a href="zune://subscribe/?SQLServerPedia%20Audio=http://feeds.feedburner.com/SqlserverpediaSqlServerTutorialPodcastMP3">Zune One-Click Subscribe for MP3</a></li> </ul> <p>You can also download this video to watch it later:</p> <ul> <li><a href="http://podcasts.brentozar.com/SQLServerPedia-20090122-PerformanceReport2.mp4">MP4 (Apple) Video Download</a></li> <li><a href="http://podcasts.brentozar.com/SQLServerPedia-20090122-PerformanceReport2.wmv">WMV (Microsoft) Video Download</a></li> <li><a href="http://podcasts.brentozar.com/SQLServerPedia-20090122-PerformanceReport2.mp3">MP3 Audio-Only Download</a></li> </ul> <a rel="nofollow" href="http://digg.com/submit?phase=2&url=http%3A%2F%2Fsqlserverpedia.com%2Fblog%2Fsql-server-performance-tuning%2Fwriting-a-sql-server-performance-report-part-2%2F&title=Writing%20a%20SQL%20Server%20Performance%20Report%20-%20Part%202&bodytext=When%20an%20application%20is%20having%20performance%20problems%2C%20managers%20want%20to%20see%20a%20clear%2C%20objective%20report%20that%20summarizes%20what%27s%20wrong%20and%20how%20to%20fix%20it.%20%20In%20today%27s%20podcast%2C%20Brent%20explains%20how%20to%20mitigate%20the%20issues%20we%20discovered%20in%20part%201%2C%20and%20then%20how%20to" title="Digg"><img src="http://sqlserverpedia.com/blog/wp-content/plugins/sociable/images/digg.png" title="Digg" alt="Digg" class="sociable-hovers" /></a> <a rel="nofollow" [...] When an application is having performance problems, managers want to see a clear, objective report that summarizes what’s wrong and how to fix it. In today’s podcast, Brent explains how to mitigate the issues we discovered in part 1, and then [...] Quest SQL Server Discussion with Sheila Molnar, Executive Editor at SQLMag http://sqlserverpedia.com/blog/sql-server-2008/quest-sql-server-discussion-with-sheila-molnar-executive-editor-at-sqlmag/ http://sqlserverpedia.com/blog/sql-server-2008/quest-sql-server-discussion-with-sheila-molnar-executive-editor-at-sqlmag/#comments Mon, 12 Jan 2009 17:49:19 +0000 Kevin Kline http://sqlserverpedia.com/blog/?p=742 Back in November of 2008, I had the chance to sit down with SQL Server Magazine Executive Editor Sheila Molnar and the other top guys in the SQL Server business unit to discuss ideas and trends about the SQL Server space.  We talked about a lot of different topics, including the future of cloud computing for SQL Server.  Did our predictions come true?  Have a listen here to find out:

http://www.ittv.net/VideoPlayer/tabid/57/VideoId/256/SQL-PASS-Industry-Trends-Roundtable-With-Quest-Execs.aspx

http://sqlmag.com/Article/ArticleID/100863/sql_server_100863.html

You can find even more goodies at:

http://technet.microsoft.com/radio

Below are direct links to the wma and mp3’s:

WMA

http://download.microsoft.com/download/6/3/1/631A3F4A-791B-4297-BC82-365A02D2274C/TechNetRadio11252008-web.wma

mp3 Hi bandwidth

http://download.microsoft.com/download/6/3/1/631A3F4A-791B-4297-BC82-365A02D2274C/TechNetRadio11252008-hi-web.mp3

mp3 Low bandwidth

http://download.microsoft.com/download/6/3/1/631A3F4A-791B-4297-BC82-365A02D2274C/TechNetRadio11252008-lo-web.mp3

Cheers,

-Kevin

Digg del.icio.us DZone DotNetKicks Google Bookmarks Ping.fm Reddit StumbleUpon TwitThis

]]> http://sqlserverpedia.com/blog/sql-server-2008/quest-sql-server-discussion-with-sheila-molnar-executive-editor-at-sqlmag/feed/ 0 <p>Back in November of 2008, I had the chance to sit down with SQL Server Magazine Executive Editor Sheila Molnar and the other top guys in the SQL Server business unit to discuss ideas and trends about the SQL Server space.  We talked about a lot of different topics, including the future of cloud computing for SQL Server.  Did our predictions come true?  Have a listen here to find out:</p> <p class="MsoNormal" style="margin: 0in 0in 0pt;"><a href="http://www.ittv.net/VideoPlayer/tabid/57/VideoId/256/SQL-PASS-Industry-Trends-Roundtable-With-Quest-Execs.aspx"><span style="font-size: small; color: #800080; font-family: Calibri;">http://www.ittv.net/VideoPlayer/tabid/57/VideoId/256/SQL-PASS-Industry-Trends-Roundtable-With-Quest-Execs.aspx</span></a><span style="font-size: small; font-family: Calibri;"> </span></p> <p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-size: small; font-family: Calibri;"> </span></p> <p class="MsoNormal" style="margin: 0in 0in 0pt;"><a href="http://sqlmag.com/Article/ArticleID/100863/sql_server_100863.html"><span style="font-size: small; color: #800080; font-family: Calibri;">http://sqlmag.com/Article/ArticleID/100863/sql_server_100863.html</span></a></p> <p>You can find even more goodies at:</p> <p><span style="font-size: 10pt; color: blue; font-family: 'Arial','sans-serif';"><a href="http://technet.microsoft.com/radio">http://technet.microsoft.com/radio</a></span></p> <p class="MsoNormal" style="margin: 0in 0in 0pt;"> <p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-size: 10pt; color: black; font-family: 'Verdana','sans-serif';">Below are direct links to the wma and mp3’s:</span></p> <p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-size: 10pt; color: #1f497d; font-family: 'Verdana','sans-serif';"> </span></p> <p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-size: 10pt; color: black; font-family: 'Verdana','sans-serif';">WMA</span><span style="color: #1f497d;"><span style="font-size: small;"><span style="font-family: Calibri;"> </span></span></span></p> <p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="color: #1f497d;"><a href="http://download.microsoft.com/download/6/3/1/631A3F4A-791B-4297-BC82-365A02D2274C/TechNetRadio11252008-web.wma"><span style="font-size: small; font-family: Calibri;">http://download.microsoft.com/download/6/3/1/631A3F4A-791B-4297-BC82-365A02D2274C/TechNetRadio11252008-web.wma</span></a></span></p> <p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="color: #1f497d;"><span style="font-size: small; font-family: Calibri;"> </span></span></p> <p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-size: 10pt; color: black; font-family: 'Verdana','sans-serif';">mp3 Hi bandwidth</span></p> <p class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="color: #1f497d;"><a href="http://download.microsoft.com/download/6/3/1/631A3F4A-791B-4297-BC82-365A02D2274C/TechNetRadio11252008-hi-web.mp3"><span style="font-size: small; [...] Back in November of 2008, I had the chance to sit down with SQL Server Magazine Executive Editor Sheila Molnar and the other top guys in the SQL Server business unit to discuss ideas and trends about the SQL Server space.  We talked about a lot of [...] Meet Performance Tuning Editor Denny Cherry http://sqlserverpedia.com/blog/podcasts/meet-performance-tuning-editor-denny-cherry/ http://sqlserverpedia.com/blog/podcasts/meet-performance-tuning-editor-denny-cherry/#comments Sun, 26 Oct 2008 09:00:29 +0000 Brent Ozar http://sqlserverpedia.com/blog/?p=502 Christian Hasker of Quest interviewed Denny Cherry, known around the web as MrDenny.  Denny Cherry specializes as a professional Microsoft SQL Server Database Administrator, and he recently became a SQL Server MVP, and now he’s the Performance Tuning Editor for SQLServerPedia.

In this podcast, Denny talks about some of his experiences at MySpace and Awareness Technologies and about how junior DBAs can work their way up the ladder.

You can subscribe to our podcast feeds here:

Digg del.icio.us DZone DotNetKicks Google Bookmarks Ping.fm Reddit StumbleUpon TwitThis

]]> http://sqlserverpedia.com/blog/podcasts/meet-performance-tuning-editor-denny-cherry/feed/ 1 <p>Christian Hasker of Quest interviewed <a href="http://www.mrdenny.com/">Denny Cherry</a>, known around the web as MrDenny.  Denny Cherry specializes as a professional Microsoft SQL Server Database Administrator, and he recently became a SQL Server MVP, and now he’s the Performance Tuning Editor for SQLServerPedia.</p> <p>In this podcast, Denny talks about some of his experiences at MySpace and Awareness Technologies and about how junior DBAs can work their way up the ladder.</p> <p>You can subscribe to our podcast feeds here:</p> <ul> <li><a href="http://feeds.feedburner.com/SqlserverpediaSqlServerTutorialPodcastMP4">MP4 (Apple) Video Feed</a></li> <li><a href="http://feeds.feedburner.com/SqlserverpediaSqlServerTutorialPodcastWMV">WMV (Microsoft) Video Feed</a></li> <li><a href="http://feeds.feedburner.com/SqlserverpediaSqlServerTutorialPodcastMP3">MP3 Audio-Only Feed</a></li> </ul> <a rel="nofollow" href="http://digg.com/submit?phase=2&url=http%3A%2F%2Fsqlserverpedia.com%2Fblog%2Fpodcasts%2Fmeet-performance-tuning-editor-denny-cherry%2F&title=Meet%20Performance%20Tuning%20Editor%20Denny%20Cherry&bodytext=Christian%20Hasker%20of%20Quest%20interviewed%20Denny%20Cherry%2C%20known%20around%20the%20web%20as%20MrDenny.%C2%A0%20Denny%20Cherry%20specializes%20as%20a%20professional%20Microsoft%20SQL%20Server%20Database%20Administrator%2C%20and%20he%20recently%20became%20a%20SQL%20Server%20MVP%2C%20and%20now%20he%27s%20the%20Performance%20Tunin" title="Digg"><img src="http://sqlserverpedia.com/blog/wp-content/plugins/sociable/images/digg.png" title="Digg" alt="Digg" class="sociable-hovers" /></a> <a rel="nofollow" href="http://delicious.com/post?url=http%3A%2F%2Fsqlserverpedia.com%2Fblog%2Fpodcasts%2Fmeet-performance-tuning-editor-denny-cherry%2F&title=Meet%20Performance%20Tuning%20Editor%20Denny%20Cherry&notes=Christian%20Hasker%20of%20Quest%20interviewed%20Denny%20Cherry%2C%20known%20around%20the%20web%20as%20MrDenny.%C2%A0%20Denny%20Cherry%20specializes%20as%20a%20professional%20Microsoft%20SQL%20Server%20Database%20Administrator%2C%20and%20he%20recently%20became%20a%20SQL%20Server%20MVP%2C%20and%20now%20he%27s%20the%20Performance%20Tunin" title="del.icio.us"><img src="http://sqlserverpedia.com/blog/wp-content/plugins/sociable/images/delicious.png" title="del.icio.us" alt="del.icio.us" class="sociable-hovers" /></a> <a rel="nofollow" href="http://www.dzone.com/links/add.html?url=http%3A%2F%2Fsqlserverpedia.com%2Fblog%2Fpodcasts%2Fmeet-performance-tuning-editor-denny-cherry%2F&title=Meet%20Performance%20Tuning%20Editor%20Denny%20Cherry" title="DZone"><img src="http://sqlserverpedia.com/blog/wp-content/plugins/sociable/images/dzone.png" title="DZone" alt="DZone" class="sociable-hovers" /></a> <a rel="nofollow" href="http://www.dotnetkicks.com/kick/?url=http%3A%2F%2Fsqlserverpedia.com%2Fblog%2Fpodcasts%2Fmeet-performance-tuning-editor-denny-cherry%2F&title=Meet%20Performance%20Tuning%20Editor%20Denny%20Cherry" title="DotNetKicks"><img src="http://sqlserverpedia.com/blog/wp-content/plugins/sociable/images/dotnetkicks.png" title="DotNetKicks" alt="DotNetKicks" class="sociable-hovers" /></a> <a rel="nofollow" [...] Christian Hasker of Quest interviewed Denny Cherry, known around the web as MrDenny.  Denny Cherry specializes as a professional Microsoft SQL Server Database Administrator, and he recently became a SQL Server MVP, and now he’s the Performance [...]