Skip to main content

SQL Saturday Detroit 2013

The SQL Saturday is a free one day training event for SQL Professionals. This was my first attendance in SQL Saturday event. Overall the event was action packed with lots of things new and interesting in the fields that I work in or am interested to work in. Not sure, how many or what features or technologies I will be able to apply in day to day operations or projects, but I gained lot of new knowledge.

I started off with Kevin Boles “Common T-SQL Mistakes”, even though I have worked with T-SQL for years, I felt the need to review the basics and sit through the common mistakes and see, if I am making any. The take away I got from this was to avoid “User Defined Functions” in store-procedures or queries as they tend to tax the hardware.

Second session I attended was the Dustin Prescott’s “Hacking SQL Server”, this seemed to be the most popular session of all the sessions I attended. The session was more about defensive measures rather than Hacking. Dustin mentioned about the popular products like “BackTrack” and “Kali Linux”.

I have attended some of the other sessions and one of the interesting fact was about what services NOT to run by default like “SQL Writer” and “SQL Auth”. SQL Writer is primarily for backup and unless a backup schedule is setup for automatic execution, there is no need for this service to run by default, it should be turned into a manual service.

The last session I attended before the price drawing, which I usually lose was, Colleen Morrow’s “So I started this blog…. now what?”. After all day of technical sessions, I was exhausted and it felt like a relief to sit in a non 100% technical session and besides all the other session were good to know but didn’t apply to my work, at least not yet.

Colleen’s session was very informative. Even though I have been blogging for a while, it’s nice to know the basics and common issues. Her agenda was “5 common roadblocks for new bloggers” and “5 ways to improve your blog”, and both of items seems to fill the gap that I feel are in my process of blogging.

Overall the SQL Saturday event was very informative and I am glad that I have attended it.


Comments

Popular posts from this blog

Working hours in six months to a year

I usually try to look for how many hours I have worked on a given project and what hours that I  spend on learning or network management tasks.

Below I have added some hours calculation, after finding the breakdown by months from Berkeley website.


Credit: http://controller.berkeley.edu/payroll/payroll-system-pps/pps-training-materials/number-working-hours-month

2017Working hours six months (Jan 1st - Jun 30th): 
130 days x 8 hours =  1040 hours


Working hours six months (Jul 1st - Dec 31th): 
130 days x 8 hours =  1040 hours

Working hours for the year:
1040 hours + 1040 hours = 2080 hours
MonthWorking Days in the monthMonthly Working Hrs1/2 of working hrsMidpoint of working days in the monthDates of HolidaysJanuary22176888 a.m. 1/172,16February20160808 a.m. 2/1520March2318492Noon 3/1631April20160808 a.m. 4/17May2318492Noon 5/1629June22176888 a.m. 6/16July2116884Noon 7/174August2318492Noon 8/16September2116884Noon 9/154October22176888 a.m. 10/17November22176888 a.m. 11/1610,23,24December21168…

Completed UiPath - RPA Developer Advance Training

After a month of training, with late nights and weekends I have completed the UiPath RPA Developer Advance Training.

The Level 1 Foundation Training pretty much covered all the basics of Desktop studio and workflows, only draw back was I started with the default foundation course which was for 2016, and all document reference links where pointing to 2016 version. I didn't understand it during the foundation training and kept switching to 2018 version document/page.

Only after completing the Foundation course that I realized, I was suppose to have started with the 2018 version of Level 1 Foundation Training, but as it was optional I didn't have to retake the 2018 version, the 2016 was good enough for moving to level 2.

The Level 2 Orchestrator 2018.3 Training as good. It gave good understanding of Queue's, Jobs, and schedules and I was able to complete the level two much faster then the level 1.

The Level 3 UiPath Advanced Training was bit tough as it involved the assignme…