Tag: sql server

Hadoop – facts and myths

TweetWhen it comes to Big Data, Hadoop comes into picture – having an unique position within data platform in processing/managing multi-structured data for analytics and visualisations. Business Intelligence and Data Warehousing are key strategies to manage data platform, so as…

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…

SQL Server R Service – enterprise-scale data science

TweetData Science is the new workforce that has geared up in most of business domains now,data is a centric force for every organisation irrespective of size-of-business. In this space when Microsoft acquired Revolution Analytics that marks development tools and enhanced R…

What is Big Data – brief notes and technology players?

TweetData, data and data everywhere. Relational and Analytical data forms have been here for a very long time, now the new form of data has evolved which is Big Data. A natural evolution of data, more efficient ways to process…

Truncate and Shrink Transaction Log: What To Choose?

TweetTransaction file is the most vital element yet overlooked sometimes. The transactions carried out in the SQL Server database are recorded and logged into the transaction log database. This is why the file is named ‘Transaction Log Database’. There exists…

DocumentDB – have a look at new possibilities from NoSQL JSON database

TweetWhen you are dealing with applications with query and transactions over schema-free database then you are not new about NoSQL way of dealing such development. Rather call it as non-relational way of dealing the database, Azure DocumentDB is a NoSQL…

Meet and greet your data with Power BI empowerment

TweetIn the current times data is most important arsenal for any company to analyse, mine and visualise required information without having a dependancy on external sources. Being a Data Analyst right software is always helpful to create visualisations and get…