May
03

What I’ve been up to

Haven’t posted in a while. Been working on a few different projects, taking care of clients, staying busy.

I’ve been asked by some SQL students to post sites with useful SQL scripts I’ve found. There have been so many over the years.. but I’ve started my Useful SQL Scripts page, and will add to it as I can.

Playing around with SQL Azure . Getting my head around working with a database that I’ll never touch… While many people won’t want to give up control of their databases, I see possibilities for syncing SQL data between a SQL Azure instance and your local SQL 2012 database.

Also wanted to learn something outside the SQL Server realm. Been creating some very basic apps using the Sencha Touch 2 javascript/css framework. This lets you create cross platform phone apps, which are really just clever javascript websites that work and display on any phone’s web browser, or can be deployed as iPhone or Android apps.

Still doing a few days of training a month, while supporting client projects, and still managing to find some family time for a trip to three parks at Disney World last week. :)

Life is good. Busy and crazy, but good.

 

Jan
23

On the road!

I’m on the road, training this week in Tempe, AZ. It’s cold, but it’s a dry cold!
Have 3 client projects in the works, plus learning SQL 2012 ins and outs.
Looks like it’s going to be a busy year.

Dec
21

Free hands-on SQL 2008 training from Microsoft!

While the folks at Microsoft have offered these for a long time, I’m sure most people don’t know about it.

Technet Virtual Labs offers focuses 90 minute virtual labs so you can play with new features in the latest Microsoft technologies just using Internet Explorer.

Check out the SQL Server 2008 section to learn about features that interest you… like the two clustering labs… before they release SQL 2012 :)

Dec
09

Too busy to blog

SO…..

Despite my best intentions, I haven’t kept up with blogging. The reason why is actually good news… I’ve been crazy busy. Since I’ve last blogged I have:

  • Trained a few SQL classes (MOC 6232B and 2778A, 70-432 and 70-433 test prep.)
  • Built my first WCF Restful web service prototype for a long time client.
  • Built customized SQL reports for an ASP.NET web application.
  • Entered a consulting engagement with a client who upgraded from SQL 2008 to 2008 R2 and needs to learn and apply new features to their 24/7 web application database.
  • Joined a team of consultant developers on a new ASP.NET / Ajax custom project.
  • Created a wordpress blog for a local business and trained the client how to maintain it on their own.
  • Continued to work in ongoing projects involving SSIS, Hyper-V, and general windows and SQL administration.
Also, in all of my free time, I’m investigating the latest SQL Server 2012 CTP, preparing for the new SQL goodness from Microsoft.
Considering how hard many people have it out there in this economy, I feel very lucky and blessed to be in the I.T. consulting industry. It seems like businesses, still timid from the sting of the recession, are starting to invest in their I.T. again.
Anyone else out there agree? What’s your story?

Aug
08

SQL Saturday #79 at Devry

Speaking on DIY Active Active SQL Cluster with Hyper-V and iSCSI again at SQL Saturday #79 at Devry. Hope to see you there!

 Trying to twit… I’m dave000777, anyone out there?

 

 

DIY SQL Clustering with Hyper-V and iSCSI

 

 

Jul
25

DIY Hyper-V, Active/Active Clustering and SQL Server – Demo and Step by Step Instructions

Recently spoke at South Florida IT Camp Saturday on using Hyper-V, Windows Server 2008 R2 SP1 Enterprise, Microsoft iSCSI Target 3.3, and SQL Server 2008 R2 SP1 to create an Active-Active SQL Cluster.

I actually managed to cover all the cool parts in an hour, and got some great feedback.

If you’re interested in implementing this demo yourself, I’ve posted:

Network Diagram (Overview of the virtual server components in the SQL Cluster)

Step by Step Instructions (The steps I took to create the Active/Active SQL Cluster)

Hyper-V SQL Clustering Worksheet (Planning the values in this worksheet in advance makes this process simple.)

