Windows Tech Support

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Wednesday, 6 April 2011

Shout Out - Abs Of Beer TV Blogcast

Posted on 19:47 by Unknown


If you watch closely, you'll see my arms deftly handling the digital clapboard during the intro segment. By the way, The Birch is freaking AWESOME! John and Bryan had taken a break from doing their show for quite a while and are just now getting back into it. This is the second show since their return to the web. Enjoy!

Read More
Posted in | No comments

I hope this isn't a bad omen?

Posted on 19:30 by Unknown

The ConfigMgrSetup.log results from a recent site installation of SCCM 2007 R2.

image

When the last line says that everything is good to go, but the main word is mispelled, it doesn't make me feel warm and fuzzy.

Read More
Posted in config manager, sccm | No comments

Windows Web Admin (Final)

Posted on 15:08 by Unknown

Final build (2011.04.06.001) is online and available for download at https://sites.google.com/site/skatterbrainz/downloads/wwa.zip?attredirects=0&d=1

Read More
Posted in active directory, network administration, projects, sccm, software development, web development, wwa | No comments

The CAD Cloud. Finally. Citrix and AutoCAD 2012

Posted on 12:00 by Unknown
I'll spare you the stories about long-gone experiments with lab rats like myself and Autodesk engineers with strange names and complicated accents handing us code on disks with no names written on them and project codenames that were more like a mash-up of numbers and letters.  My brain is fading fast.

Yesterday, Shaan Hurley dropped the long-awaited bombshell from Autodesk that 9 of their products are now certified for use with Citrix and XenApp.  The internal cloud.  IT admins the world over are sitting and staring into blankness as their brain cells rattle around like a ball in a spraypaint can, just trying to get their heads around what this means.

It means ONE INSTALL on a SHARED SERVER instance.  Possibilities?  Plenty:  Client push installs?  Gone. Client updates?  Gone.  Client upgrades?  Gone.  If you have a dozen or so clients this is probably not a big deal.  If you have hundreds or thousands of clients - this is a huge deal.

System Requirements
Licensing and License File requirements for Citrix XenApp apps
AutoCAD performance recommendations for Citrix XenApp

Autodesk Press Release
Read More
Posted in application virtualization, autocad, autodesk, network administration, software deployment | No comments

Tuesday, 5 April 2011

Deploying AutoCAD with MDT 2010

Posted on 04:07 by Unknown

In my latest book I discuss the various ways to automate the deployment of Autodesk products throughout a Windows network environment.  Among these is "imaging".  This is essentially where you automate the process of loading the base operating system, drivers, updates, and a set of "standard" applications on a new computer before delivering it to the user.  If you're using a network-licensed version of an Autodesk product and the majority of your users use the product, then adding it to the base image might make sense in your environment.

Microsoft provides a free application called Microsoft Deployment Toolkit, or MDT, for creating custom imaging configurations for your various needs.  This can range from various hardware models (drivers and utilities) to various user functions (role-based configurations for various departments or skillsets).  It is also the required component for deploying imaging services within System Center Configuration Manager 2007, where it rolls up into what is known as the Operating System Deployment (OSD) feature.  MDT employs a variety of components and toolkits such as WAIK (Windows Automated Installation Kit), .NET framework and so on.  For more information about MDT visit the Microsoft TechNet MDT web site.

MDT uses a "task sequence" process that allows you to create a custom chain of events to install and configure everything you need on each computer.  Think of it as being kind-of like a giant BAT script, but with a very robust GUI environment to work with.  You configure which operating system, which service packs and updates, which drivers, which settings to customize, and which applications.  You also configure the order in which these things are executed.

Why would you want to use MDT to deploy Autodesk Network-Licensed Products?

It can save on product network traffic overhead compared with pushing the installations out to computers in the environment.  You can easily segment and isolate network traffic between the MDT host server and the workbench where the computers are imaged.  This keeps the traffic off of your production routers and switches, thereby avoiding slowing down your users even during peak production hours.

Why would you NOT want to do this?

