Software Craftsperson
Home
About
Search
Software Craftsperson
  • LINQ - watchout for slow queries

    Feb 14, 2016 | 4 min read SQL sql server ssms query optimization linq
    Share on:

    LINQ or Language Integrated Query is great for application developers to develop applications that interact with databases. But remember it is a tool and like every tool, you have to use it wisely to achieve the best results. I currently maintain a web based application that is meant to allow job scheduling, and …


    Read More
  • SQuirreL graphical user interface for Vertica

    Sep 24, 2013 | 5 min read SQL SQuirreL GUI SQL client vertica
    Share on:

    Hey guys, I tried out DBVisualizer earlier. I liked it and I have blogged about setting that up for your Vertica database. But it is expensive. I mean I can't buy it for my personal use unless a company actually sponsors me. I'm a poor developer you see. So I searched for alternatives and I kind of liked SQuirrel SQL …


    Read More
  • Vertica Query Performance Tuning - An introduction

    Sep 12, 2013 | 5 min read columnar database hp vertica SQL performance query optimization vertica
    Share on:

    Hey there, I guess you have been having a lot fun with your Vertica databases. I thought I'd share some of the things that I did to improve my query performance. Tables and Projections in Vertica In Vertica even though we access data through tables everything is stored in projections which are stored among nodes in …


    Read More
  • Vertica and its version - Find out using SQL

    Jun 24, 2013 | 1 min read SQL vertica version
    Share on:

    I was playing around with Vertica and my friend suddenly asked me what version of Vertica I was using. This was because he was trying to debug something and posted a question to guys from Vertica and they asked him that question. At my workplace we use the same Vertica cluster for development. It is a playground with a …


    Read More
  • Exploring Vertica's INTERPOLATE predicate

    Jun 18, 2013 | 1 min read hp vertica interpolate previous value SQL analytical sql dbms back fill interpolate vertica fill previous value
    Share on:

    Vertica has a special feature to join tables and fill in the last available values where values would otherwise be null. I had a similar use case and wanted to test how I could make the best use of it. I played with simple examples and got it right, but with a slightly more complex one, I was stuck or maybe I just …


    Read More
  • Vertica - Calendar table with dates from a start date to an end date using analytical SQL

    Jun 18, 2013 | 1 min read columnar database hp vertica SQL calendar dbms dates vertica database systems
    Share on:

    I had a problem creating a table with just SQL that is supported by Vertica. Most of the solutions that I came across online were using procedures. But after a lot of playing around and reading vertica documentation I found a solution to my problem. read more about the problem and the solution at Stackoverflow


    Read More
  • Viewing function definitions in Vertica

    Jun 5, 2013 | 2 min read database SQL vsql view function definition export_objects vertica
    Share on:

    I don't know if you have tried this. But I did try to read function definition from the system tables in Vertica. I used the table called USER_FUNCTIONS which is a table in the V_CATALOG system schema. More details can be found here: https://my.vertica.com/docs/6.1.x/HTML/index.htm#15021.htm But unfortunately when I …


    Read More
  • Vertica DELETE columns from one table using data from another

    May 30, 2013 | 2 min read hp vertica SQL vsql vertica
    Share on:

    My colleague had an issue in Vertica. He had a set of values in table 1 to be deleted based on the records in a table table2. I didn't think this would be easy considering VERTICA didn't support joins when doing deletes unlike MYSQL. But they do have something else. Let me take you through the steps I followed. I …


    Read More

Eakan Gopalakrishnan

Software craftsperson and hobbyist photographer who loves tech, music, dance and staying fit.
Read More

Featured Posts

  • DevOps, Continuous Integration, Delivery and Deployment
  • Azure Cognitive Search (formerly Azure Search)
  • Git, Case Sensitivity and Github actions
  • Client Side Search for your Hugo Blog with Fuse.js
  • Event Storming
  • Good Bye Wordpress. Hello Hugo on Azure Storage
  • Containers! Docker! Virtual Machines! What exactly do they do?

Recent Posts

  • Azure Service Principal Credential Reset
  • Coaching conversations using the GROW Model
  • Leadership, trust and how not to ruin it
  • What are Git submodules?
  • What is Agile Scrum?
  • Building software quality from Day 1 using Lean Quality Assurance
  • Customize your Mac or Linux prompt or terminal
  • Site Reliability Engineering vs Devops: What are they? How do they differ?

Categories

SOFTWARE-DEVELOPMENT 37 LEADERSHIP 4 TECHNOLOGY 3 WEB-DEVELOPMENT 3 DATABASES 1 DEVOPS 1 DOMAIN-DRIVEN-DESIGN 1 SOFTWARE-ARCHITECTURE 1 SYSTEM-DESIGN 1 TOOLS-AND-UTILITIES 1
All Categories
DATABASES1 DEVOPS1 DOMAIN-DRIVEN-DESIGN1 LEADERSHIP4 SOFTWARE-ARCHITECTURE1 SOFTWARE-DEVELOPMENT37 SYSTEM-DESIGN1 TECHNOLOGY3 TOOLS-AND-UTILITIES1 WEB-DEVELOPMENT3 WEB-HOSTING1
[A~Z][0~9]

Series

ENTITY-FRAMEWORK-CORE 5 PRACTICAL-GIT 5

Tags

