7.7. SQL Server Summary

 < Day Day Up > 

This chapter went into some intermediate-level topics on SQL Server that you may not already be familiar with. I could write several chapters on the topics covered, but I just wanted to introduce them in this chapter. If you type in the examples as shown, you can see how they work. I find that by following examples and tweaking code, I learn a lot about how things work. I encourage you to follow these examples, and I strongly suggest that you test everything in Pubs or Northwind before trying it on a production database if you are not completely familiar with SQL Server.

If you are already familiar with SQL Server, I hope that the topics on DTS introduced you to some additional functionality. When I work with clients using SQL Server, I find that very few take advantage of the ActiveX script tasks, Email tasks, and scheduling functionality, except in the case of administrative tasks. There are so many ways to use the scheduling tool that I even use it when it doesn't involve SQL Server. You can create connections to Access databases with DTS and drop and create tables on a daily basis for different types of reporting, even if none of the data is on SQL Server. In addition, you can find a lot of good examples in the SQL Server Books Online if you get stumped trying to figure something out.

It is going to be increasingly difficult to ignore SQL Server and other enterprise databases as these databases are used at more companies. Even though it is unlikely that you want or need to become an expert in SQL Server, just understanding the basics will be very helpful. I encourage you to look at the online resources offered by Microsoft, O'Reilly, and other user groups to gain additional knowledge. For the most part, when you use SQL Server, you will work with a database that is already created, and you may not be in an administrative role. This differs from typical Excel and Access practice, but your Access and Excel skills will be relevant to processing information you've extracted from SQL Server.

     < Day Day Up > 


    Integrating Excel and Access
    Integrating Excel and Access
    ISBN: 0596009739
    EAN: 2147483647
    Year: 2005
    Pages: 132

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net