tag:blogger.com,1999:blog-47627033254816680052024-02-06T23:22:53.187-06:00Senen FernandezSenen Fernandezhttp://www.blogger.com/profile/06019141076697175679noreply@blogger.comBlogger146125tag:blogger.com,1999:blog-4762703325481668005.post-66257646462184214772017-07-04T22:41:00.001-05:002017-07-04T22:41:40.479-05:00#July4<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-lrsZkQP3Qds/WVxfYHgSavI/AAAAAAAACdw/ygD7_Z_4aNoX9zX2uAPsqYYZQcl1BKI4gCLcBGAs/s1600/July4.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="595" data-original-width="1600" height="215" src="https://2.bp.blogspot.com/-lrsZkQP3Qds/WVxfYHgSavI/AAAAAAAACdw/ygD7_Z_4aNoX9zX2uAPsqYYZQcl1BKI4gCLcBGAs/s640/July4.JPG" width="580" /></a></div>
<br />Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-38877794867815314282017-01-07T15:38:00.001-06:002017-01-07T15:38:42.607-06:00MAN 2017 =)<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-qHHLPY4SjVI/WHFfoTaYlJI/AAAAAAAACVQ/xTOHim9FOx018B30DJcK8CipWFN54wieACLcB/s1600/WP_20170105_07_44_08_Pro.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="225" src="https://1.bp.blogspot.com/-qHHLPY4SjVI/WHFfoTaYlJI/AAAAAAAACVQ/xTOHim9FOx018B30DJcK8CipWFN54wieACLcB/s400/WP_20170105_07_44_08_Pro.jpg" width="400" /></a></div>
<br />Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-2319868938868228192016-12-24T20:37:00.003-06:002016-12-24T20:37:47.154-06:00Feliz Noche Buena =)<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-8MGuQ0R8qos/WF8wynrLOqI/AAAAAAAACUo/p7SdwEs20j0rXhBcLU773D__b4zgidIvACLcB/s1600/IMG_20161224_195734_619.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="390" src="https://2.bp.blogspot.com/-8MGuQ0R8qos/WF8wynrLOqI/AAAAAAAACUo/p7SdwEs20j0rXhBcLU773D__b4zgidIvACLcB/s400/IMG_20161224_195734_619.jpg" width="400" /></a></div>
<br />Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-33255542661460535772016-11-14T22:25:00.001-06:002016-11-15T07:48:34.455-06:00Super Moon 2016<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhC7Uia4gF7-dpA5iJdGaYd8EqhF1yae3ubNCVfICk0wyjHMT-v0HIA7s6uXj2k52WNHuXjWPxg_aqujO21EDEJp95Ww8SB1mWtIhCH1jsn0_T2drPf7ZOFscXdRmvtQ96AbZzUlNMKtA0/s1600/SenenMoon2016.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhC7Uia4gF7-dpA5iJdGaYd8EqhF1yae3ubNCVfICk0wyjHMT-v0HIA7s6uXj2k52WNHuXjWPxg_aqujO21EDEJp95Ww8SB1mWtIhCH1jsn0_T2drPf7ZOFscXdRmvtQ96AbZzUlNMKtA0/s400/SenenMoon2016.JPG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFvMuSTJykgkwG0z7sP1iA1woDSNkOoiphIFqEUOSK1tL1ArFmkghNjmSN6aPdTVhnDmXfWdK4pQA1JvTQTIv_dmiAvYoXV6p_HfVU2gaHoyLxQ_2vt-CGN2wqTNQBUs2SNEznu6Fdn7k/s1600/SenenMoon2016Morning.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFvMuSTJykgkwG0z7sP1iA1woDSNkOoiphIFqEUOSK1tL1ArFmkghNjmSN6aPdTVhnDmXfWdK4pQA1JvTQTIv_dmiAvYoXV6p_HfVU2gaHoyLxQ_2vt-CGN2wqTNQBUs2SNEznu6Fdn7k/s400/SenenMoon2016Morning.JPG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/a2vTSg32FvU" width="480"></iframe>
</div>
<br />Anonymoushttp://www.blogger.com/profile/05087821211337319069noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-10409568305412658152016-03-16T19:48:00.000-06:002016-03-16T19:48:22.282-06:00Smile, Enjoy Your Life and Be Happy =)<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-SaZv0dI2cYY/VuoMdY1pjUI/AAAAAAAACFE/4sDgITw3z2syyu9w9-9ykUxgKxaJwzBqA/s1600/SenenFernandezBeHappy.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://4.bp.blogspot.com/-SaZv0dI2cYY/VuoMdY1pjUI/AAAAAAAACFE/4sDgITw3z2syyu9w9-9ykUxgKxaJwzBqA/s400/SenenFernandezBeHappy.JPG" width="400" /></a></div>
Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-42655514918605488962016-02-22T22:19:00.000-06:002016-02-22T22:19:20.266-06:00Suavizando las curvas con Savitzky y Golay =)<div style="text-align: center;">
<span style="color: #0000ee;"><span style="color: #0000ee;"></span></span></div>
<div style="text-align: center;">
<span style="color: #0000ee;"> </span><a href="https://en.wikipedia.org/wiki/Savitzky%E2%80%93Golay_filter"><img alt="https://en.wikipedia.org/wiki/Savitzky%E2%80%93Golay_filter" border="0" height="301" src="https://4.bp.blogspot.com/-9xdTFrAHunI/VsvX3O6IHrI/AAAAAAAACD4/n_vFIXoL2cI/s400/SavitzkyGolayFilter.gif" width="400" /></a></div>
<br />Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-6349363630237650262015-03-14T08:51:00.003-06:002015-03-14T08:51:36.519-06:00Happy Pi Day 3.14.15<div style="text-align: center;">
<br /><iframe allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/uKuG4qqtP1Q?rel=0" width="420"></iframe></div>
Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-80262132879359170762014-11-21T09:17:00.001-06:002014-11-21T09:19:52.186-06:00Calm<div class="separator" style="clear: both; text-align: center;">
<a href="https://lh5.googleusercontent.com/-s3SiEpZYe7s/VG9XXQvEpQI/AAAAAAAABts/V8GHuSpsr8U/s640/blogger-image--1749862401.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://lh5.googleusercontent.com/-s3SiEpZYe7s/VG9XXQvEpQI/AAAAAAAABts/V8GHuSpsr8U/s640/blogger-image--1749862401.jpg" width="500" height="375" /></a></div>Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-55106758923413387882014-06-25T14:30:00.000-05:002014-06-25T14:30:14.679-05:00Sonríe, es Gratis :)<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-4nUxXmr3OYs/U6simERTKAI/AAAAAAAABfk/x1pVMDGeBqA/s1600/SenenSonr%C3%ADeesGratis.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-4nUxXmr3OYs/U6simERTKAI/AAAAAAAABfk/x1pVMDGeBqA/s1600/SenenSonr%C3%ADeesGratis.jpg" height="215" width="580" /></a></div>
<br />Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-62580658464650390252014-05-27T20:18:00.000-05:002014-05-27T20:18:43.923-05:00Born<div class="separator" style="clear: both; text-align: center;">
<a href="https://lh5.googleusercontent.com/-xp_k0wNtDBM/U4U5NscpPQI/AAAAAAAABco/LRT1eUoXYSI/s640/blogger-image--718863581.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://lh5.googleusercontent.com/-xp_k0wNtDBM/U4U5NscpPQI/AAAAAAAABco/LRT1eUoXYSI/s640/blogger-image--718863581.jpg" /></a></div>
Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-32645259731302667702014-05-19T20:23:00.002-05:002014-05-19T20:23:51.321-05:00Rose<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-S9wQSb8AZsA/U3qua8vA-VI/AAAAAAAABbA/06vjUEN8VW8/s1600/SenenRose.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-S9wQSb8AZsA/U3qua8vA-VI/AAAAAAAABbA/06vjUEN8VW8/s1600/SenenRose.JPG" height="580" width="580" /></a></div>
<br />Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-10163612032037913482014-04-24T17:00:00.000-05:002014-04-24T17:00:00.278-05:00Palindrome Checker<div style="background-color: white; opacity: 0.8; padding: 15px;">
<pre class="csharpcode" style="font-family: Consolas, 'Courier New', Courier, monospace;"><span class="kwrd" style="color: blue;">bool</span> IsPalindrome(<span class="kwrd" style="color: blue;">string</span> phrase = <span class="str" style="color: #a31515;">"Yo dono rosas, Oro no doy"</span>)
{
<span class="kwrd" style="color: blue;">string</span> text = Regex.Replace(phrase.ToLower(), <span class="str" style="color: #a31515;">"[^A-Za-z0-9À-ü]"</span>, <span class="str" style="color: #a31515;">""</span>);
<span class="kwrd" style="color: blue;">for</span> (<span class="kwrd" style="color: blue;">int</span> index = 0; index < text.Length / 2; index++)
{
<span class="kwrd" style="color: blue;">if</span> (text[index] != text[text.Length - 1 - index])
{
<span class="kwrd" style="color: blue;">return</span> <span class="kwrd" style="color: blue;">false</span>;
}
}
<span class="kwrd" style="color: blue;">return</span> <span class="kwrd" style="color: blue;">true</span>;
}</pre>
</div>
Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-62537861043287267262014-04-22T17:30:00.000-05:002014-04-22T17:30:01.559-05:00Last Backup Report<div style="background-color: white; opacity: 0.8; padding: 15px;">
<span style="color: blue; font-family: monospace; font-size: 12px;">SELECT </span><span style="font-family: monospace; font-size: 12px;">T1.name </span><span style="color: blue; font-family: monospace; font-size: 12px;">AS </span><span style="font-family: monospace; font-size: 12px;">[Database]</span><br />
<span style="color: grey; font-family: monospace; font-size: 12px;"> , </span><span style="color: magenta; font-family: monospace; font-size: 12px;">ISNULL</span><span style="color: grey; font-family: monospace; font-size: 12px;">(</span><span style="font-family: monospace; font-size: 12px;">T2.physical_device_name</span><span style="color: grey; font-family: monospace; font-size: 12px;">, </span><span style="color: red; font-family: monospace; font-size: 12px;">'DANGER!!!'</span><span style="color: grey; font-family: monospace; font-size: 12px;">) </span><span style="color: blue; font-family: monospace; font-size: 12px;">AS </span><span style="font-family: monospace; font-size: 12px;">[Backup]</span><br />
<span style="color: grey; font-family: monospace; font-size: 12px;"> , </span><span style="font-family: monospace; font-size: 12px;">T2.backup_size </span><span style="color: blue; font-family: monospace; font-size: 12px;">AS </span><span style="font-family: monospace; font-size: 12px;">[Size]<br /> </span><span style="color: grey; font-family: monospace; font-size: 12px;">, </span><span style="font-family: monospace; font-size: 12px;">T2.backup_start_date </span><span style="color: blue; font-family: monospace; font-size: 12px;">AS </span><span style="font-family: monospace; font-size: 12px;">[StartDate]<br /> </span><span style="color: grey; font-family: monospace; font-size: 12px;">, </span><span style="font-family: monospace; font-size: 12px;">T2.backup_finish_date </span><span style="color: blue; font-family: monospace; font-size: 12px;">AS </span><span style="font-family: monospace; font-size: 12px;">[FinishDate]</span><br />
<span style="color: blue; font-family: monospace; font-size: 12px;">FROM master</span><span style="font-family: monospace; font-size: 12px;">.sys.sysdatabases T1</span><br />
<span style="color: blue; font-family: monospace; font-size: 12px;">LEFT JOIN</span><br />
<span style="color: grey; font-family: monospace; font-size: 12px;">(<br /> </span><span style="color: blue; font-family: monospace; font-size: 12px;">SELECT </span><span style="font-family: monospace; font-size: 12px;">T2.database_name<br /> </span><span style="color: grey; font-family: monospace; font-size: 12px;">, </span><span style="font-family: monospace; font-size: 12px;">T1.physical_device_name<br /> </span><span style="color: grey; font-family: monospace; font-size: 12px;">, </span><span style="font-family: monospace; font-size: 12px;">T2.backup_size<br /> </span><span style="color: grey; font-family: monospace; font-size: 12px;">, </span><span style="font-family: monospace; font-size: 12px;">T2.backup_start_date<br /> </span><span style="color: grey; font-family: monospace; font-size: 12px;">, </span><span style="font-family: monospace; font-size: 12px;">T2.backup_finish_date</span><br />
<span style="color: blue; font-family: monospace; font-size: 12px;"> FROM </span><span style="font-family: monospace; font-size: 12px;">msdb.dbo.backupmediafamily T1<br /> </span><span style="color: blue; font-family: monospace; font-size: 12px;">INNER JOIN </span><span style="font-family: monospace; font-size: 12px;">msdb.dbo.backupset T2 </span><span style="color: blue; font-family: monospace; font-size: 12px;">ON </span><span style="font-family: monospace; font-size: 12px;">T1.media_set_id </span><span style="color: blue; font-family: monospace; font-size: 12px;">= </span><span style="font-family: monospace; font-size: 12px;">T2.media_set_id<br /> </span><span style="color: blue; font-family: monospace; font-size: 12px;">INNER JOIN<br /> </span><span style="color: grey; font-family: monospace; font-size: 12px;">(<br /> </span><span style="color: blue; font-family: monospace; font-size: 12px;">SELECT </span><span style="font-family: monospace; font-size: 12px;">database_name</span><span style="color: grey; font-family: monospace; font-size: 12px;">, </span><span style="color: magenta; font-family: monospace; font-size: 12px;">MAX</span><span style="color: grey; font-family: monospace; font-size: 12px;">(</span><span style="font-family: monospace; font-size: 12px;">backup_finish_date</span><span style="color: grey; font-family: monospace; font-size: 12px;">) </span><span style="color: blue; font-family: monospace; font-size: 12px;">AS </span><span style="font-family: monospace; font-size: 12px;">backup_finish_date<br /> </span><span style="color: blue; font-family: monospace; font-size: 12px;">FROM </span><span style="font-family: monospace; font-size: 12px;">msdb.dbo.backupset<br /> </span><span style="color: blue; font-family: monospace; font-size: 12px;">WHERE TYPE = </span><span style="color: red; font-family: monospace; font-size: 12px;">'D'<br /> </span><span style="color: blue; font-family: monospace; font-size: 12px;">GROUP BY </span><span style="font-family: monospace; font-size: 12px;">database_name<br /> </span><span style="color: grey; font-family: monospace; font-size: 12px;">) </span><span style="font-family: monospace; font-size: 12px;">T3 </span><span style="color: blue; font-family: monospace; font-size: 12px;">ON </span><span style="font-family: monospace; font-size: 12px;">T3.database_name </span><span style="color: blue; font-family: monospace; font-size: 12px;">= </span><span style="font-family: monospace; font-size: 12px;">T2.database_name</span><br />
<span style="color: grey; font-family: monospace; font-size: 12px;"> AND </span><span style="font-family: monospace; font-size: 12px;">T3.backup_finish_date </span><span style="color: blue; font-family: monospace; font-size: 12px;">= </span><span style="font-family: monospace; font-size: 12px;">T2.backup_finish_date</span><br />
<span style="color: grey; font-family: monospace; font-size: 12px;">) </span><span style="font-family: monospace; font-size: 12px;">T2 </span><span style="color: blue; font-family: monospace; font-size: 12px;">ON </span><span style="font-family: monospace; font-size: 12px;">T2.database_name </span><span style="color: blue; font-family: monospace; font-size: 12px;">= </span><span style="font-family: monospace; font-size: 12px;">T1.name</span><br />
<span style="color: blue; font-family: monospace; font-size: 12px;">ORDER BY </span><span style="font-family: monospace; font-size: 12px;">T2.backup_finish_date </span><span style="color: blue; font-family: monospace; font-size: 12px;">DESC</span><span style="color: grey; font-family: monospace; font-size: 12px;">, </span><span style="font-family: monospace; font-size: 12px;">T1.name</span><span style="font-family: arial, verdana, sans-serif;"> </span></div>
Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-16838780812940599182014-04-15T02:57:00.002-05:002014-04-15T03:06:06.643-05:00Red Moon<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-ApYywR-H8w8/U0zl3RDFSEI/AAAAAAAABOw/vVZ-acStlns/s1600/RedMoon.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-ApYywR-H8w8/U0zl3RDFSEI/AAAAAAAABOw/vVZ-acStlns/s1600/RedMoon.JPG" height="425" width="580" /></a></div>
<span id="goog_1502381209"></span><span id="goog_1502381210"></span><br />Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-77518246000282737902014-04-07T09:03:00.000-05:002014-04-07T09:03:26.736-05:00Smart Image Comparer<div style="background-color: white; clear: both; font-family: Trebuchet MS, sans-serif; padding: 5px; text-align: center;">
<a href="https://smartimagecomparer.codeplex.com/"><img border="0" src="http://2.bp.blogspot.com/-ttBpu5zlZIM/U0KtzyADvlI/AAAAAAAABOQ/8CDYr2dXhY8/s1600/SmartImageComparer.png" height="55" width="320" /></a>
<br />
<a href="https://smartimagecomparer.codeplex.com/">SmartImageComparer.codeplex.com</a>
<br />
<br /></div>
Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-46321331649392432602014-04-05T20:07:00.001-06:002014-04-05T20:07:03.246-06:00Mescalero Lake<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-b1B01SyOEYg/U0C1yl0AqKI/AAAAAAAABNI/Fu40Cuv7yLM/s1600/MescaleroLake.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-b1B01SyOEYg/U0C1yl0AqKI/AAAAAAAABNI/Fu40Cuv7yLM/s320/MescaleroLake.JPG" height="425" width="580" /></a></div>
Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-30527663970739398612014-04-02T20:51:00.000-06:002014-04-02T20:51:27.353-06:00Sensktop 1.0<div class="separator" style="clear: both; text-align: center; padding:15px; background-color:#fff; opacity:0.8;">
<a href="https://sensktop.codeplex.com/"><img alt=" Sensktop 1.0" border="0" src="http://1.bp.blogspot.com/-VhC77H3DaVk/UzzLu6yWawI/AAAAAAAABMg/15Tr9IX2rxU/s1600/Sensktop.png" /></a>
<br />
<a href="https://sensktop.codeplex.com/">sensktop.codeplex.com</a>
</div>
<br />Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-28328119041425578602014-03-31T09:02:00.000-06:002014-03-31T09:05:31.126-06:00WPF Color Generator<div style="background-color: white; opacity: 0.8; padding: 15px;">
<pre class="csharpcode" style="font-family: Consolas, 'Courier New', Courier, monospace; font-size: small;"><span class="kwrd" style="color: blue;">namespace</span> SenenFernandez.SmartExtensionMethods
{
<span class="kwrd" style="color: blue;">using</span> System;
<span class="kwrd" style="color: blue;">using</span> System.Windows.Media;
<span class="kwrd" style="color: blue;">public</span> <span class="kwrd" style="color: blue;">class</span> SmartColorGenerator
{
<span class="kwrd" style="color: blue;">private</span> <span class="kwrd" style="color: blue;">readonly</span> Random random;
<span class="kwrd" style="color: blue;">private</span> <span class="kwrd" style="color: blue;">static</span> <span class="kwrd" style="color: blue;">readonly</span> <span class="kwrd" style="color: blue;">object</span> sync = <span class="kwrd" style="color: blue;">new</span> <span class="kwrd" style="color: blue;">object</span>();
<span class="kwrd" style="color: blue;">private</span> <span class="kwrd" style="color: blue;">static</span> SmartColorGenerator instance;
<span class="kwrd" style="color: blue;">public</span> <span class="kwrd" style="color: blue;">static</span> SmartColorGenerator Instance
{
<span class="kwrd" style="color: blue;">get</span>
{
<span class="kwrd" style="color: blue;">lock</span> (sync)
{
<span class="kwrd" style="color: blue;">return</span> instance ?? (instance = <span class="kwrd" style="color: blue;">new</span> SmartColorGenerator());
}
}
}
<span class="kwrd" style="color: blue;">public</span> SmartColorGenerator(<span class="kwrd" style="color: blue;">int</span> seed = 255)
{
random = <span class="kwrd" style="color: blue;">new</span> Random(seed);
}
<span class="kwrd" style="color: blue;">public</span> SolidColorBrush GetBrush(<span class="kwrd" style="color: blue;">double</span> opacity = 1.0)
{
<span class="kwrd" style="color: blue;">var</span> brush = <span class="kwrd" style="color: blue;">new</span> SolidColorBrush(GetColor(opacity));
brush.Freeze();
<span class="kwrd" style="color: blue;">return</span> brush;
}
<span class="kwrd" style="color: blue;">public</span> Color GetColor(<span class="kwrd" style="color: blue;">double</span> opacity = 1.0)
{
<span class="kwrd" style="color: blue;">int</span> alpha = (<span class="kwrd" style="color: blue;">int</span>)
(255*(opacity > 1.0 ? 1 : opacity < 0 ? 0 : opacity));
<span class="kwrd" style="color: blue;">var</span> color = <span class="kwrd" style="color: blue;">new</span> Color
{
A = (<span class="kwrd" style="color: blue;">byte</span>) (alpha),
R = GetNext(),
B = GetNext(),
G = GetNext()
};
<span class="kwrd" style="color: blue;">return</span> color;
}
<span class="kwrd" style="color: blue;">private</span> <span class="kwrd" style="color: blue;">byte</span> GetNext()
{
<span class="kwrd" style="color: blue;">return</span> (<span class="kwrd" style="color: blue;">byte</span>) (random.Next(127) + 128);
}
}
}</pre>
</div>
Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-48401360685180535232014-03-26T23:47:00.000-06:002014-03-31T08:04:07.197-06:00WMI Query to Get IP Address<div style="background-color: white; padding: 15px; opacity:0.8;">
<pre class="csharpcode" style="font-family: Consolas, 'Courier New', Courier, monospace;"><span class="kwrd" style="color: blue;">var</span> query = <span class="kwrd" style="color: blue;">new</span> System.Management.SelectQuery(
<span class="str" style="color: #a31515;">@"SELECT *
FROM Win32_NetworkAdapterConfiguration
WHERE IPEnabled = TRUE
OR DHCPEnabled = TRUE"</span>);
<span class="kwrd" style="color: blue;">var</span> searcher = <span class="kwrd" style="color: blue;">new</span> System.Management.ManagementObjectSearcher(query);
<span class="kwrd" style="color: blue;">var</span> netCards = searcher.Get();
<span class="kwrd" style="color: blue;">foreach</span>(<span class="kwrd" style="color: blue;">var</span> netCard <span class="kwrd" style="color: blue;">in</span> netCards)
{
<span class="kwrd" style="color: blue;">var</span> ips = netCard[<span class="str" style="color: #a31515;">"IPAddress"</span>] <span class="kwrd" style="color: blue;">as</span> <span class="kwrd" style="color: blue;">string</span>[];
<span class="kwrd" style="color: blue;">if</span> (ips != <span class="kwrd" style="color: blue;">null</span>)
{
System.Console.WriteLine(<span class="str" style="color: #a31515;">"{0}\t{1}"</span>
, netCard[<span class="str" style="color: #a31515;">"Description"</span>]
, netCard[<span class="str" style="color: #a31515;">"MACAddress"</span>]);
<span class="kwrd" style="color: blue;">foreach</span>(<span class="kwrd" style="color: blue;">var</span> ip <span class="kwrd" style="color: blue;">in</span> ips)
{
System.Console.WriteLine(<span class="str" style="color: #a31515;">"\t{0}"</span>, ip);
}
}
}</pre>
</div>
Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-72432514956072899622014-03-26T21:33:00.001-06:002014-03-31T08:04:13.462-06:00SQLServer Connection Monitor<div style="background-color: white; padding: 15px; opacity:0.8;">
<code style="font-size: 12px;"><span style="color: blue;">SELECT </span><span style="color: black;">T1.session_id </span><span style="color: blue;">AS </span><span style="color: black;">[SessionId]<br /> </span><span style="color: grey;">, </span><span style="color: black;">T1.host_process_id </span><span style="color: blue;">AS </span><span style="color: black;">[HostPid]<br /> </span><span style="color: grey;">, </span><span style="color: magenta;">DB_NAME</span><span style="color: grey;">(</span><span style="color: black;">T3.dbid</span><span style="color: grey;">) </span><span style="color: blue;">AS </span><span style="color: black;">[Database]<br /> </span><span style="color: grey;">, </span><span style="color: black;">T1.</span><span style="color: magenta;">HOST_NAME </span><span style="color: blue;">AS </span><span style="color: black;">[Host]<br /> </span><span style="color: grey;">, </span><span style="color: black;">T1.program_name </span><span style="color: blue;">AS </span><span style="color: black;">[ApplicationName]</span></code><br />
<code style="font-size: 12px;"><span style="color: black;"> </span><span style="color: grey;">, </span><span style="color: black;">T1.login_name </span><span style="color: blue;">AS </span><span style="color: black;">[UserName]<br /> </span><span style="color: grey;">, </span><span style="color: black;">T2.client_net_address </span><span style="color: blue;">AS </span><span style="color: black;">[IP]<br /> </span><span style="color: grey;">, </span><span style="color: black;">T1.cpu_time </span><span style="color: blue;">AS </span><span style="color: black;">[Cpu]<br /> </span><span style="color: grey;">, </span><span style="color: black;">T1.memory_usage </span><span style="color: blue;">AS </span><span style="color: black;">[Ram]<br /> </span><span style="color: grey;">, </span><span style="color: black;">T4.Connections </span><span style="color: blue;">AS </span><span style="color: black;">[Connections]<br /> </span><span style="color: grey;">, </span><span style="color: black;">T4.net_transport </span><span style="color: blue;">AS </span><span style="color: black;">[NetTransport]<br /> </span><span style="color: grey;">, </span><span style="color: black;">T2.net_packet_size </span><span style="color: blue;">AS </span><span style="color: black;">[NetPacketSize]<br /> </span><span style="color: grey;">, </span><span style="color: red;">'[' </span><span style="color: grey;">+ </span><span style="color: magenta;">DB_NAME</span><span style="color: grey;">(</span><span style="color: black;">T3.dbid</span><span style="color: grey;">) + </span><span style="color: red;">'].['<br /> </span><span style="color: grey;">+ </span><span style="color: black;">object_schema_name</span><span style="color: grey;">(</span><span style="color: black;">T3.objectid</span><span style="color: grey;">, </span><span style="color: black;">T3.dbid</span><span style="color: grey;">) + </span><span style="color: red;">'].['<br /> </span><span style="color: grey;">+ </span><span style="color: magenta;">OBJECT_NAME</span><span style="color: grey;">(</span><span style="color: black;">T3.objectid</span><span style="color: grey;">, </span><span style="color: black;">T3.dbid</span><span style="color: grey;">) + </span><span style="color: red;">']' </span><span style="color: blue;">AS </span><span style="color: black;">[ObjectName]<br /> </span><span style="color: grey;">, </span><span style="color: black;">T3.</span><span style="color: blue;">TEXT AS </span><span style="color: black;">[Query]</span></code><br />
<code style="font-size: 12px;"><span style="color: blue;">FROM </span><span style="color: black;">sys.dm_exec_sessions T1</span></code><br />
<code style="font-size: 12px;"><span style="color: blue;">INNER JOIN </span><span style="color: black;">sys.dm_exec_connections T2 </span><span style="color: blue;">ON </span><span style="color: black;">T2.session_id </span><span style="color: blue;">= </span><span style="color: black;">T1.session_id</span></code><br />
<code style="font-size: 12px;"><span style="color: grey;">CROSS </span><span style="color: black;">APPLY sys.dm_exec_sql_text</span><span style="color: grey;">(</span><span style="color: black;">T2.most_recent_sql_handle</span><span style="color: grey;">) </span><span style="color: black;">T3</span></code><br />
<code style="font-size: 12px;"><span style="color: blue;">INNER JOIN</span></code><br />
<code style="font-size: 12px;"><span style="color: grey;">(<br /> </span><span style="color: blue;">SELECT </span><span style="color: black;">T1.dbid</span><span style="color: grey;">, </span><span style="color: black;">T1.spid</span><span style="color: grey;">, </span><span style="color: black;">T2.net_transport</span><span style="color: grey;">, </span><span style="color: magenta;">COUNT</span><span style="color: grey;">(</span><span style="color: black;">T1.dbid</span><span style="color: grey;">) </span><span style="color: blue;">AS </span><span style="color: black;">[Connections]<br /> </span><span style="color: blue;">FROM </span><span style="color: black;">sys.sysprocesses T1<br /> </span><span style="color: blue;">INNER JOIN </span><span style="color: black;">sys.dm_exec_connections T2 </span><span style="color: blue;">ON </span><span style="color: black;">T1.spid </span><span style="color: blue;">= </span><span style="color: black;">T2.session_id<br /> </span><span style="color: blue;">GROUP BY </span><span style="color: black;">dbid</span><span style="color: grey;">, </span><span style="color: black;">T1.spid</span><span style="color: grey;">, </span><span style="color: black;">T2.net_transport</span></code><br />
<code style="font-size: 12px;"><span style="color: grey;">) </span><span style="color: black;">T4 </span><span style="color: blue;">ON </span><span style="color: black;">T4.spid </span><span style="color: blue;">= </span><span style="color: black;">T1.session_id</span></code><br />
<code style="font-size: 12px;"><span style="color: blue;">ORDER BY </span><span style="color: black;">Connections </span><span style="color: blue;">DESC</span><span style="color: grey;">, </span><span style="color: black;">Cpu </span><span style="color: blue;">DESC</span><span style="color: grey;">, </span><span style="color: black;">Ram </span><span style="color: blue;">DESC
</span></code></div>Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-46660414857693762942014-03-17T12:30:00.002-06:002014-03-31T09:03:13.937-06:00WPF Display Manager<div class="separator" style="background-color: white; clear: both; text-align: center;">
<a href="https://displaymanager.codeplex.com/"><img alt=" https://displaymanager.codeplex.com/" border="0" src="http://3.bp.blogspot.com/-GpkqNNVaNX0/Uyc-iun2zCI/AAAAAAAABL0/GpfAyqUO0HU/s400/WPFDisplayManager.png" /></a></div>
<div class="separator" style="background-color: white; clear: both; text-align: center;">
<a href="https://displaymanager.codeplex.com/">https://displaymanager.codeplex.com/</a></div>
<div class="separator" style="background-color: white; clear: both; text-align: center;">
<br /></div>
Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-26658368959020078842014-03-10T22:32:00.001-06:002014-03-10T22:32:58.050-06:00Taquitos de lechuga =)<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.pinterest.com/senenfernandez/comida/"><img alt=" Para el Antojo" border="0" src="http://media-cache-ec0.pinimg.com/736x/c2/0d/0c/c20d0c92a430624dbd7eaf80a21c2fee.jpg" height="387" width="400" /></a></div>
<br />Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-32445144860710779812014-03-06T18:00:00.000-06:002014-03-06T18:00:02.878-06:00Update SQLServer Identity Column<div style="background-color: white; opacity: 0.8;">
<br />
<code style="font-size: 12px;"><span style="color: blue;">DECLARE </span><span style="color: #434343;">@NewId </span><span style="color: blue;">INT = </span>23</code><br />
<code style="font-size: 12px;"><span style="color: blue;"><br /></span></code>
<code style="font-size: 12px;"><span style="color: blue;">DECLARE </span><span style="color: #434343;">@TableName </span><span style="color: blue;">VARCHAR</span><span style="color: grey;">(</span><span style="color: magenta;">MAX</span><span style="color: grey;">) </span><span style="color: blue;">= </span><span style="color: red;">'Database.Schema.TableName'</span></code><br />
<code style="font-size: 12px;"><span style="color: blue;"><br /></span></code>
<code style="font-size: 12px;"><span style="color: blue;">DBCC </span>CHECKIDENT <span style="color: grey;">(</span><span style="color: #434343;">@TableName</span><span style="color: grey;">, RESEED</span><span style="color: grey;">, </span><span style="color: #434343;">@NewId</span><span style="color: grey;">)</span></code><br />
<code style="font-size: 12px;"><span style="color: grey;"><br /></span></code><span style="background-color: white; font-family: arial, verdana, sans-serif;"> </span>
</div>
Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-36409109443055619952014-03-05T20:39:00.000-06:002014-03-05T20:41:56.589-06:00Fix SQLServer Database marked as Suspect or Corrupted<div style="background-color: white;opacity:0.8;">
<span style="font-family: Trebuchet MS, sans-serif;">ERROR: Database 'SenenDB' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
You can bring it online using the following steps:</span><br />
<br />
<span style="color: green; font-family: monospace; font-size: 12px;">--Reset the suspect flag</span><br />
<span style="color: blue; font-family: monospace; font-size: 12px;">EXEC </span><span style="color: darkred; font-family: monospace; font-size: 12px;">sp_resetstatus </span><span style="color: red; font-family: monospace; font-size: 12px;">'SenenDB'</span><br />
<span style="color: green; font-family: monospace; font-size: 12px;"><br /></span>
<span style="color: green; font-family: monospace; font-size: 12px;">--Set the database to emergency mode so that it becomes read only and not accessible to others</span><br />
<span style="color: blue; font-family: monospace; font-size: 12px;">ALTER DATABASE </span><span style="font-family: monospace; font-size: 12px;">SenenDB </span><span style="color: blue; font-family: monospace; font-size: 12px;">SET </span><span style="font-family: monospace; font-size: 12px;">EMERGENCY</span><br />
<span style="color: green; font-family: monospace; font-size: 12px;"><br /></span>
<span style="color: green; font-family: monospace; font-size: 12px;">--Check the integrity among all the objects</span><br />
<span style="color: blue; font-family: monospace; font-size: 12px;">DBCC </span><span style="font-family: monospace; font-size: 12px;">CheckDB </span><span style="color: grey; font-family: monospace; font-size: 12px;">(</span><span style="color: red; font-family: monospace; font-size: 12px;">'SenenDB'</span><span style="color: grey; font-family: monospace; font-size: 12px;">)</span><br />
<span style="color: green; font-family: monospace; font-size: 12px;"><br /></span>
<span style="color: green; font-family: monospace; font-size: 12px;">--Set the database to single user mode</span><br />
<span style="color: blue; font-family: monospace; font-size: 12px;">ALTER DATABASE </span><span style="font-family: monospace; font-size: 12px;">SenenDB </span><span style="color: blue; font-family: monospace; font-size: 12px;">SET </span><span style="font-family: monospace; font-size: 12px;">SINGLE_USER </span><span style="color: blue; font-family: monospace; font-size: 12px;">WITH ROLLBACK IMMEDIATE</span><br />
<span style="color: green; font-family: monospace; font-size: 12px;"><br /></span>
<span style="color: green; font-family: monospace; font-size: 12px;">--Repair the errors</span><br />
<span style="color: blue; font-family: monospace; font-size: 12px;">DBCC </span><span style="font-family: monospace; font-size: 12px;">CheckDB </span><span style="color: grey; font-family: monospace; font-size: 12px;">(</span><span style="color: red; font-family: monospace; font-size: 12px;">'SenenDB'</span><span style="color: grey; font-family: monospace; font-size: 12px;">, </span><span style="font-family: monospace; font-size: 12px;">REPAIR_ALLOW_DATA_LOSS</span><span style="color: grey; font-family: monospace; font-size: 12px;">)</span><br />
<span style="color: green; font-family: monospace; font-size: 12px;"><br /></span>
<span style="color: green; font-family: monospace; font-size: 12px;">--Set the database to multi user mode, so that it can now be accessed by others</span><br />
<span style="color: blue; font-family: monospace; font-size: 12px;">ALTER DATABASE </span><span style="font-family: monospace; font-size: 12px;">SenenDB </span><span style="color: blue; font-family: monospace; font-size: 12px;">SET </span><span style="font-family: monospace; font-size: 12px;">MULTI_USER</span><br />
<br /></div>Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0tag:blogger.com,1999:blog-4762703325481668005.post-3951873470501830372014-03-05T18:40:00.000-06:002014-03-05T18:40:49.097-06:00SmartExtensionMethods<h3 style="text-align: center;">
<span style="font-family: Trebuchet MS, sans-serif;">It's time to share knowledge with the world,</span></h3>
<h3 style="text-align: center;">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span><b><span style="font-family: Trebuchet MS, sans-serif;">Visit my first of many open source <a href="https://smartextensionmethods.codeplex.com/">SmartExtensionMethods</a> :)</span></b></h3>
<div>
<b><span style="font-family: Trebuchet MS, sans-serif;"><br /></span></b></div>
<div>
<b><span style="font-family: Trebuchet MS, sans-serif;"><br /></span></b></div>
Senen Fernandezhttp://www.blogger.com/profile/02919627552513929617noreply@blogger.com0