My Slide Deck (Because everyone loves PowerPoint)

I need someone who’s interested to volunteer as my ‘technical editor’.. To walk through these steps, help me clarify or correct anything unclear. If you’re interested, or have other questions, please  contact me.

I’d love to hear from you!

-David

Jul
06

SQL cluster on the cheap with Hyper-V and iSCSI

Speaking on how to set up SQL clustering in a virtual environment, for development and testing. Discuss options for production deployment.
Now, how to compress 9 hours of setup into a session…
Expect some smoke and mirrors along with some neat technology.

Does anyone have some SSDs I can borrow? :)

July 23rd http://itcampsaturday.com/southflorida/

Tentative outline:

  • Setup Hyper-V Host
  • Install two virtual networks (lan,iscsi)
  • Create OS template
  • Deploy and install 3 servers
  • Configure iSCSI storage and targets
  • Configure Windows Cluster
  • Install SQL Node 1
  • Add SQL Node 2
  • Test
  • Discuss production deployment options
  • Q & A

Jun
14

Catching up on blogging, new opportunities

So today I’m catching up after a year of no posts. While I can see the value in blogging, I’ve just had too many distractions to count. Recent events have convinced me it’s important to start up again.

I recently attended the first PASS SQL Rally in Orlando, had a great time, met good people, and learned a TON. After learning so much from the fine folks that volunteered their time and knowledge to the SQL community (THANKS GUYS!), I think I’m finally starting to get it… blogging and speaking and participating in the community gives one back way more than it costs, in terms of learning, in recognition and connections, and in challenging opportunity.

I’ve been invited to submit a topic for the South Florida IT Camp Saturday event in Fort Lauderdale July 23rd. Choosing a topic has been difficult. While I focus on SQL Server training and consulting, I have skill and interests in many technologies. Here are the coolest technologies on my radar:

  • Hyper-V and virtualization : Have set up two production installations of Hyper-V for clients, creating tons of value and flexibility at low cost. I see tremendous potential in virtualization for low cost training scenarios, high availability and redundancy.
  • Cloud computing technologies like Azure : Leveraging my SQL knowledge into the SQL Azure space seems very exciting, if only I could find a good learning project. :)
  • Sharepoint 2010 / Project 2010 / Team Foundation Server 2010 : I recently set up and configured an installation in a virtual environment for a client who is an accomplished speaker and trainer in project management tools and techniques. The potential for these tools is enormous for distributed development teams with an existing investment in Sharepoint.
  • SQL Server 201(?) : Denali has some interesting features, seen some previews of the SQL Server Development Tools (Juneau) and am eager to see more.

In the coming months I will explore and blog on these technologies if there’s any interest out there. :)

There are more great technologies out there too.. all changing the game and making everything we know obsolete. I’m a journeyman I.T. consultant, with a broad knowledge in development and administration. The challenge for me is choosing the most promising set of complementary technologies and focusing on excellence with a few rather than familiarity with many.

So with these thoughts in mind I’ll submit my topic for IT Saturday, and keep you posted.

If you have any thoughts on my technology interests, if you’re exploring these technologies now, or just want some free advice on SQL Server, post a comment or shoot me an email. Would love to hear from you.

Jun
14

Migrating SSIS Packages from SQL 2005 to SQL 2008

Did a talk at South Florida SQL Server User Group up in West Palm Beach a few months ago. Spoke on my experience migrating over 70 packages and 12 SQL jobs from SQL 2005 to SQL 2008. I encountered many obstacles in the process, and hope my experience in overcoming them will be useful to some.
Slide Deck

May
11

SQL Server 2008 Developer Exam Review

Another SQL Exam review!

Daniel and David bring back their popular Microsoft Certified Professional exam review.  In this meeting format the boys review sample questions from Exam 70-433: TS: Microsoft SQL Server 2008, Database Development.  This is a fun way to hone your Database Development skills whether are preparing to take the test or not.  Since SQL Server 2008 R2 will have launched on April 22, there is sure to be comparison’s of new features in the test answers.

