Posts

Showing posts from October, 2018

Why Construction Companies Outgrow the Software They Started With

Image
  A construction company can have plenty of software and still spend a surprising amount of time moving information between systems. The estimator works in one system. Project managers use another one . Accounting has its own platform. Field teams submit reports through a mobile app. Schedules live somewhere else. And somewhere in the middle, everyone usually depends on an Excel file. Each system may work well on its own. The trouble starts when information has to move  between them. A change order gets approved, but accounting doesn't see it until someone sends an update. A project manager needs the latest cost information, so someone exports a report. A new project is won, and the team manually enters customer and contract information into another application. This is often when construction companies realize they don't necessarily need more software . They need software that works better together. When Off-the-Shelf Software Stops Fitting Off-the-shelf construction softw...

The most dangerous command in SQL

Image
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...