Home‎ > ‎

Announcements

Come see us present at the Malibu SQL Server User Group on May 8th

posted May 1, 2013, 3:34 PM by William Yeager

Featured Presentation:

SQL Server Performance Tuning – Keeping it Simple

William (Bill) Yeager, Principal IT Consultant at AdminsDirect

Today’s world is full of websites containing highly technical information and can really overwhelm the DBA at any level of experience.  While some may choose to deep dive into internals, there is tremendous value at keeping things simple as you work toward solving seemingly complex problems.  Microsoft advocates an upside-down pyramid approach to problem solving, and with a few free simple tools – you can quickly begin to find your needles in the haystack of your systems.  The purpose of this presentation is to outline quick approaches in order to keep things simple and solve problems fast.

http://sqlmalibu1305.eventbrite.com/

Tune Scribe processes on the Backend

posted Mar 22, 2013, 1:05 PM by William Yeager

Anyone familiar with running Scribe ETL for interfacing with GP/Dynamics/CRM is probably familiar with how challenging it can be to tune.  Running a profiler trace against it doesn't help much, since the sqltext is most often encrypted - so you really don't know what to tune.  Even in the most latest versions of Scribe it is possible to perform bulk operations, however all of your steps in the DTS must be insert operations.  Another handcuff.  What i've found is that it is important to look at the working structures you have created in GP/Dynamics or CRM and make sure they are tuned correctly.  If your DTS solution includes scripts and maintenance operations, make sure that your underlying tables are indexed or created properly. By simply turning the heap table into a clustered index can make all the difference.  For more information - contact us!

Recover SSIS Packages from a restored MSDB backup

posted Mar 21, 2013, 4:22 PM by William Yeager

I needed to recover an old version of an SSIS package that I knew was good.  The copies in BIDS was questionable.  
Find your backup of MSDB (hopefully you have one!).  
Restore it to somewhere else on the server.  
DO NOT OVERLAY MSDB!!!
Name it something else such as MSDB_Restore
DO NOT OVERLAY MSDB!!!

Extract the files using bcp then import them into version control or back into MSDB.

bcp "select cast(cast(packagedata as varbinary(max)) as varchar(max)) from yourMSDBrestore.dbo.sysssispackages 
where name = 'YourPackageName'" queryout c:\tt\YourPackageName.dtsx -Slocalhost -T -c

Hope that helps.

AdminsDirect presents at SQLOC - Feb 7, 2013

posted Mar 7, 2013, 6:44 PM by William Yeager

Presentation Topic:  Sql Server Performance Tuning – Keeping it Simple

Presentation Abstract: 

Today’s world is full of websites containing highly technical information and can really overwhelm the DBA at any level of experience.  While some may choose to deep dive into internals, there is tremendous value at keeping things simple as you work toward solving seemingly complex problems.  Microsoft advocates an upside-down pyramid approach to problem solving, and with a few free simple tools – you can quickly begin to find your needles in the haystack of your systems.  The purpose of this presentation is to outline quick approaches in order to keep things simple and solve problems fast.

Windows VMWare Workstation 8 Bridged Adapter Problem

posted Mar 7, 2013, 3:31 PM by William Yeager

Today one of my VM's wouldn't connect externally - after running for months without a hitch.  The host is a Windows 7 64 bit, the guest is a Windows 7 32 bit.
Bridged networking was not working.  I could switch to NAT and it would work, but I need to hit this box directly.

After digging I found that there is a kernel driver that must be started in Windows via 'net start' that is not listed in the Services.msc.
Open a command box as Administrator, type in:   net start vmnetbridge
and you are off an running again.  An entry was added to the virtual network editor for me and all was happy again.

Credit is due to Steve Friedl here.  Thanks Steve.   http://blog.unixwiz.net/2010/09/vmware-workstation-there-are-no-un-bridged-host-network-adapters.html

1-5 of 5