Browse by Tags

In this post, we are going to see how we can generate XML in the below-mentioned format from the relational data. < row > < column >1</ column > < column >1</ column > </ row > < row > < column >2</ column > ...

Someone asked, what is the fastest way to remove all non-numeric characters (including space) from a varchar variable without affecting the performance. This will be used to check multiple columns in the table so thread originator was looking for some efficient way to do this: Example of the...

Microsoft Active Directory stores user logon history data in the event logs on domain controllers. Starting from Windows Server 2008 and up to Windows Server 2016, the event ID for a user logon event is 4624. These events contain data about the user, time, computer and type of user logon. Using the...

Table of Contents Abstract Introduction Examples Code In Detail Output filename Prepare HTML file using CSS Code Code with Email Validation and a single recipient Code for Multiple recipients with no email validation References Abstract Monitoring disk space utilization of server(s) is a critical...

Part 2 to this article is located here Below is compiled to help get helpdesk, system admins/ engineers, and security personnel started on a set path to not just learn powershell but to maintain that knowledge and it is all free. Getting Started with PowerShell 3.0 Jump Start: http:/...

Table of Contents Foreword Creating a new Azure SQL Database Performance considerations to the new SQL Database tiers Monitoring an Azure SQL Database Performance Considerations Recover From ‘Oops’ Failures Dusk of Azure SQL Database Federations Recover From Disasters Other facts References Just a...

What is Switch Parameter? Help about_Functions_Advanced_Parameters How to Use Switch Parameter? Param ( [ Parameter ( Mandatory = $false ) ] [Switch] $ColorText ) How to consume switch parameter? Demo function if switch -colortext is included...

How To Create a Borderless form with pull out compartments in Visual Basic. This can be difficult at first, but i will attempt to keep it short and sweet. Have you ever wanted to have a compartment that you could pull out of your form, one that extended beyond the border of the form? Well, this...

How To execute a dos script in Visual Basic without creating an external process. Not all DOS commands can be executed with this, such as CLS, diskpart, echo, etc.... If you discover unsupported commands, please add them to this list: Unsupported Dos Commands: CLS Echo DiskPart ? ...

(Try using the table below to decipher this!) Table of Contents Download Introduction Braille to Binary Table Example Code (Visual Basic) Example Code (C Sharp) Summary See also Download You can download a more elaborate version of this code (the project version) at the following link. Introduction...

Table of Contents Code Used Reason Fix Error Message Code Used Add-Type -AssemblyName 'Microsoft.Office.Interop.Outlook' $Outlook = New-Object -ComObject 'Outlook.Application' Reason The code is correct, no issues identified. The reason is OUTLOOK process is...

We will get a SCOM alert for Exchange 2010 Management Pack unable to run the Troubleshootdatabase.ps1 after we install Windows Management Framework 3.0 or higher versions on the Exchange servers. What is this TroubleshootDatabase.ps1 ? The Troubleshoot-Database.ps1 is located by default at...

Table of Contents Finding files with Visual Basic Source Code Download Introducing the DriveSearcher Class search parameters FileFoundEventHandler StatusChangedEventHandler SearchStatus FilesComparedSoFar DirectoriesSearchedSoFar UnsearchableDirectories DriveSearcher Class Resources See also Finding...

Table of Contents What is Cascading Dropdown List: $().SPServices.SPCascadeDropdowns: How to use $().SPServices.SPCascadeDropdowns: Reference: What is Cascading Dropdown List: One drop-down list content depends on parent dropdown list selection, that is called cascading dropdown list. For example...

Table of Contents .NET Error: Path too Long NET 4.6.2 and long paths on Windows 10 Other .NET libraries which support long path QuickIO.NET AlphaFS Use Robocopy as a workaround Use a Share or a substitution as a workaround PowerShell Path too Long and .NET PowerShell Robocopy Clone .NET See Also ...

Table of Contents 1 Introduction 2 Storing and Retrieving JSON Schemas run.csx project.json Logic App HTTP Request Trigger The Logic App Parse JSON Action JSON Validation with an Azure Function schema.json run.csx project.json JSON Validation with Integration Account Maps & Assemblies XSLT...

Table of Contents Introduction? Getting the bytes of a System.Decimal Creating an instance of the System.Decimal from bytes Summary ? Code Examples Visual Basic C# ReferencesMSDN Library Introduction? At first, glance converting the datatype (System.Decimal) to and from bytes may appear to be a...

erview This is a wizard-style app. that through a series of questions determines which type of Triangle Solver you need. The solution is given to your chosen number of Decimal Places or Significant Figures, both in the solver form and as an HTML page where step by step solutions are shown, along...

Table of Contents Introduction to Unity 3D Create your first Unity 3D application Code Part Introduction to Unity 3D Framework How to add a C# Script to a Unity 3D application How to add the C# Script to selected object to produce the result How to Build and Run the Unity 3D application to web See Also...

Table of Contents 1. NLog 2. Logging 2.1. Logging Frameworks 2.2. Install NLog 2.3. NLog Targets 2.4. Target Layout 2.5. NLog rules 2.6. Nlog levels 2.7. Let’s see what’s in action 2.8. How to use multiple targets 3. Download 3.1. TechNet Gallery 3.2. GitHub 4. Conclusion 5. References Many of the...

Table of Contents Overview Code Conclusion Download See Also Overview This is a simple Password Strength Meter, consisting of a TextBox to enter a password, with a maxlength of 20, which uses * as the Password Character. There's a second TextBox with the same attributes to confirm...

I have seen administrators working hard to copy permissions from one list to another list. This is a very important task from the security perspective as well. To ease this process I received various requests to develop something that will allow this via web service call since the tool will be used...

Project Description Merge PDF Files using the iTextSharp library. We pass a set of PDF files to the method and get one file with all the passed files merged. Code using System; using System.Collections.Generic; using System.Text; using System.IO; using iTextSharp...

Table of Contents Purpose Example Case (Input Excel File) Other Considerations and Further Steps Code Snippet Customize Code to Your Enviornment (Domain, OU, etc.) Execute the Script Sample Output / Results See Also Purpose This article explains how to use a VBScript application to read a single...

The below script does quite a few things. This script will allow a user to chose an option 1-6 pick a network drive and it will map them to that network share. This script detects if a program is running and will not execute the commands until the process is closed for example notepad. This can...