Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Tuesday, July 7, 2015

key Impact on Database Size.

Hi All,

I am not sure about the article that i am writing that i Should Write it or not. The area that i am about to discuss is something where i am a newbie and would like to explore the area.

The Reason behind article was something asking a query about database size based on keys.

In this article we will see by a small demo how much the database size get increased based on No. of Keys that we have in one table.

Wednesday, July 17, 2013

Impact of User Roles in SQL in NAVISION.

Hi all,

I was thinking about this post form a long time. It's about roles assigned to user in SQL.

Let's see how these roles effect us in Navision.

Thursday, January 24, 2013

SQL Maintenance Plan with Database Mail.

Hi all,

As discussed in last two post about

1) How to Configure Database Mail in SQL Server.
2) How to create operator in SQL?

Let's see the uses of last post in this post, by creating a simple maintenance plan for taking automatic Backup from SQL and Notifying the administrator about success or failure of the Job performed by Maintenance Plan.

There are many Default maintenance Task available in SQL, but for demo we will be using Complete Backup Maintenance Task.

Wednesday, January 23, 2013

How to create operator in SQL?

Hi all,

I hope everyone is great. As discussed in last post, lets have a look on how to add operators in SQL.

Use of Operator -

The operator is used in SQL Management Plans and Jobs to send mail in case of Success or Failure of Jobs.
We will discuss how to create jobs and SQL Maintenance Plans in a separate post.

As of now let's stick to agenda and discuss how to create the operator.

Monday, January 21, 2013

How to Configure Database Mail in SQL Server.

Hi all,

Let's see how to configure Database Mail in SQL Server. we will see use of same in future post.

Open SQL Server Management Studio.

Open Management and Right Click Database Mail as shown below.

Wednesday, June 6, 2012

Restore a Database In SQL Server Managment Studio.

Hi all,

Most of us are aware with Navision Backup but at the same time unaware of SQL Server Backup. So lets discuss how to restore a SQL Database backup.

Let see the steps how to restore a SQL Server Database Backup.

Friday, February 3, 2012

Copy Navision Data Between Databases using SQL Server

Hi all,

Microsoft SQL Server has an import and export wizard that assists you in copying Navision data from one database to another. This import and export wizard is available in any version of SQL Server, and it lets you copy tables, data, functions and other database objects. This is beneficial when you want to move your Navision data to a faster server for better querying performance.

Friday, November 4, 2011

Configure SQL Server Agent Mail to Use SQL Mail.

Hi all,

This topic describes how to use SQL Server Management Studio to set up SQL Server Agent Mail to use SQL Mail. Before you can use SQL Mail, you must enable SQL Mail and set up a mail profile. SQL Mail can be enabled by opening the Properties dialog box from the SQL Mail node, by using the Surface Area Configuration facet of Policy-Based Management, or by the using the sp_configure stored procedure.

Wednesday, November 2, 2011

Schedule a database backup operation by using SQL Server Management Studio in SQL Server

To schedule a database backup operation by using SQL Server Management Studio in SQL Server, follow these steps:

1) Start SQL Server Management Studio.

2) In the Connect to Server dialog box, click the appropriate values in the Server type list, in the Server name list, and in the Authentication list.

3) Click Connect.

Thursday, September 8, 2011

Database Backup from SQL Server Managment Studio

Hi all,

Some Client requires to take database backup on daily basis but due to increasing size of data its is tedious and time consuming if we suggest to go for Navision Backup.At this point the best solution to suggest is to take backup from SQL Server.So lets discuss how to take backup of a database from SQL Server Managment Studio.

For taking Backup from SQL Server there are certain steps -