Author Archives: Spradlike

About Spradlike

Husband and father, epilepsy survivor, avid percussionist, technology enthusiast...insisting on the road less traveled.

Unix – beginnings

Today, we covered in class – basic commands for unix. Log into the system, run id and pwd to discover location and who you are connected as. users need to belong to at least one group id -a id -a … Continue reading

Posted in Tools and Tricks, Unix | Tagged | 1 Comment

Check existing databases then create

— CHECK existing databases for existence. if exists (select * from master..sysdatabases where name = ‘dbName’ ) drop database dbName GO create database dbName on primary (name = ‘dbName’, filename = ‘C:\data\dbName.mdf’), log on (name = ‘dbNameLOG’, filename = ‘C:\data\dbName.ldf’) … Continue reading

Posted in SQL, Tools and Tricks | Tagged | Leave a comment

Objects Query

/* Select ALL table names and column names from a given table. */ select o.name as [TableName], c.name as [ColumnName] from sys.objects o inner join sys.columns c ON o.object_id = c.object_id where 0=0 and type = ‘U’ — and c.name … Continue reading

Posted in SQL, Tools and Tricks | Tagged | Leave a comment

Data and log file iteration

——————————————————————– — This will generate a list of databases to iterate through and pull — data and log file locations, plus size, etc. — There are 2 parts. 1 generates the list and 2 creates the output. ——————————————————————– /* PART … Continue reading

Posted in SQL, Tools and Tricks | Tagged | Leave a comment

Check Space

—————————————————- — WORK IN PROGRESS — xp_fixeddrives joined with sys.masterfiles view — Looking at space, judging db size, growth and — free space on the server. — use sp_helpfile for SQL 2000 —————————————————- set nocount on declare @fixeddrives table — … Continue reading

Posted in SQL, Tools and Tricks | Tagged | Leave a comment

Checking Active Partition – Windows 7

Recently, I messed up the installation on my son’s machine. I removed the first partition and did not adjust the boot loader. This left Windows 7 (2nd partition) unbootable. I spent some time running through tests and trying to figure … Continue reading

Posted in Tools and Tricks | Tagged | Leave a comment

Windows 7 Startup Repair Disc

The bad news is that this is not readily available in most cases, as the operating system is pre-installed, and (in most cases) the operating system disc is not included when you purchase a desktop/PC. What this means is that … Continue reading

Posted in Tools and Tricks | Tagged , | Leave a comment

Social media to spread your cause, but what about the hardware and software?

There are numerous articles on making use of social media to help spread the word about a nonprofit organization, but what about the hardware and software facilitating this communication? At the heart of this communication lie the bits and bytes … Continue reading

Posted in Nonprofit Technical Support | Leave a comment