CBT Nuggets: Exam-Pack 70-431: SQL Server 2005 Implementation and Maintenance

Exam-Pack 70-431: SQL Server 2005 Implementation and Maintenance
Exam 70-431 for MCTS Certification

SQL Server 2005 has been tweaked drastically to make your life as a Database Administrator (DBA) or Developer easier.

While much of the core functionality has been carried over from previous versions of SQL Server, many of the rules of play have changed:

• SQL Server 2005 makes your life as a DBA or Developer easier because it combines good productivity features, easy to use new tools, and a more powerful than ever database engine.
• Now DBAs and Developers can work together more easily--the tools for each job have been integrated and simplified inside the new SQL Server Management Studio.
• SQL Server 2005 is faster than all previous versions--it broke the 1,000,000 transactions per minute milestone, which means it can now compete with the major players in the enterprise database market.

With this new version, there's a lot to learn.

In this series, instructor Garth Schulte shows you what's new, what's different, and what's useful. As you go through and watch each video, you learn not only the features that SQL Server 2005 has, but what they do and--most importantly--how to use them. Plus you'll be preparing for MCTS certification exam 70-431 at the same time.

Here's what you'll learn to do with SQL 2005:

• Install SQL Server 2005--even upgrade with minimal downtime--then configure your installation for your database needs. (Video 2)
• Secure your installation of SQL Server 2005--understand the security architecture of SQL Server (covering schemas, principals, securables, and permissions), how to manage security, and how to manage the context in which commands execute. (Video 3)
• Be prepared when disaster strikes by implementing disaster recovery--learn which backup types, recovery models, and restores work for different situations, and how to choose and implement the one for you. (Video 4)
• Monitor and audit performance and activity on your SQL Server, using System Monitor, SQL Server Profiler, SQL Server Management Studio, DDL Triggers, and Event Notifications. (Video 5)
• Keep SQL Server up and running for high availability using Failover Clustering, Database Mirroring, or Log Shipping solutions. (Video 6)
• Copy data easily from one SQL Server to another using snapshot, transactional, or merge replication--and understand why you'd use each one. (Video 7)
• Automate tasks with SQL Server Agent so you can kick back, sip a cool drink, and get paid to do so--okay, so that may be overkill, but automating boring, common database tasks can make your life a lot easier. (Video 8)
• Put data in, pull data out, and change data in your database using the Transact-SQL (TSQL) language--beyond knowing what commands do what, you'll understand the syntax of the language so you can do much more with TSQL than we could ever teach you in the video. (Video 9)
• Where's the action at in any database platform? The database. Learn how to create, manage, and maintain both simple and advanced databases in SQL Server. (Video 10)
• Tables are where your database stores all your data--design and create tables in your database that are easy to use and offer you quick access to the data when you need it. (Video 11)
• Speed up data retrieval in your database using indexes--including what indexes are, what types are available, which one is right for your needs, and how to use indexes to make your database easily searchable. (Video 12)
• Create virtual tables, or views, that combine data from multiple sources for easy access--including standard, index, and partition views--then modify data through the views when needed. (Video 13)
• Execute complex database tasks with minimal work using stored procedures--pretty much anything a program could do, a stored procedure can do too. (Video 14)
• Interact with your database using custom functions--when Microsoft created SQL Server they couldn't predict everything you'd need it to do, so they gave you the power to add your own functionality. (Video 15)
• XML is universally supported, easy to read, can store lots of data, and now interfaces easily with SQL Server. Learn how to work with XML data in SQL Server 2005. (Video 16)
• Create programs that interact directly with your database by integrating the .NET framework with SQL Server 2005--giving you more freedom and flexibility plus more data manipulation power. (Video 17)
• Design and use "notification applications" to send messages to users when trigger events occur--think daily weather updates, live sports statistics, stock tickers, or any other data-driven event you can imagine. (Video 18)
• Build and automate data integration and workflow solutions with SQL Server Integration Services--which really means making tough tasks easy by automating your more difficult computing and data manipulation tasks. (Video 19)
• Compile and present reports based on the data in your database, making it easy for businesses and customers to get the information they need access to on a regular basis. (Video 20)

