Articles - Database (SQL Server)

0

Like

This simple SQL Q & A article will explain what is ‘nchar’ & ‘nvarchar’ data-type and the difference between them. ...Read more
Posted by: Shivprasad H. Bist
On 06 Sep 2017 | Views: 129 | Categories: Database (SQL Server)
0

Like

In this post we will see different ways to calculate running total using T-SQL. I am using Microsoft SQL SERVER 2008 R2. ...Read more
Posted by: Muhammad Idrees
On 06 Aug 2017 | Views: 151 | Categories: Tips & Tricks, Patterns, Other, Database (SQL Server)
0

Like

In this post, I will explain how to script multiple objects using SQL Server Management Studio. You may be aware of generating script by right clicking on specific object (Table / Stored Procedure / Function / View etc), or also you may generate scripts by right clicking on the database node, select Tasks, and then click on Generate Scripts... option. ...Read more
Posted by: Muhammad Idrees
On 26 Jul 2017 | Views: 118 | Categories: Tips & Tricks, Database (SQL Server)
0

Like

In this post, I am sharing a solution for a problem I faced while I started using Power BI. When you try to connect with SQL Server as Data Source, you may encounter this error message:

The user was not authorized ...Read more
Posted by: Muhammad Idrees
On 26 Jul 2017 | Views: 122 | Categories: Tips & Tricks, Database (SQL Server)
0

Like

I created small utility program for different routine tasks to run on different schedules, one of which is to take database backup to a local folder, and it was working fine. To have access it across network for selected users, and making it available for copy/move to other backup devices, we shared this folder on network. ...Read more
Posted by: Muhammad Idrees
On 26 Jul 2017 | Views: 112 | Categories: Tips & Tricks, Database (SQL Server)
0

Like

In this article we will explain basic fundamentals of the MSBI and SQL Server technology. ...Read more
Posted by: Shivprasad H. Bist
On 02 Jan 2017 | Views: 151 | Categories: Database (SQL Server)
0

Like

In this article learn to install SQL Server 2014 step by step using our example . ...Read more
Posted by: Shivprasad H. Bist
On 29 Dec 2016 | Views: 125 | Categories: Database (SQL Server)
0

Like

In this video we will learn SQL Server step by step in 16 hours. ...Read more
Posted by: Shivprasad H. Bist
On 12 Dec 2016 | Views: 136 | Categories: Database (SQL Server)
0

Like

Table Value Constructor provides a way to construct a table from row value expressions. It allows multiple rows of data to be specified in a single DML statement. One simpler version of select statement with single row values may be used like this. ...Read more
Posted by: Muhammad Idrees
On 05 Dec 2016 | Views: 192 | Categories: Patterns, Other, Database (SQL Server), ADO.NET
0

Like

Keyboard shortcuts speed up development tasks in order to get more productive results. I encountered this problem that some keyboard shortcuts stopped working like CTRL+K, CTRL+C is not commenting the selected text, and it seemed unaffected. There could be two possible reasons which may cause this behavior: ...Read more
Posted by: Muhammad Idrees
On 01 Dec 2016 | Views: 151 | Categories: Database (SQL Server)
Page 1 of 11
Other lins

.Net Techies
Other lins