Brien Posey

1 day ago | itprotoday.com | Brien Posey

[Editor's Note: This is Part 3 of a three-part series on commonly used SQL commands.]So far in this article series, I have shown you various SQL Server commands for creating and deleting database tables, as well as commands for creating, modifying, and removing data records within a table. I'll conclude this series by demonstrating how to retrieve data from a SQL Server database table. Retrieving data from a SQL Server database table involves using a SELECT command.

3 days ago | awsinsider.net | Brien Posey

AWS Step-by-Step Brien Posey details how to protect internet-exposed AWS VPCs with firewalls and walks through the setup process. An AWS VPC is Amazon's version of a virtual network. Like any other virtual network, VPCs that are exposed to the internet need to be protected with a firewall. Even so, setting up a VPC firewall isn't quite as intuitive as you might expect. In this article, I will walk you through the process.

3 days ago | itprotoday.com | Brien Posey

[Editor's Note: This is Part 2 of a three-part series on commonly used SQL commands. Check back on April 23 for Part 3.]In my previous article, I showed you techniques for creating and modifying tables within a SQL Server database. We'll continue the discussion by demonstrating how to add data to the table you've created. Admittedly, data is normally added through an application, but such an application uses SQL commands internally to add data to the database.

6 days ago | redmondmag.com | Brien Posey

Posey's Tips & Tricks Here's how to restore missing context menu options and file associations in Windows when File Explorer shortcuts As strange as it might sound, Notepad has always been my editor of choice for writing PowerShell code. Sure, Notepad lacks a lot of the features that are found in other code editors, but I like Notepad's minimalistic interface.

1 week ago | itprotoday.com | Lastname Varchar |Brien Posey

The primary way to interact with a SQL Server database is with SQL commands. These commands are often embedded into applications but can also be used in command-line environments, such as PowerShell, or entered directly into the SQL Server Management Studio. In this three-part series, I'll explain some of the most commonly used SQL commands. Check back soon for Parts 2 and 3. Every SQL Server database contains one or more tables.