.NET Code Catto Blogger Blog

Catto’s in Top 20 Windows Phone 7 Developer List

noreply@blogger.com (Catto) — Wed, 16 Mar 2011 10:11:00 +0000

Catto’s in Top 20 Windows Phone 7 Developer List

Hey Now,

The is a new Info Graph that I saw from the WP7 AppHub that lists many facts about the new MarketPlace where we go for Windows Phone 7 apps. Also my friend from Florida Russ Toolshed Network Inc is listed too. It’s been a ton of fun to develop the apps for WP7 and I plan to continue since I many more ideas that I would like to developed into apps. Check it out:

That is all there will be more;

Catto

Catto’s Interview on Cloud Plumbing Podcast by Ryan Parsley a TekTalkshow

noreply@blogger.com (Catto) — Wed, 16 Mar 2011 09:46:00 +0000

Catto’s Cloud Plumbing Podcast Interview by Ryan Parsley

Hey Now,

I’m very pleased to announce that last week I was asked to be on the Cloud Plumbing Podcast an internet technical talk show hosted by Ryan Parsley. I’ve been a BIG fan of Cloud Plumbing since I first heard the show sponsored by Linxster. Podcasts & tek talk shows have been very enjoyable to listed to me while I work since it’s a great way to learn about technology. This episode is ~15 minutes and you can check it out:

Chris Catto’s Cloud Plumbing Interview

I’ve meet Ryan though .NET community events who is a graphic designer for Linxter. Linxter is a very successful cloud messaging company local in south Florida founded by a brilliant man by the name of Jason Milgram. Jason recently was asked to present about Linxter at the 2011 Microsoft MVP Summit. It’s one of the great success stories how Jason has founded such a good & growing company.

Ryan & I talk about software development from an interesting perspective in the episode. We also discuss Windows Phone 7 and the apps I’ve produced in the marketplace. We also discuss MovieTickets.com, the .NET community and some other area’s where I’m interested in. I’d like to thank Stephanie Helf the Marketing Manager at Linxter for helping organizing the episode along with a BIG thanks again to Ryan for having me on the show!

That is all there will be more;

Catto

Blendin #WP7Dev – #SFCC using Expression Blend 4 building FLA Code Camp App

noreply@blogger.com (Catto) — Fri, 11 Feb 2011 04:38:00 +0000

Hey Now Everybody,

7th Annual South Florida Code Camp is going to be a stellar event. The event is totally free. There are over 800 people registered; over 70 training session to choose from, free food all day & many raffles including giving a XBox 360 Kinnect! Here is the FLA.NET Code Campe home page; along with two twitter tags #SFCC & #FLDEV.

My session this year is ‘Blendin WP7Dev’ where we’ll go use Microsoft Expression Blend 4 & VS10 to build a Windows Phone 7 app & submit it to the marketplace! The app we build is going to be the ‘Florida .NET Code Camp app’! Including a way to obtain information about the 6 code camps around our state.

Here is a picture from last year:

There is also a nice set of video’s on my YouTube channel from a previous year.

The people at the code camp are the best. It’s so fun to meet new people & see many of my old friends. The training sessions are super too. It’s amazing all this cutting edge education is all free. The list of speakers is impressive check it out below including links to their home pages & twitters:

Adam Jorgensen @adam_jorgensen
Adrian Wible @awible
Alex Funkhouser @sherlocktech
Alexander Koval @alexkoval
Bayer White @BayerWhite
Becky Isserman @MossLover
Bill DeLisi
Brandon Berry
Byron Blank
Catto
Chris Eargle @kodefuguru
Chris Love @ChrisLove
chris stewart
Colin Blakey
Dan Sandlin
Dave Noderer @DaveNoderer
Duray Akar @durayakar
Edward Rhodes
Eugene Chuvyrov @eugenechuvyrov
Fritz Francis
Greg Leonardo @gleonardo
Hector Hernandez
Henry Lee
Herve Roggero @hroggero
J.C. Novoa @J_C_Novoa
Jared Freedman
Jason Beres @JasonBeres
Jason Milgram @jmilgram
Jason Rainwater @attachedwpf
Jay Hill @jittery
Joe Healy @devfish
Joe Homnick @smokingjoe
John Dunagan @johndunagan
Jonas Stawski @jstawski
Josef Diago
Karin Kennedy @karin_kennedy
Kathy Malone
Keith Tingle @ktingle
Kevin Wolf @bytemaster
Lindsay Shugerman @lindsay39
Louis Datz @loudatz
Matt Van Horn @mvanhorn
Michael Longin @mlongin
Michael Potts @hmhackmaster
Michael Stark @mstarktv
Mike Suarez @msuarz
Moonis Tahir
Nathan Totten @ntotten
Nikita Polyakov @nikitap
Oleg Sych @olegsych
Page Horton
Perry Kaye
Phillip E. Rosen @BIwPhil
Plamen Ratchev @PlamenRatchev
Rainer Habermann @RainerHabermann
Rajeev Singh @rsingh68
Ray Almonte, PMP @appdevpm
Rey Bango @reybango
Rich Dudley @rj_dudley
Robert Vanderwall
Russell Fustino @russtoolshed
Ryan Morgan @arrownuke
Ryan Parsley @Ryan Parsley
Sam Abraham @wildturtle21
Scott Katarincic
Scott Klein @SQLScott
Seth Juarez @SethJuarez
Shervin Shakibi @shervsherv
Stan Schultes @fstanschultes
Stonly Baptiste @StonlyBaptiste
Timothy P McAliley
Walter V. Williams, Jr.
Wes Dumey
Woody Pewitt @woodyp
Zachary Gramana

Here is some of the XMAL code generated by Expression Blend 4:

        <Style x:Key="btnSFCC2" TargetType="Button">
            <Setter Property="Template">
                <Setter.Value>
                    <ControlTemplate TargetType="Button">
                        <Grid>
                            <Rectangle RadiusY="33" RadiusX="33" Stroke="Black">
                                <Rectangle.Fill>
                                    <LinearGradientBrush EndPoint="0.5,1" StartPoint="0.5,0">
                                        <GradientStop Color="#FF1A24BE" Offset="0"/>
                                        <GradientStop Color="White" Offset="1"/>
                                    </LinearGradientBrush>
                                </Rectangle.Fill>
                            </Rectangle>
                            <ContentPresenter HorizontalAlignment="{TemplateBinding HorizontalContentAlignment}" VerticalAlignment="{TemplateBinding VerticalContentAlignment}" Content="SFCC"/>
                        </Grid>
                    </ControlTemplate>
                </Setter.Value>
            </Setter>
        </Style>

So There we have it; South Florida Code Camp & ‘Blendin WP7Dev’! If you can’t make the camp look for the app on the Windows Phone.

As always all comments welcome. That is all, there will be more,

Catto

2011 .NET Goals (more WP7Dev) & 2010 4th 1/4 recap

noreply@blogger.com (Catto) — Fri, 31 Dec 2010 18:15:00 +0000

Hey Now Everybody,

2011 is right around the corner should be a great year for most. 2010 was great, the past few months I’ve really been focused on WP7 Dev (Windows Phone 7 Development) and that is the reason there haven’t been blog posts the past few months. In 2010 the forth quarter I’ve also spoke a few times recently such as:

1. @FAU Azure Group I presented ‘How I build the Sherstaff Tech’ Windows phone app!

2. @ WPB .NET Meetup Group I presented ‘Windows Phone 7 Dev’

3. @ Devry presented the Sherstaff Tech app quickly after Devfish’s WP7Dev session

All there meetings were so much fun with some great people & technology there. Presenting @ FAU was special for me since that is my Alma mater.

2011 Goals – Events – More WP7Dev

2011 what I’d like to focus on is more WP7Dev; building more apps & improving my most popular apps. I want to continue to work diligently at MovieTickets.com . In January hopefully we’ll have another .NET meetup in WPB maybe on WCF. February will be the notorious South Florida Code Camp. I plan to present a new session called ‘Blendin WP7Dev’ focused on Expresion Blend 4. In the summer during SQL Saturday will be fun with Denali (SQL Server 2011) scheduled for release next year. Then in the fall Swamp coast code camp will be on again. As for content that I plan to study more is WCF RIA services to get data to the phone.

I also plan to release a new profile picture as I have in the past years; this year there is a new image check it out:

That is all there will be more,

Catto

Swamp Coast FLA Code Camp #3- Data Driven .NET Apps Code Crackin #31

noreply@blogger.com (Catto) — Fri, 24 Sep 2010 03:02:00 +0000

Swamp Coast FLA Code Camp
Data Driven .NET Apps Code Crackin #31

Hey Now Everybody,

In this Post:
1 Swamp Coast Overview
2 Data Driven .NET App Session Overview
3 Vid of Session Content
4 List of Speakers (blog & twitter links)
5 Session Resources Links
6 DAL class file Code

1 Swamp Coast Overview
The Swamp Coast Code Camp #3 in SWFla is gonna be another stellar event. This code camp is @ FGCU which provided a nice venue. The best part of code camps is all the people that are there to talk tek with. I”m really looking forward to relaxin with my geek friends & learning a bunch. There are going to be some great sessions there some that I’m looking forward to seeing are mostly in WP7Dev such as:

Design for WP7 – Diane Leeper
Push Notification with Windows Phone 7 Jonas Stawski
WP7 – Tips & Tricks Kevin ‘WolfBytes’ Wolf
WP7 Marketplace, Panel, Install Fest Nikita Polyakov

Special thanks to John Dunagan & all the people who volunteered to make this event possible.

2 Data Driven .NET App Session Overview
This year my session is going to Data Driven .NET Applications. This session will be fun with a ton of content. It’s meant for any skill level, the main concept we’re going to discuss is to have content of apps driven by a data source not just static. There will be a great mix of theory & code. Here is what I plan to discuss:

DB Driven Mindset - Static vs.. Data Drive Apps
DB Dev / T-SQL
Web App ASP.NET
Data Access ADO.NET
WP7 - XML RSS Data Source
(more detailed list below)

3. Vid of Session Details

Here are some details:

DB Driven Mindset - Static vs.. Data Drive Apps
Overview & Advantages of Apps that display content from a data source
DB Dev / T-SQL
Fundamentals to Database Development
Query Window vs.. Design View
Stored Procedures
Advanced T-SQL Topics
Web App ASP.NET
Intro ASP.NET & VS10 as an IDE
.NET Controls
UI – Master Pages & CSS
Debuggin
Data Access
ADO.NET
Web Services
XML / RSS
WP7
WP7 Overview (IDE & Marketplace)
WP7 Catto Free App (my open source WP7 App)
XML RSS Data Sources
Other WP7 Apps on Emulator

4 List of Speakers (blog & twitter links)

There are many great people who are going to be there here is a list of most that I put together along with there twitter:

LIST OF TWEEPS:

Duray Akar @durayakar
Colin Blakey @ Colin Blakey
Jyoti Chawla
Oleg Sych @olegsych
Michael Wells
Jay Hill @jittery
Ken Tucker
John McFetridge
Kathy Malone
Keith Kabza @KeithKabza
Henry Lee
Greg Leonardo @biztalkdev
Christopher Bennage @bennage
Sam Abraham @wildturtle21
Todd Anglin @toddanglin
Jason Beres @jasonberes
Scott Dorman @sdorman
Chris Eargle @kodefuguru
Jason Milgram @jmilgram
Nikita Polyakov @nikitap
Herve Roggero @hroggero
Stan Shultes @fstanschultes
Jonas Stawski @jstawski
Max Trinidad @maxtrinidad
Alex Funkhouser @sherlocktech
Joe Healy @devfish
Joe Hominick @smokingjoe
Adam Jorgensen @adam_jorgensen
Scott Klein @scottklein
Diane Leeper @dianeleeper
Ryan Parsley @RyanParsley

5 Session Resources Links

Here are some other links that my be helpful regarding the content from my session:

SQL2008 Database Dev 70-433 Skills Measured
SQL 2008 DB Dev 70-433 Programming Objects
SQL 2008 DB Dev 70-433 XML Data
SSMS Toughest Program to Install
Microsoft Visual Studio Hotkey Shortcuts
.NET 4 ASP.NET ‘Skills Overview’ 70-515 Exam

6 DAL Class File code

     public class DAL
   {
        private static string ConnectionString
        {
            get
            {
                return ConfigurationManager.ConnectionStrings["100827_wpb5ConnectionString"].ConnectionString;
            }
        }

        public static DataTable ExecuteDataTable(string storedProcedureName, params SqlParameter[] arrParam)
        {
            DataTable dt = new DataTable();
            SqlConnection cn = new SqlConnection(ConnectionString);

            SqlCommand cmd = new SqlCommand(storedProcedureName, cn);
            cmd.CommandType = CommandType.StoredProcedure;


            if (cn.State == ConnectionState.Closed || cn.State == ConnectionState.Broken)
                cn.Open();

            try
            {
                if (arrParam != null)
                {
                    foreach (SqlParameter param in arrParam)
                        cmd.Parameters.Add(param);
                }

                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(dt);
                return dt;
            }
            catch (Exception ex)
            {
                throw new Exception("Error: " + ex.Message);
            }
            finally
            {
                cmd.Dispose();
                cn.Close();
            }
        }

    }

That is all, there will be more,

Catto

WP7 Windows Phone 7 Application Development - Now is the Time - Catto Code Crackin #30

noreply@blogger.com (Catto) — Wed, 01 Sep 2010 01:36:00 +0000

WP7 Windows Phone 7 Application Development Catto Code Crackin #30

Hey Now Everybody,

WP7! Windows Phone 7 App Dev! The place is here & the time is now. We always here ‘Timing is everything’ & right now is the time to develop apps for WP7 ‘DubP7’. The tools are all free, the windows marketplace will accept WP7 apps soon & the phone/device will be available to the public soon. Therefore since we can be in the first group of apps in the marketplace there is a nice potential for generating revenue. All this combined with developing in cutting edge technology including Silverlight, VS10, Blend, XNA are the reasons I’m really enjoying WP7Dev. Here is what I’ve been focusing on including some references & my current project.

1. Developing my App

2. Documenting my Research ‘Catto’s Windows Phone Book’

3. Code ‘WP7 Catto Free App’– Public @ CodePlex

4. Vid of my Catto Free App in Emulator

5. Microsoft Live Training

6. Developer.WindwosPhone.com – MarketPlace Account All ready!

7. Resources

---------------------------------------------------------------------------
---------------------------------------------------------------------------

Here are some details on these items:

1. Developing my App – This is really where I’ve been focusing my time since it’s the most fun for me, most important to producing an app and a great way to learn.

2. Documenting my Research ‘Catto’s Windows Phone Book aka WP7 App Dev Windows Phone Development using Silverlight’’ – I’ve been writing a technical book which currently is very raw and in a rough draft. It’s were I’ve been documenting what I’ve been learning.

3. Code ‘WP7 Catto Free App’ – Public @ CodePlex – I’ve posted my code from my project all public on CodePlex so anyone can download it to view, run & learn from it.

4. Vid of my Catto Free App in Emulator -

5. Microsoft Live Training – Thursday I’m attending a Firestarter event @ the Microsoft Office in Ft. Lauderdale.. This will be really fun & educational with many people there.

6. Developer.WindwosPhone.com – MarketPlace Account All ready! I’ve paid $100 to join the marketplace & I’m all ready to upload my .xap file.

7. Resources – Here are a ton of links that I’ve been learning from:

Developer Windows Phone
Windows Phone Blog
Catto’s WP7 Free App
Windows Phone 7 Panorama & Pivot controls
Windows Phone 7 database
Windows Phone 7 Developer Training Kit at Channel9
Charles Petzold’s Programming Windows Phone 7 eBook
WP7 Listbox
WP7 Twitter Dev #WP7Dev
Design Day Recordings
PicFx
Animated Banner Tutorial 11
Count Me In
Reaction Time
WP7 Guide
Tilt Content Control
WP7 Tutorials
WP7 Forums & Sample Apps
Chris Koenig Working W/ Data
ADO.Guy WP7
More ADO Guy
Github Seven Auth
Unit Testing WP7
Panos
Square dot game
MSDN Library WP7Dev
MSDN Base Controls
App Bar
WP7 Webcam
WP7 Programming Guide MSDN
Custom Transitions
Bing Map WP7
Multi-Touch Manipulation
nRoute Framework
FourSquare for Windows Phone 7
Windows Phone 7 Analogue Clock
BeeHive Game for Windows Phone 7
Phone 7 Action Pack (Windows Phone 7)
XNA Panoramic Menus For Windows Phone 7
OneBusAway for Windows Phone 7
SharePhone
Widows Phoen Developer Blog
Brandon Watson's Blog
Charlie Kindel's Blog
Anand Iyer's Blog
Peter Torr’s Blog
Mike Ormond's Blog
Paul Foster's Blog
Martin Beeby's Blog
Windows Phone 7: A New Kind of Phone
Overview of the Windows Phone 7 Application Platform
Windows Phone 7 Architecture Deep Dive
Understanding Marketplace and Making Money with Windows Phone 7 Applications
Understanding the Windows Phone 7 Development Tools
An In-Depth View of Building Applications for Windows Phone 7 with Microsoft Silverlight (Part 1)
An In-Depth View of Building Applications for Windows Phone 7 with Microsoft Silverlight (Part 2)
Microsoft Silverlight Performance on Windows Phone
Designing and Developing for the Rich Mobile Web
Developing Occasionally Connected Applications for Windows Phone 7
Building Windows Phone Games with Microsoft XNA Game Studio
Building a High Performance 3D Game for Windows Phone
Developing Mobile Code Today that will run on Windows Phone 7 Tomorrow
Coding4Fun: Learn Windows Phone 7 Development by Creating a Robotic T-Shirt Cannon
Application Platform Overview for Windows Phone
Getting Started Guide for Developing for Windows Phone
What’s New in Windows Phone Developer Tools Beta
Breaking Changes for Windows Phone Developer Tools Beta
The Silverlight and XNA Frameworks for Windows Phone
Windows Phone Developer Tools (WPDT)
Programming Guide for Windows Phone
Class Library Reference for Windows Phone
Download the Windows Phone Developer Tools (WPDT) Beta
Installation Notes: Windows Phone Developer Tools
Uninstall issues with the Windows Phone Developer Tools
Understanding the Windows Phone 7 Development Tools
Get Started page on Silverlight.net

