Michael Otey

While virtually every organization makes sure their servers are backed up, that’s not always the case for endpoints. While some larger organizations have backup products that are capable of protecting desktop PCs and mobile devices like laptops, many smaller and medium sized business do not. I think it’s fair to say that a good percentage of PCs are not backed up at all.

As organizations struggle to find a new balance between expanding remote work options and repatriation back to the office, endpoint management has become a top issue. And with the growing risk of cyberthreats becoming more tangible every day – effective endpoint management is essential to ensure security and compliance. Unified Endpoint Management (UEM) solutions allow organizations to manage, monitor, secure, and ensure compliance remotely and through a single-pane-of-glass.

The T-SQL ALTER TABLE statement is used to modify the structure of a table. Using the T-SQL ALTER TABLE statement you can add new columns, delete columns, change the data type of existing columns, or create indexes or constraints. ALTER TABLE can also reassign and rebuild partitions and/or disable and enable constraints and data compression. Let’s take a closer look at how to use the T-SQL ALTER TABLE statement for some of the most common T-SQL operations.