News

Consulting and Learning Solution provider


Latest Postings

July 18 2012

Can’t wait for Office 2013? Try it now for free!

Office 2013 Customer Preview Installation Steps

The Customer Preview of Office 2013 can be installed in just a few minutes and co-exists side-by-side with an existing version of Office, so there’s no need to uninstall your existing Office. You will need either Windows 7 or Windows 8 as your installed operating system to get started. The final version of Office 2013 will be able to be deployed via the Office 365 cloud or traditional enterprise software deployment methods, but the Customer Preview steps below are designed to install from the cloud to make it quick and easy to get started with testing.

NOTE: Microsoft Office Professional Plus 2013 Preview is also available for download using a traditional MSI-based installation package. Please note the traditional installation does not support fast cloud-based streaming of the installation or side-by-side operation with older versions of Office, and you will need to uninstall existing Office programs on your PC if you use the MSI-based installation approach. You can download the .MSI installation bits here if you prefer.

Before getting started, review the Office 2013 System Requirements, located here to make sure your system is capable of running Office 2013. The biggest change in terms of system requirements is the Operating System requirements – Windows 7 or Windows 8 is required on client machines to run Office 2013.

1.To start the Office 2013 Customer Preview installation, visit http://office.com/preview
2.If you are a home user, click on the “Sign Up” button. Business users can click on the “Office 365 Enterprise” link to test the most robust business version of the new Office.
3.Complete a new user profile and create a new Microsoft account. Note – If you are currently an Office 365 subscription user, you’ll need to sign up for a new Microsoft account that is different from your Office 365 login credentials to test the Customer Preview.
4.Once you’ve signed up for a new Microsoft account, login to http://portal.microsoftonline.com with your new ID.
5.From the Office 365 Admin home page, click the “Download Software” admin shortcut on the right side of the page
6.Click the “install” button. This will launch the new “Click-to-Run” installer. (What’s Click-to-Run? Here’s a technical overview of this new technology)
7.The new Office installer will launch via Click-to-Run technology.
8.Review the Microsoft Office licensing agreement and click the “Accept” button
9.Within a couple minutes, the core of Office will install and you’ll be greeted by a short introductory video explaining some of the new Office features.
10.Choose a look-and-feel to personalize the new Office client applications.

That’s it! Jump in and start using Office while the rest of Office 2013 installs in the background over the next few minutes via the Click-to-Run streaming installation.

What’s New in SharePoint 2013

When Microsoft officially introduced its coming version of Office on July 17, one of the quickly mentioned features that generated the most questions was something called SkyDrive Pro.

Photobucket

SkyDrive is Microsoft’s cloud storage mechanism for consumers. So will SkyDrive Pro be its complement for business users? Will SkyDrive and SkyDrive Pro offer users two different cloud storage locales? Does SkyDrive Pro basically kill off Groove and/or SharePoint Workspace?

LiveSide.Net has a good rundown of some of the many unknowns around SkyDrive Pro.

Microsoft mentioned SkyDrive Pro a couple of times, very briefly, in its downloadable reviewers’ guide for the new Office. On July 17, officials offered a few more tidbits about the mysterious new version of SkyDrive.

SkyDrive Pro is considered to be both part of SharePoint Online in Office 365 and of SharePoint Server 2013. This is how Microsoft Corporate Vice President of SharePoint Jeff Teper defined SkyDrive Pro in a July 17 post on the new SharePoint:

“SkyDrive Pro makes it easy it to work with your documents in SharePoint – save, sync, share and collaborate are all drop-dead simple. The name conveys the simplicity and increased consistency with our SkyDrive consumer cloud service while reinforcing the ‘Pro’ features of SharePoint like social networking, collaboration, search, metadata, workflow and compliance. Click ‘Sync’ on a SharePoint library and you will get the documents offline in the Windows Explorer, Office applications and more. SkyDrive Pro is part of both the SharePoint service in Office 365 and server.”

A Microsoft spokesperson said that Microsoft does not consider SkyDrive Pro to be a replacement for SharePoint Workspace. The spokesperson also said users could opt to have two SkyDrives: One for work (SkyDrive Pro) and one personal (SkyDrive). It’s not clear to me whether the two would simply sync, or if users could opt to merge these into one. Hopefully things will become clearer as testers start weighing in about the Customer Preview of SharePoint 2013 and the new Office 365 bundles.

