PowerShell: UNC File Copy with Credentials - author: jason - date: 2019-05-04 09:58:53
Copy a file with PowerShell to a remote share with a hard coded user and password. Sounds simple, bu ... Read More

PowerShell: Invoke-SqlCmd - author: jason - date: 2019-05-04 09:41:55
PowerShell can be configured to run SQL commands. And it's pretty easy to do so... Join the fun! ... Read More

PowerShell: Deluxe Bulk Insert CSV! - author: jason - date: 2019-05-04 09:29:11
Use PowerShell to read the list Column Names from a CSV, Create a Table in SQL, and then Bulk Insert ... Read More

SQL 2017: Bulk Insert, now with Quotes! - author: jason - date: 2019-05-04 08:17:58
So... SQL just got the ability to import quoted fields as of SQL 2017. Where have you been all my ... Read More

Visual Basic: Multiline Literals, Its the Strings, Really... - author: jason - date: 2019-05-03 10:39:05
New in VB14 is strings that can go on more than one line!! Wowser... So, I did a couple things i ... Read More

Windows 2016: Remote UNC with Local User - author: jason - date: 2019-05-03 10:21:26
I ran into a problem the other day with a couple Windows 2016 servers that were in a Workgroup (not ... Read More

C#: SQL Execute a Stored Procedure with Parameter and fill DataSet - author: jason - date: 2019-01-20 14:27:43
Further building on the previous connecting to SQL statements... Below we are executing a Stored Pr ... Read More

C#: SQL ExecuteNonQuery - author: jason - date: 2019-01-20 14:01:25
Building upon the previous SQL Connect with Using, here is executing a non-query, i.e. a tsql statem ... Read More

C#: SQL Connection with Reader and Using - author: jason - date: 2019-01-20 12:53:52
Here is a quick an easy code snippet for grabbing query results from a sql database. According to t ... Read More

C#: DataTable to Csv String - author: jason - date: 2019-01-19 15:42:09
Often I need to send a DataTable out as a CSV. And I need the fields wrapped in quotes. Here is so ... Read More

C#: Conditional Operator ?: - author: jason - date: 2019-01-19 14:46:13
I frequently want to set null/blank/empty things to actually be something. I also frequently forget ... Read More

SQL 2017: Combine Concat_Ws with String_Agg - author: jason - date: 2019-01-19 13:58:09
Oh my, we're getting crazy now, combining CONCAT_WS with STRING_AGG. What's going to happen!?? I'm ... Read More

SQL 2017: Translate over Replace - author: jason - date: 2019-01-17 11:23:20
In SQL 2017 a more powerful TRANSLATE command can be used instead of REPLACE. What would take multi ... Read More

SQL 2017: Concat_WS - Another String Builder - author: jason - date: 2019-01-17 11:21:28
SQL 2017 introduces more string building with CONCAT_WS, i.e. concatenate with string. This is tre ... Read More

SQL 2017: Trim me up - author: jason - date: 2019-01-17 11:19:33
Introduced in SQL 2017 is the TRIM command. No longer do you need to RTRIM and LTRIM. Now you can s ... Read More

SQL 2017: String Aggregate - author: jason - date: 2019-01-17 11:17:34
This new string aggregate function in SQL 2017 is way cool. If you need to build a Column from Rows ... Read More

SQL 2016: New Date features - author: jason - date: 2019-01-17 11:14:18
There are some new Date features in SQL 2016: DATEDIFF_BIG, AT TIME ZONE, and sys.time_zone_info ... Read More

SQL 2016: Send to JSON - author: jason - date: 2019-01-17 11:12:48
In SQL 2016 you can natively send data out as JSON, which is pretty nice since quite a few languages ... Read More

SQL: Make string with FORMATMESSAGE - author: jason - date: 2019-01-17 11:08:56
According to Microsoft, this was introduced in SQL 2008. FORMATMESSAGE lets you build a nvarchar st ... Read More

SQL 2016: Create or Alter - author: jason - date: 2019-01-17 11:04:14
Another cool addition to SQL 2016 is CREATE OR ALTER, as in: CREATE OR ALTER dbo.sp_someProcedure ... Read More

SQL 2016: Drop If Exists - author: jason - date: 2019-01-17 10:59:08
A new feature introduced in SQL 2016 is the tsql syntax: DROP IF EXISTS The following items can b ... Read More

SQL: Scope Identity - author: jason - date: 2016-10-21 09:33:09
I got caught by a feature that can be a bug if misused in SQL. The SCOPE_IDENTITY() function. Acco ... Read More

SQL: Custom SQL Info/Config Report - Printer Ready! v1.7 - author: jason - date: 2016-05-04 12:43:37
Here is an updated printable report for SQL Information and Configuration! I've tested the report qu ... Read More

SQL: Custom SQL Info/Config Report - Printer Ready! v1.6 - author: jason - date: 2016-05-04 10:02:55
Here is an updated printable report for SQL Information and Configuration! I've tested the report qu ... Read More

DevOps: Release Management REST API - author: jason - date: 2015-09-08 16:02:42
Here is a method to kick off a Release Template (deploy a release) via Release Management's REST API ... Read More

SQL: Updating a VARCHAR value with a Large value, aka SQL can push it real good... - author: jason - date: 2015-09-02 15:52:53
Interesting SQL behavior... You have a table with a couple columns, one or two are variable length ... Read More

SQL: When does (MAX) go LOB? - author: jason - date: 2015-09-02 14:40:53
When does a NVARCHAR(MAX) or VARCHAR(MAX) column go LOB? Is it right away? Is it after 8KB? A Lar ... Read More

DevOps: Release Management and PowerShell DSC Links - author: jason - date: 2015-09-02 08:41:27
Here is quite a few links/blogs about Release Management and PowerShell Desired State Configuration ... Read More

DevOps: PS/DSC Multiple Servers, Different Configs - author: jason - date: 2015-09-01 13:43:31
In the previous article I showed a small PowerShell Desired State Configuration script that "ensured ... Read More

DevOps: PowerShell Desired State Configuration - author: jason - date: 2015-09-01 10:55:57
The PowerShell Desired State Configuration (DSC) feature is a pretty cool way to summarize the state ... Read More

DevOps: Release Management (MS RM 2015) - author: jason - date: 2015-09-01 10:30:12
Microsoft's Release Management 2015 product with Team Foundation Server 2013 can be used to automate ... Read More

SQL Server Agent: Alerts - author: jason - date: 2015-07-10 09:27:33
SQL Server Agent can be configured for Alerts​, here are a couple recommended alerts. Alerts ... Read More

SQL: Recover login when all hope is lost - author: jason - date: 2015-07-09 12:41:04
If you installed SQL and just went NEXT through the screens or lost the SA password and just can't f ... Read More

SQL Indexes and Plans, Oh My! - author: jason - date: 2015-06-17 10:46:22
Before we start Indexes are unique and magical to each system. How each system is used wi ... Read More

SQL Missing Index in Cached Query PLan - author: jason - date: 2015-06-01 11:21:16
I can't remember where I got this, likely from SQL Authority... Its a great query for high count us ... Read More

SQL Missing Indexes - Link - author: jason - date: 2015-03-12 10:20:31
Good Missing Index Script: http://basitaalishan.com/2013/03/13/find-missing-indexes-using-sql-ser ... Read More

SQL: Deadlocks - author: jason - date: 2014-07-04 19:42:25
I ran into a bunch of deadlocks the other day. Unfortunately the quick and dirty fix was adding the ... Read More

SQL: My Optimization Recommendations - author: jason - date: 2014-06-26 13:13:33
Here, for your reading pleasure, is my list of SQL optimizations and recommendations. Take them wit ... Read More

SQL: Get the Cached Query Plan - author: jason - date: 2014-06-25 11:32:23
Our programmers will often ask for the Query Plan of the stored procedure. Here is a great script f ... Read More

SQL: Checking the Plan Recompile Number - author: jason - date: 2014-06-25 11:18:06
Another thing I'm getting alerts on (got a monitoring tool? they're great by the way) is Plan Rec ... Read More