There we have it; WP7 is on; it’s just the beginning, hope we can all have some fun w/ WP7Dev & generate some revenue.

 
    x:Class="wp7CattoFreeAppv2.MainPage"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:phone="clr-namespace:Microsoft.Phone.Controls;assembly=Microsoft.Phone"
    xmlns:shell="clr-namespace:Microsoft.Phone.Shell;assembly=Microsoft.Phone"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    FontFamily="{StaticResource PhoneFontFamilyNormal}"
    FontSize="{StaticResource PhoneFontSizeNormal}"
    Foreground="{StaticResource PhoneForegroundBrush}"
    SupportedOrientations="Portrait" Orientation="Portrait"
    mc:Ignorable="d" d:DesignWidth="480" d:DesignHeight="768"
    shell:SystemTray.IsVisible="True">

That is all, there will more,

Catto

SQL Saturday #40 - DB Dev T-SQL 0-60 - Code Crackin #29

noreply@blogger.com (Catto) — Tue, 27 Jul 2010 09:46:00 +0000

SQL Saturday #40 - DB Dev T-SQL 0-60 - Code Crackin #29

Hey Now Everybody,

SQL Saturday #40 on July 31st 2010, #sqlsat40
I'll be presenting a Database Developement session named T-SQL 0-60 (from standing to sprinting) a beginner's level 70 minutes session to cover some stellar content. This session will include a good mixture of high level concepts along with detailed examples of T-SQL code. We are going to use two simplifed tables from the ASP.NET Membership database (a real world db not northwind) that will work with to demonstrate many skills. There is a script in this post that you may use & I'll use as our examples. The session will include a little swag give away of a recorded episode of DotNetRocks! & RunAs Radio. Here is a link to my slide deck.
This Database Development T-SQL 0-60 session will be broken up into four major session:
1. IDE SSMS & Queries - Fundamentals including management studio, objects & queries
2. Design View vs. Query Editor Window - Comparing GUI vs. Script to accomplish same tasks
3. Stored Procedures - In depth examples of stored procedures
4. Sky is the Limit - Additional query techniques

Here is an image of the session:

Along with all the stellar content the people whe are going to be there should be fun relax with & talk technology:

Kevin Boles @TheSQLGuru
Dmitri Korotkevitch
Mike Davis @MikeDavisSQL
Ronald Dameron @RonDBA
Brent Ozar @BrentO
Devin Knight
Jack Corbett @uncleBiguns
Jorge Segarra @sqlChicken
Rodney Landrum @rodney_landrum free SQL ebook
Timothy Ford @sqlagentman
Aaron Nelson @sqlvariant
Troy Gallant @gratefuldba
Adam Jorgensen @adam_jorgensen
Argenis Fernandez @afernandez
David Corrales @SAPIEN
David Levy @Dave_Levy
Don Gabor .com
Jose Chinchilla @sqljoe
Patrick LeBlanc @patrickdba
Rafael Salas @rafsalas
Timothy McAliley @SysFrameWorks
Pam Shaw @pamshaw
Hector Hernandez
Maximo Trinidad @maxtrinidad
Jared Nielsen @jarednielsen
Sam Abraham @wildturtle21
Scott Klein
Herve Roggero @hroggero
Shervin Shakibi @shervsherv
Joe Devfish Healy @devfish
Telmo Sampaio @telmosampaio
Michael Mollenhour
Elijah Baker

Here are some details on my session:
1.1. IDE SSMS SQL Server Management Studio
1.1.a. Installation of SQL Server 2008
1.1.b. Connoting to Server
1.1.c. Object Explorer
1.1.d. Query Editor Window
1.1.e Design View
1.1.f Best SSMS Hotkeys
1.2. Queries (Common Commands)
1.2.a. Syntax
1.2.b. Comments
1.2.c. Data Types
1.2.d. Create
1.2.e. Select
1.2.f. Insert
1.2.g. Where
1.2.h. Update
1.2.i. Delete
1.2.j. AND
1.2.k. OR
1.2.l. Order By
1.2.m. Group By
1.2.n. Count
1.2.o. Joins
1.2.p Views
2.1. Design View
2.1.a Creating Tables
2.1.b Modifying Tables
2.1.c Building Queries
2.2. Query Editor Window
2.2,a General
2.2.b Execute & Parse
2.2.c Highlighting Text
2.2.d Scripting
3. Stored Procedures
a. Create
b. Database Definition (Use)
c. Comments
d. Common Settings
e. Begin End
f. Alter / Modify
g. Drop
h. Rollback
i. Grant Permission
j. Execute SP
k. Parameters
4. T-SQL’s Sky is the Limit
a. Alias
b. Scripting
c. Commands
d. Temp Tables
e. Select Into
f. Nested Select
g. Cursors
h. Case vs. If
i. Dependencies
j. Grants
k. Schemas
l. Template Explorer
m. Datetime
n. Try Catch Blocks
o -Execution Plan
p.1 XML
p.2 XML PATH
p.3 XML PATH SHOWPLAN
Q Third Party tools
q.1 Red Gate SQL Search
q.2 SQL Format Snippet Inserter (Google Code)
q.3 SQL Beauty
R. Reference MSDN
S MCTS 70-433
s.1 Skills Measured
s.2 Programming Objects
s.3 Query Fundamentals
s.4 XML Data

A couple sessions I’m looking forward to are:

Troy Gallant - Introduction to Transactional Replication
Brent Ozar - BLITZ! One Hour SQL Server Takeovers
David Corrales - Sneak Preview: SAPIEN's Visual PowerShell 2011
Dmitri Korotkevitch - Database design with performance in mind
Kevin Boles - Advanced TSQL Solutions

  -- Catto Database Development DB Script
