Monitoring your SQL Server Your mission is to detect and eliminate performance bottlenecks. Run a health check and get the most out of your SQL 2000 servers. One of the most satisfying feelings is improving performance by finding bottlenecks on your network. As a side effect you will learn how …
Understanding SQL’s security and permissions is not a trivial task. Many of your choices come in pairs, firstly there are two overall strategies or approaches: a) Develop and refine your vision of who should see what information. b) Check all the places where you can set security and permissions in …
Make it your goal to automate boring, repetitive tasks. I would always choose a morning of to automate followed by and afternoon testing, rather than spending the whole day doing the same monotonous chore. SQL Server 2000 provides a separate SQL Server Agent Service to handle Jobs and Alerts. The …
SQL Transact UPDATE Statement One you have mastered SELECT, its time to turn your attention to SQL’s UPDATE statements. Lesson 1 – UPDATE .. SET The scenario: You prices must rise! You need to increase prices in line with inflation, you have held down the price for two years, but …
SQL Transact – Northwind Database Northwind is free. With SQL server, Microsoft has provided THE most marvellous and comprehensive database. Another benefit of Northwind is that once SQL is installed, then you have a copy of Northwind and so you can try my examples. Once you have finished installing SQL, …
SQL Transact – Getting Started with the Query Analyser. Once you have installed SQL server you may begin querying the databases with the Query Analyser. To get started, click on the Start Menu, Programs, Microsoft SQL Server, then click on Query Analyser. Next, I would select the radio button ‘Connect …
Installing Microsoft’s SQL 2000 server is a pretty simple job. However any installation of a database needs a few minutes to plan; the old saying that 7 minutes of planning saves an hour of rework is never more true than with an installation. The most important part is the post-installation …
SQL Transact Comments Good comments show the purpose of your SQL transact query. They explain the actions that statement will perform. SQL supports two methods to block or ‘Rem’ out transact statements. 1) Block Comments /* …. */ As the name suggests these comment are when you have a paragraph, …
Microsoft now call OLAP – Analysis services. Another term for this feature is data warehousing. Recent research show that interest in OLAP or Analysis Service is the fastest growing area of SQL 2000. To see this feature you need to re-run Install and select options, Install Analysis Services. The …
What ever your job, I always think it an advantage to take the time to understand how things work ‘under the covers’. I recommend that even if your job is just to administer SQL server that you learn a few transact statements, and delve into how data is stored. This …