SQL: Watching for Mid Page Splits - author: jason - date: 2014-06-25 11:11:07
I have a couple SQL servers that have, what I think, are high Page Splits per second, as monitored b ... Read More

SQL: Best Practice VLF Size - author: jason - date: 2014-06-13 09:55:04
While the size of your transaction log is important, the size of the internal virtual log files is a ... Read More

SQL: Check Free Space - author: jason - date: 2014-05-14 10:44:23
I was trying to figure out how much free space each database file had and ran across the below artic ... Read More

SQL: Always On Availability Group - Custom Report v1.1 - author: jason - date: 2014-05-08 14:49:01
While the built SQL 2012 Dashboard Reports are nice, I wanted to see a little more information. I c ... Read More

SQL: Always On Availability Group - Builtin Dashboard Reports - author: jason - date: 2014-05-08 14:39:21
SQL 2012 has some nice built-in Dashboard reports to display the status of the Availability Groups. ... Read More

SQL: Always On Availability Group - Database Replication - author: jason - date: 2014-05-08 14:31:30
Here is nice script to review the Availability Group Database Replication status with tSQL. At the ... Read More

SQL: Always On Availability Group - Server Replica Info - author: jason - date: 2014-05-08 14:28:21
Here is small script to review the Availability Group Server Replica info with tSQL. Monitor Avai ... Read More

