7z aka seven zip, todays savior

Curse my maintenance plans to archive data in a timely manner. Why curses? Freak'n tasks which were to act upon data prior to back up, were out of sync(timing got thrown off by reports failing to down load...blah blah blah). So now I got to unzip a crap load of files, bulk insert data into temp table for lookups and more boring stuff.

7z e *.zip *.837 -r

Extract all .837 files from all zip files found in current directory.

YAY!!!

When should you deploy?Weekday? Weekend? Whenever?

I've struggled with the logic behind all claims.

"We should deploy immediately" ~ cause we over committed

"We should wait till after peak hours" ~ cause it might have issues, less people may be impacted.

"Friday Night" ~cause you have the to weekend to try and resolve any issues that arise.

"Whenever" ~eh, we can take it or leave it...Not important to anyone important.

I've learned the best answer is to adhere to political hierarchy.

1. Who signs your check?

2. Who is most likely to complain to the person who signs your check?

3. If you screw up what will the person who signs your checks think?

4. What are the risk factors?

5. How easy will it be to rollback?

6. Have you even thought about how to handle the rollback?

7. Please tell me you are at least second guessing yourself

8. "You arrogant ass! You've killed us!" ~Andrei Bonovia [Hunt for Red October]

My advise is test, test, test and get buy in from those who may impact the judgement of the person who signs your check. Above all do right by the system.

The person who signs your check, is merely a metaphor for the COMPANY.

You are employed to help ensure the success of the company, period. If thats not your goal, you're in the wrong place.

Rant, rant, rant, blah, blah, blah, just do good. Respect the system, the users, and don't be arrogant.

MURPHY's LAW it tantamount is IT, and life.

SQL installs always take forever.

I never really get why it takes so dang long to intall. Disks are blazing, CPU not even sneezing, Memory for days.... but still draaaaaaaaags. And then the Service pack after that, and then the configuration and then.....

Lost your windows share? Export next time as a backup

Unfortunately this is usually discovered after the fact, but don't let it happen again.

So you spent hours fiddling with windows NTFS permission and then created corresponding folder shares. Of course, it was by hand and over the course of several month.

In comes Murphy.

POOF!!!

ISCSI shares didn't import after windows update/reboot, hence disk not available and no shares to present. Hence the share info is gone. If your loucky after to get the shares mounted, it will still retain the NTFS permissions you painstakingly configured.

Yeah, you gotta start all over, boo. But take heart in the fact that it will be the last time that ever happens to to you.

1. Re-config your shares
2. Capture what you setup to a txt file for manual restore with this nugget.

• C:\>SRVCHECK \\yourservernamehere >ManualSharesConfig.txt

3. Export those bad boys from the registry

• SYSTEM\CurrentControlSet\Services\LanmanServer\Shares see this

4. Have a nice day

