mattslay

# Adapted from here https://www.simple-talk.com/blogs/powershell-script-all-objects-on-all-databases-to-files/
# Also see this one: https://gist.github.com/cheynewallace/9558179


<#  This simple PowerShell routine scripts out all the user-defined functions,
stored procedures, tables and views in all the databases on the server that
you specify, to the path that you specify.
SMO must be installed on the machine (it happens if SSMS is installed)
To run – set the servername and path. Open a command window and run powershell

mattslay

/* This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
 * Portions Copyright (C) Philipp Kewisch, 2009-2013 */

"use strict";

try {
    Components.utils.import("resource:///modules/gloda/suffixtree.js");
} catch (e) {

mattslay

$machines = 'MSPC5', 'JRPC5', 'CWPC5', 'RPPC5', 'TMPC4', 'MIPC5', 'TWPC5', 'JBPC5', 'DNC2', 'FS6-VM1', '192.168.0.60'

foreach ($machine in $machines)
{
    trap{"$machine`: not reachable or not running WsMan"; continue}
    if(test-wsman -ComputerName $machine -ea stop){
        $result = gcim -Class CIM_Product -Filter 'Name like "%DWG%"' |
            select name, version
        Write-Host  $machine $result.name, $result.version

mattslay

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BubbleSort
{
    class Program
    {

mattslay

// Taken from: https://www.c-sharpcorner.com/blogs/bubble-sort-algorithm-in-c-sharp

using System; 

class BubbleSort {
    static void Main(string[] args) {
		
            Console.WriteLine("Enter the Size of Array");
            int size = int.Parse(Console.ReadLine());  //Read array size.
            Console.WriteLine("Enter the Array elements");

mattslay

What percentage of the Sun's energy hits the Earth:

Moved this content to my blog:

http://mattslay.com/what-percentage-of-the-suns-energy-hits-the-earth/

mattslay

This.ClearSqlParameters()
This.oSQL.AddParameter(lnJobID, "JobID")

lcStoredProc = "[BillingRegister].[GetTimeRecordsByJobId]"

lnReturn = This.ExecuteStoredProcedure(lcStoredProc, lcCursor)

If lnReturn < 0
	This.SetError("Error calling Sql Server Stored Proc: " + lcStoredProc)
EndIf