SQL: Always On Availability Group - Listener - author: jason - date: 2014-05-08 14:25:46
Here is small script to review the Availability Group Listener settings and state with tSQL. Moni ... Read More

SQL: Always On Availability Group - Group Info - author: jason - date: 2014-05-08 14:23:47
Here is small script to review the Always On Availability Group status/settings with tSQL. Monito ... Read More

SQL: Always On Availability Group - Failover Cluster Members - author: jason - date: 2014-05-08 14:21:06
Here is small script to review the Windows Failover Cluster Member status from inside SQL 2012. M ... Read More

SQL: Always On Availability Group - Failover Cluster Info - author: jason - date: 2014-05-08 14:15:17
Here is small script to review a couple Windows Failover Cluster settings from inside SQL 2012. M ... Read More

SQL: Always On Availability Group - ServerProperty - author: jason - date: 2014-05-08 14:00:08
Here is small script using SERVERPROPERTY to check the Always On Availability Group settings with tS ... Read More

SQL: Custom SQL Info/Config Report - Printer Ready! v1.5 - author: jason - date: 2014-05-02 20:03:16
Introducing a new printable SQL Information and Configuration Report! I've tested the report queri ... Read More

SQL: Get All Tables and All Indexes from All Databases - author: jason - date: 2014-04-13 17:48:14
Use the sp_MSforeachdb procedure to go into each database and select from the sys.tables and sys.ind ... Read More

SQL: When was the Last CheckDB for each Database? - author: jason - date: 2014-04-11 17:09:27
Here's a neat script to loop through the databases and list out the last time a CheckDB was run. ... Read More

SQL: What is Reporting Services doing?? - author: jason - date: 2014-04-11 16:14:51
Use the ExecutionLog2 View in the ReportServer database to see what reports are being called and the ... Read More

SQL: More Table Statistics - author: jason - date: 2014-04-11 12:07:50
I wanted to put together the number of times a table was accessed, along with the size of the table ... Read More

SQL: Types of Cached Queries - author: jason - date: 2014-04-10 12:59:59
Here is a great script from Kimberly Tripp / Paul Randal over at SQL Skills. It shows what types of ... Read More

SQL: Buffer Cache Contents - author: jason - date: 2014-04-08 12:38:44
Here is a script that will show what Indexes are currently cached in RAM in the Buffer Cache. This ... Read More

SQL: Configuration Settings Info Listing - The Big One, v1.4 - author: jason - date: 2014-04-04 17:42:46
I've compiled a gigantic script of configuration settings, database info, performance details. I g ... Read More

SQL: Virtual Log File Counts - author: jason - date: 2014-04-02 14:42:47
Virtual Log Files (VLF) are the mini logs inside the Transaction Log. Having a large number of them ... Read More

SQL: Job Results - Last Execution Info - author: jason - date: 2014-03-20 00:00:00
Here is a script for viewing Job History of how a job ran the last time it ran. Note, I am avoiding ... Read More

