sqlshots: Installing SQL Server 2008 via Configuration File

VN:F [1.8.1_1037]
Rating: 0.0/10 (0 votes cast)

Tags: , , , , , , ,

sqlshots: Extracting Installation Files from SQL Server 2008 Express Install Package

VN:F [1.8.1_1037]
Rating: 0.0/10 (0 votes cast)

Tags: , , ,

BlackBerry CaptureIT Screen Capture App

There have been a couple of times where I wanted/needed to send a snapshot of my BlackBerry screen to a someone. Unlike the iPhone who has the functionality built-in you need to install the screen capture software which is a snap. Below are the details.

Installation Instructions

  1. Launch the BlackBerry Browser
  2. Browse to: m.TheTechMogul.com
  3. Download & Install the App
  4. Application Icon

Useage

  1. Click the menu button on the keypad
  2. Select Capture IT
  3. Once the vibration stops the screen cast is complete
  4. Check your device or media card for the image file
VN:F [1.8.1_1037]
Rating: 0.0/10 (0 votes cast)

Tags: , , , , , ,

vbs: Simple File Organizer

What exactly is VBScript? Well VBScript is Microsoft’s Visual Basic Scripting Edition which allows you to script in pretty much any windows environment like within the desktop, web client and IIS! VBS is part of the Visual Basic family and you can do many things as VBScript is able to communicate to host applications via Windows Script. Typically you would see VBS within classic ASP pages, but System Admins automate processes using VBS and frankly that’s my bag baby!

Using VBS I can query the registry, get system information and write it a file, create files and folders, clean out logs, add/remove an account to an AD group, connect to and query SQL Server (Which I have done on several occasions), automate processed within ArcCatalog for GIS purposes and so on!

Well I deal with a great deal of files and in this particular case I have over 24,444 files that I needed to organize. I felt it would be best to group all 24,444 files into folders categorized by the create date or modified date. The only problem is trying to sort through all 24,444 files would take me a lifetime. Okay I admit that statement was a little extreme but in all fairness it would have taken me a while to do it manually and I am not a fan of doing things manually (if I can help it)!

With that said I decided it would be in my best interest to write a script that would handle it for me since I am a big fan of using command line, batch files and vbs scripts. I decided to write a vbs that grabs the modified date stamp on the file and in turn use it to create a folder. So if the file had a date stamp of 4/1/2009 a folder would be created and named 04-01-09 then all files with the same date stamp would be moved to that folder. Nifty isn’t it! I though so!!! It is a very simple script and works well. I used it to organize 24,444 files so expect the processor to spike when dealing with file amounts in that ballpark.

Without further ado here is the script in action…

Useful Links

VBScript User’s Guide
Microsoft TechNET Scripting Center
Microsoft TechNET Scripting Guide
Microsoft TechNET Script Repository
Scripting Tools and Utilities
Script Runtime

VN:F [1.8.1_1037]
Rating: 0.0/10 (0 votes cast)

Tags: , , , , , , , , , , , , , , , , , , , , , , , ,

sqlshots: (IT – Where do I fit?)

A few friends and family of mine some of which are in the IT Field and some are considering making a move to IT. A few have asked me, “how do I get into it?” and others have asked, “which path should I choose?” or, “what else can I do?“. I respond simply with, “Well I was accepted into the IT field based on my rugged good looks and sophisticated charm!“. I am kidding about the charm part… because I really became a DBA to meet chicks! All jokes aside it really depends! Even though there are many paths to pursue within IT some positions will not be ideal for everyone.

For example if you are a systems admin and your primary responsibilities and experience are spec’ing, setting up and configuring servers, workstations and such then chances are that you will not enjoy switching to a programmer seat or a dba for that matter and vice versa. For those who are looking might like interfacing with people or “clients” face to face while others are more of the back-end “behind the scenes” folks. So in a nutshell you need to do what you are comfortable with, more importantly do what you feel passionate about, because if you love what you do then it’s not really considered work!