This is a bit tricky, and often subjective, but you have to consider how many licenses of the Autodesk product you have available (FLEXlm), compared with how often you max out usage, compared also with what percentage of your total computer user population could use a license at any given point in time.  An example might be if you have 500 computers/users, but only 100 AutoCAD licenses.  If 150 of your employees are potential AutoCAD users, especially frequent users, you may experience the dreaded "No available licenses / try again later" scenario.  If you are in this scenario, then putting AutoCAD on every desktop and laptop might only exascerbate the problem by making it too easy for even casual users or curious folks (non-users) to attempt to launch AutoCAD.

The missing piece

Assuming you're not worried about the downside described above, and you wish to pursue adding this into your base image process, what do you need to do?

You need to create a Deployment share for AutoCAD.  This is not to be confused with the "Deployment Share" referenced within MDT.  That's a different deployment share.  You have to create a network deployment share for the Autodesk product and create the deployment for the product to publish into that share.  This is done from the installation media main setup interface.  You will need to follow the same basic process as if you were creating a deployment for SCCM.  You should make sure you include the installation of .NET Framework 4.0 before the task sequence item that installs the Autodesk 2012 edition of your products.  You may also need to (separately) package the DirectX components.  Last but not least, you need to make sure your command-line for installing AutoCAD includes the /I /Q and /W parameters (as shown in the NAG, or Network Administration Guide).  If you forget the /W parameter, the installation will not pause the Task Sequence until it finishes, and will then create a problem where the next step begins execution before the AutoCAD installation is even partially completed.

If you build a proper AutoCAD Deployment and configure the Task Sequence within MDT properly, you should have a smooth process for including it in all of your newly imaged, or re-imaged computers before delivering them to the end-users.

Cheers!

Read More
Posted in autocad, autodesk, automation, deployment, network administration, operating systems, sccm, software deployment, software packaging | No comments

Saturday, 2 April 2011

Estimation 101: Migrating an MS-Access DB to SQL Server

Posted on 23:19 by Unknown

This is a very common scenario: A customer contacts me and asks "what would it take/cost for you to port our MS-Access database application to SQL Server and maybe put a web front end on it?"

That is quite often verbatim wording.

The answer I always give, and it's really not related to my being employed as a consultant, is "It depends."

Rather than dive into some ugly minutae, I'll give you the 50,000 foot skydive overview.  This is the conceptual, philosophical level, not the technical or procedural level, but it's important for both business and technical folks to understand this at a basic level:

There are two basic parts to what most people call a "MS-Access Database Application":

1. The database content (i.e. the tables, queries, and data stuffed into them)

2. The interface (forms, reports, menus, toolbars, etc. which users interact with when using the application)