Meanwhile, what else is new in the coming SharePoint Server 2013/SharePoint Online service?

Based on what’s in the SharePoint Online 15/2013 technology preview, here are some of the features likely to be part of the release:

SharePoint Duet: A cloud version of the Duet add-on Developed by SAP and Microsoft that allows SharePoint to integrate with SAP applications Support for viewing business intelligence content on Apple iPad devices Improved Web Apps: With the 15 release, Office Web Apps won’t be running from the SharePoint “farm.” Instead the Webified versions of Microsoft’s Office apps will run from a new Office Web Apps Server. Third party developers will be able to tie into the Office Web Apps service and provide access to documents stored in IBM FileNet, OpenText, and Oracle Metro user interface: Tiles in site collections will display more information when you hover your mouse over them, in a Metro-like style Rights Management Services (RMS): RMS is being integrated directly into SharePoint Server 15 (and Exchange Server 15). Sounds like the same is happening with the cloud versions of these products. It seems RMS on the cloud side also might be available as an add-in or separate SKU Project Online: New Project site to manage lightweight projects. Microsoft officials and the company’s partners have been hinting about this one for the past year Visio Online: Sounds as though there will be a Visio cloud service component, too, as I hear last year, though in the tech preview it doesn’t seem to be available as a standalone entity. (Seems to be bundled with Project client)

This week, Microsoft officials and partners shared more details, including the more pervasive social-networking capabilities; the integration of FAST Search technology; and a new SharePoint Sites hub. There’s also a new feature called Shredded Storage, which removes file duplicates and reduces the amount of content sent across the wire.

SharePoint Training

July 16 2012

New Microsoft Office coming October 2012

Photobucket

Today, Microsoft Corp. CEO Steve Ballmer unveiled the customer preview of the new Microsoft Office. The next release features an intuitive design that works beautifully with touch, stylus, mouse or keyboard across new Windows devices, including tablets. The new Office is social and unlocks modern scenarios in reading, note-taking, meetings and communications and will be delivered to subscribers through a cloud service that is always up to date. Below are some new features you will find in various Microsoft Office programs:

SharePoint
The newest SharePoint is designed to help everyone in your organization share content and ideas, organize teams and projects, and discover connections to get work done.

  • Share documents easily from SharePoint or any Office application, and track the people you’ve shared them with.
  • Follow sites, documents, and people with updates delivered to your activity feed.
  • Share ideas and tap into the knowledge of specialists from across your organization.
  • Search for documents, people, discussions, and #tags from anywhere in SharePoint.
  • Discover and trial third party apps in the marketplace to customize your SharePoint sites.

Photobucket

Exchange
The newest Exchange enables you to increase user productivity and keep your organization safe, while maintaining the control you need.

  • Move to the cloud on your terms with flexible migration options.
  • Help your users do more on any device, manage increasing volumes of email, and work together more effectively as teams.
  • Protect business communications and sensitive information as you meet internal and regulatory compliance requirements.

Photobucket

Lync
The newest Lync is an enterprise-ready, unified communications platform that connects people everywhere on Windows 8 and other devices.

  • Use a single, unified client for real-time communications, including voice and video calls, Lync meetings, presence, instant messaging, and persistent chat.
  • Get HD video conferencing across a range of devices. The Lync video gallery allows Lync meeting attendees to simultaneously view up to 5 different participants, identify the active speaker, and associate names with faces.

Photobucket

Office Web Apps Server
With Office Web Apps Server, your users get browser-based productivity from nearly any device on your terms and within your own private network.

  • Keep your users productive and working together, no matter where they are or what device or software they have, using browser-based versions of Word, Excel, PowerPoint and OneNote.
  • Manage updates to Web Apps Server independent of other products with standalone server deployment and configuration.
  • Get simple, seamless integration with your existing servers including Exchange, SharePoint, Lync, line-of-business applications and file shares.

Project
The new Project offers flexible service or on-premises solutions for project portfolio management (PPM) and everyday work. Try it in these three versions:

  • Project Online Preview is our online solution that gives you flexible options for achieving strategic priorities while helping your team deliver efficiently from virtually anywhere.
  • Try Project Server 2013 Preview, our on-premises solution to set clear strategic priorities and help your team execute effectively against them.
  • With Project Professional 2013 Preview you can call or instant message right from your project with Lync*—just two new ways to improve collaboration while keeping your team productive and on track. (* Requires Lync Online or Lync 2013, which are sold separately.)

