http://techsapphire.in/ Thu, 15 Sep 2016 06:06:27 GMT uCoz Web-Service <h1>Code snippets and steps to create custom code snippets</h1> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/IfENsQ-FVGc" width="640"></iframe></p> <p>Code snippets are meant as small region of reusable code. Which allow you to use intellisense to insert set of code N number of times. Below are the content you will cover in lecture. Using code snippets can save a lot of time and effort. Also help in distributing common standard code among team.</p> <p>&bull; Code Snippets &ndash; Introduction<br /> &bull; Ways to insert code snippets<br /> &bull; Custom Code Snippets<br /> &bull; XML File walkthrough<br /> &bull; Examples<br /> &bull; Using the custom snippets</p> <p>&bull; Ready made code fragments<br /> &bull; Two types<br /> &nbsp; &nbsp;&bull; Expansion code snippet<br /> &nbsp; &nbsp;&bull; Surround with code snippet</p> <p><br /> Custom code snippets:<br /> &bull; Steps to create custom code snippet<br /> &bull; Create an XML file w... <h1>Code snippets and steps to create custom code snippets</h1> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/IfENsQ-FVGc" width="640"></iframe></p> <p>Code snippets are meant as small region of reusable code. Which allow you to use intellisense to insert set of code N number of times. Below are the content you will cover in lecture. Using code snippets can save a lot of time and effort. Also help in distributing common standard code among team.</p> <p>&bull; Code Snippets &ndash; Introduction<br /> &bull; Ways to insert code snippets<br /> &bull; Custom Code Snippets<br /> &bull; XML File walkthrough<br /> &bull; Examples<br /> &bull; Using the custom snippets</p> <p>&bull; Ready made code fragments<br /> &bull; Two types<br /> &nbsp; &nbsp;&bull; Expansion code snippet<br /> &nbsp; &nbsp;&bull; Surround with code snippet</p> <p><br /> Custom code snippets:<br /> &bull; Steps to create custom code snippet<br /> &bull; Create an XML file with extension .snippet<br /> &bull; Import the snippets in Visual Studio<br /> &bull; XML File boilerplate</p> <p><a download="" href="http://www.techsapphire.in/CustomCodeSnippet.xml">Download CustomerCodeSnippert.xml</a></p> <p>XML used for custom code snippet in video is:</p> <p><?xml version="1.0" encoding="utf-8" ?&gt;&nbsp;<br /> <CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/CodeSnippet"&gt;<br /> &nbsp; &nbsp; <CodeSnippet Format="1.0.0"&gt;<br /> &nbsp; &nbsp; &nbsp; &nbsp; <!-- The header contains metadata about the snippet --&gt;<br /> &nbsp; &nbsp; &nbsp; &nbsp; <Header&gt;</p> <p>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<!-- The Title of the snippet, this will be shown in the snippets manager --&gt;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<Title&gt;</Title&gt;</p> <p>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<!-- The description of the snippet --&gt;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<Description&gt;</Description&gt;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<!-- The author of the snippet --&gt;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<Author&gt;</Author&gt;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<!-- The set of characters that must be keyed in to insert the snippet --&gt;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<Shortcut&gt;</Shortcut&gt;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<!-- Snippet type - Expansion, SurroundsWith --&gt;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<SnippetTypes&gt;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<SnippetType&gt;</SnippetType&gt;<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;</SnippetTypes&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<br /> &nbsp; &nbsp; &nbsp; &nbsp; </Header&gt;<br /> &nbsp; &nbsp; &nbsp;&nbsp;<br /> &nbsp; &nbsp; &nbsp; &nbsp; <!-- Snippet code and literals, if any --&gt;<br /> &nbsp; &nbsp; &nbsp; &nbsp; <Snippet&gt;<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <!-- Specify the code language and the actual snippet content. --&gt;<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <Code Language="CSharp"&gt;<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <![CDATA[<br /> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;ACTUAL SNIPPET CODE<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ]]&gt;<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </Code&gt;<br /> &nbsp; &nbsp; &nbsp; &nbsp; </Snippet&gt;<br /> &nbsp; &nbsp; </CodeSnippet&gt;<br /> </CodeSnippets&gt;</p> <p><a download="" href="http://www.techsapphire.in/CustomCodeSnippet.xml">Download CustomerCodeSnippert.xml</a></p> http://www.techsapphire.in/news/code_snippets_and_steps_to_create_custom_code_snippets/2016-09-15-68 Programming Admin http://www.techsapphire.in/news/code_snippets_and_steps_to_create_custom_code_snippets/2016-09-15-68 Thu, 15 Sep 2016 06:06:27 GMT <p><strong><span style="font-size:14px;">Keypress event in WPF to validate integer input is replaced by PreviewTextInput in C#</span></strong></p> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/MDWRJwmwo5k" width="640"></iframe></p> <p>In WPF we don't have keypress event, generally people used keypress event in windows forms application to validate text input. Now in this example I have showed how you can validate&nbsp;input from textbox using PreviewTextInput event. In this example I validated input to accept float values, you can use this to validate integer or any other number type validation.</p> <p>Code used in example is:</p> <p>XAML:</p> <p><Window x:Class="TestApplication.MainWindow"<br /> &nbsp; &nbsp; &nbsp; &nbsp; xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"<br /> &nbsp; &nbsp; &nbsp; &nbsp; xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"<br /> &nbsp; &nbsp; &nbsp; ... <p><strong><span style="font-size:14px;">Keypress event in WPF to validate integer input is replaced by PreviewTextInput in C#</span></strong></p> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/MDWRJwmwo5k" width="640"></iframe></p> <p>In WPF we don't have keypress event, generally people used keypress event in windows forms application to validate text input. Now in this example I have showed how you can validate&nbsp;input from textbox using PreviewTextInput event. In this example I validated input to accept float values, you can use this to validate integer or any other number type validation.</p> <p>Code used in example is:</p> <p>XAML:</p> <p><Window x:Class="TestApplication.MainWindow"<br /> &nbsp; &nbsp; &nbsp; &nbsp; xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"<br /> &nbsp; &nbsp; &nbsp; &nbsp; xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"<br /> &nbsp; &nbsp; &nbsp; &nbsp; Title="MainWindow" Height="350" Width="525"&gt;<br /> &nbsp; &nbsp;&nbsp;<br /> &nbsp; &nbsp; <Grid&gt;<br /> &nbsp; &nbsp; &nbsp; &nbsp; <TextBox Width="400" Height="50" PreviewTextInput="TextBox_PreviewTextInput" &nbsp; &nbsp;/&gt;<br /> &nbsp; &nbsp; </Grid&gt;<br /> </Window&gt;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>C#:</p> <div class="code"> <pre style="font-size: 13.3333px; color: rgb(0, 0, 0); font-family: 'Courier New'; margin-top: 0px; margin-bottom: 0px; line-height: 20.8px; border: 1px dashed rgb(204, 204, 204); overflow-x: auto; overflow-y: hidden; padding: 0px; word-wrap: normal; background: rgb(240, 240, 240);"> <span class="keyword" style="color: rgb(0, 0, 255);">using</span> System; <span class="keyword" style="color: rgb(0, 0, 255);">using</span> System.Collections.Generic; <span class="keyword" style="color: rgb(0, 0, 255);">using</span> System.Linq; <span class="keyword" style="color: rgb(0, 0, 255);">using</span> System.Text; <span class="keyword" style="color: rgb(0, 0, 255);">using</span> System.Threading.Tasks; <span class="keyword" style="color: rgb(0, 0, 255);">using</span> System.Windows; <span class="keyword" style="color: rgb(0, 0, 255);">using</span> System.Windows.Controls; <span class="keyword" style="color: rgb(0, 0, 255);">using</span> System.Windows.Data; <span class="keyword" style="color: rgb(0, 0, 255);">using</span> System.Windows.Documents; <span class="keyword" style="color: rgb(0, 0, 255);">using</span> System.Windows.Input; <span class="keyword" style="color: rgb(0, 0, 255);">using</span> System.Windows.Media; <span class="keyword" style="color: rgb(0, 0, 255);">using</span> System.Windows.Media.Imaging; <span class="keyword" style="color: rgb(0, 0, 255);">using</span> System.Windows.Navigation; <span class="keyword" style="color: rgb(0, 0, 255);">using</span> System.Windows.Shapes; <span class="keyword" style="color: rgb(0, 0, 255);">namespace</span> TestApplication { <span class="comment2" style="color: rgb(128, 128, 128);">///</span><span class="comment" style="color: rgb(0, 128, 0);"> </span><span class="comment2" style="color: rgb(128, 128, 128);"><summary&gt;</span> <span class="comment2" style="color: rgb(128, 128, 128);">///</span><span class="comment" style="color: rgb(0, 128, 0);"> Interaction logic for MainWindow.xaml</span> <span class="comment2" style="color: rgb(128, 128, 128);">///</span><span class="comment" style="color: rgb(0, 128, 0);"> </span><span class="comment2" style="color: rgb(128, 128, 128);"></summary&gt;</span> <span class="keyword" style="color: rgb(0, 0, 255);">public</span> <span class="keyword" style="color: rgb(0, 0, 255);">partial</span> <span class="keyword" style="color: rgb(0, 0, 255);">class</span> <span class="type" style="color: rgb(43, 145, 175);">MainWindow</span>: <span class="type" style="color: rgb(43, 145, 175);">Window</span> { <span class="keyword" style="color: rgb(0, 0, 255);">public</span> MainWindow() { InitializeComponent(); } <span class="keyword" style="color: rgb(0, 0, 255);">private</span> <span class="keyword" style="color: rgb(0, 0, 255);">void</span> TextBox_PreviewTextInput(<span class="keyword" style="color: rgb(0, 0, 255);">object</span> sender, <span class="type" style="color: rgb(43, 145, 175);">TextCompositionEventArgs</span> e) { <span class="keyword" style="color: rgb(0, 0, 255);">if</span> (e.<span class="type" style="color: rgb(43, 145, 175);">Text</span> != <span class="string" style="color: rgb(163, 21, 21);">"."</span> &amp;&amp; IsNumber(e.<span class="type" style="color: rgb(43, 145, 175);">Text</span>) == <span class="keyword" style="color: rgb(0, 0, 255);">false</span>) { e.Handled = <span class="keyword" style="color: rgb(0, 0, 255);">true</span>; } <span class="keyword" style="color: rgb(0, 0, 255);">else</span> <span class="keyword" style="color: rgb(0, 0, 255);">if</span> (e.<span class="type" style="color: rgb(43, 145, 175);">Text</span> == <span class="string" style="color: rgb(163, 21, 21);">"."</span>) { <span class="keyword" style="color: rgb(0, 0, 255);">if</span> (((<span class="type" style="color: rgb(43, 145, 175);">TextBox</span>) sender).<span class="type" style="color: rgb(43, 145, 175);">Text</span>.IndexOf(e.<span class="type" style="color: rgb(43, 145, 175);">Text</span>) &gt; -1) { e.Handled = <span class="keyword" style="color: rgb(0, 0, 255);">true</span>; } } } <span class="keyword" style="color: rgb(0, 0, 255);">private</span> <span class="keyword" style="color: rgb(0, 0, 255);">bool</span> IsNumber(<span class="keyword" style="color: rgb(0, 0, 255);">string</span> Text) { <span class="keyword" style="color: rgb(0, 0, 255);">int</span> output; <span class="keyword" style="color: rgb(0, 0, 255);">return</span> int.TryParse(<span class="type" style="color: rgb(43, 145, 175);">Text</span>, <span class="keyword" style="color: rgb(0, 0, 255);">out</span> output); } } }</pre> </div> <p>&nbsp;</p> http://www.techsapphire.in/news/keypress_event_in_wpf_to_validate_integer_input_is_replaced_by_previewtextinput_in_c/2016-03-06-67 Programming Admin http://www.techsapphire.in/news/keypress_event_in_wpf_to_validate_integer_input_is_replaced_by_previewtextinput_in_c/2016-03-06-67 Sat, 05 Mar 2016 21:29:53 GMT <h1 class="creator-editor-title" style="margin: 8px 0px; padding: 0px; border: 0px; font-size: 18px; line-height: 1em; color: rgb(0, 0, 0); font-family: Roboto, arial, sans-serif; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"><span style="font-size:24px;"><strong><a dir="ltr" href="https://www.youtube.com/watch?v=98c8spD5k5s" id="creator-editor-title-link" style="margin: 0px; padding: 0px; border: 0px; color: rgb(51, 51, 51); cursor: pointer; text-decoration: none; max-width: 700px; height: 1.1em; display: inline-block; overflow: hidden; white-space: nowrap; word-wrap: normal; text-overflow: ellipsis; background: transparent;" title="SQL server 100% CPU usage fix">SQL server 100% CPU usage fix</a></strong></span></h1> <p>This issue is very common and commonly faced by DBA, developers and server management team on production server i.e. ... <h1 class="creator-editor-title" style="margin: 8px 0px; padding: 0px; border: 0px; font-size: 18px; line-height: 1em; color: rgb(0, 0, 0); font-family: Roboto, arial, sans-serif; background-image: initial; background-attachment: initial; background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"><span style="font-size:24px;"><strong><a dir="ltr" href="https://www.youtube.com/watch?v=98c8spD5k5s" id="creator-editor-title-link" style="margin: 0px; padding: 0px; border: 0px; color: rgb(51, 51, 51); cursor: pointer; text-decoration: none; max-width: 700px; height: 1.1em; display: inline-block; overflow: hidden; white-space: nowrap; word-wrap: normal; text-overflow: ellipsis; background: transparent;" title="SQL server 100% CPU usage fix">SQL server 100% CPU usage fix</a></strong></span></h1> <p>This issue is very common and commonly faced by DBA, developers and server management team on production server i.e. SQL server leads into 100% CPU usage and also start consuming all available memory. Now most of the time you have seen technical people restarting sql services, or killing long running processes and even restarting complete server, and they can avoid this situation. Before starting any thing I would like to discuss a common myth people have that&nbsp;this is happening because of long running queries only. Which is not all ways true, some times:</p> <ul> <li>Longer running query can be problem</li> <li>Query having maximum worker time are also problem</li> <li>Query execution count can also cause problem</li> </ul> <p>Now in order to fix this issue you have to go through below video:</p> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/98c8spD5k5s" width="640"></iframe></p> <p><a href="http://www.techsapphire.in/index/sql_server_100_cpu_usage_fix/0-166">For reading complete article click here.</a></p> http://www.techsapphire.in/news/sql_server_100_cpu_usage_fix/2015-10-05-66 Database Admin http://www.techsapphire.in/news/sql_server_100_cpu_usage_fix/2015-10-05-66 Mon, 05 Oct 2015 06:05:27 GMT <p><strong>C# Best Practices</strong></p> <p>In this article I have focused on practical aspect more, and also I have not included basic practices as you can learn them from any article available online. I have tried to cover basic practices which will minimize your coding effort as well as it will make your code more manageable and also will reduce run time exceptions.</p> <p>Topics covered in today&rsquo;s lecture are:</p> <ul> <li>Common Coding Guidelines</li> <li>SQL Helper Class</li> <li>Using Lamda expression or LINQ</li> <li>Some common tips</li> <li>Cross resolution design</li> <li>LINQ operators and operations</li> </ul> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/ZSErmqe_1Qc" width="640"></iframe></p> <p><a href="http://www.techsapphire.in/index/c_best_practices/0-165">To read full article click below:</a></p> <p><strong>C# Best Practices</strong></p> <p>In this article I have focused on practical aspect more, and also I have not included basic practices as you can learn them from any article available online. I have tried to cover basic practices which will minimize your coding effort as well as it will make your code more manageable and also will reduce run time exceptions.</p> <p>Topics covered in today&rsquo;s lecture are:</p> <ul> <li>Common Coding Guidelines</li> <li>SQL Helper Class</li> <li>Using Lamda expression or LINQ</li> <li>Some common tips</li> <li>Cross resolution design</li> <li>LINQ operators and operations</li> </ul> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/ZSErmqe_1Qc" width="640"></iframe></p> <p><a href="http://www.techsapphire.in/index/c_best_practices/0-165">To read full article click below:</a></p> http://www.techsapphire.in/news/c_best_practices/2015-09-18-65 Programming Admin http://www.techsapphire.in/news/c_best_practices/2015-09-18-65 Fri, 18 Sep 2015 07:20:18 GMT <h2><strong>Error: Subreport could not be shown. RDLC using with ASP.NET.</strong></h2> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/Q6lsB-S6jO4" width="640"></iframe></p> <p>This exception is thrown only in 3 cases:<br /> 1. Parameter is not passed to sub report<br /> 2. Parameter which is been passed is not been created on sub report<br /> 3. Data type of parameter on main report and sub report is not matching up.</p> <p><a href="http://www.techsapphire.in/index/error_subreport_could_not_be_shown_rdlc_using_with_asp_net/0-163">To view complete article click here.</a></p> <h2><strong>Error: Subreport could not be shown. RDLC using with ASP.NET.</strong></h2> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/Q6lsB-S6jO4" width="640"></iframe></p> <p>This exception is thrown only in 3 cases:<br /> 1. Parameter is not passed to sub report<br /> 2. Parameter which is been passed is not been created on sub report<br /> 3. Data type of parameter on main report and sub report is not matching up.</p> <p><a href="http://www.techsapphire.in/index/error_subreport_could_not_be_shown_rdlc_using_with_asp_net/0-163">To view complete article click here.</a></p> http://www.techsapphire.in/news/error_subreport_could_not_be_shown_rdlc_using_with_asp_net/2015-07-15-64 Programming Admin http://www.techsapphire.in/news/error_subreport_could_not_be_shown_rdlc_using_with_asp_net/2015-07-15-64 Wed, 15 Jul 2015 10:53:04 GMT <p><span style="font-size:14px;"><strong>Uploading and downloading file on SFTP using private key in .NET using SharpSSH</strong></span></p> <p><strong>Topic to cover:</strong></p> <p>Connecting SFTP using Private Key using .NET console App<br /> &bull; Downloading and Uploading File</p> <p><strong>For complete SFTP operation in detail check link below:</strong><br /> Article: http://www.techsapphire.in/index/sftp_download_upload_and_delete_file_using_sharpssh_library/0-150<br /> Video: https://youtu.be/VVqh0BCgFpM</p> <p>Library used&nbsp;Sharpssh. To install:</p> <p>&bull; Got to Tools:&gt;Library Package Manager:&gt;Manage NuGet Pankages for solutions</p> <p>&bull; Search SharpSSh</p> <p>&bull; Install</p> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/uiMsTmjZOcw" width="640"></iframe></p> <p><a href="http://www.techsapphire.in/index/uploading_and_downloading_file_on_sftp_using_private_key_in_net_using_sharpssh/0-162">To view comple... <p><span style="font-size:14px;"><strong>Uploading and downloading file on SFTP using private key in .NET using SharpSSH</strong></span></p> <p><strong>Topic to cover:</strong></p> <p>Connecting SFTP using Private Key using .NET console App<br /> &bull; Downloading and Uploading File</p> <p><strong>For complete SFTP operation in detail check link below:</strong><br /> Article: http://www.techsapphire.in/index/sftp_download_upload_and_delete_file_using_sharpssh_library/0-150<br /> Video: https://youtu.be/VVqh0BCgFpM</p> <p>Library used&nbsp;Sharpssh. To install:</p> <p>&bull; Got to Tools:&gt;Library Package Manager:&gt;Manage NuGet Pankages for solutions</p> <p>&bull; Search SharpSSh</p> <p>&bull; Install</p> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/uiMsTmjZOcw" width="640"></iframe></p> <p><a href="http://www.techsapphire.in/index/uploading_and_downloading_file_on_sftp_using_private_key_in_net_using_sharpssh/0-162">To view complete article click here</a></p> http://www.techsapphire.in/news/uploading_and_downloading_file_on_sftp_using_private_key_in_net_using_sharpssh/2015-07-09-63 Programming Admin http://www.techsapphire.in/news/uploading_and_downloading_file_on_sftp_using_private_key_in_net_using_sharpssh/2015-07-09-63 Thu, 09 Jul 2015 07:24:28 GMT <p><strong><span style="font-size:22px;">SQL for Beginners</span></strong></p> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/Fg3DI8stjPI" width="640"></iframe></p> <p><strong>SQL (Structured Query Language)</strong></p> <ul> <li>It is high level language which provide you capability to query data from any structured data source (Tables).&nbsp;</li> <li>High level language means language which is used by us to communicate (English).&nbsp;</li> <li>For learning, we will be using online SQL editor provided by W3C.</li> <li>http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all</li> </ul> <p>SQL script:</p> <p>SQL Queries:</p> <p>Using Wild Card (*) :<br /> Selecting all data&nbsp;<br /> SELECT * FROM CUSTOMERS</p> <p>Specific Columns:<br /> SELECT CustomerName, ContactName,Address,<br /> &nbsp;City FROM CUSTOMERS</p> <p><a href="http://www.techsapphire.in/index/sql_for_beginners/0-161">Click to continue</a></p> <p><strong><span style="font-size:22px;">SQL for Beginners</span></strong></p> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/Fg3DI8stjPI" width="640"></iframe></p> <p><strong>SQL (Structured Query Language)</strong></p> <ul> <li>It is high level language which provide you capability to query data from any structured data source (Tables).&nbsp;</li> <li>High level language means language which is used by us to communicate (English).&nbsp;</li> <li>For learning, we will be using online SQL editor provided by W3C.</li> <li>http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all</li> </ul> <p>SQL script:</p> <p>SQL Queries:</p> <p>Using Wild Card (*) :<br /> Selecting all data&nbsp;<br /> SELECT * FROM CUSTOMERS</p> <p>Specific Columns:<br /> SELECT CustomerName, ContactName,Address,<br /> &nbsp;City FROM CUSTOMERS</p> <p><a href="http://www.techsapphire.in/index/sql_for_beginners/0-161">Click to continue</a></p> http://www.techsapphire.in/news/sql_for_beginners/2015-05-26-62 Database Admin http://www.techsapphire.in/news/sql_for_beginners/2015-05-26-62 Tue, 26 May 2015 09:29:36 GMT <p><strong><span style="font-size:14px;">Show data or details in horizontal layout in SSRS</span></strong></p> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/PMrSHGTngpA" width="640"></iframe></p> <p>To show data in horizontal layout like mentioned below:</p> <p><img alt="" src="http://www.techsapphire.in/Horizontal_Details.png" style="width: 263px; height: 204px;" /></p> <p><a href="http://www.techsapphire.in/index/show_data_or_details_in_horizontal_layout_in_ssrs/0-160">Click here to continue</a></p> <p><strong><span style="font-size:14px;">Show data or details in horizontal layout in SSRS</span></strong></p> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/PMrSHGTngpA" width="640"></iframe></p> <p>To show data in horizontal layout like mentioned below:</p> <p><img alt="" src="http://www.techsapphire.in/Horizontal_Details.png" style="width: 263px; height: 204px;" /></p> <p><a href="http://www.techsapphire.in/index/show_data_or_details_in_horizontal_layout_in_ssrs/0-160">Click here to continue</a></p> http://www.techsapphire.in/news/show_data_or_details_in_horizontal_layout_in_ssrs/2015-05-18-60 SSRS Admin http://www.techsapphire.in/news/show_data_or_details_in_horizontal_layout_in_ssrs/2015-05-18-60 Mon, 18 May 2015 10:08:14 GMT <p><strong><span style="font-size:16px;">SSIS Row Number</span></strong></p> <p>Generating Row Number in SSIS for each record.&nbsp;</p> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/3vEqXq38To4" width="640"></iframe></p> <p>Steps for Generating Row Numbers are: <a href="http://www.techsapphire.in/index/generate_row_number_in_ssis/0-159">Click to Download Project</a>.</p> <p><strong><span style="font-size:16px;">SSIS Row Number</span></strong></p> <p>Generating Row Number in SSIS for each record.&nbsp;</p> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/3vEqXq38To4" width="640"></iframe></p> <p>Steps for Generating Row Numbers are: <a href="http://www.techsapphire.in/index/generate_row_number_in_ssis/0-159">Click to Download Project</a>.</p> http://www.techsapphire.in/news/generate_ssis_in_row_number/2015-05-05-59 Database Admin http://www.techsapphire.in/news/generate_ssis_in_row_number/2015-05-05-59 Tue, 05 May 2015 09:15:24 GMT <p><span style="font-size:14px;"><strong>PIVOT:</strong></span><br /> &bull;Convert your output from (values)vertical order to horizontal(making columns) one</p> <p><strong>Topic to cover:</strong><br /> &bull;PIVOT example<br /> &bull;PIVOT syntax<br /> &bull;Interview Question<br /> &bull;PIVOT on northwind<br /> &bull;Dynamic PIVOT query</p> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/PECb7QExowY" width="640"></iframe></p> <p><a href="http://www.techsapphire.in/index/pivot_sql_lesson_with_generating_dynamic_columns_with_pivot/0-158">Click to continue</a></p> <p><span style="font-size:14px;"><strong>PIVOT:</strong></span><br /> &bull;Convert your output from (values)vertical order to horizontal(making columns) one</p> <p><strong>Topic to cover:</strong><br /> &bull;PIVOT example<br /> &bull;PIVOT syntax<br /> &bull;Interview Question<br /> &bull;PIVOT on northwind<br /> &bull;Dynamic PIVOT query</p> <p><iframe allowfullscreen="" frameborder="0" height="360" src="http://www.techsapphire.in//www.youtube.com/embed/PECb7QExowY" width="640"></iframe></p> <p><a href="http://www.techsapphire.in/index/pivot_sql_lesson_with_generating_dynamic_columns_with_pivot/0-158">Click to continue</a></p> http://www.techsapphire.in/news/pivot_sql_lesson_with_generating_dynamic_columns_with_pivot/2015-04-23-58 Database Admin http://www.techsapphire.in/news/pivot_sql_lesson_with_generating_dynamic_columns_with_pivot/2015-04-23-58 Thu, 23 Apr 2015 11:21:14 GMT