CBT Nuggets: Exam-Pack 70-431: SQL Server 2005 Part 1
CBT Nuggets: Exam-Pack 70-431: SQL Server 2005 Part 2
CBT Nuggets: Exam-Pack 70-431: SQL Server 2005 Part 3
CBT Nuggets: Exam-Pack 70-431: SQL Server 2005 Part 4
CBT Nuggets: Exam-Pack 70-431: SQL Server 2005 Part 5

Foxit Reader Pro 2.2.2129

Foxit Reader is PDF document viewer and printer, with incredible small size (only 2.1 M download size), breezing-fast launch speed and rich feature set. Foxit Reader supports Windows 98/Me/2000/XP/2003/Vista. Its core function is compatible with PDF Standard 1.7.

In the past, you've had to download a huge PDF reader from another software company, go through a lengthy installation process and wait for an annoying splash window to disappear just to open a PDF document. Moreover, if you want to annotate a PDF document, you have to pay US$299 to buy certain software.

Now with Foxit Reader, you don't have to endure such pain any more. The following is a list of compelling advantages of Foxit Reader:

* Incredibly small: The download size of Foxit Reader is only 2.1 M which is a fraction of Acrobat Reader 20 M size.
* Breezing-fast: When you run Foxit Reader, it launches instantly without any delay. You are not forced to view an annoying splash window displaying company logo, author names, etc.
* Annotation tool: Have you ever wished to annotate (or comment on) a PDF document when you are reading it? Foxit Reader allows you to draw graphics, highlight text, type text and make notes on a PDF document and then print out or save the annotated document.
* Text converter: You may convert the whole PDF document into a simple text file.
* High security and privacy: Foxit Reader highly respects the security and privacy of users and will never connect to the Internet without users' permission. While other PDF readers often silently connect to the Internet in the background. Foxit PDF Reader does not contain any spyware.

New features in version 2.2

* Capture words via mouse
If you are using a dictionary software, you may want to use your mouse to capture words inside a PDF file and has it translated. You can turn on this feature by checking ¡°Screen word-capturing¡± option under ¡°Edit¡±>¡±Preference¡±>¡±General¡±.

* Search PDF in another way
Now you can search a string either in a single PDF file or in multiple PDF files under a specified folder. When the search finishes, all occurrences will be listed in a tree view, allowing you to quickly preview the contexts and jump to specific locations.

* Minimize Foxit Reader to the system tray
You now can save space on your task bar by minimizing the Foxit Reader to system tray. This feature can be turned on by checking ¡°Minimize to system tray¡± option under ¡°Edit ¡°>¡±Preference¡±>¡±General¡±.

* Work with friendly bookmarks
Now when you navigate through the PDF document, the highlighted bookmark item will automatically be kept in sync with the current page being displayed. And you can click on a handle to hide or show the bookmark panel.

* Remove all evaluation marks at once
For trial users, Foxit Reader will stamp evaluation marks on edited pages. After they purchase and install licenses, they can choose ¡°Help¡±>¡±Remove Evaluation Marks¡± to remove all the evaluation marks on this file at once.

* View PDF page size
Now the actual size of each PDF page is displayed on the status bar.

* Select text easily
Now, when you click and drag your mouse to select some text, you can keep moving your mouse and Foxit Reader will scroll automatically. This will allow you to select text out of current view. Version 2.2 also fixes some bugs of the text selection tool in the previous version.

* Enjoy other improved features
You will enjoy many other improved features, including:
Well-organized toolbars
Better command line support
Enhanced support for eastern Asian languages

* Many bug fixes

Download Foxit Reader Pro 2.2.2129 with Addon

Pro SQL Server 2008 Relational Database Design

Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to “get it right” in SQL Server database design and lay a solid groundwork for the future use of valuable business data.

Solid foundation in best practices and relational theory
Maximize SQL Server features to enhance security, performance, scalability
Thorough treatment from conceptual design to an effective, physical implementation


