Skip to main content

Posts

Showing posts from October, 2018

5 Powerful Tools Every Business Needs to Start with Business Analytics

  I n troduction   In today’s data-saturated world, successful businesses aren’t just collecting data but making sense of it. Whether you’re a startup looking to optimize operations or an established enterprise aiming to uncover new revenue streams, business analytics is the key to unlocking smart, strategic decisions. But getting started can feel overwhelming without the proper foundation.   That foundation starts with the tools . From organizing raw data to visualizing insights and making data-backed decisions, the right business analytics tools can help transform your business from reactive to predictive, even prescriptive. In this article, we’ll explore five essential tools that every business needs to build a solid analytics strategy and how they fit into a broader data engineering solution designed by data engineers.    Top 5 Tools for Business Analytics   Power BI / Tableau: Visualize to Realize   The first thing that likely comes to mind w...

The most dangerous command in SQL

Vijay is a SQL Server/Microsoft Data Platform professional with over 10 years of experience working in various fields such as financial, healthcare, and Manufacturing Domains. He has worked in various DB-related roles from database Modeler to database developer to Data Warehouse. The most dangerous command in SQL There’s one command, in particular, that has been effectively hidden since it was introduced pre-SQL Server 2000. I present to you  DBCC WRITEPAGE  – the most dangerous command you can use in SQL Server. Well, no danger of death  DBCC WRITEPAGE  allows you to alter any byte on any page in any database, as long as you have sysadmin privileges. It also allows you to completely circumvent the buffer pool, in other words, you can force page checksum failures. The purposes of  DBCC WRITEPAGE  are: To allow automated testing of  DBCC CHECKDB and repair by the SQL Server team. To engineer corruptions for demos and testing. To a...