Photobucket

Visio
The new Visio lets you easily create professional, versatile diagrams that help you organize and make sense of complex information.

  • Create diagrams more intuitively—including new and updated shapes and stencils, improved effects, and themes.
  • Make your diagrams more dynamic by linking shapes to real-time data, and then share them with others via Visio Services in SharePoint—even if they don’t have Visio installed.
  • Simplify teamwork with new coauthoring features.

Photobucket

Office Professional Plus 2013
For IT pros, you can also try the Office Professional Plus 2013 MSI-based installation, which includes Word, PowerPoint, Excel, Outlook, OneNote, Access, Publisher, and Lync. Note that this is not the Click-to-Run installation used by Office 365 ProPlus and does not support fast streaming installation or side-by-side operation with older versions of Office. In addition, you must uninstall the existing version of Office on your PC to try Office Professional Plus 2013.

Office at Its Best on Windows 8

  • Touch everywhere: Office responds to touch as naturally as it does to keyboard and mouse. Swipe your finger across the screen or pinch and zoom to read your documents and presentations. Author new content and access features with the touch of a finger.
  • Inking: Use a stylus to create content, take notes and access features. Handwrite email responses and convert them automatically to text. Use your stylus as a laser pointer when presenting. Color your content and erase your mistakes with ease.
  • New Windows 8 applications: OneNote and Lync represent the first new Windows 8 style applications for Office. These applications are designed to deliver touch-first experiences on a tablet. A new radial menu in OneNote makes it easy to access features with your finger.
  • Included in Windows RT: Office Home and Student 2013 RT, which contains new versions of Word, Excel, PowerPoint and OneNote applications, will be included on ARM-based Windows 8 devices, including Microsoft Surface.

Photobucket

Office Is in the Cloud

  • SkyDrive: Office saves documents to SkyDrive by default, so your content is always available across your tablet, PC and phone. Your documents are also available offline and sync when you reconnect.
  • Roaming: Once signed in to Office, your personalized settings, including your most recently used files, templates and even your custom dictionary, roam with you across virtually all of your devices. Office even remembers where you last left off and brings you right back to that spot in a single click.
  • Office on Demand: With a subscription, you can access Office even when you are away from your PC by streaming full-featured applications to an Internet-connected Windows-based PC.
  • New subscription services: The new Office is available as a cloud-based subscription service. As subscribers, consumers automatically get future upgrades in addition to exciting cloud services including Skype world minutes and extra SkyDrive storage. Subscribers receive multiple installs for everyone in the family and across their devices.

Photobucket

Office Is Social

  • Yammer: Yammer delivers a secure, private social network for businesses. You can sign up for free and begin using social networking instantly. Yammer offers integration with SharePoint and Microsoft Dynamics.
  • Stay connected: Follow people, teams, documents and sites in SharePoint. View and embed pictures, videos and Office content in your activity feeds to stay current and update your colleagues.
  • People Card: Have an integrated view of your contacts everywhere in Office. The People Card includes presence information complete with pictures, status updates, contact information and activity feeds from Facebook and LinkedIn accounts.
  • Skype: The new Office comes with Skype. When you subscribe, you get 60 minutes of Skype world minutes every month. Integrate Skype contacts into Lync and call or instant message anyone on Skype.

Photobucket

Office Unlocks New Scenarios

  • Digital note-taking: Keep your notes handy in the cloud and across multiple devices with OneNote. Use what feels most natural to you — take notes with touch, pen or keyboard, or use them together and switch easily back and forth.
  • Reading and markup: The Read Mode in Word provides a modern and easy-to-navigate reading experience that automatically adjusts for large and small screens. Zoom in and out of content, stream videos within documents, view revision marks and use touch to turn pages.
  • Meetings: PowerPoint features a new Presenter View that privately shows your current and upcoming slides, presentation time, and speaker notes in a single glance. While presenting, you can zoom, mark up and navigate your slides with touch and stylus. Lync includes multiparty HD video with presentations, shared OneNote notebooks and a virtual whiteboard for collaborative brainstorming.
  • Eighty-two-inch touch-enabled displays: Conduct more engaging meetings, presentations and lessons, whether in person or virtually, with these multitouch and stylus-enabled displays from Perceptive Pixel.

August 30 2011

Configuring a split tunnel PPTP VPN in Windows 7