On another note (being a little bias) I did suggest the database track for a few reasons:

  1. damn near everything uses a database in one form or another
  2. data is very important which makes the database field relatively stable compared to other IT positions

With that said most would start by saying, “the only way to learn is to get yourself a copy of SQL Server Developer or Express edition and start practicing!“. Which is easier said then done, because if you have never worked with a Relational Database Management System (RDBMS) before then how would you know where to actually start? Well installing the product is probably your best bet, but how?

As a beginner you don’t know:

  1. if you should use a default or named instance
  2. if you should use windows or mixed mode authentication
  3. if you should place the data files on a different spindle
  4. what a schema is
  5. how to use the UI
  6. how write a query because you are not familiar with the syntax

So it is unfair or somewhat unreasonable for me to simply say, “just start doing it!“. I know this can be argued differently because that is exactly what I did. I purchased a SQL book, ordered SQL Server developer edition, downloaded the AdventureWorks database and began experimenting, but that is just my nature.

Another motivating factor for me to want to contribute more was a recent blog post by a friend and fellow sql-naut by the name of Jorge Segarra AKA (@SQLChicken) who started writing educational post (way back when) on his blog site SQLChicken.com. It is a great resource that gets very in depth with SQL and provides a lot of examples.

Which got me thinking about:

  1. my recent turn of events
  2. ways I can become more actively involved with the SQL community… and then it hit me.

sqlShots_sm

Not exactly SQLU, formal training or a college course, but smaller subsets of SQL doses to help folks get started! Starting with blog posts followed by video tutorials that show you how to install, configure and use SQL Server along with writing T-SQL statements using the AdventureWorks database. So if you are a newbie to SQL or the database world perhaps I can be of assistance to you or not. So let the train wreck… (I mean train ride) begin!

VN:F [1.8.1_1037]
Rating: 0.0/10 (0 votes cast)

Tags: , , , , , , , , , , , , , , , , , , ,

Geddan On It!

This video speaks for itself, but I am totally want to make one!!!

VN:F [1.8.1_1037]
Rating: 0.0/10 (0 votes cast)

Tags: , , , , , , , ,

Google Wave

Google Wave has been in the works for a little while now and is intended for online communications. Calling it a “JUICED” Instant Messenger would be a great disservice! Reason why it because traditional IMs only allow you to send files back and fourth, send a message and wait for a response, blah blah blah… Things have changed with Google Wave! Just watch and learn!

Live collaborative editing

Natural Language Processing

15 features

VN:F [1.8.1_1037]
Rating: 0.0/10 (0 votes cast)

Tags: , , , , , , , , , ,

Send SMS & MMS messages to cell phones via email

I have searched several sites that showed information about sms and mms messaging to cell phones via email address and most of them are out of date. So luckily for me most of my friends had different carriers. Here is the break down! Now if you are unsure of who your friends carrier is, you can always ask them or visit [fonefinder.com]. Wikipedia offers a nice list of SMS gateway information [website].

Step 1:

Enter the the following information into the following fields, then hit search.
SearchSection

Step 2:

These are the results. In some cases you might need to click on the link under the Telephone Company Web link column to find the actual carrier.
Results

SMS/MMS Transit addresses

So here is the scoop. I tested a lot of the addresses mentioned on the wikipedia site for both the SMS and MMS and so far here are the results:

CARRIERSMSVERIFIED ONP/FMMSVERIFIED ONP/F
ALLTEL@message.alltel.com08-23-2009Pass@mms.alltel.net08-23-2009Pass
AT&T@txts.att.net08-23-2009Pass@mms.att.net08-23-2009Fail
NEXTEL@page.nextel.com@messaging.nextel.com
SPRINT@messaging.sprintpcs.com08-23-2009Pass@pm.sprint.com08-23-2009Pass
TMOBILE@tmomail.net08-23-2009Pass@tmomail.net08-23-2009Pass
VERIZON@vtext.com08-23-2009Pass@vzwpix.com08-23-2009Pass