Thank you GlassGiant.com

                             ..   ...   =. .                                    
                             .=.. .$7.. ~:                                      
                             .O.:.:I??.I:$.                                     
                             .8.Z?I$+ZZO+D..                                    
        ...                  .8:ZI$8$8OODN.                    ...              
       .. .                  .?IOOOO8ZI88O.                    ..~              
       I=..                  .I8IZ:.,??8ZN:.....             ...,$:...          
       ?+.                   .,DZZ~,,?I8ZD. .. .....  .    .    .,:...          
      .I+.                 .. .+OZ~:.II8O.....: .=....     ......:7. .          
      .++...... . .......=..7?....7$78O8$7::~7I?O7???O...:DO7+$$?7OI..          
       ~?...  .......:~==$D+OD????I7$8ZZZZZZZZZZOO8888~.8D8~I?=+??O$~.          
     ...777$$ZZZO8=..ZZZOO88888OOOOOO8OOOZ$III7$ZOD?OONNDD88Z.:Z~OO87.          
     .~~OZ$$7$$ZO8$.7O88~?7O888OZZO7O8O7OOZZ7777II?IOONNDD8O~OO7?OZ8~,          
      =:O8Z$7$$$Z8ND8O888I+?II7$OOO78O8O8OZZ$777III$OO8NZDDOOO7=$O8DZ=.         
     .::$8OZ777$Z8NNDOO8O7?IIII$ZO$$OOOO8$OOZ7O7III7OOO..Z?O888DO$IIZ+..        
      =,$8OZ77$$$O8?$$8O8+I?7=7?OOZ$ZO8OOOOZ$I7I788O8O8..,O8?==+?=++$7+         
     .~.OOOZ$77ZZ8:..+$ID,~+?7$$$ZZ77O8O=I7$77$7I$7$OOZ ..DO7=+==?777=: .       
      ,:$=:,.:...$D..,7O?:+Z77OOOOOOOODOOOOOOOOOOOOOOOZ...O8ID88NDO7Z,...       
     .:,+~..,~...Z8. .$$7O8OOOOOOZZO88N8NNNM8OOOZO8DOZ.  .=ZOOO8+,:$O?ZZ.....   
     ..,.~?I7$$$$ZD. .$OOO8DNNNN8Z$III?+==+IZ~~~===~~=.   .$OO$7$7$OO77$Z$:..   
         .7ONNN8DN8....+~===:~:~~I$$7~Z?Z7I?Z=~~=~~~~7.   ..?I?8Z$$$Z$ZZO8DD    
       ..77DD8D8Z$7. ..7~~~~~~~=~I$I+=$?Z7I=8~~~=~~~~$.   .,I7OZO8O888888O8O.   
       .:7ZN8.DO77I?....~~~~~~~=~7$?==I?II?~8~=~~~~~~,.    .?OOOOO8ODO$$?78O.   
       .?7OD8=O$OOIZ....?~~~~~==+$7ZI7????I~ODOOOOZ.       .????7OO?Z88O7IO8.   
       .$$Z::=+ZOO~~.. ..8D888O88IO87$=?$?I:Z8OOOO..       ..I+?$$87?O$$ZOO8,   
       .OZOO8OOOOO?~.. ....O888DD78OZO~?$77~7DOOOZ..      . ..~$Z$8?ZZ8OOOOO~   
   D=. .OO7I777OOO=+ .   . .88DZO$DOZO~I$7I=INNDD?.           ..?IO88ZOOOOOO~   
   .,+$O$8?I777OOO==..   ...888OO$777~===II7?DOOOZ7           ....$Z7IOO8OO..   
       ?8OO$O$$OZ8==..   ..+8OOOOZ?7ZDNNNDDZ77I++=I.               . .:=:..     
       78O8IIZOOO8=~..   .I:,,:~~:7,.,,,:,Z=OOOO+=++.             .  ....       
   .  .ZOOOOZOOO8Z=, .   .~:?????=?,++++=:Z+?+?+=+=?.                           
   .  .$ZZZZZZOZOO=...   .I~===~::=:????+~O=+????+=?.                           
   .  .ZOO8O88888I+...   .+~~~+??+~:+???=:Z~+===~~~,                            
   ....77ODDDDD87$I. .   . ~?+~~:::~::::::$+==+DZI?.                            
       .IO8O8D88Z$=...   .,:~?77$8$Z$ZZZZZZ?+~77$==I.                           
       ..ZOOODI7ZZ7...  .,~?==?I7$ZOOOZ7+?=~~?+=~I~?..                          
       ..ZZD8ZI$......   :=+=+I~IID7$7. .=~,..=..?:?:.                          
       .,OO8DZZZ......  .7III?++IZZ?7?...,.,,,?,,:+$+                           
        .ZOOZZO...       IIIII??I77$I~ .. :~::=:::~$+                           
       ..+ZZOOO...      .7???$+I77$$7, ...+?~~:~~~=$?                           
       ...O8O8O...       $???Z+I7$$ZZ. .. 77~~~~~=$O+                           
          ..7I....       Z???Z+7$$Z8Z  .  =7+~=+++88I                           
                   .... .DI8DZ$I$$ZO$..... 8Z$O8O$D8I. .                        
                  ...,+7OIO$ONNIO$O8,.....,DD$OOZZZZ$$+~...                     
                  ...$ZOZ7$788ND8888?$O.7$$7$$$7$$$$$$$O:+,~                    
                  ...$ZOZZZZ7?8OO888888.$$$Z$ZZZZ$7$$$Z8+~,,                    
                  ..$$ZD8ZZ$Z$OOO8888D8.$$$87D$$7$7$$$ZDZ=,,                    
                  ..8ZZ88OOO$$OOO8888D8.$$$O$77O777$$$ZO,:,:                    
                  .88ZZD8OZZ$$OO88888D8.ZZZOZ77Z777ZZZZDO~,.                    
                  I88$ZD88OZ$ZOO8888DD8.ZZZZO$$$$$ZZZZZ:. .                     
                  D8$I$8ZZZZ$$888888888.7ZZZOZZZZZZZZZZ:= ..                    
                  .7?I8I?II$$$88888888=.7$ZZZZZZZZZZ$$$$=:==.                   
                  .=$$7IIII??O88888888=.$ZZZZ$$O77$$ZZZ$IDD8.                   
                  ..,77$$$$IO8888888D8=.I$ZZZZZZZZZZO,~ZIND8:                   
                  ..,8777777O8O8888888I..ZZZZZZ$$$$$Z.:Z=ND8I.                  
                  ..:DOOZ$7$Z888888888I .ZZZ87IIIIIIZ.:Z=D88+                   
                  ..~88ZZZ7$OD8O88888O? .ZZZ8$ZOOOOO$.,7+D88?                   
                  ..=8O$$$$ZOOO88888DO7..ZZZ8$777777Z.,=?D88I                   
                  ..=DOOZZOI8OOO888888D..ZZZ8$$77I7IZ,,:?NDD+.                  
                  .$?8OZZZO?7NO88888ND8..Z$ZO7IIIIIIZ?~??,:=?                   
                  .?INO$$7I7$$NOO8888OO..:$$ZZ$$Z$$$Z$.?IONN8.                  
                     .+$777$OOOOOO88OOZ..IZZZ$$ZZ888$ZZOIIND8,                  
                   ...I$ZZ7$OO8DOOOOOZZ..=$$ZZOO888888Z$$=N88~                  
               .....~Z7ZO8DDNN$OOOOOZZ$.. INDDN7NNNND88O$,DDO~                  
              ..  .?ZZZ$OO88ONDZZZ8O$$$...,D8DD8DDDDDD88Z.DDO~                  
              . ..7$ZZ8OO8OZZON$$$Z$$77....8O8888D88888OZ~D8O=                  
              .~$$$$ZOOO8$$ZZZ88$$$7777.. .OOZOOO8OOOOO$O7DZ$:                  
              .$ZI$OOOOOOO$$ZZZ8$$$$7......Z7OOO8888ODZ+O$I.                    
              .ZOOIZZZZZZZZ$$$$ZZ+..        ?NO8O8O8O$D,...                     
              .,7Z7Z$ZZ$$O=7:.. ....        ,D$$$ZZZZ,D:...                     
              ...... ...... ..... ...       .IZ..OOOZ+$~...                     
                                            .~$OO888$$. .                       
                                            . .........                         
                                                                                
                                                                 GlassGiant.com

