Skip to main content

Posts

Showing posts from May, 2019

A Blog – Its importance & Why Every Business Needs One

In today’s digital world, every business needs a website. Modern business owners and managers understand the need to have a presence on the web. What is surprising, though, is the number of businesses that don’t leverage the power of a blog at all. Or, they have one, but they rarely update it. Here’s a look at what you are missing out on if you don’t make regular use of one. A Blog Grows and Strengthens a Brand A blog helps to build and strengthen a brand. Without one, building a brand can be an uphill struggle. It provides you with the opportunity to connect with customers and prospects and allows you to convey the ethos of your business. It also gives you a platform on which you can tell the stories that will create interest in the brand and foster brand loyalty. It Fosters a Community Blogs help you build a community around your brand. They can encourage feedback, reviews and comments. When you post relevant and engaging content, the community will grow. As more p

Dangerous command in SQL

SQL Server/Microsoft Data Platform professional with over 10 years of experience working in various fields such as financial, healthcare, and Manufacturing Domains. we have 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 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 by manu