This quick post is based on tool shared by my colleague Ambuj. Heidisql - SQL Editor for MSSQL and MYSQL
Step 1 - Pretty simple and quick to install. Downloaded and Installed it from link
Step 2 - You can setup sessions and connect to MSSQL / MYSQL instances. I have used SSMS, Atlantis SQL Explorer. This single interface for both MYSQL and MSSQL is very useful.
Happy TSQL coding !!!
June 19, 2013
June 12, 2013
May 15, 2013
TSQL Formatting Tools
Back to blogging after a month long break. Things were quite busy @ work. This post is to focus on TSQL formatters. There are several code formatters that I had come across recently.
1. SQL Formatter for Notepad++ - Download and install Notepad++ plugin from link. Copying the DLL's and checking the Notepad++ Option listed below
Step 1. Copy the DLL's in plugin directory of Notepad++
2. Online SQL Formatter - Link
3. PoorSQL - Online SQL Formatter - Link
4. SSMS Tools pack - SSMS Addons - Link
5. Instant SQL Formatter - Online version - Link
6. Atlantis Interactive SQL Server IDE - Very good IDE for MSSQL - Link
7. SQLInform - SQL Online formatter - Link
Other Free Useful Tools
1. Programmers Notepad - Link
2. TextPad - Link
3. Notepad++ - Link
Happy Learning!!!
1. SQL Formatter for Notepad++ - Download and install Notepad++ plugin from link. Copying the DLL's and checking the Notepad++ Option listed below
Step 1. Copy the DLL's in plugin directory of Notepad++
Step 2. NotePad++ SQL Formatter Options2. Online SQL Formatter - Link
3. PoorSQL - Online SQL Formatter - Link
4. SSMS Tools pack - SSMS Addons - Link
5. Instant SQL Formatter - Online version - Link
6. Atlantis Interactive SQL Server IDE - Very good IDE for MSSQL - Link
7. SQLInform - SQL Online formatter - Link
Other Free Useful Tools
1. Programmers Notepad - Link
2. TextPad - Link
3. Notepad++ - Link
Happy Learning!!!
Labels:
QA Free Tools,
TSQL Code Formatting
March 17, 2013
Big Data Conference Tech Talks Talks
Please find Tech Talk videos of Interesting Big Data Sessions. Please refer session notes from previous posts
Big Data Analytics @ InMobi
Messaging architecture at Facebook
More Interesting Tech Talk Videos Please check hasgeek TV
Happy Learning!!!
Big Data Analytics @ InMobi
Messaging architecture at Facebook
More Interesting Tech Talk Videos Please check hasgeek TV
Happy Learning!!!
Labels:
Big Data
March 09, 2013
SQLite and Java Client
This post is on trying out SQLite and Java Client for querying databases. There were several results returned from google search. The following post Connect Java with SQLite using JDBC Tutorial
Download Links
Pretty much post was self-explanatory. Posting screenshots of the same project
Step 1 - Running Sqlite ( Pretty easy - console app)
Step 2 - DB and Table Creation
Step 3 - Create a Java Application and add SQLite JAR reference
Step 4 - Java Project Console Results - Path Changed to Where DB is present
Happy Learning!!!
Labels:
SQLite
March 06, 2013
Programming Learning Resources
Good Collection of Programming Learning Resources for Beginner's
Coding Tips - Link
AppendTo
LearnStreet
Code Avengers
Hackbright Academy
Another Good Collection of Learning Materials
Udemy
Learn to Code from Code Academy
Learn Web Design from Tree House
Read Quote of Abhishek Choudhary's answer to Learning to Program: What should I do to improve my programming skills in a short amount of time? on Quora
Read Want to learn Ruby on Rails? Start Here…
Read Quote of David Byttow's answer to Computer Programming: How do you keep your programming skills sharp? on Quora
Read Quote of Nagesh Salunke's answer to Computer Programming: What are the software concepts that every programmer should know? on Quora
Happy Learning!!!
February 24, 2013
Selenium Builder - Magic Tool for Web Testing
Selenium Builder tool caught my attention from recent selenium post. Selenium IDE is available past few years. It is very useful, robust to get started. The challenging problem for me was fixing XPATH related issues prior to web driver implementation. Selenium Builder seems to remove some of those pain points. In a quick dry run I found below things impressive about Selenium builder.
1. Converting from Selenium 1 to 2
2. Alternatives Suggestions for actions is amazing
3. Run Locally or against Selenium Instance
Earlier we have seen BITE - Browser Integration Test Environment - File Bugs from Browser Level
We Can Simplifying Manual Web Test Process by using
Happy Re-Learning!!!
1. Converting from Selenium 1 to 2
2. Alternatives Suggestions for actions is amazing
3. Run Locally or against Selenium Instance
Earlier we have seen BITE - Browser Integration Test Environment - File Bugs from Browser Level
We Can Simplifying Manual Web Test Process by using
- Selenium Builder to Records your exploratory tests and replay it for every build
- Any error encountered File Bugs using BITE
- Filing bugs is simpler, lot of details attached with bugs filed using BITE and reduces bug logging time
Happy Re-Learning!!!
Labels:
Selenium - Get Started
February 19, 2013
Web Test Automation Fundas - One Liners
Below notes are based on my personal learning's from project's I have worked on. This presentation from Bindu - Design Patterns in Automation Testing is the inspiration for this post.
Learning Tip #1 - Page Object - Create Class for Each Page in a website. Ex- HomePage, SearchPage Each Page will have a class on its own. These classes will have methods to simulate the functionality. All example posts on Developing Automation Framework in my blog is based on Page Object pattern
Learning Tip #2 - Factory Pattern - You will still have a single class for each page in your website. When you support multiple locales Factory Pattern is useful to simulate the method based on the locale specified in Test Run. Please refer this earlier post on Data Driven Testing and Design patterns. Example for Factory Pattern is provided in the example
Learning Tip #3 - Data Driven Testing - Running the same test for different Data Sets. Basically Automation Framework should be configurable to run against dynamic data sets (not limited to fixed data sets). Although this is a continuous challenge but this is achievable
Learning Tip #4 - Validation Procedures - Validating data need to be performed using independent Service Calls / DB Queries / Prepared Expected Results output. Use of XML to read configurable parameters, storing DB queries of different DB platforms (DB2, MSSQL, MYSQL..) would help to dynamically fetch queries based on the platform tests are executed
More Reads http://code.google.com/p/selenium/wiki/DesignPatterns
Page Object Pattern and how to use Selenium
Happy Re-Learning!!!
Learning Tip #1 - Page Object - Create Class for Each Page in a website. Ex- HomePage, SearchPage Each Page will have a class on its own. These classes will have methods to simulate the functionality. All example posts on Developing Automation Framework in my blog is based on Page Object pattern
Learning Tip #2 - Factory Pattern - You will still have a single class for each page in your website. When you support multiple locales Factory Pattern is useful to simulate the method based on the locale specified in Test Run. Please refer this earlier post on Data Driven Testing and Design patterns. Example for Factory Pattern is provided in the example
Learning Tip #3 - Data Driven Testing - Running the same test for different Data Sets. Basically Automation Framework should be configurable to run against dynamic data sets (not limited to fixed data sets). Although this is a continuous challenge but this is achievable
Learning Tip #4 - Validation Procedures - Validating data need to be performed using independent Service Calls / DB Queries / Prepared Expected Results output. Use of XML to read configurable parameters, storing DB queries of different DB platforms (DB2, MSSQL, MYSQL..) would help to dynamically fetch queries based on the platform tests are executed
More Reads http://code.google.com/p/selenium/wiki/DesignPatterns
Page Object Pattern and how to use Selenium
Happy Re-Learning!!!
February 18, 2013
Database Reads
Good Read - 6 Part Series on CAP Theorem
An analysis of the CAP Theorem
CAP Theorem Part 2: What is the CAP Theorem?
CAP Theorem Part 3: Definitions and terminology
CAP Theorem Part 4: The relationship between Consistency, Availability, and Partition Tolerance
CAP Theorem Part 5: Implications of the relationship between Consistency, Availability, and Partition Tolerance
Cap Theorem Part 6: Conclusion
Happy Reading!!!
February 12, 2013
Database Internals [Good Reads]
Please download and read white paper 'OLTP Through the Looking Glass, and What We Found There'
The whitepaper provides more details on current architecture of OLTP RDBMS Systems. I can closely relate it with MSSQL Server. It covers the key architecture details. The Paper evaluates options by eliminating some of the features based on current hardware systems and demonstrates significant performance gains
At a beginner level some of architecture keywords / concepts good to learn are
Two Phase Locking - A detailed note of how transaction is executed from Brent Ozar Post
The whitepaper provides more details on current architecture of OLTP RDBMS Systems. I can closely relate it with MSSQL Server. It covers the key architecture details. The Paper evaluates options by eliminating some of the features based on current hardware systems and demonstrates significant performance gains
- WAL (Write Ahead Logging)
- Log Manager
- Buffer Manager
- Two Phase Locking
- Concurrency
- Eventual Consistency
- Transaction Manager
I am posting some relavant simple explanations of the same based on MSDN documentation. WAL -
Write Ahead Logging (Source - Link)
Buffer Manager - Page is fetched to main memory through Buffer Manager (Source - Link)
Two Phase Locking - A detailed note of how transaction is executed from Brent Ozar Post
Concurrency Control - Governed by Isolation levels, Earlier discussed in same blog
Log Manager - Manages Logging, WAL
Eventual Consistency - Over a period of time the data will be consitent across different nodes (databases) distributed over network. Read More @ Consistency models in nonrelational dbs
More Reads
- ColumnStores vs. RowStores: How Different Are They Really?
- Materialization Strategies in a Column-Oriented DBMS
- Query Execution in Column-Oriented Database Systems
Happy Reading!!!
Subscribe to:
Posts (Atom)