VN:F [1.8.1_1037]
Rating: 0.0/10 (0 votes cast)

Tags: , , , , , , , , , , , , , ,

Google Docs (Business Card Template)

I was working the other day on a document and in doing so I wanted to see if there were any templates available. To my surprise it was staring me in the face… a small link titled “Browse template gallery”. There were hundreds to thousands of templates supplied by several creative people and some that were just strange. My search was side-tracked a bit as I went through each category just to see what was out there and to get an idea for future endeavours.

I stumbled on the business cards templates and remembered the google card give away. I figured since I missed out on them, I could create something similar in nature using an existing Avery business card template. So I found the Avery Business Cards, Wide template and made some modifications. Not a lot, but I call it Search Engine Style.  So if you like it… here is where you can get it [Google Doc - Business Card Template Search Engine Style].

TemplateSnippet

TemplatePreview

VN:F [1.8.1_1037]
Rating: 0.0/10 (0 votes cast)

Tags: , , , , , , , , ,

Burning ISO data to disk via cdburn.exe

Normally when you burn data to a disk you would use a cd burning software, usually via a nice UI. In this case we will be using a nice command-line utility which is packed into the Windows Server 2003 Resource Kit Tools! (Download link @ bottom of post)

Command-line syntax

cdburn.exe d: c:folder\file.iso

command-line-syntax

Tool List