In general, when you migrate an Access Database Application to SQL Server you are really only moving the data and data structures (tables, queries, etc.), while the interface aspects require redevelopment with something to make either a client/desktop application (aka "client-server") or a web application. Examples include Visual Studio, ASP.NET or even ASP or PHP (note: there are many more possibilities, but I'm trying to keep this short)

If the database "application" provides no custom interfaces and simply has the user opening tables and queries to interact with, and use, the application - it's a piece of cake.  You can either (A) use the Access "Upsizing" utility to "push" the data up to a SQL Server, or (B) use Integration Services to "pull" the data from the Access database into a SQL Server.  I prefer [B] because [A] sucks and is too limited and inflexible while [B] is incredibly flexible and yields better results with less effort.

If the database "application" provides extensive interfaces like dynamic drop-down lists, graphics, radio buttons, checkboxes, toolbars or ribbons, well, it will take longer, but again: it depends.

Case 1: Migrating an Employee Database

The Access ACCDB (Access 2010) database contains a simple form for entering basic employee data to create a new employee record.  There are a minimum number of tables and views and only one form.  The database contains 20,000 employee records (rows).  Only three employees should have rights to access the application and they are all in one AD security group.

One Solution: Copy the table structures and data into an existing SQL Server host and develop a web interface for managing employee records.  The IIS web site is configured for Windows Authentication, the web app folder is secured with NTFS permissions for the AD group.  The SQL connections are "trusted" with explicit AD group access configured in the SQL database.  Total time to implement: 4 hours.

Case 2: Migrating an Asset Inventory Management Database

The Access MDB (Access 2003) database contains multiple forms, numerous tables and queries, as well as about a dozen reports.  Some employees are allowed full permissions to edit records, while a select group is allowed only read permissions.  Other employees are denied access.  This results in 3 distinct roles.  The roles are managed within the database (application security).  The forms consist of many dynamic components and tons of clever graphics.

The company owns licenses for Office 2010 but has decided to hold off until this application can be updated to remove the reliance upon Access 2003.  MDOP/App-V is not an option for this customer and neither is Embedded XP or Remote Desktop Services (TS Remote, Terminal Server, Citrix, Xen or whatever).  They just want this beast killed and disposed of.

One Solution: Chain the Access developers to the back of a truck and drive off down a long gravel road at 60 mph.

There.  That was easy now, wasn't it?  Clear as mud.

Read More
Posted in applications, business, consultants, databases, programming, software development, web development | No comments

Friday, 1 April 2011

Holy Cow! Strep and Couch Fatigue

Posted on 12:17 by Unknown

I've been quiet lately because I've been getting punched out cold by a combination Strep infection + chest cough, so I've been spending more time on the couch watching Regis & Kelly, Rachel Ray and other daytime horrors that destroy the human mind.  There's lots going on, but unfortunately I'm too worn out to type a lot just yet.

But on a really cool note, two of my books are in the top 10 of Amazon's Best Sellers in the "AutoCAD" category!  Holy cow (times a hundred)!  The latest book (AutoCAD Network Administrator's Bible, 2012 Edition) is at #7.  The previous edition (2011 Edition) is at #9.  I don't know what to say.  I'm really surprised and I appreciate every copy purchased.  See the list at http://www.amazon.com/gp/bestsellers/books/3483

image

Read More
Posted in amazon, books, health, network administration, publishing | No comments
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Popular Posts

  • Voting Time: Help Me Out?
    I need to get a better view of how I should manage this blog if I'm going to keep at it. I'd like to know how you typically discover...
  • A World Without Competition
    Try to imagine what things would be like today had there not been fierce competition in certain key parts of our world.  I’ll give you some ...
  • Book Update
    I posted some gibberish a few weeks ago about another book project.  Well, I'm getting close to wrapping it up, so I thought I'd go ...
  • Cost
    Software technology, like any technology, provides a means to solving problems.  Some big. Some small.  Some that help.  Some that hurt.  An...
  • Windows 7: Default User vs All Users
    A lot of confusion seems to occur with understanding the difference between the "Default User" profile, and the "All Users...
  • Time to Give Props
    With the ever-expanding volume and breadth of information on the Internet today, it's easy to focus on my own thoughts, experiences, ide...
  • Table of Contents (Preliminary)
    Here's the preliminary Table of Contents for my new book "The AutoCAD Network Administrator's Bible - 2013 Edition".  I...
  • The Nicest IT and IT Vendor Folks I Know
    I've ranted many times before how it's unfair to "hate" an entire company, without providing a rationale for it based on s...
  • Windows 8
    Two small, yet irritating things, that I hope Windows 8 addresses with respect to Windows 7: Being able to put the Recycle Bin in the S...
  • Stupid Assumptions
    After years of watching sci-fi TV shows, movies, etc. it's finally come to a point where even the so-called brightest of our authors and...

