The grep command is perfect in these situations and we explore some of it’s capabilities here.
While many organisations have moved over to “The Cloud” many are nervous of making the move with security being the number one concern. I came across a couple of interesting articles last week, which I thought I would share with you as they highlight some common IT security concerns among IT Security Managers and present some possible solutions to protect your company from common threats.
Although we can create Linked Tables in Access that pull information from a SQL Server Database there are times when you want to check a value or lookup a value from an underlying SQL Server database directly from an Access Query.
We will look at an example that enables us to lookup a customer’s total revenue value from an Access Query.
Although we can create External Data Sets in Excel that pull information from a SQL Server Database there are times when you want to check a value or lookup a value from an underlying SQL Server database directly from an Excel formula.
We will look at an example that enables us to lookup a customer’s total revenue value from an Excel Formula.
It is easy enough to extract the first word from a string in a database query, but what if you need to separate all words in a given string into a list of separate words?
This is a job for Common Table Expressions (CTEs) as they enable us to repeatedly read a single record while changing it each time.
Here is a SQL Server example which takes a string variable and spearates it into inidividual words. We use a combination of CHARINDEX, LEFT and RIGHT functions to achieve it.
Linux Systems offer an X Windows interface which can make changing system settings and configuration pretty straight forward, but what if you remotely log in via a Secure Shell (SSH) session using a tool such as putty?
Here is how to change the system date and time and the hostname from the command line.
The date command can be used by root to change the system date and time.
If you've heard of the cloud, and wondered what it could do for your business, you've probably encountered a dazzling lexicon of jargon about it - as well as some who claim it's the future of IT, and others who say it's complex and problematic. So what is cloud computing and what is the truth? As is so often the case, it comes down to using the technology effectively, not just using it because it's there...
The dictionary definition of cloud:
If you work with SQL Server based applications then probably quite a few!
No matter what the application you are working with (CRM, Sales Order Processing, Financial Accounting, Contact Management, Booking System (to name but a few!)) there is a database behind it. Most common applications will store their data in either a Microsoft SQL Server Database or an Oracle Database (of course there are other relational database platforms out there).
Adding a Button to an Access Form using the Command Button Wizard
Adding an OpenQuery Macro to an Access Form
