Erald Gjoni

10 Posts | 0 Comments

I currently work as a Senior Software Developer for a Furniture Company. I work closely with the E-Commerce team and support their whole infrastructure. Previously, I did continuos development for over 8 years at a technology company, while maintaining operations for a bank.

For most companies, development and operation teams play a game of volleyball passing blame on each other when service/product has issues. Lack of communication and understanding between the two, causes costly and timely problems for every company. DevOps is not a title, nor is a position. DevOps is culture represented by a white flag waved from both directions. Cooperation and Communication are at the heart of DevOps. It tears down the wall and pride of these two very valuable entities inside a company and unleashes the power of teamwork towards a common goal!

Erald Gjoni

Oct 16

Netflix Sneak Peak

Comments | Share

This past week I had the privilege to peek behind the curtain of a service provider that has become a streaming titan in a relatively short time. We all have been guilty of hanging up our responsibility coat at the door, and binge watch a favorite show on a variety of devices. Netflix, kindly sent a representative at the 2016 SQL Pass conference to ......

Posted On Friday, October 28, 2016 5:53 PM devops , Data , Azure , SqlPass , bigdata , AWS , Netflix

SQLPass First Timer

Comments | Share

Finally, after 3 years of wanting to make it to Pass Summit, the planets aligned and I was able to go. So far it has been a great experience. However, it once again reiterates the magnitude of the Data World that appears to be forever expanding. If "drinking from a fire hose" depicts an image in your head of someone overwhelmed and water splattering ......

Posted On Friday, October 28, 2016 1:24 PM sql , Microsoft , Sql Server , Azure , SqlPass

May 15

Application Insights

Comments | Share

Data is a concept that no longer needs an extensive introduction to portray its glory. While each business takes advantage of it in their own way, I have come to know it from an E-Commerce point of view. Recently, our team members have embraced the idea of Data Driven Decision. After all, "A decision without data, it's just another opinion" according ......

Posted On Monday, May 18, 2015 7:28 PM Devlopment , analytics , Google Analytics , Application Insights

May 15

Treat technology like your 401k!

Comments | Share

What is the first thing every financial advisor usually tells you? Diversification of your funds is key to success!!! I look at technology the same way. Why have all your eggs in one basket?Statistics show that technology has a radical turn over every two to three years. Think of what your phone looked like or what its capabilities were two years ago ......

Posted On Sunday, May 10, 2015 2:05 PM development , Microsoft , asp.net , Sql Server

May 15

Microsoft Ignite

Comments | Share

This past week I had the opportunity to attend my very first Microsoft conference, Microsoft Ignite in Chicago, IL. Aside for the intimidating size of McCormick Place which played host to 23,000 attendees over the last 5 days, I was surprised to see the number of vendors which their whole business revolves around implementation of Microsoft Technology. ......

Posted On Saturday, May 9, 2015 3:38 PM devops , development , Microsoft Ingnite

Jun 14

DB Indexes

Comments | Share

Below is a quick query that identifies information about Indexes in a particular DB.SELECT TableName = t.name, IndexName = ind.name, IndexId = ind.index_id, ColumnId = ic.index_column_id, ColumnName = col.name, ind.*, ic.*, col.* FROM sys.indexes ind INNER JOIN sys.index_columns ic ON ind.object_id = ic.object_id and ind.index_id = ic.index_id INNER ......

Posted On Friday, June 6, 2014 3:25 PM devops , sql , Data , index

May 14

High Availability and Redundancy Plan

Comments | Share

What's your failover plan. In today's world downtime equates lost money for most companies. High availability & up time is so crucial, that most are willing to spend the money and mirror their primary environment. We are all familiar with the infamous banner: "The website is down for routine maintenance". It's as annoying as counterproductive. In ......

Posted On Wednesday, May 28, 2014 7:50 AM devops , redundancy , high availability , failover , load balancing

May 14

Creating SSIS Package Templates for Reusability

Comments | Share

We often need to create similar SSIS packages which contain some common components such as connection managers, data flow components, log providers, event handlers, etc... So do we really need to create a package from scratch each time and add all these commonly used components in each package again and again. Is it possible to create a SSIS package ......

Posted On Monday, May 26, 2014 6:53 PM devops , ETL , SSIS , SSIS Template , Data

May 14

DB space check

Comments | Share

Here is a quick query to identify your db status when it comes to disk space:SELECT ds.name as filegroupname, df.name AS 'FileName' , physical_name AS 'PhysicalDBName', size/128 AS 'SizeInMB', size/128.0 - CAST(FILEPROPERTY(df.name, 'SpaceUsed') AS int)/128.0 AS 'RemainingSpaceInMB' , CAST(FILEPROPERTY(df.name, 'SpaceUsed') AS int)/128.0 AS 'SpaceUsedInMB', ......

Posted On Sunday, May 25, 2014 8:22 PM sql , t-sql , database size

DEVOPS!?!?

Comments | Share

Posted On Sunday, May 25, 2014 7:44 PM devops , development , operations , communication