While working remotely I noticed my bandwidth would drop when I connected to our VPN. It appeared that all internet packets were being routed through our VPN connection. While this normally wouldn’t be a problem, I often found myself downloading large files and my connection performance was limited to the available bandwidth to the VPN connection. That’s when I learned about what a “split tunnel” vpn connection is. I wrote this article to walk you through the process of setting up your VPN to take advantage of this option in Windows Networking.

With a “split tunnel vpn” connection, the internet traffic is routed through the local gateway connection. All other network traffic works through the vpn connection as you would expect. This is a feature that is available with Windows Vista and XP PPTP VPN connections, but it isn’t the default setting.

Here is how you configure your VPN connection to use the local gateway:

Step 1

Right click on your VPN connection and choose “properties”

Step 2

Click on the “Networking” tab. This is where we will need to make changes to the TCP/IP settings for your VPN connection. If you are using V6 IP addresses or V4, you’ll need to make the change in both locations just to be sure.

Step 3

Click on the “Advanced” button to get to the Advanced TCP/IP options

Step 4

The VPN connection by default configures all packets to route to the remote server’s gateway. We want to turn this option off by clicking on the “Use default gateway on remote network” option.

That’s it! Once you have made those changes you will notice your internet packets are no longer automatically routing through the VPN server.

August 18 2011

Advanced T-SQL Querying, Programming and Tuning featuring Itzik Ben-Gan – Sept 12-16, 2011

 

Itzik Ben-Gan is returning for another session on SQL Server 2008 Advanced T-SQL Querying training in Sacramento on September 12-16, 2011.

Description

The course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2005 and 2008. In this course you will learn the details and capabilities of T-SQL in the following areas: Logical Query Processing; Query Tuning; Subqueries, Ranking Functions, Joins and Set Operations; Aggregating and Pivoting Data; TOP and APPLY; Data Modification; Data Type Related Problems; Programmable Objects (Dynamic SQL, Views, User Defined Functions, Stored Procedures, Triggers, Transactions and Concurrency, Exception Handling); Graphs, Trees and Hierarchies.

Along the course you will learn how to use T-SQL to solve practical problems such as: Relational Division, Ranking, Missing and Existing Values (Islands and Gaps), Separating Elements, Tie Breakers, Running Aggregations, Pivoting and Unpivoting, Custom Aggregations, Histograms, Dynamic Analysis of Grouping Sets, TOP Problems, Paging, Median, Handling Sequences, and more.

You will learn how to tune your queries, how to develop efficient routines including user defined functions, stored procedures and triggers, work in multi-user environments with transactions and isolation levels, and use dynamic SQL securely and efficiently.

You will also learn how to maintain and query hierarchical data. You will learn what graphs, trees and hierarchies are, what the common requests against graphs are, and how to write T-SQL code to handle those requests. Several different solutions will be presented including: Enumerated Paths, Nested Sets, Nested Iterations using Recursive Queries, and using the HIERARCHYID datatype.

The course provides a dedicated module focusing on query tuning. The module covers internals and index tuning, index access methods, temporary tables, set vs. cursors, and query tuning using query revisions. Moreover, query tuning is in the heart of this course and is incorporated in the different modules throughout the course.

With each querying/programming problem the discussions will revolve around logical aspects, set-based vs. procedural programming and optimization of the solutions.


Author

This course was developed by Itzik Ben-Gan, a mentor and one of the founders of Solid Quality Mentors, author of several books about T-SQL, a columnist in SQL Server Magazine, and a regular speaker in SQL Server related events.


Audience

This course is intended for:

  • T-SQL Programmers, DBAs, Architects, and Analysts
  • Those that need to write or review T-SQL code in SQL Server 2005 and 2008

Prerequisites

Before attending this course, it is recommended that students have the following skills:

  • At least one year of T-SQL querying and programming experience in SQL Server

Course Objectives

Upon completion of this course, the student will:

  • Understand logical query processing
  • Understand SQL Server’s internal data structures
  • Be able to analyze and tune query performance
  • Be able to analyze query execution plans
  • Be able to solve complex querying and programming problems
  • Think in terms of sets
  • Be able to compare set based and cursor based solutions
  • Know how to handle date and time data
  • Understand compilations, recompilations and reuse of execution plans
  • Understand transactions and concurrency aspects of database programming
  • Know how to handle hierarchical data and write recursive queries
  • Be familiar T-SQL enhancements in SQL Server 2005 and 2008

 

Click here for more information, or to register