SQL: Emailing Query Results as a HTML Report - author: jason - date: 2014-02-27 13:36:46
Use SQL Database Mail and SQL Agent Jobs if you want to automate the sending of routine/simple HTML ... Read More

SQL: The One And Only Amazing PIVOT! - author: jason - date: 2014-02-07 16:58:01
Why did I not know about the PIVOT operator sooner? Is sooner a word? Merriam-Webster says Yes, a ... Read More

SQL: Get the TSQL for Longest Running Requests - author: jason - date: 2014-02-07 13:20:18
Use the Dynamic Management View sys.dm_exec_requests to get running requests. But that isn't too i ... Read More

SQL: Get the TSQL for Oldest Running Open Transaction DBCC OPENTRAN - author: jason - date: 2014-02-07 11:44:23
The DBCC command OPENTRAN can be used to find the oldest running open uncommitted transaction in a g ... Read More

SQL: PowerShell and Exporting Query Results (CSV) - author: jason - date: 2014-02-06 16:17:52
Here is a very easy to use PowerShell script to export a query from SQL as a CSV into the local serv ... Read More

CommVault Backups: Pre and Post Commands - author: jason - date: 2014-02-06 14:48:20
I wanted to use PowerShell scripts from CommVault as Pre/Post Commands to be run before and after th ... Read More

SQL: Long Running Jobs - author: jason - date: 2014-02-05 15:56:50
There are quite a few tools out there that will monitor SQL for long running transactions, processes ... Read More

SQL: Check Database Cursor - author: jason - date: 2014-02-05 11:23:40
I've run into situations where I can't use a Maintenance Plan or the other DBAs just don't want t ... Read More

SQL: Most Recent Full Backup and Restore - author: jason - date: 2014-02-05 11:05:51
This is a combination of some common Backup and Restore scripts. I've added a Temp Table to hold t ... Read More

SQL: Check Fragmentation with DBCC SHOWCONTIG - author: jason - date: 2014-01-31 15:02:19
If your database is SQL 2000 it is not possible to use the Dynamic Management View sys.dm_db_index_p ... Read More

SQL: When was the last Restore? - author: jason - date: 2014-01-31 14:04:54
Here is a great query from MSSQLTips on getting the previous Restore information about your database ... Read More

SQL: Table Width - author: jason - date: 2014-01-31 13:13:49
I ran across this method for calculating the width of a table. Not sure where I got it from though. ... Read More

SQL: General Database Info - author: jason - date: 2014-01-31 12:53:35
Expanding a little bit on some earlier posts about general info, system info, etc, here are a couple ... Read More

SQL: Make a Comma Separated String, featuring XML! - author: jason - date: 2014-01-28 15:10:29
A frequent question is how to turn rows into a comma separated string. We can use the power of XML ... Read More

SQL: Duplicate Check with CTE - author: jason - date: 2014-01-28 11:32:33
I am still using the ROW_NUMBER() OVER PARTITION BY Window Function, but I've added a Common Table ... Read More

SQL: Move Tables between FileGroups - author: jason - date: 2014-01-28 09:14:26
Here is a very good article and stored procedure on moving tables between file groups inside SQL. ... Read More

MacBook Air and Windows 2008 R2 Server - author: jason - date: 2014-01-28 08:57:21
I am dual-booting my MacBook Air with OSX and Windows 2008 R2. I was even able to load the Bootcamp ... Read More

SQL: Tables and Columns and Lists Oh My! - author: jason - date: 2014-01-24 14:37:56
Use the following two procedures to get a listing of tables and columns associated with a table. ... Read More

SQL: Where are my DB files located? - author: jason - date: 2014-01-24 14:23:52
Use sp_helpfile for a quick look at where your Database Files are located and the properties associa ... Read More

SQL: XML Clever Combining - author: jason - date: 2014-01-24 11:59:29
What if you want to combine two distinctly different tables into 1 gigantic XML string? You can! C ... Read More

SQL: Arbitrary XML Attributes - author: jason - date: 2014-01-24 11:02:01
SQL allows us to Alias columns in the SELECT statement if we need to put arbitrary fields into XML ... Read More

