Installation Issues

On my desktop(Win7) I had originally installed SQL 2008 using SQL Auth mode with a newly created user. Well later when creating some sample databases in a unique Win directory I kept running into Windows permissions errors. Even after creating a new Windows users to match my SQL user name I was still getting permission errors. Pain in the rear because the SQL errors are hard to decipher. So I tried to find a way around this,  just  switch to using WinAuth but I couldnt get it to ever work. So I eventually wound up just re-installing SQL 2008 after having to manually going thru and uninstalling about 10 SQL programs. There were issues when I got to the ServerConfig option where you specify a username for each SQL service, ugh. Like be sure you know what your doing here! In later releases MS seems to fill in a default different username for each SQL service but in 2008 these fields are blank. Finally got around it and the issues resulting from this.

During this time I also installed SQL 2012 on my laptop(win8). Which for the most part went smooth then I realized the next day I had installed while being logged in on a non-admin account. I had given permissions during installation but the next day when logging in via SSMS the WinAuth was trying to use my non-admin user and for some reason SSMS has the userName boxed greyed out during login, why is that? Also the SQL Browser service was in the “Disabled” state, ugh again.

What is sort of strange to me is just trying to do a default installation I felt would be a lot more simpler and error-free. As of this moment everything appears to be working but I am sure there are a ton more “gotchas” waiting to be discovered.

Posted in The Journey | Leave a comment

Exam 70-432

Learning Plan for Implementing and Maintaining Microsoft SQL Server 2008 (Exam 70-432)

This learning plan is intended to help IT professionals and developers gain the knowledge and skills required to implement and maintain Microsoft SQL Server 2008, and ultimately to prepare for Microsoft exam 70-432.

Step 1 – Features and Tools Overview (SQL Server 2008)
This TechNet guide contains content on the variety of Microsoft SQL Server features and tools that you can use to develop and manage your databases and solutions.

Step 2 – Collection 6187: What’s New in Microsoft SQL Server 2008
In this 3 hour on-line collection, IT Professionals will learn about the new features in SQL Server 2008.

Step 3 – Course 6231A: Maintaining a Microsoft SQL Server 2008 Database
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

Step 4 – Course 6232B: Implementing a Microsoft SQL Server 2008 R2 Database
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to implementing a database.

Step 5 – Collection 6369: Implementing and Maintaining Microsoft SQL Server 2008
This 16-hour collection provides you with the skills and knowledge required for implementing and maintaining Microsoft SQL Server 2008.

Topics covered in this course include:
– Installing and Configuring SQL Server 2008
– Creating and Managing Databases
– Planning, Creating, and Optimizing Indexes
– Backing Up and Restoring Databases
– Managing Security
– Automating Administrative Tasks
– Monitoring and Controlling Resources
– Implementing High Availability and Replication

Step 6 – Course 2778A: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This three-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

Step 7 – MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 – Implementation and Maintenance
This 2-in-1 kit delivers in-depth preparation plus practice MCTS Exam 70-432, SQL Server 2008—Implementation and Maintenance. Ace your exam prep—and build real-world job skills—with lessons, labs, practice tests, and more.

Step 8 – SQL Server 2008 Books Online
This SQL Server TechCenter resource contains content on the following topics:
– Database Engine
– Analysis Services—Multidimensional Data
– Analysis Services—Data Mining
– Integration Services
– Replication
– Reporting Services
– SQL Server Service Broker

Step 9 – TechNet Webcast: 24 Hours of SQL Server 2008
This series of 90-minute webcasts explores the features of SQL Server 2008. Learn how to:
– Manage, monitor, secure, and optimize consolidated data systems
– Consolidate servers with multiple databases
– Consolidate data services through virtualization
– Migrate databases
– Build a scalable infrastructure that manages reports and analysis and eases data access

Step 10 – Preparation Guide for Exam 70-432
This certification exam measures your ability to implement and maintain Microsoft SQL Server 2008 installations.

Step 11 – Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance
Register now to take Exam 70-432.

Posted in Exam 70-432 | Leave a comment

Where to Start

