Category: Best Practices

Bye bye SQL Server 2005, now is the time for you to #upgrade

TweetFrom today SQL Server 2005 will no longer have any support from the Microsoft, which means no security updates or hotfixes that might affect your production platform if you are still managing 2005 version instances. Microsoft and partners (along with MVPs)…

Data Driven event live – don’t miss the opportunity

TweetThere is no doubt that Microsoft is making big impact within data platform arena with new features and fixtures in SQL Server 2016 version. You name it: advanced analytics, distribution processing, cloud & on-premise data management with stretch database, R…

Machine Learning – new thinking in Data platform world

TweetIn the recent times technology is not limited to a vendor or product, open source is one arena where data mining and data warehousing techniques opened up new ventures and methods to look for patterns than formulated results. This is…

Troubleshooting Transactional Replication In MS SQL Server

Troubleshooting SQL Server Replication

TweetOverview Replication in SQL Server can be defined as the technique of copying and distributing data from one database to another database and then synchronizing between databases to maintain consistency. It helps in improving performance, easy maintenance reducing conflicts when…

Business Analytics and Data Science – launch and decide career in data platform

TweetThe multitude of Business Intelligence and Data Warehousing is mature enough with necessary tools & technologies, based on this business users are well versed with requirements. However, the new age of data analysis turned into expansion of Analytics which has…

PaaS – get to know SQL data warehouse loading patterns and strategies

TweetPaaS (Platform-as-a-Service) is best chosen when majority of your business needs relies upon web, not having necessity of storing data on-premise. A popular choice within cloud computing services.Combing with Infrastructure as a Services that provides virtual machines and/or storage from…