ToolDescription
Acctinfo.dll(documented in Readme.htm)
Adlb.exeActive Directory Load Balancing Tool
Admx.msiADM File Parser
Atmarp.exeWindows ATM ARP Server Information Tool
Atmlane.exeWindows ATM LAN Emulation Client Information
Autoexnt.exeAutoExNT Service
Cdburn.exeISO CD-ROM Burner Tool
Checkrepl.vbsCheck Replication
Chklnks.exeLink Check Wizard
Chknic.exeNetwork Interface Card Compliance Tool for Network Load Balancing
Cleanspl.exeSpooler Cleaner
Clearmem.exeClear Memory
Clusdiag.msiCluster Diagnostics and Verification Tool
Clusfileport.dllCluster Print File Port
Clusterrecovery.exeServer Cluster Recovery Utility
Cmdhere.infCommand Here
Cmgetcer.dllConnection Manager Certificate Deployment Tool
Compress.exeCompress Files
Confdisk.exeDisk Configuration Tool
Consume.exeMemory Consumers Tool
Creatfil.exeCreate File
Csccmd.exeClient-Side Caching Command-Line Options
Custreasonedit.exeCustom Reason Editor (documented in Readme.htm)
Delprof.exeUser Profile Deletion Utility
Dh.exeDisplay Heap
Diskraid.exeRAID Configuration Tool
Diskuse.exeUser Disk Usage Tool
Dnsdiag.exeSMTP DNS Diagnostic Tool (documented in Readme.htm)
Dumpfsmos.cmdDump FSMO Roles
Dvdburn.exeISO DVD Burner Tool
Empty.exeFree Working Set Tool
Eventcombmt.exeCheck Replication
Fcopy.exeFile Copy Utility for Message Queuing
Frsflags.vbs
Getcm.exeConnection Manager Profile Update
Gpmonitor.exeGroup Policy Monitor
Gpotool.exeGroup Policy Objects
Hlscan.exeHard Link Display Tool
Ifilttst.exeIFilter Test Suite
Ifmember.exeUser Membership Tool
Inetesc.admInternet Explorer Enhanced Security Configuration
Iniman.exeInitialization Files Manipulation Tool
Instcm.exeInstall Connection Manager Profile
Instsrv.exeService Installer
Intfiltr.exeInterrupt Affinity Tool
Kerbtray.exeKerberos Tray
Kernrate.exeKernel Profiling Tool
Klist.exeKerberos List
Krt.exeCertification Authority Key Recovery
Lbridge.cmdL-Bridge
Linkd.exe
Linkspeed.exeLink Speed
List.exeList Text File Tool
Lockoutstatus.exeAccount Lockout Status (documented in Readme.htm)
Logtime.exe
Lsreport.exeTerminal Services Licensing Reporter
Lsview.exeTerminal Services License Server Viewer
Mcast.exeMulticast Packet Tool
Memmonitor.exeMemory Monitor
Memtriage.exeResource Leak Triage Tool
Mibcc.exeSNMP MIB Compiler
Moveuser.exeMove Users
Mscep.dllCertificate Services Add-on for Simple Certificate Enrollment Protocol
Nlsinfo.exeLocale Information Tool
Now.exeSTDOUT Current Date and Time
Ntimer.exeWindows Program Timer
Ntrights.exe
Oh.exeOpen Handles
Oleview.exeOLE/COM Object Viewer
Pathman.exePath Manager
Permcopy.exeShare Permissions Copy
Perms.exeUser File Permissions Tool
Pfmon.exePage Fault Monitor
Pkiview.mscPKI Health Tool
Pmon.exeProcess Resource Monitor
Printdriverinfo.exeDrivers Source
Prnadmin.dllPrinter Administration Objects
Qgrep.exe
Qtcp.exeQoS Time Stamp
Queryad.vbsQuery Active Directory
Rassrvmon.exeRAS Server Monitor
Rcontrolad.exeActive Directory Remote Control Add-On
Regini.exeRegistry Change by Script
Regview.exe (documented in Readme.htm)
Remapkey.exeRemap Windows Keyboard Layout
Robocopy.exeRobust File Copy Utility
Rpccfg.exeRPC Configuration Tool
Rpcdump.exe
Rpcping.exe
RPingRPC Connectivity Verification Tool
Rqc.exeRemote Access Quarantine Client
Rqs.exeRemote Access Quarantine Agent
Setprinter.exeSpooler Configuration Tool
Showacls.exe
Showperf.exePerformance Data Block Dump Utility
Showpriv.exeShow Privilege
Sleep.exeBatch File Wait
Sonar.exeFRS Status Viewer
Splinfo.exePrint Spooler Information
Srvany.exeApplications as Services Utility
Srvcheck.exeServer Share Check
Srvinfo.exeRemote Server Information
Srvmgr.exeServer Manager
Ssdformat.exeSystem State Data Formatter
Subinacl.exe
Tail.exe
Tcmon.exeTraffic Control Monitor
Timeit.exe (documented in Readme.htm)
Timezone.exeDaylight Saving Time Update Utility
Tsctst.exeTerminal Server Client License Dump Tool
Tsscalling.exeTerminal Services Scalability Planning Tools
Uddicatschemeeditor.exeUDDI Services Categorization Scheme Editor
Uddiconfig.exeUDDI Services Command-line Configuration Utility
Uddidataexport.exeUDDI Data Export Wizard
Usrmgr.exeUser Manager for Domains
Vadump.exeVirtual Address Dump
Vfi.exeVisual File Information
Volperf.exeShadow Copy Performance Counters
Volrest.exeShadow Copies for Shared Folders Restore Tool
Vrfydsk.exeVerify Disk
Winexit.scrWindows Exit Screen Saver
Winhttpcertcfg.exeWinHTTP Certificate Configuration Tool
Winhttptracecfg.exeWinHTTP Tracing Facility Configuration Tool
Winpolicies.exePolicy Spy
Wins.dllWINS Replication Network Monitor Parser
Wlbs_hb.dll & Wlbs_rc.dllWindows Load Balancing Server Network Monitor Parsers

Download

Microsoft Windows 2003 Resource Kit Tools

VN:F [1.8.1_1037]
Rating: 0.0/10 (0 votes cast)