SQL Server is a massive product so the learning curve will be steep and a life long process to stay current. To tackle my initial goal of passing the MS exams I will need to first decide how best to proceed to get a good foundation and minimize at least becoming quagmired in all the available SQL Server information.

One initial area of confusion was the Microsoft Learning site. There are 2 different “MyLearning” areas one here and the other under the MS Virtual Academy-MyDashboard. They both help with organizing your resources needed for a course, exam, subject area. Though the MVA courses are more focused on the newest features in the latest (SQL 2014) version.

Having viewed an on  going survey showing that 80% of SQL shops still have SQL Server 2008 in production I am surprised MS is retiring 2 SQL Server 2008 exams at the end of July this year. I was thinking this was the version to focus on. I may still try to at least get the MCITP: DBA cert and time permitting the MCITP: DB Developer one for 2008.

A few of the first things that come to mind are 1) in order to blog this journey I will be updating my html skills for improved text formatting. The default text formatting here on WordPress is bloated and the uploaded Word documents are coming out mangled. Since XML documents can be stored in SQL and perhaps read(?) by SQL it may come in handy down the road. 2) I will need to brush up on the SQL syntax & commands 3) become familiar with using the SSMS 4) map out then perform a divide and conquer on the SQL components 5) design a database environment to use while learning SQL Server. As well as using the AdventureWorks or NorthWind databases. Current ideas are to monitor and build a list similar to the IBD stock components based on a few different criteria, along with storing TickerMonkey chat logs in order to do full text searches. 6) identifying the relevant resources materials for where I am at in this process.

One place I will be looking at is the blog “How To Learn SQL Server Online


Posted in Uncategorized, Where to Start | Leave a comment

Exam 98-364

Learning Plan for Database Administration Fundamentals (Exam 98-364)

– Understand core database concepts (DML, DDL, and RDBMS)
– Create database objects (TSQL, data types, tables, and views)
– Manipulate data (SELECT queries, update and delete data)
– Understand data storage
– Administer a database (security, backup, and restore)

This learning plan also helps students prepare for Microsoft exam 98-364 – Database Administration Fundamentals. By passing exam 98-364, candidates earn the Microsoft Technology Associate (MTA) certification.

Step 1 – Video Series: SQL Server 2005 Express Edition for Beginners
This video series includes almost 9 hours of video-based instruction that walks SQL Server beginners through the steps of learning about SQL Server databases to actually connecting a SQL Server database to a Web application.

Step 2 – Beginning Developer Learning Center: Windows Development Tier Three
In Tier Three of the Absolute Beginner’s Series for Windows Development you learn how to work with data in a database, connect that data to your user interface, work with XML, manage potential errors using exceptions, and step through two different sample applications to really see what makes things work.

Step 3 – SQL Server Samples and Starter Kits
These Samples and Starter Kits are fully functional sample applications. Each sample is complete and well-documented so that you can get started right away.

Step 4 – SQL Server 2008 Books Online (March 2009): Administration (Database Engine)
This section of Books Online provides information to help you get the best performance out of your database system and to protect your data against hardware failure or natural disaster. Topics include:

– Managing Servers
– DDL Triggers
– Logon Triggers
– Connecting to the SQL Server Database Engine
– Managing the Database Engine Services
– Managing Transaction Logs
– Backing Up and Restoring Databases in SQL Server
– Rebuilding System Databases
– Importing and Exporting Bulk Data
– Copying Databases to Other Servers
– Administering Servers by Using Policy-Based Management
– Administering Multiple Servers Using Central Management Servers

Step 5 – Collection 2778: Querying and Modifying Data in Microsoft SQL Server 2008 with Transact-SQL
This collection of nine two-hour courses provides database developers and administrators with the knowledge and skills to query and modify data in Microsoft SQL Server 2008 by using Transact-SQL.

Step 6 – Course 6231B: Maintaining a Microsoft SQL Server 2008 R2 Database
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database

Step 7 – Exam 98-364: Database Fundamentals
Register now to take Exam 98-364.

Posted in Certifications, Exam 98-364, SQL 2008, SQL 2012 | Leave a comment