Navigation

	Home Page
	Index
	All Pages

Quick Search
Advanced Search »

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

Home Page

Welcome¶

Welcome to the Jasinski Technical Wiki, which currently has 796 articles.

URL:	http://www.jasinskionline.com/TechnicalWiki/
Logged in as:	Guest

Attachments¶

See page attachments for SQL Server Support Views, including DbLayout, FKeys, TableRowCounts, and CodeObjects.

Index¶

	(drafts)
	ActiveDirectoryQuery Class Angular Notes Creating Group Header Rows in a GridView Creating Templates - Visual Studio 2005 Data Modelling Standards DeveloperPanel Class - ASP.NET Installer Attributes - NSIS Lookup Class - ASP.NET MVC Template - ASP.NET MVC Paginate Function SqlBuilder Class SSRS Extender Cache Class Using Site Maps - ASP.NET Validation Notes - ASP.NET MVC
	(Favorites)
	AJAX Example - jQuery and JavaScript Angular Notes Angular Walkthrough ASCII Codes Cascading Style Sheets Quick Reference Class Library Pages Code Snippets - JavaScript Data Modelling Standards Database Layout - SQL Server DbIndexes View - SQL Server Extensions - jQuery Foreign-Key Pages - SQL Server Git Quick Reference JSON Data in T-SQL - SQL Server LINQ Examples Quick Reference - JavaScript Quick Reference - jQuery Regular Expressions Quick Reference Schema Change Scripts - SQL Server Table Row Counts - SQL Server XSL Quick Reference
	(uncategorized)
	AuditableBase Class for Automaticatlly Tracking Data Changes - Entity Framework Code First Binding the Private Key to an SSL Certificate Changing a User's Password - SQL Server CIDR IP Address Range - SQL Server Configuration Settings in ASP.NET Core Configuring Authentication and Users - Mongo DB DB Tools Desktop Text App Determining Geolocation (Latitude and Longitude Coordinates) from Google Maps Displaying UTC DateTime in Local Time Zone - ASP.NET and JavaScript Email Setup on Smartphones for Office 365 Enforcing Required Fields in a PDF Form - ASP.NET and ActivePDF Find a Certificate by Certificate Hash or Thumbprint - C# Forms Authentication Behind a Load Balancer - ASP.NET Freeing Disk Space Home Page Index LINQ Extensions - C# Main Page Merging Entity Framework Code First Migrations - Entity Framework Code First Report Publisher Add-In for Visual Studio 2005 Report Server Object Enumeration - SSRS Splitting CSV Values - SQL Server SqlCommand and SqlConnection Objects Stopwatch Updating SSL Certificate on SSRS Server User Role Membership - SQL Server What's New
	·Net Core
	JSON Serialization and Deserialization - C# Redirecting Process Output
	·Net Framework
	AddBusinessDays Function - C# Adding A Description To A .Net Windows Service AuditableBase Class for Automatically Tracking Data Changes - Entity Framework Code First Azure Blob Service - C# Azure Functions Version Building an Address by Concatenating Field Values Calculating Age from Date of Birth Calculating Midnight in a Time Zone - SQL Server Changing XSL Code on the Fly - .NET Framework Class Library Pages ClickOnce App.Config Location - .Net Framework ClickOnce Bad Hash Error - .Net Framework Code Analysis Code First Entity Framework - .NET Framework Code First Shortcomings Code Snippets - .NET Framework Command Text Generation from a SqlCommand Object Command Timeout in Entity Framework Common, Useful Exception Classes Concurrency Exceptions - Entity Framework 6 and EF Core ConfigManager - ASP.NET and Azure Functions Configuration Settings - .NET Framework ConnectionString Class - .NET Framework Converting A .Net DataSet To An ADODB Recordset Converting Between Hex and Integer Converting DateTime Properties to UTC - .NET Framework Creating a COM object in .NET Creating a WCF Self-Hosted Service Creating a ZIP File In Memory - .NET Framework CSV File Exporter Class - .NET Framework, ASP.NET Custom Configuration Sections Example - .NET Framework Data Annotation - .NET Framework Database Command Timeouts: Performance Differences between .NET and Management Studio Database Seeding Framework - C# Database-Table-Wrapper Class Code Generator DateTimeExtensions - C# Declaration Modifiers - C# and VB.NET Determining Which Versions Are Installed - .NET Framework Displaying an XML DataSet in a DataGridView - .Net Framework Displaying an XSL Transformation in a Web Browser Control - .Net Framework Downloading a File - .NET Framework Downloading a Web Page Programmatically - .NET Framework Dropping Emails onto a .NET Application Email Templating Using the ASP.NET Razor View Engine Encrypting Web.Config Connection Strings - ASP.NET Exception Extensions - C# Exporting Time Zones - C# Extracting Data from a Grid Bound to a Typed DataSet- .Net Framework Extracting Images from Icons FileSizeFormatProvider - C# Format Codes Formatting Raw XML - Microsoft .Net Framework FTP Client Wrapper Class in C# Getting a MAC Address - C# GZip Error with Code First - .NET Framework IAuditable Interface - .NET Framework Indexers - C# Installing a .NET Windows Service Multiple Times LinkLabel Example LINQ Examples LoaderExceptions Property - .NET Framework Looking Up a User in Active Directory - .Net Framework Lookup Class - ASP.NET LookupItem Class for DropDownLists - .NET Framework MailServer Class Making an IEnumerable Enum - .Net Framework Merging Entity Framework Code First Migrations - Entity Framework Code First Minimize to System Tray - C# and Windows Forms Numeral Class Opening Windows Explorer to a Folder - C# Optional Parameters in C# Ordinal Function - .NET Framework Parsing a Person's Name - C# Parsing CSV Text - C# Printing a Variable Name and Value - .NET Framework QueueEngine Class - Azure Reading Excel Files with OLEDB Reconnect to VPN - C# Redirecting Process Output Reflection - .Net Framework Regular Expression Samples - .Net Framework Renaming an Assembly SecurityContext Class - .NET Core Sending Email - .Net Framework SendKeys Class Quick Reference Setting Command Timeout - Entity Framework 6 - .NET Framework Setting the Connection String for a TableAdapter SQL Statement used by LINQ SqlDatabase Base Class - SQL Server and .NET Framework SqlEngine - C# StepTimer Class - A Performance Tool - .NET Framework Streams - .NET Framework String Extender Functions String Extensions - C# Thumbnails - Creating in C# Time Database Columns in .NET Timer Triggers in Azure Functions - NCRONTAB Expressions UrlCombine Function - .NET Framework Using Custom Sections in an App.Config File - .Net Framework Using Embedded Resources - .Net Framework Using MSBuild Community Tasks to create an installer Using Reflection to Document a Web API - ASP.NET Using the ListView.ListViewItemSorter property - .Net Framework Using the SelectNodes Method with XML Namespaces - .Net Framework Validation Errors - .NET Framework Version - C# Windows Services in Visual Studio 2005 Standard Edition Windows Taskbar Wrapper Class - C# XML Encoding XML Serialization of an Object - C#
	Algorithms
	Annuity Calculations Building an Address by Concatenating Field Values Calculating Age from Date of Birth Estimated Time of Completion Calculation - C# Estimated Time of Completion Calculation - SQL Server Parsing CSV Text - C# Transforming a Name from First-Last to Last-First
	Amazon Web Services
	Converting Unencrypted Volumes to Encrypted Volumes - Amazon Web Services Error When Migration MySQL Database to Amazon RDS Granting Access to a S3 Bucket - Amazon Web Services Shrinking a Volume - Amazon Web Services Updating an SSL Certificate on Elastic Beanstalk - Amazon Web Services
	Android
	Android Versions and API Levels Code Snippets - Android Setting Up a PC for Android Development
	ASP·NET MVC
	AJAX Example - jQuery and JavaScript Changing Cookie Names - ASP.NET Security Changing Password without the Old Password - ASP.NET Membership API Compile-Time Checking of ASP.NET Views ConfigManager - ASP.NET and Azure Functions Configuration Settings - .NET Framework Connection Strings Externalized - ASP.NET Cookies - ASP.NET CSV File Exporter Class - .NET Framework, ASP.NET Custom AuthorizeAttribute - ASP.NET MVC Custom Controller Factory - Putting Controllers in an External Assembly - ASP.NET MVC CustomValidation Attribute - ASP.NET Database-Table-Wrapper Class Code Generator Data-Level Security - ASP.NET Core and EF Core DatePicker Editor Template - ASP.NET MVC Email Templating Using the ASP.NET Razor View Engine Excel Export - ASP.NET MVC Formatting Field Values - ASP.NET MVC GZip Error with Code First - .NET Framework HOSTS File Location How to Handle "Maximum request length exceeded" Error - ASP.NET MVC IAuditable Interface - .NET Framework jQuery-UI Tab Code Generator LoaderExceptions Property - .NET Framework LookupItem Class for DropDownLists - .NET Framework Menu System based on User Roles Model State Errors - ASP.NET MVC Basics - ASP.NET MVC MVC Template - ASP.NET MVC Programmatically Logging into an ASP.NET Website Quick Reference - ASP.NET reCaptcha Implementation in MVC3 - ASP.NET MVC Remote Connections to IIS in Windows 7 Taking Down a Website for Maintenance - ASP.NET Uploading Files - ASP.NET MVC2 UrlPath Class - Path.Combine for URLs Using Reflection to Document a Web API - ASP.NET Validation Notes - ASP.NET MVC View Engine (Razor and ASPX) Syntax - ASP.NET MVC Web API - Client IP Address
	ASP·NET Security
	Changing Cookie Names - ASP.NET Security Data-Level Security - ASP.NET Core and EF Core Programmatically Logging into an ASP.NET Website SecurityContext Class - .NET Core
	ASP·NET Web Forms
	ActionValidator Class - ASP.NET AJAX Coding in ASP.NET Web Forms An Extensive Examination of the DataGrid Web Control - ASP.NET Apostrophes - Correct Usage in HyperLinks AttachmentSelector Web Control - ASP.NET Building A Truly Dynamic Menu - ASP.NET Changing Cookie Names - ASP.NET Security Changing Password without the Old Password - ASP.NET Membership API CheckBoxList Class - ASP.NET CheckedListBox User Control - ASP.NET Class Library Pages CompareValidator Class - ASP.NET Comparison of the GridView, Repeater, and DataList Controls - ASP.NET ConfigMgr Class Connection Strings Externalized - ASP.NET ConnectionString Class - .NET Framework Consuming Custom Controls in ASP.NET Cookies - ASP.NET Creating a Reset Button - ASP.NET Creating Group Header Rows in a GridView CSV File Exporter Class - .NET Framework, ASP.NET CustomValidation Attribute - ASP.NET CustomValidator Class Data Annotation - .NET Framework Database Command Timeouts: Performance Differences between .NET and Management Studio DataTypeValidator Class - ASP.NET Date-Picker Source and Demo - JavaScript DeveloperPanel Class - ASP.NET Disable the Submit Button - jQuery Downloading a Web Page Programmatically - .NET Framework Encrypting Web.Config Connection Strings - ASP.NET Extending Built-In Web Controls - ASP.NET Favorites Icon - Creating and Installing a FAVICON.ICO File FileUpload Control Sample - ASP.NET FileUploadExtender Class - ASP.NET GridView Class - ASP.NET GridViewExtender Class - ASP.NET GridViewRowExtender Class GZip Error with Code First - .NET Framework HOSTS File Location IAuditable Interface - .NET Framework Internet Explorer Quirks Journal Class and Logging - ASP.NET jQuery-UI Tab Code Generator Life Cycle of a Page - ASP.NET LoaderExceptions Property - .NET Framework Lookup Class - ASP.NET LookupItem Class for DropDownLists - .NET Framework Membership API in ASP.NET Membership API with Windows Authentication and a Custom Role Provider - ASP.NET Menu System based on User Roles Merging a Code-Behind File into Its APX File Merging Reports - SSRS MyGridViewRow Class - ASP.NET Paging Data and the PageSelector Control Parser Class Password Generator - ASP.NET PDF Generation via RDLC Report File Programmatically Logging into an ASP.NET Website Publishing a Website in Visual Studio Express Edition QueryString Class Quick Reference - ASP.NET RegularExpressionValidator Class - ASP.NET Remote Connections to IIS in Windows 7 Required Field Validation (Conditionally) - ASP.NET RequiredFieldValidator Class - ASP.NET Security - Showing and Hiding Page Elements Based on User Role ServerVar Class - ASP.NET SessionVar Class - ASP.NET Setting the Default Button - ASP.Net Setting Up ASP.Net Settings Class - ASP.NET ShowLinkAs Page - ASP.NET Sitecore Extensions Methods Site-Root-Relative References - ASP.NET SqlDatabaseWeb Class - ASP.NET State Persistence - ASP.NET Streaming a File from a Web Page - ASP.NET Taking Down a Website for Maintenance - ASP.NET TelephoneNumberTextBox Class - ASP.NET Telerik Grid Quick Reference TextBox Class - ASP.NET Thumbnails - Creating in C# Trapping MaxRequestLengthExceeded UrlPath Class - Path.Combine for URLs Using Microsoft Access with ASP.NET Using MSBuild Community Tasks to create an installer Using Site Maps - ASP.NET Using the GridView Web Control - ASP.NET Validation Controls - ASP.NET Validation Errors with AJAX Calls - ASP.NET ValidationSummary Class - ASP.NET Website Review - ASP.NET
	Azure
	Azure Blob Service - C# Azure Functions Version Configuration Settings - .NET Framework Managing Durable Function Orchestrations - Azure and C# QueueEngine Class - Azure Timer Triggers in Azure Functions - NCRONTAB Expressions Transforming AppSettings.json to Azure Configuration Settings Updating the Firewall for SQL Azure Database
	C and C-plus-plus
	C++ Data Types C++ Functions C++ Logic Flow Control C++ Operators C++ Pointers and References Console Input and Output - C++
	Class Library
	ActionValidator Class - ASP.NET ActiveDirectoryQuery Class AttachmentSelector Web Control - ASP.NET Cascading DropDownLists - jQuery CheckBoxList Class - ASP.NET Class Library Pages CompareValidator Class - ASP.NET ConfigMgr Class ConnectionString Class - .NET Framework Consuming Custom Controls in ASP.NET CustomValidator Class DataTypeValidator Class - ASP.NET DeveloperPanel Class - ASP.NET FileUploadExtender Class - ASP.NET GridView Class - ASP.NET GridViewExtender Class - ASP.NET GridViewRowExtender Class Journal Class and Logging - ASP.NET MailServer Class MyGridViewRow Class - ASP.NET Numeral Class Paging Data and the PageSelector Control Parser Class Password Generator - ASP.NET QueryString Class RegularExpressionValidator Class - ASP.NET RequiredFieldValidator Class - ASP.NET ServerVar Class - ASP.NET Settings Class - ASP.NET SqlDatabase Base Class - SQL Server and .NET Framework SqlDatabaseWeb Class - ASP.NET SSRS Extender Cache Class TelephoneNumberTextBox Class - ASP.NET TextBox Class - ASP.NET ValidationSummary Class - ASP.NET
	Code Generator
	Database-Table-Wrapper Class Code Generator jQuery-UI Tab Code Generator
	Code Sample
	Database Layout - SQL Server Database Object Counts - SQL Server DbIndexes View - SQL Server FileUpload Control Sample - ASP.NET ProperCase Function - SQL Server SqlDatabase Base Class - SQL Server and .NET Framework Using MSBuild Community Tasks to create an installer
	DB2
	Special Registers - DB2 SQL Formatting System Tables - DB2 Useful Commands - DB2
	Design Patterns
	Desktop Applications
	DotNetNuke
	HTML Content in the Database - DotNetNuke
	EF Core
	AuditableBase Class for Automatically Tracking Data Changes - Entity Framework Code First Comparing Migrations In Code Versus The Database - EF Core Concurrency Exceptions - Entity Framework 6 and EF Core Data-Level Security - ASP.NET Core and EF Core Disabling Cascade Deletes - EF Core Extensions Method to Sync Join Table Data - EF Core How to Make a Field an Identity Field - EF Core 3 Subset Relationships (a.k.a. Extension Tables) - Entity Framework Core
	Entity Framework Code First
	AuditableBase Class for Automatically Tracking Data Changes - Entity Framework Code First AuditListener - Entity Framework Calling a Stored Procedure from Entity Framework - EF6 Code First Entity Framework - .NET Framework Concurrency Exceptions - Entity Framework 6 and EF Core Disabling Code-First Data Model Checking - Entity Framework Extension Method to Seed Enum Values into Database Table - Entity Framework Code First How to Make a Field an Identity Field - EF Core 3 Merging Entity Framework Code First Migrations - Entity Framework Code First Relationships in Entity Framework Code First
	General Information
	Annuity Calculations ASCII Codes Case Types: Camel, Pascal, etc Common Software Estimate Elements Common Software Tests Converting Between Hex and Integer Countries of the World Creating a Self-Signed Certificate for Local Development Use Default Browser Deployment Checklist HOSTS File Location MAC Addresses Recurrence Patterns States and Their Postal Codes System Dossier Telephone Keypad Time Zones Types of Numbers View-Certificate Feature in Google Chrome XFDL File Decoding
	HTML and CSS
	Apostrophes - Correct Usage in HyperLinks Cascading Style Sheets Quick Reference Cascading Style Sheets Reference Color Table - HTML Creating a Reset Button - ASP.NET Creating Rounded Corners - Cascading Style Sheets Disabling Autocomplete - HTML5 Favorites Icon - Creating and Installing a FAVICON.ICO File Fixed Navigation Bar - CSS Hand Cursor - CSS HOSTS File Location Image Maps - HTML Internet Explorer Quirks MailTo Protocol - Avoiding Spammers Media Queries Read-Only Fields - Displaying as Disabled - CSS Remote Connections to IIS in Windows 7 Rotating Text with CSS Special Characters - HTML Taking Down a Website for Maintenance - ASP.NET Target Attribute - HTML/JavaScript Uploading Files - ASP.NET MVC2 Validation Controls - ASP.NET Web Browser Differences with CSS
	iPad
	MAC Addresses Tips and Tricks - iPad
	Jasinski Software
	Jasinski Visual Studio 2005 Add-In Outline Formatting Provider - Jasinski Software Web Notebook Registry Entries - Jasinski Software What's-New Formatting Provider - Jasinski Software
	JavaScript, jQuery, and Angular
	AJAX Example - jQuery and JavaScript Angular Notes Angular Walkthrough Apostrophes - Correct Usage in HyperLinks Cascading DropDownLists - jQuery Characters Left - JavaScript Checklist in HTML and jQuery Code Snippets - JavaScript ConfirmExt Function - JavaScript Copying Text to the Windows Clipboard - JavaScript Current Time - JavaScript Date Formatting - JavaScript Date Validation - JavaScript Date-Picker Source and Demo - JavaScript Disable the Submit Button - jQuery Exception-Handling in JavaScript Extensions - jQuery Flyouts - JavaScript Helper Functions - jQuery Internet Explorer Quirks jQuery-UI Tab Code Generator MailTo Protocol - Avoiding Spammers Marquee - Javascript Modal Dialogs - JavaScript Namespacing in JavaScript QueryStrings in JavaScript Quick Reference - Angular Quick Reference - JavaScript Quick Reference - jqGrid Quick Reference - jQuery Regular Expressions in JavaScript Security - Showing and Hiding Page Elements Based on User Role Sorting - JavaScript TextArea MaxLength Enforcement - jQuery Window Object's Open Method - JavaScript Words Left - JavaScript
	LINQ
	LINQ Examples SQL Statement used by LINQ Stored Procedures with Entity Framework
	Linux
	Adding a User's Public SSH Key to a Linux Server Configuring a Service to Automatically Start at System Boot - Linux Generating an SSH Key Pair on Windows Using PuTTYgen Migrating a WordPress Site to Amazon RDS
	Lotus Notes
	Managing Rules - Lotus Notes
	MCTS Exam 70-515
	Chapter 01: Introducing ASP.NET 4.0 - MCTS Exam 70-515 Chapter 02: Using Master Pages, Themes, and Caching - MCTS Exam 70-515 Chapter 03: Handling Events and Managing State - MCTS Exam 70-515 Chapter 04: Using Server Controls - MCTS Exam 70-515 Chapter 05: Input Validation and Site Navigation - MCTS Exam 70-515 Chapter 06: Globalization and Accessibility - MCTS Exam 70-515
	Microsoft Office
	Accessing Email Messages - Outlook Automation Adding Subtotals - Excel Annuity Calculations Coalesce Function - Microsoft Access Command Line Options for Various Applications CreateField Script - Microsoft Access CreateLinkedTable Script - Microsoft Access CreateRelation Script - Microsoft Access CreateTable Script - Microsoft Access Dependencies in Microsoft Access Downloading Email from an Exchange Server - Microsoft Outlook Enabling Security - Microsoft Access Excel for Mac - Get File Dialog File Extension Function - VBA Format Property - Microsoft Access HandleNotInList Subroutine - Access Killing Stray Excel References - Excel Automation Linked Server Setup from SQL Server to a Microsoft Access Database Linked Tables - Reattaching Programmatically NetWorkDays Function - SQL Server OneNote Password Issue Phone Number Best Practices - Microsoft Access PrimoPDF - Getting Started Pushing Data To Excel From SQL Server Reading Excel Files with OLEDB Ribbon Creation in Access 2007 Searching All Database Objects - Microsoft Access Security Principles - Microsoft Access Specifying Order of Address Books for Name Resolution - Microsoft Outlook VLookupExt Function - Excel WorkDay Function - SQL Server
	Mongo DB
	Configuring Encryption at Rest - Mongo DB Configuring Encryption in Transit - Mongo DB Configuring Mongo DB Configuring Replication - Mongo DB
	MSBuild
	Using MSBuild Community Tasks to create an installer
	MySQL
	Allowing Remote Connections - MySQL Configuring a Service to Automatically Start at System Boot - Linux Error When Migration MySQL Database to Amazon RDS Migrating a WordPress Site to Amazon RDS MySQLD Dead But Subsys Locked - Troubleshooting MySQL Recurring Issue Resetting the Root Password - MySQL
	NSIS
	Installer Attributes - NSIS NSIS Quick Reference Pages - NSIS
	Oracle
	Cursor Quick Reference - Oracle Data Modelling Standards Function Quick Reference - Oracle PL/SQL Quick Reference - Oracle Sequence Objects Quick Reference - Oracle SQL Formatting SQL*Plus Commands Quick Reference - Oracle SqlBuilder Class System Tables - Oracle Tips and Tricks - Oracle
	PostScript and PDF
	IFilter for PDF Files Merging Reports - SSRS PDFJOIN - Joining PDF Files Practical PostScript
	PowerShell
	Running a PowerShell Script in Windows Task Scheduler
	Quick Reference
	Cascading Style Sheets Quick Reference Cursor Quick Reference - Oracle Function Quick Reference - Oracle NSIS Quick Reference PL/SQL Quick Reference - Oracle Quick Reference - ASP.NET Quick Reference - JavaScript Quick Reference - jqGrid Quick Reference - jQuery Quick Reference - SQL Server Regular Expressions Quick Reference Security in SQL Server SendKeys Class Quick Reference Sequence Objects Quick Reference - Oracle SQL*Plus Commands Quick Reference - Oracle Telerik Grid Quick Reference Trigger Quick Reference - SQL Server T-SQL Quick Reference - SQL Server XSL Quick Reference
	Real Player
	Basics of a Skin - Real Player Skin.ini File - Real Player
	Regular Expressions
	Regular Expression Samples - .Net Framework Regular Expressions in JavaScript Regular Expressions in SQL Server Regular Expressions Quick Reference Using Regular Expressions In The Replace Dialog - Visual Studio
	ScrewTurn Wiki
	File Formats - ScrewTurn Wiki Moving a ScrewTurn Wiki Navigation Paths - ScrewTurn Wiki Outline Formatting Provider - Jasinski Software Page Editing - ScrewTurn Wiki Page Transclusion - ScrewTurn Wiki Snippets - ScrewTurn Wiki Tables - ScrewTurn Wiki What's-New Formatting Provider - Jasinski Software
	Sitecore
	Best Practices and Pitfalls to Avoid - Sitecore Code Snippets - Sitecore Custom Editors - Sitecore Developer Primer - Sitecore Error: Can't Login to Admin Site - Sitecore Hierarchy of Items - Sitecore Installing Sitecore Media Item ID versus File Path - Sitecore Media Library Item Creation - Sitecore Multi-Site Implementation - Sitecore Package Installation - Sitecore Quick Reference - Sitecore Admin Interface Security Overview - Sitecore Sitecore Extensions Methods Sitecore URLs Sublayout Renaming - Sitecore Sublayout Usage - Sitecore Template Usage - Sitecore Unversioned versus Shared - Sitecore
	SQL Azure
	Creating a Database User - SQL Azure Databases and Their Service Objectives - SQL Azure Renaming a Database - SQL Azure Updating the Firewall for SQL Azure Database
	SQL Server
	Add Audit Fields to Every Table - SQL Server Add-Ins - SQL Server Age Last Birthday Calculation Allow Duplicate Nulls in a Unique Index - SQL Server Black Art Of Writing A SQL Server Management Studio 2005 Add-In Bulk Loading a Table without Taking it Offline - SQL Server Bulk Loading of Parent/Child Records - SQL Server Calculating a Running Total - SQL Server Calculating Midnight in a Time Zone - SQL Server Case and Accent Sensitivity in SQL Server Changing the Default Database - SQL Server Class Library Pages CLR Integration - SQL Server Code Object Differences Between Databases - SQL Server Code Objects Line Counter - SQL Server CodeObjectsContaining Function - SQL Server Column Definitions for Stored Procedure Result Set Command Text Generation from a SqlCommand Object Common Option Settings Concat Function - SQL Server Configuring SQL Server Authentication Mode - SQL Server 2005 Connection Strings - SQL Server CONVERT Function Date Formats - SQL Server Copy Every Foreign Key - SQL Server Counter Table - Generating one On-The-Fly - SQL Server Countries of the World CountWords - SQL Server Cracking SQL Server Passwords Creating a Database User - SQL Azure Creating a Linked Server with an Alias - SQL Server Data Migration without SSIS Data Migration without SSIS (for a single table) - SQL Server Data Modelling Standards Database Command Timeouts: Performance Differences between .NET and Management Studio Database Dependencies - SQL Server Database File Sizes - SQL Server Database Layout - SQL Server Database Mirroring Setup - SQL Server Database Object Counts - SQL Server Database Size - SQL Server Database Trigger Sample - SQL Server Database Trigger to Prevent Identity Columns on Extension Tables - SQL Server Database-Table-Wrapper Class Code Generator Date Calculations - SQL Server DateAdd, DateDiff, and DatePart Functions - SQL Server DBCC FREEPROCCACHE - SQL Server DbIndexes View - SQL Server DDL Syntax - SQL Server DDL Trigger Sample - SQL Server Delete Data from All Tables - SQL Server Deleting Data in Foreign Key Order - SQL Server Deleting Duplicates without a Primary Key - SQL Server Deploying a Database - SQL Server Disable Every Foreign Key - SQL Server Drop All Tables - SQL Server Drop Database with Active Connections - SQL Server Drop Every Database Object - SQL Server Drop Every Database Table - SQL Server Drop Every Default Constraint - SQL Server Drop Every Foreign Key - SQL Server Easter Calculation - SQL Server Enabling Remote Connections - SQL Server 2005 Express Environment - SQL Server Estimated Time of Completion Calculation - SQL Server Every Date in a Month - SQL Server Exception Was Thrown by the Target of an Invocation - Visual Studio and SQL Server Management Studio Execute As DBO - SQL Server Expanding Tab Characters - SQL Server Extend Functionality in SQL Server 2005 Management Studio with Add-ins Extended Properties Stored Procedure - SQL Server File Name Parsing Calculations - SQL Server Finding a Column on a Server - SQL Server Finding an Object on a Server - SQL Server Finding Database Compatibility Level - SQL Server Foreign Key Generation from Common Column Names - SQL Server Foreign-Key Pages - SQL Server Formatting Timespans - SQL Server Friday the 13th Analysis in SQL Server Generate a Range of Dates - SQL Server Generating XML from Recursive, Hierarchical Data Getting Current Time in Local Time Zone - SQL Server Grant Execute Permission to Everyone - SQL Server Grant VIEW DEFINITION Permission Across Schemas - SQL Server Granting Execute Rights to Public - SQL Server Hierarchies - SQL Server Index Columns - SQL Server Index Optimization - SQL Server Insert Statement Builder - SQL Server Installing SQL Server Management Studio Express 2008 IP Address Conversion Between Integer and String - SQL Server Job History - SQL Server jQuery-UI Tab Code Generator JSON Data in T-SQL - SQL Server Linked Server Setup from SQL Server to a Microsoft Access Database List Database Permissions - SQL Server List Databases In Use - SQL Server List Every Database Object - SQL Server List Every Foreign Key - SQL Server List Every Index - SQL Server List of Database Files for an Instance - SQL Server List Tables in Dependency (Foreign Key) Order - SQL Server Lorem Ipsum Generator - SQL Server Menu System based on User Roles MERGE INTO Example - SQL Server Multi-Row String Concatenation - SQL Server NetWorkDays Function - SQL Server NULL versus NULL - SQL Server Ordinal Function - SQL Server PadLeft Function - SQL Server Paginate Function Paging Data and the PageSelector Control Percentile Calculation PerformanceMarker Stored Procedure - SQL Server PIVOT and UNPIVOT Syntax - SQL Server ProperCase Function - SQL Server Pushing Data To Excel From SQL Server Quick Reference - SQL Server Randomly Generate a List of Names - SQL Server Re-Associating a Server Login to a Database User - SQL Server Regular Expressions in SQL Server Removing Unwanted Characters from Data - SQL Server Reseeding an Identity Column - SQL Server Restoring an Encrypted Database - SQL Server Rounding Off Datetimes - SQL Server ROW_NUMBER() Function - SQL Server Schema Change Scripts - SQL Server Schema Differences Between Databases - SQL Server Scripting Options - SQL Server Security in SQL Server Security Permission Differences Between Databases - SQL Server Selecting Top Row In Each Group Session ID - SQL Server Setting Maximum Recursions in a Common Table Expression - SQL Server Severe Error Occurred - SQL Server SP_WHO Filtering - SQL Server sp_who2 Substitute - SQL Server sp_who2 with Filtered Results - SQL Server Split-Into-Table Functions - SQL Server Splitting Text - SQL Server SQL Formatting SQL Server Versions SqlBuilder Class SqlDatabase Base Class - SQL Server and .NET Framework SqlDatabaseWeb Class - ASP.NET Stored Procedure Metadata - SQL Server Stored Procedure Template - SQL Server Tab Stops - SQL Server Managment Studio Table Row Counts - SQL Server Tables Used by Stored Procedures - SQL Server Temp Tables and How to Drop Them from Script - SQL Server Time Database Columns in .NET Transforming a Name from First-Last to Last-First Transforming AppSettings.json to Azure Configuration Settings Trigger Quick Reference - SQL Server Triggers - List All - SQL Server T-SQL Quick Reference - SQL Server Undocumented SQL Server 2005 Stored Procedures Update Statement Builder - SQL Server Updating with a Self-Join - SQL Server Using FOR XML Clause - SQL Server Using NULL to Mean "All" Using SP_AddLinkedServer - SQL Server Using SQL-CLR to create a Regular Expression Replace function Using the CROSS APPLY Syntax - SQL Server Using the OVER Keyword - SQL Server Using the XML Data Type - SQL Server VALUES Usage as Table Constructor - SQL Server Word Wrapping - SQL Server WorkDay Function - SQL Server XOR Function - SQL Server
	SQL Server System Tables
	Database File Sizes - SQL Server Databases and Their Service Objectives - SQL Azure Getting Current Time in Local Time Zone - SQL Server Index Columns - SQL Server List of Database Files for an Instance - SQL Server log_shipping_databases System Table - SQL Server 2000 log_shipping_monitor System Table - SQL Server 2000 log_shipping_plan_databases System Table - SQL Server 2000 log_shipping_plan_history System Table - SQL Server 2000 log_shipping_plans System Table - SQL Server 2000 log_shipping_primaries System Table - SQL Server 2000 log_shipping_secondaries System Table - SQL Server 2000 sysalerts System Table - SQL Server 2000 syscacheobjects System Table - SQL Server 2000 syscategories System Table - SQL Server 2000 syscolumns System Table - SQL Server 2000 syscomments System Table - SQL Server 2000 sysconstraints System Table - SQL Server 2000 sysdepends System Table - SQL Server 2000 sysdownloadlist System Table - SQL Server 2000 sysfilegroups System Table - SQL Server 2000 sysfiles System Table - SQL Server 2000 sysforeignkeys System Tables - SQL Server 2000 sysfulltextcatalogs System Table - SQL Server 2000 sysindexes System Table - SQL Server 2000 sysindexkeys System Table - SQL Server 2000 sysjobhistory System Table - SQL Server 2000 sysjobs System Table - SQL Server 2000 sysjobschedules System Table - SQL Server 2000 sysjobservers System Table - SQL Server 2000 sysjobsteps System Table - SQL Server 2000 syslockinfo System Table - SQL Server 2000 syslogins System Table - SQL Server 2000 sysmembers System Table - SQL Server 2000 sysnotifications System Table - SQL Server 2000 sysobjects System Table - SQL Server 2000 sysoperators System Table - SQL Server 2000 syspermissions System Table - SQL Server 2000 sysprocesses System Table - SQL Server 2000 sysprotects System Table - SQL Server 2000 sysreferences System Table - SQL Server 2000 systargetservergroupmembers System Table - SQL Server 2000 systargetservergroups System Table - SQL Server 2000 systargetservers System Table - SQL Server 2000 systaskids System Table - SQL Server 2000 System Tables - SQL Server 2000 systypes System Table - SQL Server 2000 sysusers System Table - SQL Server 2000
	SSIS (SQL Server Integration Services)
	Hiding Excel Sheets from a Script Task - SQL Server Integration Services Merge Join Transformations - SQL Server Integration Services
	SSRS (SQL Server Reporting Services)
	Accessing SQL Server Reporting Services from C# Chart Terminology - SQL Server Reporting Services Common Functions - SQL Server Reporting Services Custom Aggregates in a Matrix Custom Assemblies - SQL Server Reporting Services Data-Driven Subscriptions - SSRS Deploying a Report via Report Server's Web Service - SSRS Downloading Reports from an SSRS Server Environment - SQL Server Extracting Report Content from the SSRS Catalog GreenBar in Reports - SSRS Implementing a Report Viewer Page - ASP.NET MVC Merging Reports - SSRS Multi-Value Parameters and Stored Procedures - SSRS Paginate Function PDF Generation via RDLC Report File Printing Forms - SSRS Printing Forms by Consolidating SQL - SSRS Printing Forms using a Shared Dictionary - SSRS Printing Forms using Report Parameters - SSRS RDL File's XML Namespaces Repeating Row Headers - SSRS 2010 Report File Format - SQL Server 2005 Report Server URLs - SQL Server Reporting Services Setting Up A Report for Email Delivery - SQL Server Reporting Services Shortcomings - SSRS SSRS Extender Cache Class
	Visual Basic 6
	Accessing Email Messages - Outlook Automation ActiveX Data Objects (ADO) with Visual Basic ActiveX DLL Registry Entries ActiveX Objects and Controls - Visual Basic 6.0 COM+ Development COM+ Server Setup Creating a COM object in .NET File Extension Function - VBA Miscellaneous Visual Basic Topics Polymorphism in Visual Basic 6.0 Procedure Attributes - VB6 Read Entire File Contents - VB6 Safely Remove Hardware Version Compatibility
	Visual Studio and Developer Tools
	Accessing SQL Server Reporting Services from C# Add-Ins in Visual Studio Automatically Deploying an Application - Visual Studio Branching, Tagging, and Merging - Subversion Capturing a Login Bearer Token for Subsequent Calls - Postman Changing Visual Studio 2012 Menus to Mixed Case Common Option Settings Conditional Compilation - Visual Studio Creating a COM object in .NET Creating a Subversion Repository Creating a Website - Visual Studio 2005 Creating Templates - Visual Studio 2005 Difference Between Class Library Project and SQL CLR Project Exception Was Thrown by the Target of an Invocation - Visual Studio and SQL Server Management Studio Git Quick Reference GitIgnore Files How To Get Git to Stop Tracking Files in .GitIgnore - Git How To Make SourceSafe Keyword Expansion Work In Text Docs Installer Projects - Visual Studio Installing SQL Server Management Studio Express 2008 Macro to Clear the Immediate Window - Visual Studio 2005 Placing Local Code Under Git Source Control Public URLs in Mockflow Publishing a Website in Visual Studio Express Edition Renaming a Computer - TFS Setting Up a PC for Android Development Splitting Off a Folder Into Its Own Repo - Git Team Foundation Server Basics TFS Usage in SQL Server Management Studio Transforming External Configuration Files - Visual Studio 2010 Using ClickOnce to Deploy an App that Dynamically Loads DLLs Using MSBuild Community Tasks to create an installer Using Regular Expressions In The Replace Dialog - Visual Studio Visual SourceSafe Analyzer Web.Config Transformations - Visual Studio 2010 Web.Config Transformations with Web Setup Project - Visual Studio Working Directories - Team Foundation Server
	Windows (OS, IE, IIS, and MSMQ)
	Adding Find-Target to Context Menu BAT File Programming Certificate Management Console Changing a Windows Password at the Command Line Changing the Drive Letter for a USB Device Clearing Unwanted Entries from Explorer's New Menu Command Line Options for Various Applications Command Prompt Entry in a Folder's Shortcut Menu Completing an SSL Certificate Request Copying Websites Between Servers - IIS Create Local Windows Administrator via Command Line Creating a Self-Signed Certificate for Local Development Use Creating a Self-Signed SSL Certificate with an Exportable Private Key Creating Custom Explorer Bars - Internet Explorer Default Browser Disabling JavaScript - Internet Explorer Enabling WCF Services on IIS8 EXE File Fix Files Ready to be Written to the Disc - Folder Location Forcing SSL with a URL Rewrite Rule - IIS7 FTP Setup on IIS 7 Generating an SSH Key Pair on Windows Using PuTTYgen Granting Permission to AppPoolIdentity - IIS HOSTS File Location Installing a .NET Windows Service Multiple Times Logging Off Another User - Windows Vista MAC Addresses Performance Optimization in MSMQ Reconnect to VPN - C# Remote Connections to IIS in Windows 7 Requesting an SSL Certificate for Multiple Domains Safely Remove Hardware Script to Create a Virtual Directory - IIS Shrinking a Volume - Amazon Web Services Special Folders - Windows Taking Down a Website for Maintenance - ASP.NET Troubleshooting Remote Desktop Useful Windows Registry Entries Windows Registry Settings for Internet Explorer's Proxy Settings Windows Search - Adding File Types
	Windows API
	BitBlt Function - Windows API CloseHandle Function - Windows API Constants - Windows API CopyMemory Function - Windows API CreateFile Function - Windows API CreateFileMapping Function - Windows API CreateRemoteThread Function - Windows API DeviceIoControl Function - Windows API DIRECTORY_BASIC_INFORMATION Struct - Windows API DuplicateHandle Function - Windows API EnumChildWindows Function - Windows API GENERIC_MAPPING Struct - Windows API GetClassName Function - Windows API GetCurrentProcess Function - Windows API GetCursorPos Function - Windows API GetDC Function - Windows API GetDesktopWindow Function - Windows API GetExitCodeThread Function - Windows API GetFileSizeEx Function - Windows API GetKeyState Function - Windows API GetLogicalDriveStrings Function - Windows API GetMappedFileName Function - Windows API GetModuleHandle Function - Windows API GetNamedPipeHandleState Function - Windows API GetParent Function - Windows API GetProcAddress Function - Windows API GetUserName Function - Windows API GetVersion Function - Windows API GetWindowText Function - Windows API GetWindowTextLength Function - Windows API GetWindowThreadProcessId Function - Windows API GlobalAlloc Function - Windows API GlobalFree Function - Windows API GlobalLock Function - Windows API MapViewOfFile Function - Windows API mciGetDeviceIDA Function - Windows API mciSendString Function - Windows API midiOutGetVolume Function - Windows API midiOutSetVolume Function - Windows API mixerClose Function - Windows API MIXERCONTROL Struct - Windows API MIXERCONTROLDETAILS Struct - Windows API MIXERCONTROLDETAILS_UNSIGNED Struct - Windows API mixerGetControlDetailsA Function - Windows API mixerGetLineControlsA Function - Windows API mixerGetLineInfo Function - Windows API MIXERLINE Struct - Windows API MIXERLINECONTROLS Struct - Windows API mixerOpen Function - Windows API mixerSetControlDetails Function - Windows API NtClose Function - Windows API NtOpenDirectoryObject Function - Windows API NtQueryObject Function - Windows API NtQuerySymbolicLinkObject Function - Windows API NtQuerySystemInformation Function - Windows API OBJECT_ALL_TYPES_INFORMATION Struct - Windows API OBJECT_ATTRIBUTES Struct - Windows API OBJECT_BASIC_INFORMATION Struct - Windows API OBJECT_HANDLE_ATTRIBUTE_INFORMATION Struct - Windows API OBJECT_NAME_INFORMATION Struct - Windows API OBJECT_TYPE_INFORMATION Struct - Windows API OpenProcess Function - Windows API POINT_TYPE Struct - Windows API QueryDosDevice Function - Windows API ReleaseDC Function - Windows API SendMessage Function - Windows API SetForegroundWindow Function - Windows API SetWindowText Function - Windows API SYSTEM_HANDLE_INFORMATION Struct - Windows API UNICODE_STRING Struct - Windows API UnmapViewOfFile Function - Windows API Using the Windows API in .Net Languages WaitForSingleObject Function - Windows API Windows Taskbar Wrapper Class - C# WNetGetConnection - Resolve a UNC Path ZeroMemory Function - Windows API
	Windows Registry
	ActiveX DLL Registry Entries Adding Find-Target to Context Menu Clearing Unwanted Entries from Explorer's New Menu COM DLL Location - Windows Registry Command Prompt Entry in a Folder's Shortcut Menu Determining Which Versions Are Installed - .NET Framework Enabling Yahoo Email for the MailTo Protocol MRU (Most-Recently-Used) File Lists for Various Applications Registry Entries to Create Context Menu for DLL and OCX Files Useful Windows Registry Keys Windows Registry Settings for Internet Explorer's Proxy Settings Windows Search - Adding File Types
	WordPress
	Migrating a WordPress Site to Amazon RDS Protecting Against XMLRPC.PHP Exploits on WordPress Sites
	XML, XSL, and XPath
	Building XML Programmatically Changing XSL Code on the Fly - .NET Framework Code Snippets - .NET Framework Displaying an XML DataSet in a DataGridView - .Net Framework Displaying an XSL Transformation in a Web Browser Control - .Net Framework Extracting Report Content from the SSRS Catalog Formatting Raw XML - Microsoft .Net Framework Generating XML from Recursive, Hierarchical Data URL Encoding in XSL Using FOR XML Clause - SQL Server Using the SelectNodes Method with XML Namespaces - .Net Framework Using the XML Data Type - SQL Server XML Encoding XML Serialization of an Object - C# XSL Quick Reference XSL to Display Raw XML

