Articles - Database (SQL Server)

0

Like

If you have worked with multiple instances of a database, there is a high chance that you have faced issues with constraints default names. You generated the script for tables/schema changes and try to run on another instance of that database, where some constraint is being dropped from a table, and you get error message. ...Read more
Posted by: Muhammad Idrees
On 11 Jun 2018 | Views: 9 | Categories: Tips & Tricks, 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: 150 | 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: 173 | 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: 138 | 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: 145 | 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: 127 | 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: 176 | 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: 145 | 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: 159 | 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: 221 | Categories: Patterns, Other, Database (SQL Server), ADO.NET
Page 1 of 11
Other lins

.Net Techies
Other lins