VERTICA 10 LINUX 8 SQL 8 .NET-CORE 7 AZURE 7 GIT 7 HP-VERTICA 7 VERSIONING 7 PERL 5 SCM 5
All Tags
.EMACS1 .NET-CORE7 .NET-FRAMEWORK1 ACTIVE-DIRECTORY2 ADVANCED-USER1 AGILE1 ANALYTICAL-SQL1 APPLICATION-MONITORING2 ARCHITECTURE1 AUTHENTICATION1 AUTOVIVIFICATION1 AWK1 AZURE7 AZURE-BLOB-STORAGE1 AZURE-FUNCTIONS2 AZURE-PIPELINES1 BACK-FILL1 BASH4 BEST-PRACTICES1 BICEPS1 BIG-DATA1 BIND1 BLOG1 BLOG-HOSTING1 BLOGGER1 C#1 C++1 CACHE1 CALENDAR1 CAREER1 CATALYST2 CD1 CHAINING-COMMANDS-USING-PIPE1 CI1 CLOUD1 CLOUD-NATIVE1 COACHING1 CODE-COVERAGE1 CODING1 COHESION1 COLUMNAR-DATABASE3 COMMAND-LINE2 COMMUNICATION1 CONTAINERISATION1 CONTAINERS2 CONTINUOUS-DEPLOYMENT1 CONTINUOUS-INTEGRATION3 COPY-LINE1 COUPLING1 CPAN1 CSHARP2 CSV-FORMAT1 DATA-EXTRACT1 DATA-STRUCTURES2 DATABASE2 DATABASE-CONNECTION1 DATABASE-DESIGN1 DATABASE-DESIGNER1 DATABASE-SYSTEMS1 DATES1 DBMS2 DBVISUALIZER1 DDD2 DEBIAN2 DEVOPS2 DHCP1 DIR1 DISTRIBUTED-DATABASE-SYSTEM1 DOCKER2 DOMAIN-DRIVEN-DESIGN2 DOTNET1 DYNAMIC-TITLE1 EDITOR1 EF-CORE1 EMACS2 EMPATHY1 ENTITY-FRAMEWORK-CORE4 ERROR-HANDLING1 EXCEPTION-HANDLING1 EXPORT_OBJECTS1 EXTRACT1 FEATURE1 FEATURETOGGLE1 FILL-PREVIOUS-VALUE1 FUNCTIONS1 FUSE1 GIT7 GITHUB-ACTIONS1 GNU-EMACS1 GNU-SCREEN2 GOHUGO1 GUI1 GUI-FOR-DBA1 HACK1 HARDSTATUS1 HASH1 HELP1 HIGH-PERFORMANCE-DATABASE-SYSTEM1 HISTORY1 HP-VERTICA7 HUGO1 IFCONFIG1 IMPORT-DATA-TO-EXCEL-FROM-VERTICA1 INCLUDE1 INDEX1 INSTALL1 INTERPOLATE1 INTERPOLATE-PREVIOUS-VALUE1 INTRODUCTION1 JAVASCRIPT2 KEYMAP1 KNOWLEDGE-DISCOVERY1 LAMBDA1 LEADERSHIP2 LINQ2 LINUX8 LOGGING1 LS1 MANAGEMENT2 MARTIN-FOWLER1 MENTORING1 MICROSOFT1 MICROSOFT-AZURE3 MIGRATE1 MODULE2 MOTIVATION1 MULTIPLE-COMMANDS-TO-XARGS1 MYSQL1 NETWORK1 NETWORK-CONFIGURATION1 NETWORK-INTERFACE1 NETWORKING1 NODE1 NODEJS1 NPM1 OBJECT-ORIENTED-ANALYSIS-AND-DESIGN1 OPENAPI1 OPENJSON1 OPENVMS1 OPERATING-SYSTEMS1 ORACLE1 ORM4 PARTITION1 PATH1 PEOPLE-MANAGEMENT1 PERFORMANCE1 PERL5 PERL-HASH-PROBLEM1 PIPELINES1 POWER-POINT-PRESENTATION1 PROBLEM-DETAILS1 PRODUCTIVITY1 PROGRAMMING2 PROMPT2 PUTTY1 PUTTYGEN1 QUALITY1 QUERY-OPTIMIZATION2 QUOTING1 REACTJS1 READ1 REFACTOR1 RELATIONAL-DATABASE-DESIGN1 REPL1 RESPONSIVE1 REST1 SCM5 SCREEN1 SCRIPTING1 SCRUM1 SEARCH2 SERILOG1 SERVERLESS1 SHARE1 SHELL3 SHELLSCRIPT1 SHELLTITLE1 SHORTCUTS1 SITE-RELIABILITY1 SOFTWARE-DESIGN1 SOFTWARE-ENGINEERING5 SQL8 SQL-CLIENT1 SQL-SERVER2 SQUIRREL1 SSH1 SSMS1 STATIC2 STATIC-SITE-GENERATION1 STRUCTURED-DESIGN1 SURROGATE-KEYS1 SWAGGER1 SYSTEM-DESIGN1 TABLE-PARTITION1 TEAMWORK1 TERMINAL3 TERMINAL-EMULATOR1 TERMINAL-MULTIPLEXING2 TEXT-EDITOR1 TIPS2 TITLE1 TOGGLE1 TRICKS2 TRUST1 TUTORIAL2 TYPE1 UBUNTU4 UI-DEVELOPMENT1 UNIT-TESTS1 UNIX1 VERSION1 VERSION-MANAGEMENT5 VERSIONING7 VERTICA10 VIEW-FUNCTION-DEFINITION1 VIRTUAL-BOX2 VIRTUAL-MACHINES1 VIRTUALISATION1 VISUAL-STUDIO1 VSCODE1 VSQL3 WEB-API1 WEBAPI1 WINDOW-TITLE1 WINDOWS2 WINDOWS-81 WINDOWS-8.11 WINDOWS-OPERATING-SYSTEM1 WORDPRESS1 XARGS1
[A~Z][0~9]
Software Craftsperson

Copyright  SOFTWARE CRAFTSPERSON. All Rights Reserved