What you’ll learn

• Develop conceptual models of client data using interviews and client documentation.
• Normalize data models to enhance scalability and the long term use of valuable data.
• Translate conceptual models into high–performing SQL Server databases.
• Secure and protect the integrity of data as part of meeting regulatory requirements.
• Take full advantage of new SQL Server features such as the spatial datatype, XML support, transparent data encryption, and more.
• Create effective indexing to speed query performance.

Download Pro SQL Server 2008 Relational Database Design and Implementation

Lemonade Tycoon 2

Selling lemonade isn't just for kids anymore! Now you can storm the streets of New York City - from the Bronx to Time Square - building your lemonade empire!

Lemonade Tycoon 2 offers more features, more chances to make money, and yet all the same fun as the original. Now you can run more than 1 lemonade stand at once, either in the same district or in multiple areas targeting different income classes.

Another awesome feature of Lemonade Tycoon 2 is immediate and specific customer response to your lemonade.

Price too high? They'll tell you. Not enough lemons? You can find that out too. This lets you hone in on exactly the problem with your business, letting you make the necessary adjustments to achieve greater success.

Other amazing updates in the new game include:

• New equipment upgrades so you can hone your business for great profit
• 19 different locations to set up a lemonade stand
• Upgradeable sales staff so you can have the very best!

Full Version Features

• Unlimited play on up to 5 computers - you own the game!
• Instant activation so you can play right away with no additional downloads required if you have the trial installed!
• No shipping, waiting or CD-ROM necessary.
• 48-hour money back guarantee
• Unlimited play - you own the game!
• Instant activation
• No additional downloads
• No shipping, waiting or CD-ROM necessary

Download Lemonade Tycoon 2 FULL

SmartDraw 2009

12 Great Reasons to Upgrade to SmartDraw 2009.
Even if you own SmartDraw 2008!

Save time, manage more effectively and go home earlier.
SmartDraw 2008 made it incredibly easy to create flowcharts, org charts and other diagrams by drawing for you. SmartDraw 2009 takes this automation even further saving you even more time.

1.Smarter Flowcharts
Create flowcharts in minutes to define your processes and improve your operations.
With SmartDraw 2009, you can create flowcharts that branch with a simple click, plus other improvements.

2.Smarter Project Charts
Get your projects done on time with SmartDraw 2009's new project management features.
More than six major improvements including:

* Dependency
Make one task start when another ends. Change the end date of the first task and the start date of the second changes automatically.
* Groups of tasks
Tasks can also be grouped hierarchically so that the length of the parent task reflects the length of all the child tasks.
* Milestones
Add a milestone with a single click.
* Automatic Chart Sizing
As tasks are added and removed, the chart grows and shrinks to accommodate the new date range.

3. Smarter Mind Maps
Organize your ideas with a mind map. Now with automatic styling for better readability, export to outline format, hide and reveal detail, and of course automatic conversion into a project chart.

4. Smarter Organization Charts
Organize your people with org charts and team charts. Now hide and reveal any branch with a single click.

5. Smarter Timelines
Now timelines draw for you too. Simply click to add an event, change the format of your timeline from days to months to years on the fly.

Continue on SmartDraw Homepage

Download SmartDraw 2009 with KeyGen

Internet Download Accelerator 5.6.1.1133

Internet Download Accelerator lets you to noticeably increase the speed of file download from the Internet using HTTP, HTTPS and FTP protocols. The acceleration is achieved by splitting a file being downloaded into several parts and downloading these parts at the same time. Internet Download Accelerator resumes broken downloads from where they left off from both HTTP, HTTPS and FTP servers.
To increase usability Internet Download Accelerator integrates with Internet Explorer, Firefox, Mozilla, Opera, Nescape and others, replacing the standard download modules. Morover, the program monitors the system clipboard and detects URLs in the clipboard. Whatever your connection type, Internet Download Accelerator will use the bandwidth of your connection most effectively and download files extremely fast.
Power and useful tool for management of download categories. Possiblity of automatic file type detection with automatic file placement to the specified categories. Unlimited number of categories and hierarchy levels. With the site manager, you can automatically pass a user name and password to a server and specify a folder for saving files downloaded from a certain site. IDA also features import and export of the download list. International users are provided with multi-language interface option.

