Posts

Showing posts from August, 2011

Screencast sobre SQL Server Denali Developer Tools Juneau

Image
Les comparto este screencast en el cual vemos una instroducción a las herramientas de desarrollo en SQL Server Denali http://www.youtube.com/watch?v=-wBx2PnF74E     Saludos,   Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP http://tiny.cc/comwindows http://mswindowscr.org http://comunidadwindows.org Costa Rica Technorati Tags: SQL Server LiveJournal Tags: SQL Server del.icio.us Tags: SQL Server http://ecastrom.blogspot.com http://ecastrom.wordpress.com http://ecastrom.spaces.live.com http://universosql.blogspot.com http://todosobresql.blogspot.com http://todosobresqlserver.wordpress.com http://mswindowscr.org/blogs/sql/default.aspx http://citicr.org/blogs/noticias/default.aspx http://sqlserverpedia.blogspot.com/

Wait Stats in SQL Server

Image
When you are optimizing a SQL Server installation you must look at the Wait Stats in SQL Server and the easier way to check them is using the following DMVs  sys.dm_os_waiting_tasks, sys.dm_exec_requests and sys.dm_os_wait_stats. The sys.dm_os_wait_stats contains aggregated information about wait statistics for SQL Server, you must be aware that these wait statistics are aggregated at the server level, and there is no detail level available in this DMV. The following scripts queries this DMV. SELECT * FROM sys.dm_os_wait_stats ORDER BY wait_time_ms DESC The previous query returns the all waits with an accumulated wait time expressed in milliseconds. Because these wait stats are cumulative since the SQL Server service started to run, one way to clear these counters is to execute the DBCC SQLPERF(“sys.dm_os_wait_stats”,CLEAR) and from this point SQL Server begins to accumulate the wait stats again. Best Regards, Eduardo Castro Microsoft SQL Server MVP http://tiny.c

Video de Overview de SQL Server Denali

Image
Les comparto este video de introducción  a las principales características de SQL Server Denali http://www.youtube.com/watch?v=VQEgKHf5_kU     Saludos,   Ing. Eduardo Castro Martínez

Screencast Introducción al desarrollo con SQL Azure y Windows Azure

Image
Les comparto este screencast en el cual vemos el desarrollo de bases de datos en la nube con SQL Azure http://www.youtube.com/watch?v=D_C5NCsjt0k     Saludos,   Ing. Eduardo Castro Martinez

Arquitectura de Aplicaciones con SQL Azure

Les comparto esta presentación que utilicé en la charla sobre desarrollo de aplicaciones en la nube con SQL Azure   Cloud application architecture with sql azure and windows azure View more presentations from Eduardo Castro . Saludos, Eduardo Castro Martinez