Posts

Showing posts from October, 2018

Why Financial Visibility Is Becoming a Competitive Advantage in Construction

Image
Introduction The hardest part of the job has never been winning projects; rather, the real challenge is keeping them profitable once they start. Projects generate hundreds of thousands of decisions regarding additional work authorizations, time tracking, equipment usage, subcontractors, materials, and many other details. If such data flows freely within the organization, company executives can gain insight into how projects are going and address minor problems before they become major. Unfortunately, that's not what happens all the time. In rapidly growing construction businesses , project information is scattered across emails, spreadsheets, handwritten documents, mobile phones, accounting applications, and other sources. Each department knows its little bit of the story, but no one has the whole story at the moment it matters most. That's why financial transparency is no longer just about reports. Financial transparency is now a competitive edge that enables contractor...

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