Categories

  • a
  • activation
  • active directory
  • advertising
  • agile
  • agility
  • amazon
  • american
  • apple
  • application virtualization
  • applications
  • art
  • articles
  • asp
  • augi
  • authors
  • autocad
  • AutoCAD Autodesk
  • autodesk
  • autolisp
  • automation
  • automotive
  • backups
  • batch
  • beer
  • beta
  • blackberry
  • blogs
  • bongloads
  • book
  • books
  • Books writing kindle amazon technology business projects
  • browsers
  • business
  • cad
  • career
  • certification
  • chrome
  • city government
  • civilization
  • cloud services
  • cmd
  • cmmi
  • comedy
  • command
  • community
  • computers
  • conferences
  • config manager
  • consultants
  • consulting
  • contracting
  • cranium drainium
  • crapware
  • culture
  • data center
  • data mining
  • databases
  • deployment
  • directx
  • DLL
  • domains
  • dumb
  • earth
  • economy
  • editor
  • education
  • election
  • elections
  • employment
  • engineering
  • entertainment
  • environment
  • error monitoring
  • events
  • exchange
  • facebook
  • family
  • firefox
  • flexnet
  • fud
  • fun
  • funny
  • games
  • gary vaynerchuk
  • gmail
  • google
  • government
  • group policy
  • hampton roads
  • health
  • history
  • holidays
  • home
  • html5
  • humor
  • hyper-v
  • iis
  • industry
  • infrastructure
  • installation
  • installshield
  • internet
  • internet explorer
  • interviews
  • jobs
  • jtbworld
  • kindle
  • kixtart
  • lab setup
  • languages
  • ldap
  • learning
  • legal
  • licensing
  • life
  • lifecycle
  • linux
  • lisp
  • logging
  • management
  • manufacturing
  • marketing
  • markets
  • mdop
  • mdt
  • medical
  • messaging
  • microsoft
  • microsoft access
  • military
  • mountains
  • movies
  • mozilla
  • music
  • nature
  • network administration
  • news
  • nook
  • nothing
  • office
  • open source
  • openoffice
  • opera
  • operating systems
  • oracle
  • osx
  • packaging
  • patches
  • people
  • photos
  • podcasts
  • policy
  • politics
  • powershell
  • predictions
  • process automation
  • products
  • programming
  • projects
  • psychology
  • publishing
  • rail
  • reading
  • registry
  • religion
  • reporting
  • reviews
  • rsat
  • rss
  • safari
  • safety
  • sales
  • satire
  • sccm
  • scheduling
  • science
  • scripting
  • search
  • security
  • servers
  • services
  • sharepoint
  • shopping
  • sms
  • social stuff
  • society
  • softgrid
  • software assurance
  • software deployment
  • software development
  • software packaging
  • sony
  • speaking
  • sports
  • sql express
  • sql server
  • statistics
  • Statistics news marketing
  • steve jobs
  • stories
  • stuff
  • stupidity
  • symantec
  • sysinternals
  • system center
  • systems architecture
  • t-sql
  • taxes
  • technet
  • technical support
  • technology
  • TED
  • ted talks
  • testing
  • textpad
  • thoughts
  • traffic
  • training
  • transportation
  • travel
  • troubleshooting
  • tutorials
  • twitter
  • ubuntu
  • unattend
  • unemployment
  • updates
  • upfront ezine
  • utilities
  • vacation
  • vba
  • vbscript
  • video
  • virginia
  • virginia beach
  • virtualization
  • visual lisp
  • vmware
  • vmware server
  • voting
  • war
  • weather
  • web
  • web browsers
  • web development
  • web sites
  • windows
  • windows 7
  • windows live
  • windows server
  • windows server 2012
  • windows8
  • winpe
  • wise
  • wmi
  • work
  • writing
  • ws08
  • wsus
  • wwa
  • x64
  • xml
  • ze frank

Blog Archive

  • ▼  2013 (37)
    • ▼  October (1)
      • 10 Questions: With Ralph Grabowski
    • ►  September (5)
    • ►  August (8)
    • ►  July (2)
    • ►  June (4)
    • ►  May (4)
    • ►  April (2)
    • ►  March (2)
    • ►  February (8)
    • ►  January (1)
  • ►  2012 (120)
    • ►  December (14)
    • ►  November (12)
    • ►  October (10)
    • ►  September (7)
    • ►  August (3)
    • ►  July (2)
    • ►  June (6)
    • ►  May (6)
    • ►  April (20)
    • ►  March (16)
    • ►  February (18)
    • ►  January (6)
  • ►  2011 (343)
    • ►  December (15)
    • ►  November (23)
    • ►  October (27)
    • ►  September (35)
    • ►  August (29)
    • ►  July (17)
    • ►  June (23)
    • ►  May (20)
    • ►  April (38)
    • ►  March (61)
    • ►  February (54)
    • ►  January (1)
Powered by Blogger.

About Me

Unknown
View my complete profile