SQL: XML, Adjusting for Node Order - author: jason - date: 2014-01-24 10:49:22
By changing the SELECT statement, in regards to the table order, we can adjust how the XML output wi ... Read More

SQL: For XML Auto, Elements - author: jason - date: 2014-01-24 10:31:55
To avoid attributes we can use the ELEMENTS tag. This produces a more familiar looking XML string t ... Read More

SQL: For XML RAW - author: jason - date: 2014-01-24 09:24:21
Here is one way to get data out of SQL in an XML format. While I do use MSDN and TechNet to figure ... Read More

SQL: Coalesce a thing of beauty - author: jason - date: 2014-01-23 14:02:10
COALESCE can be used similar to the ISNULL function. It will return the first non-null value. I us ... Read More

SQL: Parse a String with Patindex and Right - author: jason - date: 2014-01-23 14:01:47
Getting a string like a File Name out of another string like a File Path doesn't need to be difficu ... Read More

SQL: Why would I use Rank? - author: jason - date: 2014-01-23 13:51:57
Here is a very good article with examples on using RANK with OVER and PARTITION BY: http://jesborlan ... Read More

SQL: You want me to update this Excel file? - author: jason - date: 2014-01-23 12:54:24
There have been plenty of times when I've been given an Excel spreadsheet of information and been a ... Read More

SQL: Order By Substitution - author: jason - date: 2014-01-23 12:28:50
Sometimes we need the ability to "arbitrarily" order rows out of a table. A CASE statement can be ... Read More

SQL: Having in the Group By - author: jason - date: 2014-01-23 12:15:23
Using the HAVING clause can save you from manually searching through SQL results if you are looking ... Read More

SQL: Simple Cursor - author: jason - date: 2014-01-23 10:12:03
I often forget the syntax for setting up a cursor. I don't really like using cursors. I don't us ... Read More

SQL: The Magic of Apply - author: jason - date: 2014-01-23 09:33:38
Using CROSS and OUTER APPLY helps me change a one to many problem into a one to one solution. APP ... Read More

SQL: Row Numbers and Duplicates - author: jason - date: 2014-01-23 08:50:32
The ability to find duplicates in a table can be very handy. The core of finding duplicates, with t ... Read More

SQL: Safe Update with Select - author: jason - date: 2014-01-22 11:23:57
This might seem minor, but I like to nest my UPDATE statements inside SELECT statements. This reas ... Read More

SQL: Last Full Backup - author: jason - date: 2014-01-22 11:07:55
Here is a script for the last full backup. I don't remember where I got it. It was SQL Authority ... Read More

SQL: Index and Table Sizes - author: jason - date: 2014-01-22 10:55:54
It is often very helpful to know what size a particular index or table is. The below two scripts he ... Read More

SQL: Index Usage Seek/Scan - author: jason - date: 2014-01-22 10:47:53
Track the amount of seeks and scans for indexes with this script. It should help identify heavily u ... Read More

SQL: Looking at File IO - author: jason - date: 2014-01-22 10:26:18
SQL records the number of writes, reads, etc that it pushes out to its database and log files. Belo ... Read More

SQL: Watching the System - author: jason - date: 2014-01-22 09:37:23
Here are some scripts to help peer inside SQL. I use these snippets everyday to help watch what is ... Read More

What? Check for bugs? - author: jason - date: 2011-05-27 10:57:43
I overheard a user talking about the dreaded Blue Screen of Death and their computer rebooting 5 tim ... Read More

Where is my WMI? - author: jason - date: 2011-05-03 11:27:43
I had a user call and state their computer was behaving badly. I went over to visit. The computer ... Read More

Out of Resources - author: jason - date: 2011-04-29 12:28:09
Right around the time Service Pack 1 for Windows 7 came out, which was deployed with minimal testing ... Read More

Windows 7 Printer Driver Removal - author: jason - date: 2011-01-22 12:24:25
Remove a printer and sometimes the printer driver sticks around. Want to remove the driver package ... Read More