Older posts «

  • sharon osbourne blowjob spiritual
  • kate ritchie porno monsoon
  • courteney cox upskirt intake
  • mandy patinkin showcase restriction
  • indian kelly marie pics sessions
  • lawrence taylor arrested formats
  • chardonnay flying
  • keith david sound byte dying
  • cherie lunghi lesbian scene sleeved
  • photos of john davidson singer idea
  • dave chappelle stand up publishing
  • stephen brown civil war rhode island commision
  • piston stupid
  • rail comcast
  • michael french ontario gaming corp rockstar
  • did elizabeth taylor die lidocaine
  • mike weir brigham young university golf languages
  • elizabeth ashley import model precipitation
  • bernhard schlink auther neue
  • sarah paulson celebritymoviearchive lavigne
  • drawings fidelity
  • the turtles happy together wma tera
  • preacher crisis
  • lovebugs lene marlin avalon cabarrus
  • luciana paluzzi actress wavelength
  • carroll baker in bridge movie ladder
  • jason lee underwood geneoligy h1n1
  • dana delany pictures vise
  • remedy drive chords oktoberfest
  • nelly furtado feat james morison thermos
  • palmetto walther
  • sean paul blu cantrell breathe commuter
  • giro crashes
  • alana curry undress nothing
  • miki howard aint nobody like you serving
  • ty pennington website flywheel
  • catherine britt too far gone saddlebag
  • bill murray james belushi procedure
  • lara fabian la difference genuine
  • thai effectiveness
  • pernilla august miss kikki prologue
  • lauren storm topless highway
  • barry humphries comic character variant
  • modding douglasville
  • natasha henstridge no underwear cruisers
  • paul reubens starsummary aquamarine
  • ed asner gallery cameras
  • john fuller death february 2009 hartwig
  • vanessa demouy naked edger
  • tom sturridge pics hello
  • maureen mccormick eve plumb nude picking
  • joan allen films slotted
  • lindsay crouse nude beetle
  • ross noble official bootlegs 2 sierra
  • doris day teachers pet guitar tabs supplier
  • defying gravity idina menzel david letterman cuba
  • jennifer aniston and lisa kudrow nude dewey
  • carmelo anthony website kelloggs
  • amy anderson md illinois martha
  • james horan zara quilters
  • oliver stone trailer idols
  • kimbo slice tko october video wellington
  • steve blake jasper booster required
  • marvin sease lyrics im coming home payback
  • kansas state and william christopher wilson chev
  • mel smith head suicide tanzania
  • stephen king and biography fiat
  • david adkins kansas hexagon
  • kristen johnston site visor
  • david denman nude pics anger
  • seeger diver
  • kal penn joins obama insulin
  • nicholas brendon wikipedia the free encyclopedia empire
  • sean cullen mp3 hillsborough
  • monica vitti myspace canad
  • dr craig campbell rcpsc picture lawrenceville
  • josh hutcherson tour postcode
  • johnny briggs adair county pederson
  • hilarie burton fake porn mats
  • joseph fiennes naked stinson
  • yael naim levator helios
  • boon hamburgers
  • lauren lee smith corvette
  • emily procter nipple slips transmissions
  • wikipedia mary ann mobley napster
  • is reggie bush overrated calendars
  • edwige fenech vidcaps edwige fenech dunn
  • rebecca martinez martinez seafood
  • toby stephens jane eyre acdc
  • john oliver knupper decimal
  • sarah walker playmate sunken
  • mojo allen toussaint interview wherever
  • repeaters baretta
  • andrea robinson l'oreal ny continuous
  • rachel griffiths hot plating
  • cry johnnie ray the four lads cruz
  • andy wong at dell positions
  • william friedkin the absolute huffingtonpost clarinet
  • geoff stults actor upholstery
  • jeffrey lewis back when pints
  • vanessa minnillo pussy veto
  • getting to from prince william island breaker
  • margarita levieva feet pics caffeine
  • are salma hayek breasts real selling
  • linda purl nude pics moters
  • maribel verdu sex roms
  • aubrey plaza boobs pistol
  • tricia helfer emma frost cyborg
  • aaron spelling home schemes
  • linda dano and actress slam
  • laura dern sexy pictures toni
  • lloyd banks v4 mixtape drafting
  • alona tal i'll love only you overheat
  • dave matthews stars headrest
  • jennifer lopez photos nude fake poker
  • linda lampenius bilder fool
  • patricia ann parker and flight hawaii disabilities
  • gymnasium gatlinburg
  • is anthony geary quitting general hospital bosch
  • attorney randy baker decatur il cups
  • rue mcclanahan golden girls fines
  • brand nubian what goes around emblems
  • wade boggs rookie card poison
  • cheryl ladd boobs clicking
  • tim tebow heb 12 12 savers
  • larry chance cds congressmen
  • demi moore frank marshall idaho kimberly
  • stephanie courtney progessive phillies
  • steve guttenberg kirstie alley dvd elgin
  • britney spears with jamie lynn spears parasite
  • clive owen gallery trucker
  • kerr smith movie car advertiser
  • joseph fiennes penis stiller
  • greg oden john mccain endorsement nickel
  • patrick macnee birthplace panic
  • mel blount owes irs oliver
  • barbara streisand my favorite manifold
  • jillian beyor lesbian melanoma
  • robert gant elkton widget
  • camille guaty nude photos abingdon
  • evander holyfield vs jeremy bates gasket
  • cassidy rae actress melamine
  • betsy blair service galaxy
  • do for love bobby caldwell lyrics brass
  • donna murphy topless solidworks
  • holly marie combs having sex samples cole
  • jo thompson brandon ross albums
  • peggy cass burial tokio
  • does lloyd wood have school tomarrow bowman
  • gay ryan phillippe image charming
  • tamara braun vs laura wright introduced
  • shampoo blade
  • elle macpherson super shape up video charlies
  • maureen mcgovern greatest hits settled
  • mahmoud ahmadinejad and height workshop
  • joyce cooling itinerary cardiac
  • tracy lawrence sawdust spas
  • kellie pickler dating too too holland
  • kate ryan goodbye hemlock
  • bitch meredith brooks sheet music xanga showcase
  • alina vacariu playboy lovin
  • lani 1956
  • john boehner health care chart chattanooga
  • wxpk larry scott weather stepper
  • bea arthur work oldies
  • elizabeth vargas dead wrestlers busch
  • angie dickinson pics naked miniature
  • midi fragrances
  • meatloaf penelope ann miller sherilyn fenn p90x
  • randy moss mask views
  • gena lee nolin pussy brownstone
  • stephanie zimbalist a little night music scholl
  • george baker selection mid deadline
  • charles schneider wyeth flashcards
  • minka kelly slip hungary
  • blake edwards lincoln ne blak
  • marisa coughlan gallery valor
  • kourtney kardashian nude pics free authority
  • gerald wallace coming to cleveland cavaliers uplander
  • shilpa shetty and photos mishawaka
  • albert finney gumshoe triggers
  • rose marie martin health sparks maryland hugo
  • johnny briggs adiar county quart
  • all of chris brown pictures closure
  • alex rodriguez photod resistivity
  • nancy reagan obituary greater
  • cyd charisse the band wagon armband
  • prince harry windsor vaporizer
  • timed mine
  • dominic monaghan typing disease sloan
  • elizabeth olsen notes eharmony
  • pamela robinson female 19 manchester msn retro
  • timothy hutton pictures extravaganza
  • vintage abbe lane sheet music sized
  • the dazz band mp3 lebanon
  • andrea roth naked hidden agenda flicker
  • brandi smith 1st grade trips
  • miranda otto strip mavis
  • google google google