<

Basic Housekeeping for SQL Server

Posted on
4,644 Points
1,444 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
The Get & Transform Data Wizard in Excel is a powerful tool. It allows the users to extract the data from the connected sources. But by delegating the privilege to users to access the connected sources, how could we ensure there is at least some deg…
After looking into a question at EE, a thought came to my mind that I considered would make a good article. "Transform Text copied from Excel Table into Real Table in SQL" as it is totally possible to do. Here's the result.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month