Project Overview This repository contains SQL queries developed to assist in investigating employee login activities and managing department-specific system updates within a large organization. The ...

My organization is working to make their system more secure. It is my job to ensure the system is safe, investigate all potential security issues, and update employee computers as needed. The ...

One of the critical decisions facing companies embarking on big data projects is which database to use, and often that decision swings between SQL and NoSQL. SQL has the impressive track record, the ...

I have written an application that takes in a fixed-width file (thanks in no small part to advice I recieved in a seperate thread) and then dissasembles each line, runs a fairly meaty SQL SELECT query ...

In my last article, Quick and Dirty with Open Office Base, I described my initial experiences with building a simple database application for my wife in Open Office Base, having had no prior ...

You can use RSPT to reduce network traffic and to shift CPU load by sending queries for remote data to a remote server. Note: If the server is a SAS/CONNECT remote host, you can also remotely submit ...