Level 100

15 posts

All posts that are entry level or level 100 videos explaining/demonstrating simple concepts.

Windows 8 Development – XAML Design Tools Part 2

In our last video, we went over the basics of using Visual Studio design tools, and layout concepts. Now, we will explore the Visual Studio environment, and go over how to set up your workspace, as well as how to change a control from the default static layout type to a fluid layout. In this video, I will show you how to change the layout of the Visual Studio workspace, and how to reset a control's properties. References XAML Navigation, Layout, Views – http://msdn.microsoft.com/en-us/library/windows/apps/jj215600.aspx

MS SQL Server Profiler Basics, Part 3 of 3

In this video we explore how to create a server side trace using the inbuilt stored procedures available within MS SQL Server. We explore how to make this job easy by creating a trace template using the profiler tool and then implementing this within SQL Server. We will also explore how to get the details on which traces are running on a server as well as how to query data from within a trace file.

MS SQL Server Profiler Basics, Part 2 of 3

This video discusses some of the templates that are found in SQL Server profiler and how to use them in relation with other features available in MS SQL Server. We will explore using templates, creating a template and then exporting the TSQL command from within the trace.

MS SQL Server Profiler Basics, Part 1 of 3

This introduction serves as a starting point to working with SQL server profiler and how to configure a trace file and monitor events that happen on a specific database using column filters and additional events. Every DBA is expected to know how to configure and use MS SQL Server profiler and what scenarios to use it in so video is meant to serve as a starting point to understanding profiler.

Installing MySQL On a Developer Machine

While Visual Studio does come with a working version of Microsoft SQL Server for development use, it is sometimes necessary to implement another database solution. MySQL is arguably the most popular alternative relational database solution, and has brought the power of database-driven software development for no cost. While the windows installers are less complex than compiling MySQL from source on a Linux system, there are still some details to keep in mind. In this video, I will show you how to install MySQL Server, MySQL Workbench as your administration tool, and how to run a simple query.

Installing SQL Server 2008 Management Studio

SQL Server Express is installed by default along with Visual Studio, which saves developers a lot of time in choosing an appropriate relational database platform. It also exposes most of the concepts one will find in comparable products, and for using a Structured Query Language in general. This means that developers do not have to re-learn fundamental concepts when switching to other technologies such as Oracle and MySQL. There is, however, one thing that is missing by default, and that is a administration option using a graphical tool that most DBA's are familiar with. This can lead to frustrating debugging sessions and more. In this video, I will show you where to get the SQL Server 2008 Management Studio installer, and how to navigate a somewhat unintuitive installation process. From there, I will show you how to view and edit data contained in one of the tables.

How to Restore a Database Backup, Part 2 of 4

The video is aimed at the novice DBA and will get more and more detailed as we progress through the series. The next series in the video will cover how to take differential backups and restore them. Each video will build on top of previous videos to comprehensively cover the backup and restore options available within MS SQL Server.

Understanding Database Backups in MS SQL Server 2008 R2, Part 1 of 4

The video is the first of a series of videos on MS SQL Server backup and restore technologies and covers many aspects that need to be considered as part of implementing a successful disaster recovery plan.

How to write an Accelerator for Internet Explorer

I've always used IE accelerators for easy access. Translate and Bing search are some of the most commonly used accelerators for Internet Explorer when it comes to text selection. It saves the amount of time it takes to either open a new tab or use the current tab in addition to actually typing your search text. While I enjoy some of the default accelerators that come with IE, I wanted to quickly write one of my own to search for things instantly on Google's Play Store. Today let's look at how we can achieve that with a bit of XML code.

Windows 8 User Interface Overview

This video demonstrates the new user interface and the app tiles in Windows 8. It also shows a few basics of how to make life easier using Windows 8 and power options. Windows installed by the default options will choose the Balanced power plan which will not give you the best output from your processor. Selecting a High performance powerplan in the background will also allow your processor to use more power and be more efficient.

Installing System Center Virtual Manager

Watch how to install the System Center Virtual Machine Manager software on a Windows Server 2003 system. The video demonstrates step by step the required information and talks about the details of each page in the setup wizard. Also provides details on how to set up your library server and other settings.

How to capture screen with Expression Encoder

Expression Encoder is an audio/video editing and mastering tool that can also be used to capture screen movies from your computer. TechyTube uses Encoder's builtin Screen capture tool to record the screen videos that you see on the site. Watch this video to learn how you can record screen actions with audio and publish them to web in WMV format.