Geeks With Blogs

News 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 Data
Netflix Sneak Peak
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 skim over some of their technologies and processes. As expected they do a LOT of data processing. How do they do it so efficiently and with excellence? ......

Posted On Friday, October 28, 2016 5:53 PM

DB Indexes
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 JOIN sys.columns col ON ic.object_id = col.object_id and ic.column_id = col.column_id INNER JOIN sys.tables t ON ind.object_id = t.object_id WHERE ind.is_primary_key ......

Posted On Friday, June 6, 2014 3:25 PM

Creating SSIS Package Templates for Reusability
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 with a basic structure/workflow and common components which can be used as template to create subsequent packages?Below is a great article for this solution:http://www.mssqlti... ......

Posted On Monday, May 26, 2014 6:53 PM

Copyright © Erald Gjoni | Powered by: GeeksWithBlogs.net