-- This is a script from www.ChrisCatto.com for SQL Saturday's Database Development T-SQL session
--1.1. IDE SSMS SQL Server Management Studio
--     1.1.a. Installation
--     1.1.b. Connoting to Server
--     1.1.c. Object Explorer
--     1.1.d. Query Editor Window
--     1.1.e Design View
--1.2. Queries (Common Commands)
--     1.2.a. Syntax
--     1.2.b. Comments
--     1.2.c. Data Types
--     1.2.d. Create
--        1.2.d.1 db
--        1.2.d.2 table Create [catto_aspnet_Users]
--        1.2.d.3 table Add Clustered Index
--     1.2.e. Select
--     1.2.f. Insert
--     1.2.g. Where
--     1.2.h. Update
--     1.2.i. Delete
--     1.2.j. AND
--     1.2.k. OR
--     1.2.l. Order By
--     1.2.m. Group By
--     1.2.n. Count
--     1.2.o. Joins
-------------------------------------------------------
--     1.2.d.1 Create
--CREATE DATABASE [catto_dbtest6]
--GO
--DROP Database [catto_dbtest4]
--GO
--use [catto_sql_sat]
--GO
------------------------------------------------------
---- 1 Create Table [catto_aspnet_Users]
CREATE TABLE [catto_aspnet_Users]
(
[UserId] [int] NOT NULL IDENTITY
, [active] [bit] Not NULL DEFAULT 1
, [UserName] [nvarchar](256) NULL
)
GO
-- 1.2.d.3 [PK_catto_aspnet_Users]
ALTER TABLE [catto_aspnet_Users]
ADD  CONSTRAINT [PK_catto_aspnet_Users] PRIMARY KEY CLUSTERED
(
[UserId] ASC
)
ON [PRIMARY]
GO
----------------------------------------
-- 1.2.d.4 table [catto_aspnet_Membership]
--drop TABLE [dbo].[catto_aspnet_Membership]
CREATE TABLE [dbo].[catto_aspnet_Membership]
(
[MembershipID] [int] IDENTITY(1,1) NOT NULL
, [active] [bit] Not NULL DEFAULT 1
, [UserId] [int] NOT NULL
, [Password] [nvarchar](128) NOT NULL
, [Email] [nvarchar](256) NULL
, [IsApproved] [bit] NOT NULL
, [CreateDate] [datetime] NOT NULL
,
CONSTRAINT [PK_catto_aspnet_Membership] PRIMARY KEY CLUSTERED
(
[UserId] ASC
)
ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [nci_userid] ON [dbo].[catto_aspnet_Membership]
(
[UserId] ASC
)
ON [PRIMARY]
GO
----1.2.e. Select
select * from [catto_aspnet_Users]
--drop table [catto_aspnet_Users_4]
---- Create Table & PK in one script
--CREATE TABLE [dbo].[catto_aspnet_Users](
--    [UserId] [int] IDENTITY(1,1) NOT NULL,
--    [active] [bit] NOT NULL default 1,
--    [UserName] [nvarchar](256) NULL,
-- CONSTRAINT [PK_catto_aspnet_Users] PRIMARY KEY CLUSTERED
--(
--    [UserId] ASC
--)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
--) ON [PRIMARY]
--1.2.f. Insert
-- Insert Record
INSERT INTO catto_aspnet_Users
       (UserName)
VALUES ('Catto')
INSERT INTO catto_aspnet_Users
       (UserName)
VALUES ('CattoOrange')
INSERT INTO catto_aspnet_Users
       (UserName)
VALUES ('CattoPotato')
select * from catto_aspnet_Users
-----------------------------------------
--1.2.g.  where
Select [UserId]
,[active]
,[UserName]
From [catto_aspnet_Users]
where [UserName] = 'Catto'
-------------------------------------------------
--1.2.h. Update
UPDATE catto_aspnet_Users
SET       UserName = 'CattoTomato'
WHERE (UserId = 1)
Select *
from catto_aspnet_Users
where (UserId = 1)
--------------------------------------------------
--1.2.i. Delete
DELETE FROM catto_aspnet_Users
WHERE (UserId = 1)
Select *
from catto_aspnet_Users
where (UserId = 1)

INSERT INTO catto_aspnet_Users
       (UserName)
VALUES ('Catto')
--------------------------------------------------
--1.2.j. And
Select *
from catto_aspnet_Users
where (UserId = 2)
AND  (UserName = 'CattoOrange')
-- Highlighting
--     Text
--NEED INSTALL LINK
------------------------------------
--1.2.k. OR
Select *
from catto_aspnet_Users
where (UserId = 2)
OR  UserName = 'CattoPotato'
------------------------------------
--1.2.l. order by
Select *
from catto_aspnet_Users
order by UserId
Select *
from catto_aspnet_Users
order by UserId desc
------------------------------------
--1.2.m. Group by
SELECT active, UserId, UserName
FROM  catto_aspnet_Users
GROUP BY active, UserId, UserName
------------------------------------
--1.2.n. Count
SELECT COUNT(UserId) AS totalCount
FROM  catto_aspnet_Users
-- Count & Group by
SELECT active AS activeBit, COUNT(UserId) AS totalCount
FROM  catto_aspnet_Users
where active = 1
GROUP BY active
------------------------------------
--1.2.o. -- Joins
INSERT INTO catto_aspnet_Membership
       (active, UserId, Password, Email, IsApproved, CreateDate)
VALUES (1, 2, 'blahEncrypted', 'catto@domain.com', 1, CONVERT(DATETIME, '2010-08-08 00:00:00', 102))
select * from catto_aspnet_Membership
select *
from catto_aspnet_Users
INNER JOIN catto_aspnet_Membership
ON catto_aspnet_Users.UserId = catto_aspnet_Membership.UserId
GO
------------------------------------
--1.2.p Views
CREATE VIEW [dbo].[vw_catto_aspnet_Users]
AS SELECT [UserId]
, [UserName]
FROM catto_aspnet_Users
GO
-- 1.2.q selecting from View
-- Selecting from View
SELECT [UserId]
,[UserName]
FROM [vw_catto_aspnet_Users]
--------------------------------------------------------------------------------
-- 2 Design View vs. Query Editor
--------------------------------------------------------------------------------
--2.1 Desgin View Vs. Query Editor Window
--2.1. Design View
--   2.1.a Creating Tables
--   2.1.b Modifying Tables
--   2.1.c Building Queries
--2.2. Query Editor Window
--   2.2,a General
--   2.2.b Execute & Parse
--   2.2.c Highlighting Text
--   2.2.d Scripting
--------------------------
--USE [ccatto_aspnetdb]
--GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[aspnet_Roles_catto]
(
[aspnet_roles_id] [numeric] NOT NULL identity,
[RoleId] [uniqueidentifier] NOT NULL,
[RoleName] [nvarchar](256) NOT NULL,
[Description] [nvarchar](256) NULL,
PRIMARY KEY NONCLUSTERED
(
[RoleId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
--USE [catto_dbtest4]
--GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[aspnet_Roles_catto](
[aspnet_roles_id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
[roles] [nvarchar](50) NULL,
[RoleId] [uniqueidentifier] NOT NULL,
[RoleName] [nvarchar](256) NOT NULL,
[Description] [nvarchar](256) NULL,
CONSTRAINT [PK_roles_catto_id] PRIMARY KEY CLUSTERED
(
[aspnet_roles_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [nci_roleid_catto] ON [dbo].[aspnet_Roles_catto]
(
[roles] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
ALTER TABLE [aspnet_Roles_catto]
ADD application_id int null
GO
select * from [aspnet_Roles_catto]
--drop table [aspnet_Roles_catto]
-- now we will create a table in design view
INSERT
INTO            aspnet_Roles_catto(role_id, role, description, app_id)
VALUES     (1, 'admin_role', 'admin role most power', 1)
INSERT
INTO            aspnet_Roles_catto(role_id, role, description, app_id)
VALUES     (2, 'user_pawn_role', 'pawn role least power', 1)
select * from [aspnet_Roles_catto]
-- in design view lets insert values
SELECT     role_id, role, description, app_id
FROM         aspnet_Roles_catto
WHERE     (app_id = 1) and  (role_id = 1)

SELECT     COUNT(aspnet_roles_catto_id) AS TotalRecords
FROM         aspnet_Roles_catto
GO
---------------------------------
--3. Stored Procedures
-- a. Create
-- b. Database Definition (Use)
-- c. Comments
-- d. Common Settings
-- e. Begin End
-- f. Alter / Modify
-- g. Drop
-- h. Rollback
-- i. Grant Permission
-- j. Execute SP
-- k. Parameters
-- 3.a. Create
CREATE Procedure p_aspnet_Users_Get
--ALTER Procedure p_aspnet_Users_Get
AS
BEGIN
Select UserName from catto_aspnet_Users
END
GO
---------------------------------------------------
-- 3.b Use
--USE catto_dbtest4
--GO
-- 3.c Comments
-- 3.d Common Settings
-- 3.e Begin End
-- 3.f Alter
--CREATE Procedure p_aspnet_Users_Get
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure p_aspnet_Users_Get
AS
BEGIN
Select UserName
from catto_aspnet_Users
where active = 1
END
-- 3.g DROP
DROP PROCEDURE [dbo].[p_aspnet_Users_Get]
GO
Create  Procedure p_aspnet_Users_Get
AS
BEGIN
Select UserName
from catto_aspnet_Users
where active = 1
END
GO
-- 3.h ROLLBACKS
Alter Procedure p_aspnet_Users_Get
AS
BEGIN
Select UserName
from catto_aspnet_Users
--where active = 1
END
--------------------------------------------------------------------------------
-- Rollback
--------------------------------------------------------------------------------
--Alter Procedure p_aspnet_Users_Get
--AS
--BEGIN
--    Select UserName
--    from catto_aspnet_Users
--    where active = 1
--END
GO
--3.i GRANT
--3. i. Grant Permission
--Grant Execute on p_aspnet_Users_Get
--    to newUser
--GO
-- 3.j execute
Execute p_aspnet_Users_Get
GO
-- 3.k @Parameters
CREATE PROCEDURE [dbo].[p_aspnet_Membership_CreateUser]
--Alter Procedure [p_aspnet_Membership_CreateUser]
(
@UserName    nvarchar(256)
, @Password   nvarchar(128)
, @Email      nvarchar(256)
, @IsApproved bit
)
AS
BEGIN
declare @CreateDate datetime
declare @NewUserId int
SET @CreateDate = GETDATE()
INSERT INTO catto_aspnet_Users
       (UserName)
VALUES (@UserName)
set  @NewUserId =
( select top 1 @@IDENTITY from catto_aspnet_Users)
INSERT INTO catto_aspnet_Membership
(    active
, UserId
, Password
, Email
, IsApproved
, CreateDate
)
VALUES
(    1
, @NewUserId
, @Password
, @Email
, 1
, @CreateDate
)
END
GO
--------------------------------------------------
--- Check latest records in tables
Select top 1 * from catto_aspnet_Membership order by MembershipID desc
select top 1 * from catto_aspnet_Users order by UserId desc
-----------------------------------------------------
-- j. Execute SP
DECLARE    @return_value int
EXEC    @return_value = [dbo].[p_aspnet_Membership_CreateUser]
@UserName = 'ccatto',
@Password = 'blah',
@Email = 'cattoemail@chriscatto.com',
@IsApproved = 1
SELECT    'Return Value' = @return_value
GO
--  Check latest record in tables
Select top 1 * from catto_aspnet_Membership order by MembershipID desc
select top 1 * from catto_aspnet_Users order by UserId desc
-----------------------------------------
--4. T-SQL’s Sky is the Limit
-- a. Alias
-- b. Scripting
-- c. Commands
-- d. Temp Tables
-- e. Select Into
-- f. Nested Select
-- g. Cursors
-- h. Case vs. If
-- i. Dependencies
-- j. Grants
-- k. Schemas
-- l. Template Explorer
-- m. Datetime
-- n. Try Catch Blocks
--------------------------------------
-- 4.a. Alias
--- 4.a.1 example simple
select cau.UserName uname
from catto_aspnet_Users cau
-- -4.a.2 example 2
select cau.UserName
from catto_aspnet_Users cau
INNER JOIN catto_aspnet_Membership cam
ON cau.UserId = cam.UserId
-- 4.b. Scripting
------------------------------------
-- 4.c. Commands
--c.1 Declare
DECLARE @loopCounter int
DECLARE @name varchar (50)
DECLARE @theDate datetime
--c.2 SET
SET @loopCounter = 1
SET @name = 'Catto'
--c.3 If
--SET @loopCounter = 0
IF @loopCounter = 1
BEGIN
Select * From catto_aspnet_Users
END
--c.4 Case
select UserName,
case active
when 0 then 'notActive'
when 1 then 'Active'
--when 2 then 'unknown'
else 'Invalid ActiveBit' end as "Active"
from catto_aspnet_Users
--c.5 Union
--INSERT INTO catto_aspnet_Membership
--              (active, UserId, Password, Email, IsApproved, CreateDate)
--VALUES (1,998, 'blahEncrypted2', 'catto@lives2.com', 1, CONVERT(DATETIME, '2010-08-08 00:00:00', 102))

Select UserID
From catto_aspnet_Users
UNION
Select UserID
From catto_aspnet_Membership
--c.6 Like
Select *
From catto_aspnet_Users
WHERE (UserName LIKE '%Catt%')
--c.7 Top
Select top 1 *
From catto_aspnet_Users
WHERE (UserName LIKE '%Catt%')
--declare @k8variable int
--set @k8variable  = 2
--select top @k8variable * from catto_aspnet_Users
--c.8 With No Lock
Select top 1 *
From catto_aspnet_Users with (nolock)
--c.9 Sum
SELECT SUM(catto_aspnet_Users.UserId) AS SumExample
FROM  catto_aspnet_Users
--c.10 Avg
SELECT AVG(UserId) AS AverageOfUID
FROM  catto_aspnet_Users
-- 4.d. Temp Tables
-- Example of using Temp Tables:
-- Delcare Variables
DECLARE @tableID int
DECLARE @nameOfPerson varchar (50)
-- CREATE temp table tempTablePeeps
CREATE TABLE #tempTablePeeps
(
ttpPeepID int NULL
, ttpPeepName varchar(50) NULL
)
-- Select & set variables
SET @tableID =
(
Select UserId
From catto_aspnet_Users
where userid = 2
)
SET @nameOfPerson =
(
Select userName
From catto_aspnet_Users
where userid = 2
)
-- Insert Values into temp Table
INSERT INTO #tempTablePeeps
(
ttpPeepID
, ttpPeepName
)
VALUES
(
@tableID
, @nameOfPerson
)
-- Select Values from Temp Table
Select ttpPeepID as ID
, ttpPeepName as PeepsName
From #tempTablePeeps
Drop Table #tempTablePeeps
-- 4.e. Select Into w/ temp table
SELECT
userid
, username
INTO #tempTable
FROM catto_aspnet_Users
select * from #tempTable
drop table #tempTable
-- Example: In the next nifty Select into statement an identity column is created on the temp table which could be quite useful especially if the newTablePeopleName table didn't have an identity.
-- catto_aspnet_users have identity already
--SELECT
--    userid
--    , username
--    , IDENTITY( int ) AS workingID
--INTO #tempTable
--FROM catto_aspnet_Users
--select * from #tempTable
--drop table #tempTable
-- 4.f. Nested Select
SELECT username
FROM catto_aspnet_Users
WHERE userid =
(    SELECT userid
FROM catto_aspnet_Membership
WHERE email = 'catto@domain.com'
)
--------------------------------------------------
-- 4.g. Cursors
DECLARE @UID INT
DECLARE curor_Data CURSOR STATIC FOR
select userid from catto_aspnet_Membership
OPEN curor_Data
FETCH curor_Data INTO
@UID
WHILE @@FETCH_STATUS = 0
BEGIN
select *
from catto_aspnet_Users
where @UID = userid
FETCH curor_Data INTO
@UID
END
CLOSE curor_Data
DEALLOCATE curor_Data
-- 4.h. Case vs. If
declare @activeflag int
set @activeflag =1
if @activeflag = 1
Begin
select username, active from catto_aspnet_Users
End
select UserName,
case active
when 0 then 'notActive'
when 1 then 'Active'
--when 2 then 'unknown'
else 'Invalid ActiveBit' end as "Active"
from catto_aspnet_Users
GO
-- 4.i. Dependencies right click on object 'view dependencies'
-- 4.j. Grants
-- GRANT EXECUTE ON p_getNames
--TO [Catto_Person_User]
--GO
-- 4.k. Schemas
create schema s_catto
GO
-- create table [s_catto].[schemaTable] (
--[schemaTable_id] [int] IDENTITY(1,1) NOT NULL)
-- 4.l. Template Explorer 2008
-- 4.m. Datetime
declare @uglyDate datetime
set @uglyDate = '2010-07-31 12:42:36.320'
declare @prettyDate varchar(25)
SET @prettyDate =
(
SELECT CAST(DATEPART(month, @uglyDate ) as varchar(2)) + '.' + CAST(DATEPART(day, @uglyDate ) as varchar(2)) + '.' + CAST(DATEPART(year, @uglyDate ) as varchar(4))
)
select @prettyDate as prettydateOutput
GO
-- note output is 7.31.2010
-- 4.n. Try Catch Blocks
BEGIN TRY
-- let us Generate a divide-by-zero error.
SELECT 1/0;
--select 1;
END TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() AS ErrorNumber
,ERROR_SEVERITY() AS ErrorSeverity
,ERROR_STATE() AS ErrorState
,ERROR_PROCEDURE() AS ErrorProcedure
,ERROR_LINE() AS ErrorLine
,ERROR_MESSAGE() AS ErrorMessage;
END CATCH;
GO
--4.o --Execution Plan
select * from catto_aspnet_users where userid = 2 and username = 'CattoOrange'
-------------------------------------
-- 4.p.1   XML
SELECT  [UserId]
,[UserName]
FROM [catto_aspnet_Users]
FOR XML AUTO, ELEMENTS
-- 4.p.1   XML PATH
SELECT  [UserId] as  uid
,[UserName] as "info/@userName"
FROM [catto_aspnet_Users]
FOR XML PATH('K8Users');
GO
-- 4.p.3   SHOWPLan XML
SET  SHOWPLAN_XML ON;
GO
SELECT [UserId] as uid
,[UserName] as "info/@userName"
FROM [catto_aspnet_Users]
FOR XML PATH('K8Users');
Go
SET SHOWPLAN_XML OFF;
----END of SCRIPT
-------------------------------------

As Always all comments welcome that is all there will be more
Catto

SSMS Toughest Program to Install? It is!? Code Crackin #28

noreply@blogger.com (Catto) — Mon, 19 Jul 2010 09:48:00 +0000

Hey Now,

SQL Server Management Studio SSMS, is it the toughest program to install? Personally I believe it is, what do you think? Let us take a closer look @ installing SSMS. As I just put a fresh install of Win7 54-bit on this notebook I obviously had to install all of my programs again. The first program I usually install is SSMS & I took some screen shots to include in this post. The version I installed in SQL Server 2008.

Many programs that we install it’s a simple 3 clicks, next, next, finish. I think SSMS takes about 20 clicks before we get to finish. There are many options that we can choose from. Below is the sequence of steps I used to install the program:

Here is a summary of the typical steps taken:

1st Compatibility Message (SP1)
2nd SQL Server Installation Center
3rd Setup Support Rules
4th Product Key
5th License Terms:
6th Setup Support Files
7th Setup Support Rules
8th Feature Selection
9th Instance Configuration
10th Disk Space Req
11th Server Configuration
12th Database Engine Config
13th Analysis Services Configuration SSAS
14th Reporting Services Config SSRS
15th Error & Usage Reporting
16th Installation Rules
17th Installation Rules
18th Ready to Install
19th Installation Progress
20th Complete
21st Tools Options – Customize

SSMS has a whole SQL Server Installation Center that opens when we start installing the program. The option we’ll focus on is adding a new SQL Server stand alone installation. Before I started the install we’ll get prompted about installing SP1.

3 Setup Support Rules is the next step, this will indentify any issue we may have when installing, below we see we passed all six.

4th Product Key- we enter in our Product Key

5th License Terms: We read the entire legal document, click accept then click next.

6th Setup Support Files We click next to setup support files.

7th Setup Support Rules, After it runs it will display passed, failed, or warnings:

8th Feature Selection: we select all the features we want to install such as SSAS, SSRS, full text search ect:

9th Instance Configuration We create an instance & select the location:

10th Disk Space Requirements verify there is space on the drive:

11th Server Configuration, this is where I’ve spent some time trying to get this setup correctly

12th Database Engine Configuration This is where we add the users

13th Analysis Services Configuration We setup SSAS Users:

14th Reporting Services Configuration setup SSRS

15th Error & Usage Reporting – we can choose to send information to Microsoft

17th Installation Rules – Rules are run to ensure the installation process will not be blocked

18th Ready to Install – We verify all of our features we want to install

19th Installation Progress – Displays the current process of installation.

20th Complete – The SQL Server installation was successfully installed.

21. Options – In addition to adding line numbers, changing the backround to black this is one option I like to adjust after I install which

As we’ve seen SQL Server is fun to install & has many different options we can choose from. We all need a database to connect to provide database driven applications, installing it is a requirement.

What do you think, is SSMS the toughest program to install? As always all comments welcome.

That is all, there will be more,

Catto

SQL 2008 DB Dev 70-433 GCUG ‘Exam Cram’ Code Crackin #27

noreply@blogger.com (Catto) — Thu, 01 Jul 2010 01:11:00 +0000

Hey Now Everybody,

This is a review of our local .NET user group meeting where the topic was an exam cram on the Microsoft exam 70-433. The session was @ our Gold Coast User Group. The session was great & presented by David Cobb & Daniel Dunn. It was a great session where we went over about many questions from a practice exam. I took some notes on the content & wanted to share them to help people study the content for the exam.

Below are a copy of my notes. This post will help us by making us think about content from the exam:

1. Permissions Deny Select permissions Deny Select On order to John
2. Two unique constraint has not null
    Nvarchar 100 null
    Nvmar chare max
3. Three Create View With Check option answer not SchemaBinding with Schemabiding
4. Create non clustered index
5. Rebuild - Page splitting alter index all on sales.saleshistory rebuild with (fillfacor = 60 ) Rebuild option
6. Five `NonclusteredIndex Create Nonclusteree index ix_cust_acc#
7. Siz OR -
8. Eight Clustered index on FG_accountData (column_a ) C Create Clustered Index idx_accountsReceiveable on AccountsReceivable(caol_a) on FG_AcccountData(col_a)
9. Nine - B. Set Identity Insert invoice on insert into infvoice() values
10. FK
11. B Geography new data type
12. SQL_Latin_Genteral_CP1_CS_AS ‘a’ ‘A’ Case senstaive
13. C Varchar(max) compatible with SPARSE
14. D datetimeoffset – Local time
15. Alter Table Switch task table to table history
16. Create partition function,Schema create the table, Another Section
17. Stored procs Recompile ;; option(recompile ) & sp with encryption
18. Permissions A. Grant execute not impersonate user
19. READONLY Tablevalued parameters
20. Index column
    IsDeterministic = True
    IsSystemVerified = Ture
    UserDataAccess = False
    SystemDataAccesss False
21. Scalarvalued function 29 days in Feb
22. With Schemabinding – prevents tables from being deleted
23. Create trigger tr_Part_d on Part instead of delete
24. Trigger Instead of Insert trigger don’t stop the insert
25. C - Create trigger after update not for replication
26. C - DDL Rollback ddl create delete
27. On Database For
28. Missed
29. 16 try catch
30. Raiserror 10 Choice

Tray again, we never fail until you stop trying.

Here is a link to the list of topics & some test taking tips from the presenters: http://Gcdotnet.com/Sqlprep.zip

Below are the list of many of the topics discussed:

nVarChare(MAX ) Data type
with Check Option
With schemabinding
With View_metadata
Create index .. include (col [n])
Create index .. on filegroup
Alter index rebuild [with ]
Geometry
Geography
Sparse
Dataetimeoffset
Alter table switch partition
Create partition function
Create partition scheme
Create table .. on artition scheme
With recompile
Execute as
Trigger
CLR Assembly
Raise error severity levels

Whew fun hope you liked it! What did you think?

Next Up section ‘Additional Query Techniques’.
That is all there will be more,

As always all comments welcome,

Catto

SQL 2008 DB Dev 70-433 XML Data – 6th objective Code Crackin #26

noreply@blogger.com (Catto) — Thu, 13 May 2010 02:01:00 +0000

Hey Now Everybody,

This is a review of the sixth objective on the Microsoft exam 70-433 ‘Working with XML Data’

While reviewing for the Microsoft exams it’s enjoyable to combine the three sections:
1. Self Paces Book’s chapters content
2. Code, SQL Scripts
3. Concepts from Questions of the Microsoft Training Kit

6 Working with XML Data (12 percent)
6.1 Retrieve Relational Data as XML c7.1
6.2 Transform XML data into relational data c7.1
6.3 Query XML data c7.1
6.4 Manage XML data c7.1

Chapter 7.1 Key Concepts
XML can be generated using SELECT in four different modes:
For XML Raw
, For XML Auto
, For XML PATH
, For XML Explicit
For XML Path is typically the preferred mode used to generate XML
XML Data type can be either untyped or typed (validated by an XML schema collection)
Untyped XML data type all values are always interpreted as strings
We can use value, query, exist, nodes & modify methods to query & alter XML data types
Code
Query in ASP.NET Membership database querying aspnet_users table


 /****** Script for SelectTopNRows command from SSMS ******/  
SELECT [UserId]      
     ,[UserName]    
FROM [ccatto_aspnetdb].[dbo].[aspnet_Users]    
FOR XML AUTO, ELEMENTS

Here are some of the results:

Here is another example using For XML Path


/****** Script for SelectTopNRows command from SSMS ******/   
SELECT [UserId] as uid    
  ,[UserName] as "info/@userName"    
FROM [ccatto_aspnetdb].[dbo].[aspnet_Users]    
FOR XML PATH('K8Users');

Here is a sample node from the results:

Example of SHOWPLAN XML to show execution plan


/****** Script for SelectTopNRows command from SSMS ******/   
SET SHOWPLAN_XML ON;    
GO    
SELECT [UserId] as uid    
 ,[UserName] as "info/@userName"
FROM [ccatto_aspnetdb].[dbo].[aspnet_Users]    
FOR XML PATH('K8Users');     
Go    
SET SHOWPLAN_XML OFF;

Review Questions Concepts:

Create XML Schema Collection imports schema components to database

For XML Path determines the shape of resulting XML

Below are the skills measured in detail:

orking with XML Data (12 percent)

Retrieve relational data as XML.
FOR XML
Transform XML data into relational data.
OPENXML
, sp_xml_preparedocument
, sp_xml_removedocument
Query XML data.
XQUERY
, XPATH
Manage XML data.
XML datatype
, XML indexes
, XML schema collections

Next Up section four ‘Additional Query Techniques’.
That is all there will be more,

As always all comments welcome,

Catto

SQL 2008 DB Dev 70-433 Query Fundamentals – 3rd objective Code Crackin #25

noreply@blogger.com (Catto) — Wed, 12 May 2010 09:52:00 +0000

Hey Now Everybody,

This is a review of the second objective on the Microsoft exam 70-433 ‘Query Fundamentals’

3.`1 Query Data by using Select statements c1.2

Select Statement can be used to retrieve data from tables & views.
Select results sets can be filtered by adding a WHERE clause
Select results sets can be sorted by usinge the ORDER BY
Aliases & string literals can be used to manipulate & format result sets.

3.2 Modify Data by using Insert, Update & Delete statements c2.1
The Join clause allows us to retrieve columns from related tables
JOIN types include INNER< LEFT OUTER, RIGHT OUTER, FULL OUTER & CROSS
Join operators can combine 2 or more tables
Tables can be joined to itself by defining different aliases for each table
3.3 Return data by using the OUTPUT clause c2.2
The OUTPUT clause allows us to redirect info to the calling app, or to an object such as a table, about the insert, update or delete statement
3.4 Modify data by using MERGE statement c2.2
MERGE statement allows us to perform DML actions on a table based on matches found on a source table
3.5 Implement aggregate queries (LINQ) c1.3
Aggregate functions perform calculations on expressions
Use the GROUP BY clause when aggregates should be applied based on the data in rows not the whole table
Include all columns listed in a SELECT WHERE or ORDER by clause in the GROUP By clause
ROLLUP & CUBE to provide summary info
Use the GROUPING function to show which rows holds summary data provided by the rollup & cube operators
Grouping Sets to provide improvements to our Group by queries
3.6 Combine datasets c1.4
UNION operator combines result sets from 2 or more Select statements
EXCEPT operator returns rows that are in the left Select statements
Intersect operator returns only rows that are shared by the two select operators
The APPLY operator uses the results from a query as input to apply a function to each row in the results.
Outer apply returns all rows from the outer table along with the results returned by the function when rows match.
CROSS Apply returns only the rows from the outer tables which matches the function results.
3.7 Apply built in scalar functions c1.5
Built in functions to provide more meaningful results sets
date & time functions to return date info
String functions to format or return info about string expressions.

Code:

 
/****** Script for SelectTopNRows command from SSMS ******/   
SELECT TOP 000 [ApplicationId]     
    ,[UserId]    
    ,[UserName]    
    ,[LoweredUserName]    
    ,[MobileAlias]    
    ,[IsAnonymous]    
    ,[LastActivityDate]    
FROM [ccatto_aspnetdb].[dbo].[aspnet_Users]

INSERT


INSERT  INTO dbo.aspnet_Membership    
 ( ApplicationId
    , UserId 
    , Password
    , PasswordSalt
    , Email
     )    
VALUES ( @ApplicationId 
    , @UserId
    , @Password 
    , @PasswordSalt 
    , @Email 
    )

Update

UPDATE dbo.aspnet_Users
SET LastActivityDate = @CreateDate
WHERE @UserId = UserId

Order by

SELECT TOP (200) ApplicationId, UserId, UserName, LoweredUserName, MobileAlias, IsAnonymous, LastActivityDate
FROM dbo.aspnet_Users
ORDER BY UserName

Question Concepts
LEFT JOIN specifies that all rows from the left table are returned whether they meet the join criteria or not. If the join criteria are not met, output columns that correspond to the right table are set to NULL.

The OUTPUT INTO clause is a simple way to insert deleted rows into another new table. A temporary table can be populated
CONVERT(char, GETDATE(), 102) retrieves the current date with the GETDATE() function & converts it to ANSI format.
The MERGE statement performs INSERT, UPDATE, or DELETE operations on a target table based on the results of a JOIN with a source table.
The SELECT INTO statement creates a new table & populates it with the result set of the SELECT statement.

AVG is a built-in aggregate function that calculates the average value for a column. Tyou
The LEN() function returns the number of characters in a string expression

Here are the skills measured in detail:

Working with Query Fundamentals (21 percent)

Query data by using SELECT statements.
LIKE
, WHERE
, ORDER BY
, INTO
Modify data by using INSERT, UPDATE UPDATE, and DELETE statements
. row constructors
, DELETE FROM FROM
, UPDATE FROM
, TRUNCATE TABLE
Return data by using the OUTPUT clause.
INSERTED
, DELETED
, INTO
Modify data by using MERGE statements.
INSERTED
, DELETED
, OUTPUT
Implement aggregate queries.
built-in aggregate functions
, GROUPING SETS
, GROUP BY
, HAVING
Combine datasets.
CROSS APPLY
, OUTER APPLY
, all join types
; UNION
, UNION ALL
, INTERSECT
, EXCEPT
Apply built-in scalar functions.
CAST and CONVERT
; REPLACE
; LEN and DATALENGTH
; PATINDEX and CHARINDEX

Next Up section four ‘Additional Query Techniques’.
That is all there will be more,

As always all comments welcome,

Catto

SQL 2008 DB Dev 70-433 2nd objective Programming Objects Code Crackin #24

noreply@blogger.com (Catto) — Wed, 12 May 2010 01:29:00 +0000

Hey Now Everybody,

This is a review of the second objective on the Microsoft exam 70-433 ‘Programming Objects’

2 Implementing Programming Objects (16 percent)

2.1 Create & Alter Stored Procedures
2.2 Create & Alter User-Defined Functions UDFs
2.3 Create & Alter DML Triggers
2.4 Create & Alter DDL Triggers
2.5 Create & Deploy CLR-Based Objects c7.2
2.6 Implement Error handling c5.1
2.7 Manage Transactions

Book Chapters Concepts

2.1 Stored Procedures

A stored procedure is a batch of T-SQL code that has a name & stored in db
We can pass parameters to a proc either by name or by position. We can also return data from procs using output params.
We can use the EXECUTE AS clause to cause a proc to execute under a specific security context
Cursors allow us to process data on a row by row basis. However they may not be the most efficient
Try .. Catch blocks provide error handling.

2.2 UDF’s User-Defined Functions
We can create scalar functions, inline table-valued functions & multi –statement table-valued functions.
The function body must be encloded w/in a Begin END block with the exception of inline table-valued functions
Return statement terminates all functions
Functions are not allowed to change the stae of a db or a SQL Server instance.

2.3 DML Triggers – execute when we Add, modify, or remove rows
2.4 DDL Triggers
Triggers are sps that automatically execute in response to DDL or DML events
We can create 3 types of triggers DML, DDL & logon triggers
DML execute when an Insert, update or delete statement occurs
DDL triggers execute when a DDL statement for which the trigger is coded for occurs.
Logon triggers execute when there is a logon attempt
We can access the Interted & deleted tables with a DML Trigger
We can access the XML document provided by the EVENTDATA function w/in a DDL or logon trigger.

2.5 CLR-Based Objects C7.2
SQLCLR must be enabled on the SQL Server Interface when using user-defined objects based on SQLCLR
Objects for development using SQLCLR are UDFs & user-defined aggregates
If we create UDTs based on SQLCLR make sure we test
Filestream can be used when the relevant data mostly involves storing streams larger than a meg (1MB)

2.6 Error Handling
Try Catch blocks
2.7 Manage Transactions

Code –

Stored Procedure Example


USE [ccatto_aspnetdb]  
GO /****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_IsUserInRole] Script Date: 05/11/2010 21:01:07 ******/   
SET ANSI_NULLS ON    
GO 
SET QUOTED_IDENTIFIER< OFF
    
GO    
ALTER PROCEDURE [dbo].[aspnet_UsersInRoles_IsUserInRole]    
@ApplicationName  nvarchar(256)
    , @UserName nvarchar(256)
    , @RoleName nvarchar(256)    
AS    
BEGIN    
DECLARE @ApplicationId uniqueidentifier    
SELECT @ApplicationId = NULL    
SELECT @ApplicationId = ApplicationId 
FROM aspnet_Applications 
WHERE LOWER(@ApplicationName) = LoweredApplicationName     
IF (@ApplicationId IS NULL)    

   RETURN(2)    
DECLARE @UserId uniqueidentifier    
SELECT @UserId = NULL    
DECLARE  @RoleId uniqueidentifier    
SELECT @RoleId = NULL    
   SELECT @UserId  = UserId     
   FROM dbo.aspnet_Users    
   WHERE LoweredUserName  = LOWER(@UserName) 
   AND ApplicationId = @ApplicationId     
IF (@UserId IS NULL) 
    RETURN(2)    
SELECT @RoleId = RoleId     
FROM dbo.aspnet_Roles    
WHERE LoweredRoleName = LOWER(@RoleName) 
    AND ApplicationId = @ApplicationId
IF (@RoleId IS NULL)  
RETURN(3)    
IF (EXISTS( 
    SELECT *
    FROM dbo.aspnet_UsersInRoles 
    WHERE UserId = @UserId 
        AND RoleId = @RoleId ))    
      RETURN(1)    
ELSE    
   RETURN(0)    
END

Function Generic Example

CREATE FUNCTION <Inline_Function_Name, sysname, FunctionName>
(
-- Add the parameters for the function here
<@param1, sysname, @p1> <Data_Type_For_Param1, , int>,
<@param2, sysname, @p2> <Data_Type_For_Param2, , char>
)
RETURNS TABLE
AS
RETURN
(
-- Add the SELECT statement with parameter references here
SELECT 0
)
GO

Trigger Generic example from MSDN library

CREATE TRIGGER reminder
ON titles
FOR INSERT, UPDATE, DELETE
AS
EXEC master..xp_sendmail 'MaryM',
'Don''t forget to print a report for the distributors.'
GO

A few Questions Concepts:

1 Instead of Delete Trigger

2 Create a DDL Trigger to populate a table

3 Rollback & Commit

BEGIN TRANSACTION;
DECLARE @success int;
EXEC @success = spName;
IF @success = 0
ROLLBACK;
ELSE
COMMIT;

4 Alter a trigger –

5 A user-defined function (UDF) can be used directly within a SELECT statement.

6 create a UDF with the SCHEMABINDING option

7 Using Try Catch Blocks

Next Up section three Query Fundamentals.
That is all there will be more,

As always all comments welcome,

Catto

DB Dev 70-433 Implementing Tables & Views Code Crackin #23

noreply@blogger.com (Catto) — Tue, 11 May 2010 10:03:00 +0000

Hey Now Everybody,

This is a review of the first objective on the Microsoft exam 70-433 ‘Implementing Tables & View’

Objective: Implementing Tables & Views

1. Implementing Tables & Views (14 percent)
1.1 Create & Alter Tables 3.1
1.2 Create & Alter Views 5.4
1.3 Create & Alter Indexes 6.2
1.4 Create & modify Constraints 3.2
1.5 Implement Data Types C3.1 & 8.1
1.6 Implement partitioning solutions c6.2

During this series I plan on using the ASP.NET membership database for many of the examples. The reason for choosing this db is since it’s a public database & used in real world apps more so than the sample db’s such as northwind or AdventureWorks.

1. Implementing Tables & Views (14 percent)
1.1 Create & Alter Tables 3.1

Creating tables is not just defining columns. We have to choose data types correctly & implement data integrity.
Data types & how they behave is an important skill so we can use them correctly.
Data integrity is important to protect your data.

1.2 Create & Alter Views c5.4

A view is a select statement stored in the db
Views return a single result & cannot use temp tables
We can update data though a view
If a view doesn’t meet requirements for data alters, we can create an INSTEAD OF trigger to process the data modification instead.
A portioned view can be created by using a UNION ALL on two tables
Distributed partitioned views use linked servers to combine multiple tables across servers.
We can create a unique, clustered index on a view to improved performance.

1.3 Create & Alter Indexes 6.2

Indexes typically help read performance but hurt writing performance
Indexed views can increase performance.
It’s important to determine which columns to put the index key.
Analyze which indexes are being used so we can drop ones that aren’t will save storage space.

1.4 Create & modify Constraints c3.2

Implement constraints to verify data integrity
Implement constraints to support the optimizer

1.5 Implement Data Types C3.1 & 8.1
Attribute that specifies the type of data.

1.6 Implement partitioning solutions c6.2

CODE examples in a test database named dbTomato

Let’s check out a script for creating a table such as the simple aspnet_users


Use dbTomato 
CREATE TABLE [dbo].[aspnet_Users]
(
[ApplicationId] [uniqueidentifier] NOT NULL
, [UserId] [uniqueidentifier] NOT NULL
, [UserName] [nvarchar](256) NOT NULL
, [LoweredUserName] [nvarchar](256) NOT NULL
, [MobileAlias] [nvarchar](16) NULL
, [IsAnonymous] [bit] NOT NULL
, [LastActivityDate] [datetime] NOT NULL
)

Create two new data types Code example:


 01 
 
Use dbTomato
02 CREATE TYPE dbName.NAME FROM NVARCHAR(60);
03  
04 CREATE TYPE dbName.CURRENCYVALUE FROM DECIMAL(12,5);
  Create View 
  create view v_aspnet_Users_anonymous 
05 as  
06 SELECT UserId, UserName, IsAnonymous 
07 FROM dbo.aspnet_Users
08 WHERE (IsAnonymous = 1)
09 GO

Clustered indexes & non-clustered indexes differ.
10 ALTER TABLE dbTomato.aspnet_User
11 ADD CONSTRAINT PKUserID
12 PRIMARY KEY NONCLUSTERED (UserID);

Code to Modify existing table this example alters the aspnet_Users table by changing the datatype to navarchar(17) & allow not null:

ALTER TABLE aspnet_Users
13 ALTER COLUMN MobileAlias nvarchar(17) NOT NULL;
14 Constraints, a real constraint from the aspnet_Users table is below:
15 ALTER TABLE [dbo].[aspnet_Users] ADD DEFAULT (0) FOR [IsAnonymous]
16

---------------------------------------

Question Concepts Examples

1.1 When we have a field that we want to be unique such as two rows not having the same value we can right click in the design view of the table on the column & add a key with the Is Unique property set to True.

1.2 Adding a foreign key constraint

1.3 Alter table to use less space

1.3.1 Changing the data type of the Volume column from bigint to int has the potential to truncate data, but the conversion is valid

1.3.2 Nothing in the table declaration prevents it from being compressed; therefore, REBUILD WITH (DATA_COMPRESSION = ROW) is a valid alteration.

1.4 Storing videos Microsoft SQL Server 2008 introduces the FILESTREAM storage attribute for binary data stored in a varbinary(max) column, which stores binary data on the local file system rather than in the database file. This optimizes read performance for large binary objects, which makes it the best option for the application being developed.

1.5 Minimize execution time --: Indexing the monthlySalary column of the view minimizes the execution time of the GROUP BY clause of the statement in question. To create an index on a view, it must also include a unique clustered index.

1.6 Prevent users from coping a view The WITH ENCRYPTION option of the CREATE VIEW command encrypts the view definition in sys.syscomments so that it cannot be viewed by anyone, even the view's owner

1.7 A row is deleted from a table w/ an identity column . to reinsert the data we : SET IDENTITY_INSERT Products ON; allows explicit values to be entered into an identity column for the remainder of the current session or until it is turned off again.

1.8 The correct syntax for creating this alias data type is CREATE TYPE salary FROM decimal (8). The data type should be based on the decimal type rather than the float type because the values included do not exceed 10 million and a decimal column with a precision of 8 uses less storage space than does a float column

1.9 Decrease time it takes statement to execute: CREATE INDEX expertise_index ON Contractors (expertise) WHERE lastUpdated > '20080101'; is the best choice because it limits the index to only the rows relevant to the statement in question, which minimizes both the size of the index and the time to search the index.

1.10 Grant persmissions The view grants users the access they need while denying them access to any other portions of the database. It also provides flexibility for the users to work with the data as they see fit.

1.11 Add column to same table on multiple servers we create a server group

1.12 Improve perf by partitioning table

1.13 Reduce storage: Setting FILLFACTOR to 70 leaves 30 percent of the space on each leaf-level page empty, allowing for future growth and reducing page splits.

1.14 Xml file data -- > create a table

1.15 Improve select speed Add the PERSISTED option to the Profitability column. The PERSISTED option increases performance when a calculated column is retrieved at the expense of performance when the column is inserted or altered. This is achieved by performing the calculation when the data is entered and storing the result in the database. When the Profitability column is not PERSISTED, the nested CASE statements must be parsed each time the column is queried. Because retrieving calculated data is faster than calculating both CASE statements, making the Profitability column PERSISTED results in the largest performance gain.

1.16 Insert row with view & where clause

1.17 Transfer data from partition

1.18 Altering table not success due to WITH SCHEMABINDING When a view is created with the WITH SCHEMABINDING option, none of the rows used in the view can be altered without dropping or altering the view first.

Next up the other objectives in the exam!

That is all there will be more,

As always all comments welcome,

Catto

SQL2008 Database Dev 70-433 Skills Measured Code Crackin #22

noreply@blogger.com (Catto) — Thu, 06 May 2010 02:28:00 +0000

Hey Now Everybody,

SQL Server Database Development 70-433

Here we are I’m preparing for the SQL Database Dev exam & enjoying reviewing the material. Let’s inspect the skills measured for this exam & read the MSDN library on the topics. This is a good way to start preparing for this exam. Below are the skills measured for the exam along with links to mostly the MSDN library to read more information on each skill:

Official Skills Measured
Implementing Tables and Views (14 percent)
Implementing Programming Objects (16 percent)
Working with Query Fundamentals (21 percent)
Applying Additional Query Techniques (15 percent)
Working with Additional SQL Server Components (11 percent)
Working with XML Data (12 percent)
Gathering Performance Information (11 percent)

70-433 7 Sections & Major Details only

1. Implementing Tables & Views (14 percent)
1.1 Create & Alter Tables 3.1
1.2 Create & Alter Views 5.4
1.3 Create & Alter Indexes 6.2
1.4 Create & modify Constraints 3.2
1.5 Implement Data Types C3.1 & 8.1
1.6 Implement partitioning solutions c6.2

2 Implementing Programming Objects (16 percent)
2.1 Create & Alter Stored Procedures
2.2 Create & Alter User-Defined Functions UDFs
2.3 Create & Alter DML Triggers
2.4 Create & Alter DDL Triggers
2.5 Create & Deploy CLR-Based Objects c7.2
2.6 Implement Error handling c5.1
2.7 Manage Transactions

3 Working with Query Fundamentals (21 percent)
3.`1 Query Data by using Select statements c1.2
3.2 Modify Data by using Insert, Update & Delete statements c2.1
3.3 Return data by using the OUTPUT clause c2.2
3.4 Modify data by using MERGE statement c2.2
3.5 Implement aggregate queries (LINQ) c1.3
3.6 Combine datasets c1.4
3.7 Apply built in scalar functions c1.5

4 Applying Additional Query Techniques (15 percent)
4.1 Implement Subqueries c4.2
4.2 Implement CTE Common Table Expression Queries c4.1
4.3 Apply Ranking Functions c4.3
4.4 Control Execution Plans c6.1
4.5 Manage International Considerations c3.1

5. Working with Additional SQL Server Components (11 percent)
5.1 Intergrate Database Mail c8.1
5.2 Implement Full Text Search c8.2
5.3 Implement Scripts using Powershell & SMOs c9.2
5.4 Implement Service Broker Solutions c8.3
5.5 Track Data Changes LINQ c 9.3

6 Working with XML Data (12 percent)
6.1 Retrieve Relational Data as XML c7.1
6.2 Transform XML data into relational data c7.1
6.3 Query XML data c7.1
6.4 Manage XML data c7.1

7 Gathering Performance Information (11 percent)
7.1 Capture Execution Plans c6.1
7.2 Gather trace info by using the SQL Server Profiler c6.1
7.3 Collect output from the Database Engine Tuning Advisor c6.2
7.4 Collect info from system.metadata c6.1, c6.2

Skills Details

Implementing Tables and Views (14 percent)

Create and alter tables.
computed and persisted columns
; schemas
; scripts to deploy changes to multiple environments
, manage permissions (GRANT, DENY, REVOKE)
Create and alter views.
WITH ENCRYPTION
; WITH SCHEMABINDING
; WITH CHECK OPTION
; manage permissions (GRANT, DENY, REVOKE)
Create and alter indexes.
filtered
, included columns
, unique, clustered, non-clustered,
FILL FACTOR
; CREATE STATISTICS
; indexing views
Create and modify constraints.
PRIMARY KEY, FOREIGN KEY
, UNIQUE
, CHECK
, cascading referential integrity
, enabling/disabling, NOCHECK;
SET IDENTITY_INSERT
Implement data types.
FILESTREAM
; spatial, structured, and semi-structured
; collations
Implement partitioning solutions.
partitioned tables and indexes (constraints, partition functions, partition schemes, MERGE, SPLIT, SWITCH)
; distributed partitioned views (constraints, linked servers)

Implementing Programming Objects (16 percent)

Create and alter stored procedures.
table-valued parameters (TVPs),
EXECUTE AS
, RECOMPILE
, parameter direction (output)
; WITH ENCRYPTION
; manage permissions (GRANT, DENY, REVOKE)
Create and alter user-defined functions (UDFs).
WITH SCHEMABINDING, EXECUTE AS
; manage permissions (GRANT, DENY, REVOKE)
Create and alter DML triggers.
INSERTED
, DELETED
, INSTEAD OF
, EXECUTE AS
Create and alter DDL triggers.
enabling/disabling;
return event data
Create and deploy CLR-based objects.
permission sets (SAFE, UNSAFE, EXTERNAL_ACCESS),
SET TRUSTWORTHY
Implement error handling.
TRY/CATCH, RAISERROR
, retrieving error information
, custom error messages
, @@ERROR
Manage transactions.
BEGIN TRANSACTION
, COMMIT
, ROLLBACK
, SET TRANSACTION ISOLATION LEVEL

Working with Query Fundamentals (21 percent)

Query data by using SELECT statements.
LIKE
, WHERE
, ORDER BY
, INTO
Modify data by using INSERT, UPDATE, and DELETE statements
. row constructors
, DELETE FROM FROM
, UPDATE FROM
, TRUNCATE TABLE
Return data by using the OUTPUT clause.
INSERTED
, DELETED
, INTO
Modify data by using MERGE statements.
INSERTED
, DELETED
, OUTPUT
Implement aggregate queries.
built-in aggregate functions
, GROUPING SETS
, GROUP BY
, HAVING
Combine datasets.
CROSS APPLY
, OUTER APPLY
, all join types
; UNION
, UNION ALL
, INTERSECT
, EXCEPT
Apply built-in scalar functions.
CAST and CONVERT
; REPLACE
; LEN and DATALENGTH
; PATINDEX and CHARINDEX

Applying Additional Query Techniques (15 percent)

Implement subqueries.
simple
, correlated
, scalar
, list
, table valued
Implement CTE (common table expression) queries.
recursive
, non-recursive
Apply ranking functions.
RANK
, PARTITION BY
, DENSE_RANK
, OVER
, ROW_NUMBER
, NTILE
Control execution plans.
table hints
, query hints
Manage international considerations.
collations
, defining custom errors
, filtering data
, sort order
, nvarchar
, database collation
, column collation

Working with Additional SQL Server Components (11 percent)

Integrate Database Mail.
Implement full-text search.
CONTAINS
, CONTAINSTABLE
, FREETEXT
, FREETEXTTABLE
, STOPLIST
Implement scripts by using Windows PowerShell and SQL Server Management Objects (SMOs).
cmdlets
Implement Service Broker solutions.
services
, queues
, messages
, message types
, message validation
, contracts
, activation procedures
Track data changes.
change tracking
; database audit specification
; CHANGETABLE

Working with XML Data (12 percent)

Retrieve relational data as XML.
FOR XML
Transform XML data into relational data.
OPENXML
, sp_xml_preparedocument
, sp_xml_removedocument
Query XML data.
XQUERY
, XPATH
Manage XML data.
XML datatype
, XML indexes
, XML schema collections

Gathering Performance Information (11 percent)

Capture execution plans.
graphical execution plans
; SHOWPLAN
Gather trace information by using the SQL Server Profiler.
Collect output from the Database Engine Tuning Advisor.
prepare a workload
Collect information from system metadata.
Dynamic Management Views (DMVs)
, catalog views

Whew that is quite a bit of skills measured, glad we went threw them.

As Always All comments welcome
That is all, there will be more.

Catto

MCPD 4 How to Study & Take Beta Exam for Free - Code Crackin #21

noreply@blogger.com (Catto) — Wed, 05 May 2010 01:04:00 +0000

Hey Now Everybody,

Do you think Microsoft exams & certifications are a good use of time or a waste?

On Friday April 30th 2010 I took the MCPD 4 Web Dev 71-519 beta exam for free. First I heard about the beta exam by an RSS feed, then I called Prometric, registered for two exams the technical specialist & pro web dev exams. Then I had a date set & location for each exam. I prepared by reviewing the skills measured & content in the MSDN library. The previous exam for the .NET 3.5 framework is what I used as for a guide since there wasn’t much public content about the new exam.

Beta exams are really great since they are free & if you pass you get the cert. What I really enjoyed about the exams is by having a date with the exam scheduled I created a plan to study & it motivated me. It’s something to work for. I spent about 3 weeks preparing for each exam. Next week a local user group I enjoy is going to have a meeting on an exam review for another exam I’m interested in which is the SQL Server 2008 Developer exam 70-433. So now I’ve been preparing for that exam too. The content is good to study & will only help improve development skills.

Now again I ask you, Are MS Exams good to take? Is the content good to study? What do you think?

As Always all comments welcome,

That is all there will be more,

Catto

MCPD 4 Microsoft Beta Exam Prep ~80 Key Terms 70-519 Code Crackin #20

noreply@blogger.com (Catto) — Thu, 29 Apr 2010 01:44:00 +0000

Hey Now Everybody,

As preparation continues for the new MCPD 4 exam 70-519 / 71-519 / 70-564, let us inspect some key terms. Each of these terms are linked to a good resource page most to the MSDN library. By reading all these term then skimming though the resource page can only help us prepare for the Microsoft Certified Professional Developer exam. This post is intended to help people prepare for the exam & learn .NET.

Here are ~80 key terms linked to a good reference:

APP_LOCALRESOURCES
EVENTMAPPINGS/ALLAUDITS
TRACEBUMP;
ACTIVEDIRECTORYMEMBERSHIPPROVIDER;
AD Auth;ADDFILEDEPENDENCY;
AD_IMPERSONATE;
ADVANCEDENCRYPTION;
APPLICATION.ERROR –;
ASPNET_COMPILER –;
ASPNET_MEMBERSHIP – ;
ASYNC=”TRUE”;
userprofileCulure;
CONFIGURE_SITEMAPDATASOURCE –;
CONTROLSTATE –;
COOKIELESS – ;
COOKIEPROTECTION – ;
CUSTOM_PROFILE_PROVIDER –;
CUSTOM_WEB_CONTROL –;
CUSTOMER_EXTENDER – ;
DAL;
DATAPager;
DELIMITEDLISTTRACELISTENER – ;
deploywebapp;
HTMLENCODE;
excel;
FormView;
GRIDVIEW – ;
HTTPHANDLER;
HTTPHANDLER/RSS -
HTTPMODULE;
IN-MEMORY – server;
JSDEBUGGING;
JSON;
LinkButton;
LINQ;
LINQDATASOURCE;
listview;
localiationz;
MASTERPAGEFILE;
MEDIAFILES;
MEMBERSHIP;
MULTIVIEW;
OBJECTDATASOURCE;
OLEDBDATATABLEADAPTER;
sitemapresolve;
XSS;
GRIDVIEW;
HTMLENCODE;
HTTPMODULE;
HTTPS server;
MOBLIE;
MULTIVIEW;
NESTEDMASTERS
OBJECTDATASOURCE;
OLEDBDATATABLEADAPTER;
PAGE.ISVALID;
PARSECONTORL()PREINIT
PROTECTEDDATA;
REQUIREDFIELDVALIDATOR
Page.RegisterAsyncTask
RSS;
SAVESTATECOMPLETE;
SECUREHASH;
sitemapresolve;
SITEMASPPATH;
skins;
SQLDATASOURCE;
SQL-INJECTION;
ssl;
stateserver;
THEMES/PREINIT;
TRACE_ELEMENT;
UPDATECOMMAND;
WEBCONTROLADAPTER;
WEBSERVICE;
webapps vs.website
XMLDataSource

So we just went thought quite a bit of content which will help us prepare for the exams. What do you think?

As always all comments welcome.

That is all, there will be more,

Catto

MCPD .NET 4 Preparing for the Microsoft beta exam 70-519 - Code Crackin #19

noreply@blogger.com (Catto) — Fri, 23 Apr 2010 02:09:00 +0000

Hey Now Everybody,

Preparing for the Microsoft MCPD .NET 4 beta exam 70-519. This is the next version of the 3.5 70-564 exam. The MCTS exams have the self paced training kit books which are stellar resources to study from, however the MCPD exams there isn’t as much exam prep materials. Outlined are the skills measured in this exam.

This is posted to help people & myself study for the exam & learn more about .NET 4. Below are some key points that I’ve summarized so we can just read basically one or two sentences which will cover one topic or concept. I’ve tried to present this content in a way to use our time most efficiently with not much repetition and content we we use.

70-564 / 70-519 / 71-519
Key Concepts:

331 AD Authentication mode & identity Impersonation such as <authentication mode="Windows" /><identity impersonate="true" />

332 Master pages & webconfig specifies master page for application

333. DataSources for example LinqDataSource, when data's being retrieved by a datacontext object

334. Prevent harmful scripts being stored in sql db we can ValidateRequest attribute of the @Page directive should be set to false & saving the text to the database, you should make use of the Server.HtmlEncode method

335. Verifying data inputted into db is valid by when the Page.IsValid property is True use the Click event handler of the
Button control to submit the data

336 Store data for lifetime of app we can use In-memory of the Web server process should be used as the storage.

337. Web Apps -When pages are updated frequently & we want quick startup time we precompile the application along with the fixed assembly names by using the aspnet_compiler utility.

338. Ensure updating pages doesn't effect load time of other pages we use a Web site project copy the entire application to the deployment server and copy only the updated files to the server.

339. Multiple master pages with user controls to dynamically reference the control we:
Code each master page class to implement a common interface exposing the ImageUrl property of the Image control
create a strongly typed master page reference by using the @ MasterType directive on each content page

4110 Upgrading applications by upgrade the application to a Visual Studio 2010 Web application project

4111 AD auth - When an unauthenticated user hits a page we want to force them to enter uid & pw we use of Forms authentication.Use the ActiveDirectoryMembershipProvide class

4112 when a data bound control which we can page through records, create, update we can use a FormView

4113. When a page displays data from a db based on an id & not creating a new node in the sitemap for each page we can handle the SiteMap.SiteMapResolve event

4114. When we want to display data in a grid we retrieve data for the GridView control by using the SqlDataSource control

4115. When a control supports 2 languages such as all German-region views in German all others in english we can for each page without any culture specified & ge culture, create a resource file place the files in the App_LocalResources directory

4116. Consistent display properties of controls we define a skin for each type of ASP.NET server control that is used in the app

4117. A DAL supporting 3rd party vendors the data access object we use OleDbDataAdapter

4118. Deploying an app ensure assemblies comply w/ rules & naming conventions we create a Web app project, the output assembly name should be set to conform to the rules.

4119 Excel files in a folder that we don't want accessed from bots we have each the Excel files should be mapped to the ASP.NET ISAPI filter & a <deny> element should be added to the <authorization> element in the Web.config file

4120. When a firewall denies access on ports 80 & 443 we use the Secure Sockets Layer (SSL) on port 443 to expose the Web services.

8221. Databound server control that uses customized item templates & uses the DataPager we use a ListView.

8222. when subdirctories are permission based by roles & stored in a single web.config file we'd use the <location> node.

8223. Apply a theme to a page we'd use the handler for the Page.PreInit event

8224. When we store state of a shopping cart by UID the shopping cart should be stored in a user profile property.

8225. Display content in languages of users preference we use the value of the Page.UICulture property should be set to a value stored in a user profile property.

8226. Log all audit events for an app we configure the eventMappings node in the Machine.config file so that a single entry for auditing events is present for All Audits.

8227. Improve search relevancy of page URL by not having .aspx ext use an HttpModule object can be used to make sure of this.

8228 Use 3rd party db's & prevent update or delete the data tier object we choose to use OleDbDataReader

8229. Custom client side & AJAX behaviors to be added to server controls we can for each server control, a custom extender control has to be created. After add the extender controls along with the server controls in the Web forms.

8230. Validate against AD by client side script. code fragment should be added to the Web.config file of the application <authentication mode="Forms" />
configure the application, making it use the ActiveDirectoryMembershipProvider class.

8231. Implementing a master page we can:
set the MasterPageFile property on each page to the virtual path of the master page file
& configure a virtual directory within each app, and point the virtual directory to the folder containing the master page
& copy the master page into a single folder on the server

8232 Modify & update data that is retrieved from a data set. using SQLCommandBuilder the update command for related SQLDataAdapter class we'd after the UpdateCommand property of the SqlDataAdapter class is set to a SqlCommand object, we use a custom UPDATE statement and call the Update method of the SqlDataAdapter class

8233. Performance issues occur & we collect sample timings of pages. We set the enabled attribute to true and the pageOutput attribute set to false for the Web.config's trace element
Trace Element - enabled attribute = true & pageOutput attribute = false

8234 Photo sharing app to download the image, first we ascertain the request for the photo download by creating an HttpHandler class, then process photo for format & return photo

8235. DB accessed by web app, web & sql servers on separate servers we create a Web service, deploy it to the same network as the database server

8236 Application_error event: Create tracking number for errors after the exception is logged in the Application_Error event of the Global.asax file, we redirect to the customError.aspx page, pass tracking number in query string.

8237 Set up Authentication for a subdirectory add this code to the Web.config in the subdirectory.
<allow roles="TomatoSubscriber" />
<deny users="*" />

8238.Debug js by displaying fields of AJAX object in trace console in web form we choose to use Sys.Debug.traceDump

8239 Web form calls web service when page is accessed ensure two routines are called we have Async="True" attribute has to be added to the Page directive.

3440. Deploy app to server where there are more than one app is & the app is the only one that can modify certain files on the server, After the application pool is configured to use a dedicated user account, we give access for the share to the user account.

3441. AddFileDependency When a batch process updates a xml file code segment: Response.AddFileDependency(fileDependencyPath);Response.Cache.SetCacheability(HttpCacheability.Public);

3442. Create a control in VS10 toolbox we'd use a custom server control

3443. LINQ: var query =
from item in Items
where item.Books.All(b => b.Price <= 52)
select item;
All Items that have the price of the related magazine less than or equal to 52

3444. Authorization info cashed: the cookieProtection attribute should be set to Encryption in the roleManager element of the Web.config

3445. Save ViewState info in SQL we'd use the SaveStateComplete event

3446. Create UI element we'd create a custom Web control.

3447. Store sensitive data that can be viewed in db, before we store sensitive data in the database, we'd use the Advanced Encryption Standard algorithm to encrypt the data.

3448. Site uses the SiteMapPath control connected to a sitemap & we need to configure a treeview. After we configure a SiteMapDataSource control to use the XmlSiteMapProvider control, we configure the TreeView control to use the SiteMapDataSource control.

3449. Page that asks many questions & guides user though troubleshooting we'd choose to use MultiView control.

3450. Prevent bots from registering site: Implement a Completely Automated Public Turing Tests (CAPTCHA) during the reg & login
& Send confirmation e-mail to new users. Disallow new user access until user responds to the e-mail message.

3451. No profile data stored in clear text we First we create a custom profile provider. Before we store information in db, we ensure it's encrypted in the custom provider.

3452. Info able to be displayed in Excel we use the DelimitedListTraceListener class.

3453.Users able to view updates on info from site we supply a Really Simple Syndication (RSS) link adjacent to each product. And then we base the RSS feed on a Web service that returns updates for the product.

3454. Authentication using existing db w/ table of UID & PW we'd create a custom membership provider that has to be used.

3455. Users browsers specifies German we'd rename the Default.aspx.es-ES.resx file to Default.aspx.es.resx.

3456. SQL SELECT Order.OrderID
,Order.Description
,OrderDetails.UnitPrice
FROM Order JOIN OrderDetails
ON Order.OrderID = OrderDetails.OrderID
LINQ from order in db.Ordersjoin details
in db.OrderDetails onorder.OrderID
equals details.OrderIDselect
new { order.OrderID, order.Description, details.UnitPrice};

9457. Web app renders in mobile devices Add a custom browser definition file to the application App_Browsers folder.
& Configure the application code to query the Capabilities property of the Request.Browser object

9458. DataPager control ensure it has properties exposed to webpardzone controls on all pages A zonelement element should be added to the WebPartZone control on each page.
& After the DataPagerControl control is copied into a new user control, we use the @Register directive to add a reference to the new user control in each page.

9259. Ensure web form w/ link button functions in browsers w/ js disabled the LinkButton control should be replaced with an HtmlInputSubmit control

9260. Databound ddl create an XML file in the App_Data directory to represent the data in the DropDownList control & bind the XmlDataSource control to the DataSource property of the DropDownList control.

9261. Set storage for session-state the session-state values stored in the StateServer state provider

9262. Dynamically added controls used for lifetime of page event after PostBack call the Page.ParseControl() method in the PreInit event of the page.

9263. Invoke web service asynchronously & execute tasks simultaneously we invoke the RegisterAsyncTask method.

9264. Reduce SQL injection:
constrain & sanitize user input,
& use a least-privileged database account,
& use parameterized SQL statements.

9265. Dynamic Pricelist in master pages we After a custom master page is created for mobile-device browsers, modify the page that contains the price list to use device filters along with the MasterPageFile attribute of the @ Page directive.

9266. HTML stored in db & any scripts cannot be executed on browser use System.Web.HttpUtility.HtmlEncode() method

9267. Encrypt but not decrypt passwords we Encrypt passwords by using the Secure Hash algorithm before the passwords are stored in the db.

9268. Gridview using business object to select & update The DataSourceID property of the GridView control set to an ObjectDataSource instance that uses the business object.

9269. Calc time for all process requests we create and register a custom HttpModule class.

5970. Forms auth app & we make users access via AD we alter the membership provider to ActiveDirectoryMembershipProvider.

5971. Change RadioButtonLists to drop downs create a class that extends the WebControlAdapter class & register it in a browser file.

5972. Ensure VS10 automatically recognize new images added to project a Web site project we copy the files that are part of the application to the source folder of the application.

5973. Validate a user selects drop down selection that is not default selected we use RequiredFieldValidator .

5974. Control on each page at most 4 pages a SiteMapPath control added on each page, & the ParentLevelsDisplayed property set to 4

5975. App uses Forms auth & users can access sessions of other users we add to the Web.config <forms cookieless="UseCookies">

5976. Logging intermittent errors we create An event handler for the Application.Error event should be added to the Global.asax file of the app

5977. Consistent state management use ControlState

5978. Nested Masters After we create a nested master page that binds to existing master page, the reporting section-specific ContentPlaceHolder controls are added to the new master page. Then we configure content pages in the ~/Reporting folder, making it use the new master page

5979. Session State persistence we use the session-state values by using the SQLServer state provider

5980. Debug JS In IE enable script debugging

5981. Private key used to encrypt & decrypt we make use of the System.Security.ProtectedData class

5982. Data bound control built in sort we choose GridView

5983. Secure authentication cookie use a secure HTTP connection for any request that involves the transmission of an authentication cookie.

5984. ASP.NET AJAX app & a Web service returns data w/ compact format & minimum markup overhead we create a JSON Web service

5985. Implement data access for third party db's & prevents xss use parameterized SQL statements. .

5986. Web control provides data to other controls on page to third party db's use of an OleDbDataTableAdapter object.

5987. To Implement RSS we create & register a custom HttpHandler class that releases the RSS feeds & associate the HttpHandler class to the .rss extension.

5988. When page request is made provide page layouts & themes we have theme & master page have to be dynamically set in the PreInit event of each page.

Hope you enjoyed this content & the way it was presented.

That is all there will be more,

Catto

Visual studio 2010 Microsoft Event Launch Miami 4.20.10

noreply@blogger.com (Catto) — Thu, 22 Apr 2010 01:10:00 +0000

Miami Visual studio 2010 Microsoft Event Launch

Hey Now Everybody,

4.20.10 The Miami Visual studio 2010 Microsoft Event Launch. It was a fun event. I went with a two of my friends Code Monkeez & WeToddz which makes it even better. Aside from VS10 the highlight for me was seeing a the first Win7 phone in Florida.

When we got there we received a DVD of the Trial version of Visual Studio 2010 for 90 which is also available on Microsoft downloads, along with a T-Shirt & some stickers which was very nice.

We took a look at a sample web app named Blue Yonder Solutions was the demo ASP.NET application demo The two Microsoft presenters were Joe ‘DevFish’ Healy & Glenn Gordon.

Joe showed quite a few features of VS10 which he called his tackle box of vs10:

VS10 Multimonitor Support Rip Tab off
Natural Scolling
quick replace for block of code Alt+Shift+Arrow
VB Line Continuation chars are gone
Visual Studio Extentions
HTML Snippets on right click instert snippet
VB has generate method on right click of definition
Words highlighted, when one word is highlighted all the instances are highlighted
New help experience
VB Collection Initializers
C# Named & Optional Arguments
C++ Joe asked how many people using it & only 3 people raised hands
F# improvements
Office UI Customization
SharePoint Explorer (F5 run)
SharePoint 2010 Project Templates
SharePoint 2010 F5 Debugging Experience
InetlliTrace - Historical Debugging
UML / Data Diagrams
Automate UI Testing
VSTS Anywhere

We got into Silverlight a little with the Silverlight Facebook ux is better than web 1.0 sites. Silverlight is important & has started to lap WPF.
Silverlight 4 is slick since it has many rich features such as mic & webcam, multicast streaming, WCF RIA servers, Printing, Out of browser, right click/mouse wheel. There are some new controls for Silverlight to business-centric apps such as calendar, charts. Silverlight can be outof the browser, store data locally & use local resources.

When starting an empty web app there in the web config there are two config files for dev & prod for example web.debug.config web.release.config We then inspected some data access layers. We moved on to WPF where Joe built a WPF app on the fly which was pretty nice to see. He also displayed a parallel computing example by using both cpu cores. We took a break & then got back into the web development w/ vs2010. They stated web forms are far from dead & being enhanced such as dynamic data.

Glen Gordon presented a nice dynamic data web app example with a good amount of code. We spoke about MVC concepts such as how it separated concerns & is easily testable. Glen finished the session with some windows phone, he stated 3 screens and a cloud example workstation, phone & Xbox are 3 screens tied by the cloud.
Win7 phone has standardized hardware.

There was many people including some local user group leaders who announced a couple events such as Swamp Code Camp 9.25.10 (South West Fla ) Homnick's Gold Coast UG announced a meeting May 13th SQL Server 2008 Dev Exam 70-422.

For this event the room was full about There ~150 people. The live event was very enjoyable & glad I went.

That is all there will be more,
Catto

MCPD 4 Exam 70-519 Skills Measured Reviewed - Code Crackin #18

noreply@blogger.com (Catto) — Fri, 16 Apr 2010 00:27:00 +0000

Hey Now Everybody,

Microsoft .NET 4 was released Tuesday, there is a MCPD 4 beta exam 71-519 which real exam will be 70-519 that I’ve registered for. To prepare for this exam I’m going to study & start by reviewing the skills being measured on the exam. Below are is the list presented in three times each with a little more detail than the previous one. The links are some that I’ve been reading & reviewing mostly from the MSDN library. Let’s inspect what’s going to be on this brand new exam:

Skills Measured

1. Architecture
2. UX
3. Data
4. Security
5. Troubleshooting
6. Deployment

1 Designing the Application Architecture (19%)

1.1 Plan the division of application logic.
1.2 Analyze requirements and recommend a system topology.
1.3 Choose appropriate client-side technologies
1.4 Choose appropriate server-side technologies
1.5 Design state management.

2 Designing the User Experience (17%)

2.1 Design the site structure.
2.2 Plan for cross-browser and/or form factors.
2.3 Plan for globalization.

3 Designing Data Strategies and Structures (18%)

3.1 Design data access.
3.2 Design data presentation and interaction.
3.3.Plan for data validation

4 Designing Security Architecture and Implementation (17%)

4.1 Plan for operational security
4.2 Design an authentication and authorization model.
4.3 Plan for minimizing attack surfaces Input validation

5 Preparing For and Investigating Application Issues (15%)

5.1 Choose a testing methodology
5.2 Design an exception handling strategy.
5.3 Recommend an approach to debugging
5.4 Recommend an approach to performance issues

6 Designing a Deployment Strategy (14%)

6.1 Design a deployment process
6.2 Design configuration staging vs. production vs. development
6.3 Plan for scalability and reliability
6.4 Design a health monitoring strategy

Details on Skills Measured:

1 Designing the Application Architecture (19%)

1.1 Plan the division of application logic.
     Choosing between client-side and server side processing,
Planning Separation of Concern
                   partitioning functionality between controllers and evaluating business
                   & data service consumption
     planning for long-running processes
Synchronous vs. Asynchronous
1.2 Analyze requirements and recommend a system topology.
        Designing interaction between applications,
        Mapping logical design to physical implementation,
        Validating nonfunctional requirements and cross-cutting concerns
                      communications,
                      operations management
                      security
       Evaluating baseline needs
                       scale
                      quality of service
1.3 Choose appropriate client-side technologies
JavaScript
ASP.NET AJAX
jQuery
Microsoft Silverlight
1.4 Choose appropriate server-side technologies
          User controls
          Server controls
          Partials
          Custom HtmlHelper extensions
Web parts
          Inheriting controls
Dynamic data controls
1.5 Design state management.
Designing an application for the proper use of application state, session state, and request state
ex. ViewState, ControlState, Cache object, cookies, and client-side persistence

2 Designing the User Experience (17%)

2.1 Design the site structure.
     Designing application segmentation for manageability and security
           Ex. using areas, shared views, master pages, and nested master pages
     Appropriate use of style sheets
     Client-side scripting
Themes
     Client ID generation
      Rendering element modes
      Routing engine
2.2 Plan for cross-browser and/or form factors.
     Evaluating the impact on client side behaviors, themes, bandwidth, style sheets
                    (including application design - task based or scaled rendering of existing page),
     When to apply Browsers file
     Structural approaches
     User agents
     Different platforms (mobile vs. desktop)
2.3 Plan for globalization.
     Designing to support local, regional, language, or cultural preferences, including UI vs. data localization
           ex. implementing at database level or resource level
     When to use CurrentCulture vs. CurrentUICulture
     Globalization rollout plan
           ex setting base default language, planning localization
     handling Unicode data
          ex what fields to include, request encoding
     right-to-left support
     Vertical text and non-Latin topographies, calendars, data formatting, sorting

3 Designing Data Strategies and Structures (18%)

3.1 Design data access.
Choosing data access technologies such as ADO.NET Data Services, Entity Framework, Windows Communications Foundation (WCF), and ASP.NET Web Services
3.2 Design data presentation and interaction.
Pulling data from data layer and binding into views, pages, and controls, and pulling data back to data layer by using ModelBinders, data source controls, and HtmlHelper extensions, or programmatically
3.3 Plan for data validation
Contextual validation vs. data integrity, where to validate data, synchronization between UI and data layer, data annotations

4 Designing Security Architecture and Implementation (17%)

4.1 Plan for operational security
Approaches for process- and resource-level security, including local and remote resources, Code Access Security (CAS), including trust level, process identity, application pool, and identity tag
4.2 Design an authentication and authorization model.
     Authentication providers, including WindowsForms, and custom user identity flowthrough
            ex trusted subsystem
     role management
     membership providers
     URL authorization
           ex AuthorizationAttribute
     File authorization, Authorization Manager (AzMan)
4.3 Plan for minimizing attack surfaces
Input validation
Throttling inputs
Request filtering
Where to use Secure Sockets Layer (SSL)

5 Preparing For and Investigating Application Issues (15%)

5.1 Choose a testing methodology
black box, white box, integration, regression, coverage, API testing, performance testing, security testing
5.2 Design an exception handling strategy.
HandleError attribute in MVC, common error pages, post-error processing, global vs. page level
5.3 Recommend an approach to debugging
Tools and approaches for a given scenario
(for example, memory dumps, DebuggingAttributes, crashes vs. hangs, deadlocks, assembly binding), when to attach to process (Visual Studio Development Server vs. IIS vs. Internet Explorer), root cause analysis\
5.4 Recommend an approach to performance issues
Which instrumentation to watch or create
(including performance counters and event tracing) to analyze performance issues, page and fragment caching

6 Designing a Deployment Strategy (14%)

6.1 Design a deployment process.
Windows Installer (MSI) vs. xcopy vs. Web Deployment Tool, scaling, rolling deployments
6.2 Design configuration management
Using the ConfigSource attribute
(for example, connection strings),
staging vs. production vs. development, topologies, machine.config vs. web.config, using IIS vs. Visual Studio Development Server during development, application pools, configuration inheritance
6.3 Plan for scalability and reliability
scaling up, scaling out, at physical level and at architectural level, impact of offloading technologies on load balancing, including state, synchronizing machine and encryption keys
6.4 Design a health monitoring strategy
When to monitor application or business-related events (e.g., on UI every time clicked or in business layer), determining a strategy for using ASP.NET Health Monitoring, throttling, filtering, delivery method

Here is a link to the official Microsoft page of the skills measured.

Unfortunately there is no official Microsoft Self Paced Training Kit for this exam, therefore I’m going to continue to review this material. There we have it we now understand & reviewed the skills measured in to 70-519 MCPD 4 Web Dev exam.

That is all there will be more,

Catto

VS10 & .NET 4 Install Adventures Code Crackin #17

noreply@blogger.com (Catto) — Tue, 13 Apr 2010 03:34:00 +0000

Hey Now Everybody,

Today is the day we all know what was released today right.. Adobe's new tool?? Maybe but more importantly to us devs is Visual Studio 2010 & .NET 4. It’s the most important tool for me & fun that it’s released today & to install it. Here are some thoughts on the topic & the install.

First off Channel 9 & Microsoft/visualstuio had a great streaming video's all day today which were stellar even a live DNR be sure to check it out.
first we could choose what bits to download, we could use web installer or download files for iso. I prefer an an iso since then the dvd can be burned & kept. Download 4 files ~2500kb place them all in the same folder & exe the first file then they will extract & create an iso. Right click the iso file select open with, then windows disc image burner (win7 tool) or what ever iso burner of your choice.

Once you enter the iso disc in the drive choose the auto run.
Install Screens
1 Install - The first screen has install vs2010.
2 Legal - Then we accept all the legal terms of MIcrosoft click next
3 Custom - We can choose to custom install, I deselected c++ since I just wanted to install it faster & it was a third less of the footprint ~4g.
4 Then it installs brings us to a progress bar & install everything such as the VC Runtime, .NET4, TFS Object, VS2010 Ultimate, Multi-Targeting pack, ASP.NET MVC 2 SL3SDK, Then we click next
5 Success Click Finish - we could also view the install doc & link to 'Visual Studio Gallery' which is nice(where spell checker is)

& o ya, let's select our default view web dev (code only), & I got an error that read. ‘The type initialize for ‘<Module>’ threw an exception. ‘ I clicked ok & it opened the same window then I clicked ok again &

Then I research a little & saw a q/a post about some c++ item. I ran autostart.exe again, then we are prompted w/ 3 choices:

1. Add remove features
2. Uninstall
3. Some other option I didn’t choose

So I installed C++ files, restarted but still same error. I’m going have to put more time in tomorrow. The cause maybe I tried to install the RC on this PC before but it didn’t install all the way. I can uninstall it since it’s not in the uninstall programs. Therefore my plan is to install Windows 7 fresh & attempt to install VS10 again.

VS10 is great for the following reasons this is kinda off the top of my head while installing so the order & items may change over time:

0.5 Chart Server Controls - nice kinda 3.5 very useful framework
1. Debugging: IntelliTrace: we can DVR debug meaning we can debug forward & backward.
2. Multimonitor Support - nice to be able to rip a tab off & have code on two screens
3. C# Optional Parameters in .NET 4 - Nice new feature since it's a feature we'll use.
4. MVC 2 - Nice for a green project, it's been fun to learn look Ma no code behind
5. CSS Friendly Controls Layouts - This is a real feature that we can use, the menu will now work for webkit .. sweet! Tx Phil Haack
6. New application templates - It's nice to be able to start an app with masterpages, css AJAX, JQuery all included
7. Code View, provides more real estate with out source & design tab
8. Deploying Project Improvements - We have to deploy for our users
9. Spell Check (add in) - even though this is an addin it's a nifty useful tool
10. TFS2010 - Version control of today, Team Foundation is also available for download.
11. Natural Scrolling - For large font peeps like me we can just Ctrl+scroll wheel
12. Silverlight 3 SDK - Yes we can just download this for VS08, yet this is the future Silverlight 3 out of browser is so slick.
13. Multiple Framework Version Targeting - Of course we expect to target multi framework & we can
14. Themes & customization - I enjoy skinning my apps & not just default white background.
15. Design View Improvements - The design view is better than VS08 it'll be great when we have AJAX in design as a default in studio, 10 is better than 08 in this category.
16. ADO.NEt EF Tools - Working with data is so fun, EF4 is here

The .NET 4 Framework is installed in C:\Windows\Microsoft.NET\Framework\v4.0.30319.

There we have it Visual Studio 2010 & .NET needs a little more time to be Installed, whoo haa!

That is all there will be more,

Catto

Prep & Take Exam 71-515 .NET 4 ASP.NET Web Dev - Code Crackin #16

noreply@blogger.com (Catto) — Mon, 12 Apr 2010 00:23:00 +0000

Hey Now Everybody,

For quite some time I’ve prepared to take the Microsoft .NET 4 Web Dev Exam 71-515, on Saturday April 10th 2010 I took the exam. It was a great experience that I’ve learned a lot & enjoyed it. The beta exam is great since it’s free to take. The exam was longer 85 questions (not 40) & it was 170 minutes (not 120 min). Below is a summary of my preparation for the exam.

The exam 71-515 is a beta for the exam 70-515. It's the web dev for .NET 4. The web dev .NET 3.5 exam is 70-562 & here the two are compared. The skills measured for the exam are listed officially by Microsoft also here is a summary:

1 Developing Web Forms Pages (19%)

1.1 Configure Web Forms pages.
1.2 Implement master pages & themes.
1.3 Implement globalization.
1.4 Handle page life cycle events.
1.5 Implement caching.
1.6 Manage state.

2 Developing and Using Web Forms Controls (18%)

2.1 Validate user input.
2.2 Create page layout.
2.3 Implement user controls.
2.4 Implement server controls.
2.5 Manipulate user interface controls from code-behind.

3 Implementing Client-Side Scripting and AJAX (16%)

3.1 Add dynamic features to a page by using JavaScript.
3.2 Alter a page dynamically by manipulating the DOM.
3.3 Handle JavaScript events.
3.4 Implement ASP.NET AJAX.
3.5 Implement AJAX by using jQuery.

4 Configuring and Extending a Web Application (15%)

4.1 Configure authentication & authorization.
4.2 Configure providers.
4.3 Create and configure HttpHandlers and HttpModules.
4.4 Configure initialization and error handling.
4.5 Reference and configure ASMX and WCF services.
4.6 Configure projects and solutions, and reference assemblies.
4.7 Debug a Web application.
4.8 Deploy a Web application.

5 Displaying and Manipulating Data (19%)

5.1 Implement data-bound controls.
5.2 Implement DataSource controls.
5.3 Query and manipulate data by using LINQ.
5.4 Create and consume a data service.
5.5 Create and configure a Dynamic Data project.

6 Developing a Web Application by Using ASP.NET MVC 2 (13%)

6.1 Create custom routes.
6.2 Create controllers & actions.
6.3 Structure an ASP.NET MVC application.
6.4 Create and customize views.

Here is a list of good flix too along with a summary of them.

Also the WhitePaper & Scott Gu have some good .NET 4 content

Hope this helps provide info about the 71-515 exam,

The next 40 days I’m breaking up into two 20 day sections, the first focusing on the MCPD ASP.NET 4 exam & going to prepare & take that beta exam. Then changing focus to the SQL Server 2008 Developer exam. The content is great to study & learn.

That is all there is & there will be more,

Catto

.NET 4 ASP.NET ‘Video’s Overview’ 70-515 Exam Prep ASP.NET – Catto Code Crackin #15

noreply@blogger.com (Catto) — Thu, 01 Apr 2010 01:58:00 +0000

Hey Now Everybody,

In this 15^th post of the Catto Code Crackin series we’ll continue with the section ‘‘Video’s Overview’ Now that we’ve covered each section in detail I wanted to continue studying by taking a step back & review some highlights from ASP.NET 4 & VS10. Let’s look @ some of the top new features. WWW.ASP.NET is a great site for learning & flix are great to learn from. This is a summary of the videos from the offcial ASP.NET site.

Microsoft announced the .NET 4.0 Beta Exams on St. Patrick’s Day which are a free exam & if passed you get certified. Much of the study & prep materials are not available yet, therefore I’ve been studying for a similar exam 70-562 which is the .NET 3.5 ASP.NET Application Development. I hope by posting this content it will help myself along with other people in the community learn & get excited about .NET 4. If you are serious about studying for a MS Exam 2 must have resources: the Microsoft Self Paced training books are a great books to buy along with practice exams from eBay

This series of short videos introduces you to the new features of ASP.NET 4 & VS10

ASP.NET 4 Below are all the video’s & then a summary of them:

#13 | Persistent GridView Row Selection
#14 | Table Free Templated Controls
#15 | Easy State Compression
#16 | Tableless Menu Control
#17 | Imperative JavaScript Syntax for Microsoft Client Side Controls
#18 | The ScriptLoader
#19 | jQuery Syntax for Microsoft Ajax
#20 | AJAX Data Templates
#21 | Hidden Field Divs
#22 | Disabled Control Styling
Vs10
23 Code Optimized Profile
24 Code Search View Hierarchy
25 IntelliSense Smart Lists
26 Multi-Monitor Support
27 New Web Project Template
28 New Multi-Targeting
29 Websites Instead of Web Projects
30 Snippets IntelliSense
31 Use MSBuild to Automate the Compiler & 32 Merge Utilities

#1 | Chart Control
chart control in data catagorie form toolbox can use data source
Attributes Type such as bar, x & Y value member X such as title & Y # of sales
#2 | Dynamic Metadata – SEO uses MetaData
say the string contains the value we want
page.metadescription = “blah”;
page.metakeywords = “tomato ” & stringsstateId;
#3 | Permanent Redirect
Good since inbound traffic changes entry points for example a sub domain may change.
from the old page page_load event enter response.redirectpermanat(“~/newpage”);
http301
#4 | Imperative WebForms Routing – Imperative by code behind Allows clean URLs
old dirty release /Projectrelease.aspx?releaseid=33804
Good Clean downloads/realease/33804
using system.web.routing
add method
void registerTomatoRoutes(routecollection routes)
{
routes.mapPageRoute(
“list-show”
, “list/(type) “
, “list.aspx”
);
}
Void application_start(object sender, eventargs e )
( RegisterRoutes(routetables.routes);

The;n on asp.x page create link button w/ postbackURL=”~/list/people”>list / people <asp:linkbutton>

)
#5 | Declarative WebForms Routing – clean URLs global.aspx.cs enter route definition
#6 | Outbound WebForms Routing
#7 | Auto Start – specify windows/system / application host application pool always running needs to be set startmode=”AlwaysRunning” > then
2 set application to be prewarmed application host.config
‘we can pre warm cashe’ - there are a few steps for this one.
windows /system32 / inet serv config / choose app pool & set always running

C:\WINDOWS\system32\inetsrv
2 then in sites set two parms - service auto start enable = true
3 just below added serviceautostartproviders section

Then in application we created a class system.web

Specified a method preload & performed tasks on load
#8 | Clean Web.Config Files
only two enteries
#9 | Predictable Client IDs templated controls such as listview create datasource such as xml datasource then specify xpath ;
it’s a more straight forward programming model when we manipulate dom of server side controls
#10 | Selective View State – selectable view state options add placeholder control inside place label enableviewstate=”false” or enableviewstate=”true” for some controls
#11 | The HtmlEncoder Utility Method - put a button & label on page in button click event when untrusted stuff like script injection , or allow html to be displayed like if we wanted to display a code snippet on a page. This is why we’d use it. Run input threw a method to make sure it’s ran threw the utility method then it’s more secure
string untrustedInput = httputility.htmlEncode(“<script>altert(?);</script>”)
label1.text = untrusted string
#12 | New Rendering Option for Check Box Lists and Radio Button Lists
common theme in asp.net stills supports old version but us pretty ul not tables & spans
repeat layout property can be table, unordered list , or ordered list <ul> or <ol>

#13 | Persistent GridView Row Selection – after grid is wired up
when we select a row in the grid then switch page the row on the other enablepersistentSelect = “true” so if we select the fourth row then switch page the fourth row is not selected on page 2.
#14 | Table Free Templated Controls
some formview control w/ datasource uses tables by default <table> <tr> can be changed by renderoutertable = “false” this makes it not tables but removes the auto format style of the control
#15 | Easy State Compression – gets better performance on application. In web.config
<sessionState mode = “true”
add this one more - compressionenables = “true”>
#16 | Tableless Menu Control
Mneu property Rendering Mode change from table to List,
#17 | Imperative JavaScript Syntax for Microsoft Client Side Controls -
uses script loading need script files such as css sheet
lot’s of hoops to explain this topic
#18 | The ScriptLoader - great new feature use imperative syntax
sys.onread ? create an unordered list in javascrpt
#19 | jQuery Syntax for Microsoft Ajax interesting new feature drop scripts folder in project & add web form then add css folder. Used watermark control
#20 | AJAX Data Templates – used a web service
#21 | Hidden Field Divs - there is a div class on the hidden filed that we can style
DIV# aspentHidden
in css file :
{
Border: 0;
}

#22 | Disabled Control Styling – cool new feature for disabled fields. Ex Add textbox 2 buttons one button enables & the other disables the text box then the style of the textbox can differ suing the css below: new default css class any control that state is disabled
.aspnetDisabled
{
background-color: orange;
}

http://www.asp.net/learn/vs2010-quick-hit-videos/video-8774.aspx
23 Code Optimized Profile tools import & export settings web developer profile no toolbar icons & no tabs for design view tools options general chkbox for ‘enable design view’
24 Code Search View Hierarchy hightlight a word then press ctrl + , all the places will be displayed. If no word hightlighted hten ctrl + , we get intelligent search results kinda fuzzy search logic. Pascal case searching AMS (needs UPPER_case / caps) increase productivity for navigation
25 IntelliSense Smart Lists use of gridview code behind file gridview1. when intesllisence pops up there is contains search logic not just begins with search login for intellisense.
26 Multi-Monitor Support Nice just right click on the tab to rip it off!
27 New Web Project Template – The web project template is nice new to start kinda like the MVC one.
28 New Multi-Targeting – Of course we can target different versions of the framework.
29 Websites Instead of Web Projects – Opening websites is different in vs10 since there is no open web site
30 Snippets IntelliSense Improves our performance
31 use MSBuild to automate the ASP.NET Compiler & Merge Utilities

----------------------------------------------------------------------

Next up I’m really leaning to get into some more code & or review some of the training kit from Microsoft Downloads again. What do you think?

That is all, there will be more,

Catto

.NET 4 ASP.NET ‘Skills Overview’ 70-515 Exam Prep ASP.NET – Catto Code Crackin #14

noreply@blogger.com (Catto) — Wed, 31 Mar 2010 02:03:00 +0000

Hey Now Everybody,

In this 14^th post of the Catto Code Crackin series we’ll continue with the section ‘‘Skills Overview. Now that we’ve covered each section in detail I wanted to continue studying by taking a step back & look @ the skills measured in general. I looked at the MSDN library again for a while to obtain links along w/ links to my previous posts.

Skills Being Measured

This exam measures your ability to accomplish the technical tasks listed below.

1 Developing Web Forms Pages (19%)

* 1.1 Configure Web Forms pages.
* 1.2 Implement master pages & themes.
* 1.3 Implement globalization.
* 1.4 Handle page life cycle events.
* 1.5 Implement caching.
* 1.6 Manage state.

2 Developing and Using Web Forms Controls (18%)

* 2.1 Validate user input.
* 2.2 Create page layout.
* 2.3 Implement user controls.
* 2.4 Implement server controls.
* 2.5 Manipulate user interface controls from code-behind.

3 Implementing Client-Side Scripting and AJAX (16%)

* 3.1 Add dynamic features to a page by using JavaScript.
* 3.2 Alter a page dynamically by manipulating the DOM.
* 3.3 Handle JavaScript events.
* 3.4 mplement ASP.NET AJAX.
* 3.5 Implement AJAX by using jQuery.

4 Configuring and Extending a Web Application (15%)

* 4.1 Configure authentication & authorization.
* 4.2 Configure providers.
* 4.3 Create and configure HttpHandlers and HttpModules.
* 4.4 Configure initialization and error handling.
* 4.5 Reference and configure ASMX and WCF services.
* 4.6 Configure projects and solutions, and reference assemblies.
* 4.7 Debug a Web application.
* 4.8 Deploy a Web application.

5 Displaying and Manipulating Data (19%)

* 5.1 Implement data-bound controls.
* 5.2 Implement DataSource controls.
* 5.3 Query and manipulate data by using LINQ.
* 5.4 Create and consume a data service.
* 5.5 Create and configure a Dynamic Data project.

6 Developing a Web Application by Using ASP.NET MVC 2 (13%)

* 6.1 Create custom routes.
* 6.2 Create controllers & actions.
* 6.3 Structure an ASP.NET MVC application.
* 6.4 Create and customize views.

After viewing this it could be a good time to focus more on code for some of the next few posts. What do you think?

That is all there will be more,

CCatto

.NET 4 ASP.NET ‘Developing Web Forms Pages’ 70-515 Exam Prep ASP.NET – Catto Code Crackin #13

noreply@blogger.com (Catto) — Tue, 30 Mar 2010 09:52:00 +0000

Hey Now Everybody,

.NET 4 ASP.NET ‘Developing Web Forms Pages’ 70-515 Exam Prep ASP.NET – Catto Code Crackin #13

Hey Now Everybody,

In this 13^th post of the Catto Code Crackin series we’ll continue with the section ‘‘Developing Web Forms Pages’. This is the first section in the objectives but it’s the last one I chose to cover. In the .NET 3.5 Configuring and Deploying Web Applications (10 percent). In the .NET 4 exam the section is listed as ~19%.

.NET 4 - Key Objectives

Configure Web Forms

Implement Master pages & Themes

Globalization

Page Life Cycle

Cashing

Managing State

Here are the official skills measured for the 70-515:

Developing Web Forms Pages (19%)

Configure Web Forms pages.
This objective may include but is not limited to:
Implement master pages and themes.
This objective may include but is not limited to:
Implement globalization
This objective may include but is not limited to:
Handle page life cycle events
This objective may include but is not limited to:
- IsPostback
  - How to: Determine How ASP.NET Web Pages Were Invoked
- IsValid
  - How to: Disable Validation for ASP.NET Server Controls
  - How to: Display Server Side Custom Validation Messages for ASP.NET Server Controls
- dynamically creating controls
  - PlaceHolder
  - Dynamic Web Server Controls and View State
- control availability within the page life cycle
- accessing control values on postback
- overriding page events
  - PreInit
  - Init
  - InitComplete
  - PreLoad
  - Load
  - LoadComplete
  - PreRender
  - PreRenderComplete
  - SaveStateComplete
  - Render
  - Unload
Implement caching.
This objective may include but is not limited to:
Manage state.
This objective may include but is not limited to:
- server-side technologies
- client-side technologies
- configuring session state
- session state compression
- persisting data by using ViewState
- compressing ViewState
- moving ViewState

Let’s continue with some key points on these topics from the 3.5 book:

Master Pages:

Master pages provide templates that you can use to create consistent web pages though out an app.

To use master pages, create a master page & add site layout info & other common elements. Add 1 or more multiple ContentPlaceholder controls to the master page.

To create the content pages, add standard web forms to our site and select the Select Master Page check box when creating the page. Then add content inside the content placeholder control.

To reference public properties in a master page, add the @ MasterType declaration to the content page & reference the property using the Master<propertyname> to reference controls in a master page call the Master.FindControl from the content page.

Nested Master pages fit into the ContentPlaceHolder controls on a master page but can contain other content pages. To create a nested master page, add a master attribute to the @ Master page declaration & specify the parent master page.

To programmatically change the master page for a content page, set the page’s MasterPageFile property & reload the page.

Web parts

Web parts are controls that you create using custom controls that implement the web part class or stand user controls & ASP.ENT contrls. Web Parts are aslo managed b ASP.NET which allows users to close , minimize, move & edit them.

To enable users to edit or rearrange eb parts, you change the displaymode property of the webPartManager contrl on our page

Web Parts can be connected to enable them to share data. We do so by defining both consumer & provider web parts using the attribute-based programming medel Also we configure the connections between web parts by adding a <staticConnections> element in the WebPartManager contorl

To add web parts to a page add a WebPartManager control to the top of the page add WebPartZone containers to the page & then add controls to the WEbPartZone Containers.

Themes 5.2

To create a theme add an App+Themes subfolder to our app. Then for each theme in your site add a folder. The folders name becomes the name of your theme. Blog Engine .NET is a good example of this.

Themes contain skin files, a style sheet, images & other resouces.

We can apply a theme at the page level or site level thought the web.config at the individual control level.

Intrinsic Objects:

You can use the Request object to examine detail of the client web browser’s request to the web server, including the request headers, cookies client certificate, query string & more. You can use the Response objecdt to send data directly to the client w/out using standard ASP.NET server controls. You can use Server object’s static methods to perform of HTML & URL data. The context object provides several unique methods for adding errors & enabling debugging.

You can use the Browser object to determine the client Web Browser type & whether it supports cookies, ActiveX, JS, & other capabilities that can affect its ability to render your web pages correctly.

Use the Page Header.StyleSheet object to dynamically set the page style sheet including info such as the bg color & use the Page.HeaderTitle object to dynamically set the page title

Business Objects & Utility classes

ASP.NET 3.5 supports the file system web site type. This is good option when IIS is not installed on the dev’s pc & the developer wants to create a Web site w/out the use of remote web server.

ASP.NET 3.5 supports the FTP web site types. This option can be used when building a web site that is being hosted on a remote pc that does not have front page server extensions installed.

ASP.NET 3.5 supports the HTTP web site type. This option is a good choice when IIS is installed on a dev’s pc or on a remote server w/ Front Page Server extensions installed.

FTP in ASP.NET 3.5 active mode is the default. However, passive mode can solve communication problems when the client has to go through a firewall.

ASP.NET supports 2 programming models for pages. Single file & code behind . With the single file programming model all of the web page markup & code are in a single file. With the code behind model, the server side code is separate from the markup & put into a separate file such as.cs or .vb.

In ASP.NET 3.5 dynamic complication refers to the delayed complication of pages that taks place when a user requests a page.

ASP.NET 3.5 defines several folders. When a new site is created, the App_data folder is created by default. It can contain a SQL Server database, XML data file that will be used in the site.

A browser is used to make requests to a server. It renders HTML to the user, collects data from the user, & sends data back to the server. The server is responsible for accepting a resource request & sending the appropriate response. The communication between browser & server is done via the text-based communication protocol HTTP.

ASP.NET 4 supports 3 web site types: file system, FTP & HTTP

ASP.NET 4 supports two programming models for pages: single file & code behind

Visual Studio allows us to select a programming language for each web page.

ASP.NET 4 uses a hierarchy of config files that can be modified to manage the settings of an app.

ASP.NET pages have a defined cycle that determines how ASP.NET will process the page, call events, & collect data to the page.

ViewState is the mechanism by which web page object & child control object data can be maintained between page request.

A server control is a control that is programmable by writing server-side code to respond to events from the control.

Server controls contain runat=”server”

State Management

Use client side management when scalability is the top priority Use of server side state management when data must be better protected or when bandwidth is a significant issue.

ASP.NET uses view state by default to store info about controls in a web form. We can add custom values to view state by accessing the ViewState collection.

Use control state when a custom control cannot function with view state disabled.

Use hidden fields to store data in forms when view state is disabled. Hidden fields values are available to users as plaintext in the HTML.

Cookies store data on the client that the web browser submits with every web page request. Use cookies to track users track users across multiple pages.

Query Strings store small pieces of info in a hyperlink’s URL. The query strings when you want state management data to be bookmarked such as displaying multiple pages of search results.

Web site programmability

You can catch unhandled exceptions at the page level by responding to Page_Error or at the app level by responding to Application_Error. In either event handler, you read the last error by calling Server.GetLastError. Then you must remove it from the queue by calling Server.ClearError.

You can call WEbConfigurationManager.GetSection to return a configuration section from the web.config file. You cast the returned object to the section specific type. If you make an update to the conf strings write the changes by calling configuration.Save or Configuration.SaveAs

Config App Pools & Compile Application;
Deploying, Configuring & Cashing Applications

Web setup Project allow us to create executable setup.exe files & windows installer packages (.msi ) that admins can use to easily deploy our apps to a server

The copy web tool can synchronize a web site between a server & our local pc. This is useful if we want to do deployment testing on our local pc and then upload the website to a server. The copy web tool can also be useful in environments with multiple developers since it detects versioning conflicts.

Precompiling a web app removes the delay that occurs when a ASP.NET compiles an application after the first user request. Use the web site publish tool to precompile a web app. The web site publish too l in located in the build menu. We then select the destination such as FTP or local IIS. There are a couple of options worth noting for this such as the ‘Allow this precompiled site to be updated, ‘use fixed named & single page assemblies’ & ‘enable strong naming on precompiled assemblies’

’We can use the Cashe object to store data of any types. You can then access the cached data from other web pages in our app. The cashe object is an excellent way to reduce the # of db’s calls & file reads. Use the Cashe Add & Cashe.Insert methods to add an object to the cashe with dependency to ensure the cashed object does not become stale.

Page output cashing stores a copy of rendered page in the servers memory. Subsequent requests for a given resources are served from memory page Output caching practically eliminates rendering time.

User Profiles, Authorization, Authentication

We can configure user profiles using the web.config file & the <profile> element. We add fields to this element based on which data elements we intend to track users on our site.

ASP.NET automatically creates strongly typed objects based on our profile filed settings in the web.config file. We can access this calss & it’s properties through the Profile <fieldname> syntax in our code.

We call the profile.Save method to save users profile to the db

By default, ASP.NET uses the SQLProfileProvider to store & retrieve user profile information to a SQL Server db called aspnetdb.mdf . We can change the db to connect to a SQL Server db by eding the connection strings.

Exam Questions Concepts:

1 - Unless you specifically narrow the scope, the user's browser submits information stored in a cookie to every page on your site. Therefore, each page processes the user preference information. If you configure the cookie expiration to make it persistent, the browser submits the cookie the next time the user visits your site.

2 - Storing user name & password. Server-side state management provides better security for confidential information by reducing the number of times the information is transmitted across the network.

3 When you have a web part and want another web part to connect to it you should apply the ConnectionProvider attribute to a public method to allow consumers to access the method.

4 The Application object allows you to store data that is scoped at the application level and therefore available to all users.

5 Guidelines that ASP.NET provides automated testing for the following:

Visual Studio can automatically test Web applications for compliance with WCAG Priority 1 guidelines.

Visual Studio can automatically test Web applications for compliance with WCAG Priority 2 guidelines.

Visual Studio automatically tests Web applications for compliance with Section 508 guidelines.

5 Catch unhandled exceptions in an app by:

catch errors at the page level by trapping the Page_Error method.

catch application-wide, unhandled errors by trapping the Application_Error method inside the Global.asax file.

6 View state is the simplest way to store this information. Because it is enabled by default, you might not need to write any code to support state management for your form.

7 Log data to a db when a users session logged out. Respond to the Session_End event. The Session_End event handler is called when a user's session times out. However, this event will not fire in the event of the server being shut off unexpectedly or if the SessionState mode is not set to InProc.

8 Visual Studio provides an editor for the (Expressions) property that enables you to link any other property to a global resource.

9 A master page cannot be a web part but a control could be

10 The IsPostBack property indicates if the client is sending data as part of its request (true) or the page is simply being requested for display (false).

11 You can use the Cache.Insert method to add an object to the cache and specify one or more dependencies, including an expiration time span.

12 Dynamically change master page use the page_PreInit event. Page_PreInit is the last opportunity to change the master page. After this event, the page binds with the master page, preventing you from changing it.

13 The @ MasterType declaration is required to access the properties in the master page.

Content pages must have a MasterPageFile attribute in the @ Page declaration that points to the master page.

14 Themes can be specified in the Page_PreInit event

15. Store a value indicating whether a user is authenticated or not can be stored in session. This prevents the user from hackin with the data.

16 ASP.NET uses the Image.AlternateText parameter to create the alt text for an image. Screen readers typically describe images using the alt text.

DescriptionUrl links to an HTML page that provides a long description of an image. ASP.NET uses this link to create the longdesc HTML attribute.

17 The Flush method sends the current output to the client without ending the response.

18 Server.GetLastError retrieves the most recent error message. After processing it, you call Server.ClearError to remove the error from the queue.

19 The Global.asax file allows you to trap special events such as the Application_Start event.

20 Query strings are stored in the URL. Although they are not the easiest type of client-side state management to implement, they are the only way to enable state management data to be easily bookmarked and e-mailed.

21 The SiteMap class will allow you to load the given site map file and work with the data contained inside.

22 You can make a Cache object expire after a specific time span or at a specific time.

23 PreInit event is where we can store our dynamically generated controls.

24 The SiteMapPath will automatically pick up a site map file and display its contents to a user.

25 Skin files <asp:Label runat="server" BackColor="#FFE0C0" ForeColor="Red"></asp:Label> have not ID attribute

26 Track non confidential info - Client-side state management is an excellent choice for storing nonconfidential information. It is much easier to implement than server-side state management when multiple Web servers are involved, and it minimizes load on the servers.

27 The Page.Server.Transfer method transfers the page processing to another page without calling back to the client.

28 Creating & writing file on serve is indicated by the HTTP verb – PUT..

29 Themes will override attributes directly on a control:
A theme specified using @ Page Theme="MyTomatoTheme"
<pages Theme="themeNameTomato"> element in the Web.config file

30. Retrieve current cookie config settings
HttpCookiesSection section = (HttpCookiesSection)
WebConfigurationManager.GetSection("system.web/httpCookies");

31 The Response object contains methods such as Response.Cache.SetExpires and Response.AddCacheDependency that enable you to configure page output caching programmatically.

32 Configuring IIS to use worker process isolation mode allows you to create application pools.
33 The Publish dialog box allows you to precompile a Web site. It also allows you to publish from your development server.

34 Windows Authentication: The only step you need to take to enable the user's credentials to be passed to the database server is to enable impersonation

35 To configure the app pool to shut down & restart on a specific time we can add the time to the Recycle Worker Processes At The Following Times list on the Recycling tab of the application pool Properties dialog box to ensure that the process is recycled at a specific time.

36 With an ASP.NET Web Application project you can use the Publish Web dialog box to publish a Web application.

37 We want to rely on ASP.NET dynamic compilation for iterative modifications Create an ASP.NET Web site if you want to rely on ASP.NET dynamic compilation for iterative modifications. The Build command compiles Web site projects only to test them. To run Web sites, you can deploy source files and rely on ASP.NET dynamic compilation to compile pages and classes in the application.

38 Publish Dialog Box: Clear the Allow This Precompiled Site To Be Updatable check box to ensure that pages cannot be updated on the Web server.
39 The ASP.NET Merge tool (Aspnet_merge.exe) enables us to combine and manage assemblies that are created by the ASP.NET Compilation tool (Aspnet_compiler.exe). The ASP.NET Merge tool provides additional flexibility when you precompile the Web site beyond what you can achieve with the ASP.NET Compilation tool alone.

40 We need to configure session state to allow state to be shared across servers. StateServer mode stores session state in a separate process called the ASP.NET State Service. This ensures that session state is preserved if the Web application is restarted and also makes session state available to multiple Web servers in a Web farm.

SQLServer mode stores session state in a SQL Server database. This ensures that session state is preserved if the Web application is restarted and also makes session state available to multiple Web servers in a Web farm.

41 Session state stores state management information on the server and tracks a user with a single cookie. Session state is ideal for scenarios such as this because it tracks a user's information for a single visit across multiple Web pages.

42 Given integrated Windows IIS authentication, Windows ASP.NET authentication, and ASP.NET impersonation, ASP.NET will assume the client identity. You must add the accounts of the users requesting the Web page to the database.

43 We must define a membership provider to indicate the membership information store. Designate a membership provider by setting the defaultProvider attribute of the membership element to AspNetSqlProvider.

44 When users access the web app by a browser with cookies disabled. The state mode should be configured as cookieless and using InProc mode.

45 We can easily determine whether a user is in a specific role by calling Roles.IsUserInRole. Alternatively, you can call Roles.GetRolesForUser and iterate through each role to determine user membership.

46 If ASP.NET Windows authentication is configured, we must configure IIS Basic, Digest, or Integrated Windows authentication., We cannot use Integrated Windows authentication if users must authenticate through a firewall.

47 The assembly must be manually copied to the local Bin folder. Referencing from the GAC and configuring Copy Local no longer works in Visual Studio 2008.

48 If we are using a database (SQL Server ), we must run Aspnet_regsql.exe, which is found in %windows%\Microsoft .NET\Framework\<version>. When you run the tool, we specify the -Ap option.

49 With an ASP.NET Web Application project we have complete control of the project's structure, namespaces, and compilation.

50 Digest authentication, as well as Integrated Windows authentication or Basic authentication, support only Windows authentication.

51 Windows authentication can automatically authenticate users to either the Active Directory domain or the local user database. The user's browser can submit the credentials he or she used to log in to his or her computer without prompting the user for a user name and password.

52 The ASP.NET Compilation tool (Aspnet_compiler.exe) enables us to compile an ASP.NET Web application, either in place or for deployment to a target location such as a production server. In-place compilation helps application performance because end users do not encounter a delay on the first request to the application while the application is compiled. We can provide Aspnet_compiler options to prevent the copy of .aspx files.

----------------------------------------------------

Let’s continue with some Code

State Management code:

ASPX

<div>
Default Page 2 <br />
<asp:Label ID="LabelApplicationClicks" runat="server" Text="Label"></asp:Label>
<br />
<asp:Label ID="LabelSessionClicks" runat="server" Text="Label"></asp:Label>
<br />
<asp:HyperLink ID="HyperLinkPage1" runat="server" NavigateUrl="~/Default.aspx">HyperLink</asp:HyperLink>
</div>

.cs

public partial class Default2 : System.Web.UI.Page

{
protected void Page_Load(object sender, EventArgs e)
{
Application.Lock();
Application["clicks"] = ((int)Application["clicks"]) + 1;
Application.UnLock();
LabelApplicationClicks.Text = "Application clicks: " +
Application["clicks"].ToString();
Session["session_clicks"] =
(int)Session["session_clicks"] + 1;
LabelSessionClicks.Text = "Session clicks: "
+ Session["session_clicks"].ToString();
}

Xml file web.config for users & roles:

<?xml version="1.0" encoding="utf-8"?>  
<configuration>   
<system.web>   
<authorization>   
<allow roles="Administrators" />   
<deny users="*" />   
</authorization>   
</system.web>   
</configuration>

So we’ve reviewed the Programming Web Applications section & seen some important topics such as appearance, state, layout along with others.

Wow in the 13 posts we covered quite a bit. I think maybe the next posts can be just a random material or more code focused or a summary. We’ll soon find out. Hope your enjoying studying & learning the content like me. What do you think?

That is all there will be more,

Catto

.NET 4 ASP.NET (da Gu’s & whitepaper) 70-515 Exam Prep Catto Code Crackin #12

noreply@blogger.com (Catto) — Tue, 30 Mar 2010 01:48:00 +0000

Hey Now,

In this 12^th post of the Catto Code Crackin series we’ll continue with the section ‘da Gu & WhitePaper’. In .NET 4 there are many new features. I wanted to take a break from the book so I figured let’s check out what da Gu posted on the new .NET 4 features & the official whitepaper.

Microsoft announced the .NET 4.0 Beta Exams on St. Patrick’s Day which are a free exam & if passed you get certified. Much of the study & prep materials are not available yet, therefore I’ve been studying for a similar exam 70-562 which is the .NET 3.5 ASP.NET Application Development. I hope by posting this content it will help myself along with other people in the community learn & get excited about .NET 4. If you are serious about studying for a MS Exam 2 must have resources: the Self Paced training books are a great books to buy along with practice exams from eBay.

Da Gu’s Blog post

1. Multiple Monitor Support
2. Built-in Charting Controls for ASP.NET and Windows Forms
3. URL Routing with ASP.NET 4 Web Forms
4. SEO Improvements with ASP.NET 4
5. Searching and Navigating Code in VS 2010
6. Auto-Start ASP.NET Applications
7. Clean Web.Config Files
8. VS 2010 Code Intellisense Improvements
9. New Code Focused Web Profile Option
10. Starter Project Templates
11. Multi-targeting
12. HTML / ASP.NET / JavaScript Code Snippets .
13. Add Reference Dialog Improvements
14. Output Cache Extensibility with ASP.NET 4
15. WPF 4

Details

Multiple Monitor Support
- We can rip a tab of in the VS IDE & move it anywhere such as another monitor. Kind like how Chrome treats tabs.
- We can do this by clicking on a code file tab, then drag it outside the VS IDE
Built-in Charting Controls for ASP.NET and Windows Forms
- Wow this topic is huge 4 guys from Rolla placed some great content
- <asp:chart> control: it’s in data section of tool box
- Chart Picture
- Series
- Chart Area
- Sorting & many more
URL Routing with ASP.NET 4 Web Forms
- URL Routing is good for SEO
- SEO friendly URLs
- No more query strings within URLs
- Allows Mapping URLs
SEO Improvements with ASP.NET 4
- SEO is good since we can add meta tags & there are more page properties
- New Page MetaKeywords & Page.MetaDescriptions properties
- URL Routing
- Response.RedirectPermanent() method (when we move content)
Searching and Navigating Code in VS 2010
- Searching in VS2010 has seen improvements
- Navigate To –
- (Ctrl+comma) keyboard shortcut open Navigate To dialog box
- Fuzzy Search allows smart filters (when we don’t know exactly the name)
- View Call Hierarchy allows us to discover where a method or property is being called from.
- Ctrl + K, Ctrl + T Open View Call Hierarchy menu command.
- Highlighted References can be cycled threw by Ctrl+Shift+Up Arrow.
Auto-Start ASP.NET Applications
- There is an oiption for Auto start
- Our apps can be warmed up with ASP.NET 4 & IIS 7.5 by performing application startup & pre=cache logic run before any user hit the app.

§ <applicationPools>

§ <add name="MyAppWorkerProcess" managedRuntimeVersion="v4.0" startMode="AlwaysRunning" />

§ </applicationPools>

7 Clean Web.Config Files
- Clean Web Config Files are stripped down into a simple web.config file
- Here it is:

§  <?xml version="1.0"?>
§  <configuration>
§  <system.web>
§  <compilation targetFramework="4.0" />
§  </system.web>
§  </configuration>

8 VS 2010 Code Intellisense Improvements
- Pascal Case Intellisense when we type GridView1.PIC then the intellisense will display the PageIndexChanged member.
- Searching for Types is new for example type list & we’ll see list<>, SortedList<> ect.
- Intellisense filtering – Insellisense w/ fuzzy logic kinda.

9 New Code Focused Web Profile Option
- New environment settings: Web Development (code optimized ) – Anti WYSIWYG
- This affects how tool windows are displayed / hotkeys
10 Starter Project Templates
- Start Projects New Templates are nice such as
- Empty ASP.NET Web Application – minimal project
- ASP.NET Web Application (has master pages, layout / CSS / directories such as styles & scripts)

11 Multi-targeting
- We can target .NET 4 or .NET 3.5 or .NET 2.0 diifferent framework versions
- This feature is more accurate & better than in VS08
- Reference Assemblies for each .NET versions is in VS10
- Internal IIS ASP.NET dev server lists the .NET version now previously it listed the root url, port, virtual path, physical path & stop button.

12 HTML / ASP.NET / JavaScript Code Snippets
- There are many code snippets available to us
- Example is when we can start typing a control then get intellisence, then press tab to complete the control name then press tab a second time to complete the control code.

13 Add Reference Dialog Improvements
- Adding Reference Dialog box is much improved. Speedier
- Quicker including a Project tab
14 Output Cache Extensibility with ASP.NET 4
- Cache Extensibility is good
- The addition of the output cache provider enables us devs to easily pursue more aggressive & more intelligent output caching strategies for sites & apps.
- Improve performance & responsiveness

15 WPF 4
- WPF 4 is dead right w/ Silverlight 3 out of browser?
- Controls are improved in WPF4
- Office Ribbon
- Graphics & many more

Here are a couple other topics from the white paper

Here are the main points from the white pager:

Core Services

New Features in AJAX Library

Web Forms
ASP.NET MVC
Dynamic Data
VS 2010 Improvements
Web Application Deployment w/ VS10

& here are some topics that catch my eye & I feel are important for the exam:

Query Extender control – used to modify the results from a query from a data source control
CSS improvements – less table layouts. Examle the menu control now uses un ordered lists not tables wihich makes it render better in webkit.
Chart Control is a really good control for us to us. It has 36 distinct charts, chart areas, titles, can use AJAX with it, smart data labels, filtering & much more.
Wizard Controls & CreateUserWizard controls <asp:CreateUserWizard Dynamic Data – Big sections here including enabling dynamic data for existing sites, creating new projects of dynamic data types, support for filters & more.

As we’ve seen .NET 4 has quite a few enhancements, Scott Gu’s blog & the whitepaper are great resources for us.

That is all, there will be more,

Catto

.NET Code Catto Blogger Blog

Catto’s in Top 20 Windows Phone 7 Developer List

Catto’s Interview on Cloud Plumbing Podcast by Ryan Parsley a TekTalkshow

Blendin #WP7Dev – #SFCC using Expression Blend 4 building FLA Code Camp App

2011 .NET Goals (more WP7Dev) & 2010 4th 1/4 recap

Swamp Coast FLA Code Camp #3- Data Driven .NET Apps Code Crackin #31

SQL2008 Database Dev 70-433 Skills MeasuredSQL 2008 DB Dev 70-433 Programming ObjectsSQL 2008 DB Dev 70-433 XML DataSSMS Toughest Program to InstallMicrosoft Visual Studio Hotkey Shortcuts.NET 4 ASP.NET ‘Skills Overview’ 70-515 Exam

6 DAL Class File code

WP7 Windows Phone 7 Application Development - Now is the Time - Catto Code Crackin #30

SQL Saturday #40 - DB Dev T-SQL 0-60 - Code Crackin #29

Troy Gallant - Introduction to Transactional ReplicationBrent Ozar - BLITZ! One Hour SQL Server TakeoversDavid Corrales - Sneak Preview: SAPIEN's Visual PowerShell 2011Dmitri Korotkevitch - Database design with performance in mindKevin Boles - Advanced TSQL Solutions

SSMS Toughest Program to Install? It is!? Code Crackin #28

SQL 2008 DB Dev 70-433 GCUG ‘Exam Cram’ Code Crackin #27

SQL 2008 DB Dev 70-433 XML Data – 6th objective Code Crackin #26

SQL 2008 DB Dev 70-433 Query Fundamentals – 3rd objective Code Crackin #25

SQL 2008 DB Dev 70-433 2nd objective Programming Objects Code Crackin #24

DB Dev 70-433 Implementing Tables & Views Code Crackin #23

SQL2008 Database Dev 70-433 Skills Measured Code Crackin #22

MCPD 4 How to Study & Take Beta Exam for Free - Code Crackin #21

MCPD 4 Microsoft Beta Exam Prep ~80 Key Terms 70-519 Code Crackin #20

MCPD .NET 4 Preparing for the Microsoft beta exam 70-519 - Code Crackin #19

Visual studio 2010 Microsoft Event Launch Miami 4.20.10

MCPD 4 Exam 70-519 Skills Measured Reviewed - Code Crackin #18

VS10 & .NET 4 Install Adventures Code Crackin #17

Prep & Take Exam 71-515 .NET 4 ASP.NET Web Dev - Code Crackin #16

.NET 4 ASP.NET ‘Video’s Overview’ 70-515 Exam Prep ASP.NET – Catto Code Crackin #15

.NET 4 ASP.NET ‘Skills Overview’ 70-515 Exam Prep ASP.NET – Catto Code Crackin #14

.NET 4 ASP.NET ‘Developing Web Forms Pages’ 70-515 Exam Prep ASP.NET – Catto Code Crackin #13

.NET 4 ASP.NET (da Gu’s & whitepaper) 70-515 Exam Prep Catto Code Crackin #12

SQL2008 Database Dev 70-433 Skills Measured
SQL 2008 DB Dev 70-433 Programming Objects
SQL 2008 DB Dev 70-433 XML Data
SSMS Toughest Program to Install
Microsoft Visual Studio Hotkey Shortcuts
.NET 4 ASP.NET ‘Skills Overview’ 70-515 Exam

Troy Gallant - Introduction to Transactional Replication
Brent Ozar - BLITZ! One Hour SQL Server Takeovers
David Corrales - Sneak Preview: SAPIEN's Visual PowerShell 2011
Dmitri Korotkevitch - Database design with performance in mind
Kevin Boles - Advanced TSQL Solutions