Windows 2008 R2 DNS Forwarding Server EDNSProbes - author: jason - date: 2011-01-18 11:58:30
If you are using Windows 2008 R2 for a DNS Forwarding service you may have trouble getting the upstr ... Read More

Hyper-V PowerShell VM Export - author: jason - date: 2010-10-23 09:15:42
Virtual Machines are a good way to consolidate servers on one Host Platform. But putting your eggs ... Read More

Excel 2007 and Pretty Charts - author: jason - date: 2010-02-14 16:32:27
Letís start with a simple set of data to see a new Chart. Here we have an example of candy sales fr ... Read More

Excel 2007 and Pivot Tables - author: jason - date: 2010-02-14 12:17:07
Excel 2007 has made improvements to the Pivot Tables, over Excel 2003. Another nice thing about the ... Read More

Viruses, Spyware, and Your Business - author: jason - date: 2010-02-08 12:14:50
Protecting your employees, computers, and systems from virus and spyware threats is more than just r ... Read More

Clearing the Outlook To Line Cache - author: jason - date: 2009-09-11 15:57:26
Sometimes when an email address changes Outlook doesn't want to forget the old one. There is a way ... Read More

Accounting Software - author: jason - date: 2009-08-15 10:14:13
PC Magazine has a good article on free accounting software for small businesses. They talk about fr ... Read More

Backing up, inexpensive and easy - author: jason - date: 2009-08-12 09:33:15
Backing up your computers is a good way to make certain important files and documents aren't lost. ... Read More

System Maintenance - author: jason - date: 2009-08-11 13:10:22
There is a good business case for performing routine maintenance on your computer systems. Just li ... Read More

Expanding with Wireless - author: jason - date: 2009-08-11 12:05:14
Expanding your small office with wireless sounds like a good idea, and it can be, if implemented cor ... Read More

Wireless Terminology - author: jason - date: 2009-08-10 12:58:08
Wireless comes with its own set of acronyms and security terminology that we will briefly discuss. ... Read More

Small Office Setup - author: jason - date: 2009-08-10 09:32:34
Setting up a small office for 1-5 people doesn't need to be difficult. The phone/cable company can ... Read More

personal Daily Activity Log - author: jason - date: 2009-07-29 15:57:05
pDAL is a small Visual Basic application written with Visual Studio 2008 that enables users to log a ... Read More

Executing Subscriptions via Stored Procedure in SQL Reporting Services 2005 - author: jason - date: 2008-10-02 02:23:22
SQL Reporting Services allows users and administrators to set up timed subscriptions to be saved to ... Read More

SQL 2005 and OPENROWSET - author: jason - date: 2008-04-09 00:16:37
I use the command OPENROWSET to push Excel files into a table. To do this I need to change the "Su ... Read More

Microsoft SQL Server 2005 Installation - author: jason - date: 2008-04-08 23:46:50
Here is a quick run-through on installing SQL Server 2005. This install uses the Developer edition ... Read More

SQL Reporting Services Snippets - Expressions - author: jason - date: 2008-04-08 12:01:26
I've run into a couple situations with writing reports for SQL Reporting Services that I thought I ... Read More

SharePoint Services 3.0 Install - author: jason - date: 2008-04-01 03:26:34
This is a quick overview of a basic install of Microsoft SharePoint Services 3.0 on a single stand-a ... Read More

simple SQL - author: jason - date: 2007-11-19 12:03:12
simple SQL is a small Visual Basic application written with Visual Studio 2008 than enables users to ... Read More

simple Report Distribution - author: jason - date: 2007-10-28 02:13:32
simple Report Distribution is a small Visual Basic application written with Visual Studio 2008 Beta ... Read More

simple Master Station Log - author: jason - date: 2007-08-30 12:03:12
simple Master Station Log is a small Visual Basic application written with Visual Studio Express tha ... Read More

Querying WMI for DCM Events - author: jason - date: 2007-05-04 15:06:31
DCM records the results of a scan to an output XML file, the event viewer, and a WMI repository. DC ... Read More

Running DCM - author: jason - date: 2007-05-04 14:54:43
DCM can be run via the provided batch file: RunDCM.bat. In an enterprise environment SMS is used to ... Read More