Search Provider¶

To add a search provider for JasinskiOnline.com for your browser (IE, Firefox, Chrome, possibly others),

1. Click here

2. Click the "OpenSearch plug-in Jasinski Online" link.

Recent Changes¶

Wed, May 31, 2023, 5:31 PM	Administrator updated the page VALUES Usage as Table Constructor - SQL Server.
Wed, May 31, 2023, 5:31 PM	Administrator updated the page VALUES Usage as Table Constructor - SQL Server.
Mon, May 22, 2023, 6:27 AM	Administrator updated the page Redirecting Process Output.
Thu, May 11, 2023, 8:06 AM	Administrator updated the page DbIndexes View - SQL Server.
Thu, May 11, 2023, 6:52 AM	Administrator updated the page DbIndexes View - SQL Server.
Thu, May 11, 2023, 6:51 AM	Administrator updated the page DbIndexes View - SQL Server.
Wed, Mar 29, 2023, 9:23 AM	Administrator updated the page Placing Local Code Under Git Source Control.
Thu, Mar 09, 2023, 7:56 AM	Administrator updated the page Parsing a Person's Name - C#.
Wed, Mar 08, 2023, 4:54 PM	Administrator updated the page Parsing a Person's Name - C#.
Wed, Mar 08, 2023, 4:51 PM	Administrator updated the page Parsing a Person's Name - C#.

Credits¶

• Microsoft Access 2.0 Help file
• Guide to Data Access Objects, Chapter 6 of the Visual Basic 4.0 Professional Features manual, by Microsoft Press.
• Introduction to Oracle: SQL and PL/SQL, Student Guide, Volumes 1 and 2, Copyright © 1998, 1999 by Oracle Corporation.
• Microsoft SQL Server 7.0 Database Design, computer-based training by NETg
• SQL Server 7.0 Programming Unleashed, by John Papa, Matthew Shepker, et al., Copyright © 1999 by Sams Publishing.
• Intermediate Visual Basic 5.0 Programming, by Application Developers Training Company, 7151 Metro Blvd., Suite 175, Minneapolis, MN 55439, 1-800-578-2062.
• Advanced Visual Basic 5.0 Programming, Ibid.
• Microsoft Visual Basic 5.0 Help file.
• Beginning Visual C++ 6, by Ivor Horton, Copyright © by Wrox Press.
• Portions adapted from the now defunct website WWW.VBAPI.COM, Copyright © 1999-2001 by Paul Kuliniewicz.