Category: SQL Server

Compare The Market – Data Science vs Analytical Skills

Tweet“You can have data without information, but you cannot have information without data.” – Daniel Keys Moran By far, from my experience it is essential to build your argument/position having a supportive data at hand, we can’t just win the…

Solving The Issue Of SQL Server Physical File Fragmentation

TweetSQL Server physical file fragmentation causes major performance issue in database, it happens when data is deleted from a drive and left small gaps to be filled by new data files. In File fragmentation the logical sequential pages are not…

Guidelines For SQL Database Performance Monitoring

TweetOverview Monitoring SQL Server databases and instances provide the necessary information to diagnose and troubleshoot the performance issues. Once its performance is tuned then, it has to be constantly monitored as everyday data schema. Its configuration changes may lead to…

Understanding SQL Server Transaction Log Architecture

TweetTransaction log is a log that maintains the record of every transactions that has occurred. It involves data modifications, rollback modifications and database modifications. It is a major part of database’s architecture. It records every transaction in an order by…

Data Science – build your skill with problem-solving, communication, curiosity and knowledge in data platform

TweetIn the flurry of recent posts about data science topic I have had feedback about what kind of skillset is required for a Data Scientist, so here is the extract. If you want to compete and be intelligent, then it…

This computer does not have the Oracle Java SE Runtime Environment Version 7 Update 51 (64-bit) or higher installed.

TweetYou may have guessed rightly that this is an error message during an installation. As you may know SQL Server 2016 – “a new platform for intelligent application” is generally available to deploy in production platform. While I was installing SQL…

SQL Server 2016 ‘It Just Runs Faster’

TweetIt will need guts to release such a statement, that too announcement about SQL Server 2016 – it just runs faster. Not a simple statement for marketing purpose, but real-world improvements and hard-work efforts made the new version 2016 as…