Basic DCM Template - author: jason - date: 2007-05-04 14:52:10
It's a pretty easy task to create a template to check for registry settings. Let's check the Syst ... Read More

Installing Desired Configuration Monitor (DCM) - author: jason - date: 2007-05-04 14:50:10
If you have a couple servers and a couple technicians in the office you've probably run into server ... Read More

Creating and Testing a Database in SQL Express - author: jason - date: 2007-05-03 20:21:58
It is a fairly simple task to create a new database, tables, fields, and users in SQL Express. In t ... Read More

Installing and Configuring SQL Express - author: jason - date: 2007-05-03 15:59:56
Every now and then I have the need for a database and let's face the facts: 1. Microsoft Access doe ... Read More

Power Saving Group Policy Object - author: jason - date: 2007-04-30 07:32:21
Nearly all modern computers on an enterprise network have power savings capabilities. Microsoft Win ... Read More

PivotTables and PivotCharts with Excel 2003 - author: jason - date: 2007-04-30 06:36:35
So you've got a list of data. You need a report by the end of the day. You need to make pretty gr ... Read More

Migration Snippets - author: jason - date: 2007-03-29
Introduction Migrating users and computers from one Microsoft domain to another (and from one Exc ... Read More

QEMU - Emulate Windows or Linux - author: jason - date: 2005-12-23
Here are three options a person can use to create a virtual machine: Virtual PC, VMWare Workstation, ... Read More

Visual Basic Script - Listing Disabled Users from Active Directory - author: jason - date: 2005-03-30
In this lesson we are going to look at querying Active Directory for disabled users with VBScript. ... Read More

XP Remote Assistance - Auto Login - author: jason - date: 2004-11-07
Set Remote Assistance to auto login a remote user, and auto take control of the machine. The below s ... Read More

Visual Basic Script - Listing MP3 Files - author: jason - date: 2004-06-01
In this VBScript tutorial we will search for MP3 files, write them to a HTML file, then open the fil ... Read More

Visual Basic Script - Deleting Files - author: jason - date: 2004-05-31
Quick change in lesson order. I'm going to show file deletion for the third lesson. We'll go bac ... Read More

Visual Basic Script - Listing Files and Folders Recursively - author: jason - date: 2004-05-30
Here's a quick intro into getting a recursive folder and file listing from VBScript. VBScript is a ... Read More

Visual Basic Script - Listing Files - author: jason - date: 2004-05-29
Here's a quick introduction into getting a file listing from VBScript. VBScript is a great way to ... Read More

Ultimo FreeBSD - author: jason - date: 2003-11-25
Now that you've installed FreeBSD, wouldn't you like to do something with it? Like host a web or f ... Read More

Minimal FreeBSD 4.8 Install - author: jason - date: 2003-11-23
So you want to install FreeBSD, eh? Going to use a spare drive, or make room on your WinDoze drive? ... Read More

FreeBSD and BitchX - author: jason - date: 2003-11-23
All righty then... So you want to IRC from work... But your work monitors/blocks access to IRC (6667 ... Read More

FreeBSD and cron - author: jason - date: 2003-11-23
Want to run scripts at startup? Want to do it under your username and not root? I'm using FreeBSD 4 ... Read More

FreeBSD and mounting ext2 - author: jason - date: 2003-11-23
Now, I'm jumping the gun. I need to write a tut on installing FreeBSD. But you know? It's prett ... Read More

ProFTPD - author: jason - date: 2003-11-23
Installing ProFTPD in FreeBSD is the same as Linux. Don't listen to the hype! You don't need to in ... Read More

Shoutcast - author: jason - date: 2003-11-23
Now you want to stream those MP3s you've worked so hard at downloading... Everyone needs to hear th ... Read More

Lockdown W2K (in progress) - author: jason - date: 2003-05-16
The reason I like Windows 2000 Server for my home is that I use it at work. The time I spend learnin ... Read More

How to setup IIS 5.0 on XP Home - author: jason - date: 2002-10-18
Installing a full version of IIS on XP Home isn't too hard. All that's needed is a Windows 2000 C ... Read More


jason @ jasonthomasfrance.com - www.masterstationlog.com - copyright 2009