The program also contains:
- FTP Explorer;
- site manager for password and download folders management;
- scheduler;
- download speed control, automatic mode for the most comfortable browsing on the Web;
- dial for dial-up connection;
- search for files, programs, games, and music;
- IDA Bar - a toolbar for Internet Explorer.

Download with KeyGen (5 MB)

DreamCalc DCP v4.4.1 Pro Calculator Portable

DreamCalc is the leading Scientific Graphing Calculator for Windows that’s so realistic it dispenses with the need for a physical hand-held altogether!

• It Feels Real! Get the intuitive feel and productivity of a real calculator. No more hunting around for your hand-held!
• Graph functions & plot data in seconds.
• Fully featured range of math, scientific, statistical & financial functions. Supports natural fractions, complex numbers, base-n logic, unit conversions and a powerful polynomial solver. Over 260 functions!
• Select from algebraic input or RPN. DreamCalc adapts to your way of working!
• With the optional ability to run in your Windows system tray–DreamCalc will always be there whenever you find yourself reaching for a calculator.

Download DreamCalc DCP v4.4.1 Pro Calculator Portable

Flycryptor 2.0

Keep Your Files in a Secure Locker

Protect your files, folders and removable drives on-the-fly with secure password. Get instant access to protected data, lock and unlock folders with a hot-key. FlyCryptor creates protected folders that are like a password-protected archive - only they don't need an archiver!

Feature List

• Password-protect files, folders and entire removable drives
• Encrypts files, folders and entire removable drives
• Transparent operation: files and folders are encrypted on-the-fly when sent into a protected folder
• Access individual files or entire folder with a single password
• Protect files, folders or USB drives of any size with no volume constraints
• Strong encryption ensures complete security
• Taking out a protected removable drive automatically locks its content
• Configure your folders to lock automatically on a time-out for added protection
• Emergency Lock makes it possible to lock all protected folders with a single hot-key
• Password-protect FlyCryptor for yet another layer of security
• Accessing FlyCryptor-protected USB drive on a public computer does not require FlyCryptor installation

Download Flycryptor 2.0 FULL

File Recovery 7.0

Designed for Windows® 2000, XP Pro, XP Home, Vista™ Basic and Vista™ Ultimate (32-bit)
File Recover's rapid scan engine can detect recoverable files within minutes.

File Recover allows you to recover critically important documents, or other files, which have been lost by accidental deletion. These files may be lost by emptying the Recycle Bin, or using other deletion actions that bypass the Recycle Bin altogether. Such actions include Windows® Shift-Delete, command line deletion, deleting excessively large files or using applications that delete files without the Recycle Bin.

When a file is deleted from the Recycle Bin, or if the recycle bin is bypassed altogether, the file can no longer be recovered by the Windows® Operating system. The content of the file still remains on the drive, relatively intact, until the section of the drive it occupies is overwritten by another file.

File Recover identifies the contents of such lost files on the hard drive and allows you to recover them. If a file has been partially overwritten, File Recover attempts to reconstruct as much of the file as possible with the remaining contents. This allows you to salvage at least part, if not all, of that recovered file to continue using it as required.

Download File Recovery 7.0 FULL with Addon

Be Rich

Take charge of Be Rich Inc. where you are CEO to the hottest new real estate firm in the country. Build housing for undeveloped zones, provide your tenants with shopping and maintenance services, decorate greenways, builds stadiums, it`s all at your fingertips. If you can raise capital, you can turn the neighborhood of your dreams into a reality. Act now before your profit margin slips away!

• Fast, intuitive game play.
• Manage company resources.
• A nation-wide empire awaits.

System Requirements:
OS: Windows XP/Vista
CPU: 800 Mhz
RAM: 512 MB
DirectX: 8.0
Hard Drive: 86 MB

Download Be Rich FULL