SharePoint 2010 Document Content Types and Embedded Metadata in Word

In this post we will look at how to create new document content types and insert the metadata fields in the header of the Word Document.

Creating the Content Type

1. Make sure you are in the site where you want to create the content type. Click Site Actions | Site Settings.
2. In the Galleries section click Site Content Types.
3. Click Create.

4. Fill in the appropriate information on the form to create a new content Type. Give the content type a name.
Make sure to select “Document Content Types” on the Select parent content type from drop down menu. Make sure to select “Document” in the Parent Content Type drop down menu. Put the new content type in either an existing or new group. Click OK.

5. Scroll down to the bottom of the new site content type property page to find the columns section. Here you can either create new site columns or add an existing site column. The column will then be associated to the content type.

6. Content types can also have workflow, retention schedules and modified document information panels.

7. Upload a document template to

SharePoint Training

Windows 8 App Store Confirmed

Steven Sinofsky, President of the Windows Division at Microsoft, has officially confirmed that the upcoming Windows 8 operating system will have an app store. The news was mentioned via a new blog post over on MSDN, where Sinofsky listed the numerous teams which will be contributing to Windows 8′s development.

 

August 2 2011

6451B Class Resources

In this post you will find Internet Resources referenced during the ConfigMgr 2007 Class.

 

 

MyITForum.com
RegkeytoMof 3.0 and Instructions on Using Regkey to Mof
List of tools and scripts for ConfigMgr
Admin Studio for Configuration Manager 2007
Troubleshooting "Waiting on Content"
Jason Lewis Blog – SCUP and DCM
Example Afterbackup.bat
OSD on Technet
Step by Step OSD on Technet
Quest Management Xtensions

July 18 2011

Microsoft has officially released Office 365!

 

You might be wondering, what is Microsoft Office 365?

It’s familiar Microsoft Office collaboration and productivity tools delivered through the cloud. Everyone can work together easily with anywhere access to email, web conferencing, documents, and calendars. It includes business-class security and is backed by Microsoft. Whether you are a small business or multinational enterprise, Office 365 offers plans designed to fit your organization’s unique needs.

There are two plan families available:
Plan P – for professionals/small businesses
Plan E – for midsize businesses and enterprises.

Microsoft Office 365 for professionals and small businesses
This service plan is designed for up to 25 employees who want:

•A solution without dedicated IT staff
•Essential email, calendar, and website services
•Free online community support
•Month-to-month subscription

Microsoft Office 365 for midsize businesses and enterprises
This service plan is great for any size organization that wants:

•Advanced IT configuration and control
•Office Professional Plus, Active Directory or advanced archiving
•24×7 IT Administrator support
•Choice between monthly and annual contracts

Please contact an ISInc account representative for more information, or email [email protected].

March 25 2010

Enable Admin Audit Logging Exchange 2010

Exchange 2010 allows auditing of administrative actions. All actions can be audited or just specific cmdlets and parameters. To enable Audit Logging open the Exchange Management Shell and run the following commands.

Audit All cmdlets
Set-AdminAuditLogConfig -AdminAuditLogCmdlets *
or
Only audit New-Mailbox, all transport rules, all management, all set-transport cmdlets
Set-AdminAuditLogConfig -AdminAuditLogCmdlets New-Mailbox, *TransportRule, *Management, Set-Transport*

Set-AdminAuditLogConfig -AdminAuditLogParameters *

or

Set-AdminAuditLogConfig -AdminAuditLogParameters Database, *Address*, Custom*, *Region
Audits just the parameters that have Database, all parameters with *Address*, begins with Custom, ends with Region.

Set-AdminAuditLogConfig -AdminAuditLogMailbox [email protected]
All auditing is sent to the mailbox of AdminAudit.

Set-AdminAuditLogConfig -AdminAuditLogEnabled $True

 

SetAdminAuditLogEMS

All of the commands can be run on a single line if you prefer.

After creating a new mailbox by either using the EMC or the EMS, an email is sent to the AdminAudit Mailbox. Make sure the Mailbox is secured appropriately and archive or delete the mail after a specified amount of time. A command Set-AdminAuditLogConfig –AdminAuditLogAgeLimit DD.HH:MM:SS is not available for the RTM release of 2010 so be sure to watch the size of the mailbox.

Below is a screenshot of the message sent to the AdminAudit Mailbox after creating a new Mailbox and User.

AdminAuditLogEmail