MU CCD CCR CDA KMA

Get this: WebViewLayout_CDA.xsl and HITSP_C32v2.5_Rev6_16Sections_Entries_MinimalErrors.xml From http://xreg2.nist.gov/cda-validation/downloads/HITSP_C32_Examples_Jan2010.zip

....can't wait for results from http://hit.fiu.edu/challenge.htm

Sample CRD Document

Patient	Henry Levin, the 7th
Date of birth	September 24, 1932	Sex	Male
Contact info		Patient IDs	996-756-495 2.16.840.1.113883.19.5

Document Id	SAMPLE_QRPH_CRD 2.16.840.1.113883.3.72.5.1
Document Created:	February 7, 2008, 13:00:00 +0500

Author

Table of Contents

• Active Problem Concern
• Medications
• Allergies and adverse reactions

---

Active Problem Concern

Problem	Date of Onset
Patient has exercise induced asthma	1/10/2007

Medications

Medication	Dosage	Effective Time	Active?
Augmentin 125-31.25 MG CHEW	3 once a week	1/14/2008	Yes
Albuterol Sulfate 108 MCG/ACT AERS	2 Puffs q6hrs prn	1/14/2008	Yes

Allergies and adverse reactions

Penicillin

---

Document maintained by

Is task running

:: You can add more check by adding more if's

@ECHO OFF
SET TASKNAME=PingAServer
for /f "tokens=1,2 delims= " %%i in ('schtasks /QUERY ^|findstr /i running') do (
IF "%%i"=="%TASKNAME%" (
ECHO %TASKNAME% RUNNING
GOTO EOF
)
)
ECHO NOTHING RUNNING
:EOF
:: Enjoy