<

Basic Housekeeping for SQL Server

Posted on
4,334 Points
1,134 Views
2 Endorsements
Last Modified:
Published
Experience Level: Beginner
5:10
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
2
Author:Steve Wales
0 Comments
Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways. For this article, I'm going to demonstrate some of the popular ways of importing Excel data into MS SQL Server.
One of the most common issues faced while connecting to a SQL Server instance is "Login failed for user 'username'. (Microsoft SQL Server, Error: 18456)". In addition to the Error No. SQL Server will provide an Error State no. which will be helpful…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month