Skip to main content

Posts

The Hidden Opportunities of Internet of Things (IoT)

IoT is a network of connected objects that can collect and exchange data. It has been around for a while, but only recently has it become more mainstream. IoT is not just for consumer products, there are also many opportunities in the enterprise. The internet of things is often called the “next big thing” and is largely responsible for the rise of big data. The internet of things provides us with an unprecedented amount of information on how people use their products, how they behave in their homes, and what they do at work. Along with  AI , The Internet of Things is changing the expectations of consumers. It will also change the way that businesses operate. The initial uptake of interconnected smart devices was slower than was forecast. But, the demand for technology is now developing at a rapid pace. That demand will place new pressures on businesses. It will also provide businesses with new opportunities. Here are some of the ways that the Internet of Things will impact the busine

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 allow for last-ditch disaster recovery b