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.


Popular posts from this blog

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 a

KB 294807 - IIS Server - PHP FastCGI 500 Error 0xfffffffe

Resolved issue today of IIS Server - PHP FastCGI 500 Error 0xfffffffe by deleting "Windows Temp" folder files. We used Cygwin to customize some permissions of "Windows Temp" folder and after few hours the website stopped working. The search online was giving all kinds of different solution except what I was looking for. I was hoping the stackoverflow will have answers but even this post didn't cover the issue I was running into. Restarting the IIS didn't work, but deleting temp files cleared the issue, but now the problem is how long before the site will go down again? Hope the issue is resolved for ever, if not; I will update this post later.

QlikSense - Custom Form Login Screen

Extension of:  Custom login, logout and error forms for Qlik Sense by RPK QlikSense - Custom Login Screen Install Node on QlikSense Server: URL: Saved at: C:\server-tools\Downloads\Node Installed at: C:\server-tools\Runtime\nodejs\ Keep default options Create Folder: C:\QlikForm Clone git Repository and keep updates private: # Open Shell/Bash/Command Prompt cd /QlikForm # Ref: git clone --bare .git cd QS-Custom-Forms.git git push --mirror<name>/QS-Custom-Forms.git cd .. (go to parent folder) # remove other users repo clone rm -rf QS-Custom-Forms.git # clone witinc private repo git clone<name>/QS-Custom-Forms.git Get latest copy of login pages: # Open She