For a while, I’ve been wanting to explore deeper or “hack” into the internals of the BizTalk Databases, i.e. BizTalkMsgBox and BizTalkDTA. When do records gets stored in these database, how long do they stay there, and when do they get “cleaned-up”. So here is my first scenario. I use a SQL command to Find […]
In this blog, I’ll be showing how a Microsoft cursor in T-SQL is similar to and different from the most similar cursor in Oracle. Oracle actually has 3 or 4 ways to do “explicit” cursors, so in this blog, we will look only at the one that is most similar. I tried to format […]
For this blog, I create an employee table using the Oracle’s GUI tool called “SQL Developer”. I then exported that syntax to a file.With a few changes I added to Microsoft SQL Server (after adding the schema first), and modified it to include a primary key. My only reason to port this over was to […]
Below I have put together some of my favorite examples of how to use Join-Path. One of the primary features it to be able to combine a folder and a filename, without caring if the folder ends with a trailing slash or not. That is the first thing illustrated below (Path1/Path2). Path3 shows how to […]
<h1>Estimated Completion Time in PowerShell</h1> Progress Bars are all about giving the user feedback as to what the program is doing, and Powershell implements it with the Write-Progress cmdlet. It is also possible to predict the completion time by using a little math. Possible uses for the progress bar include: Showing status of reading a […]
In a prior blog, I demonstrated how to call a SQL Stored Proc from Powershell. But that article did not discuss error handling. In the stored proc, it stored two tables in a parent/child relationship. If the parent “key” was not found, then the child row cannot be stored. The parent is the based on […]
Sometimes you call SQL just to store data, but even then, sometimes you need the key of the row just stored. This code will show you how to get back that single return value when calling a stored proc, even when it is an “ExecuteNonQuery” stored proc, that returns no row sets. It is typical […]
Cannot connect to Amazon RDS with SSMS Amazon allows you to run an Relational Database Server (RDS) that runs several of the common editions of Microsoft SQLServer. After setting up your RDS server/instance and launching it, you may have issues connecting to it. Cannot connect to SQLServer – Error Message Microsoft SQLServer has a very […]
How to Call Functions in Powershell – The Right Way This applies when your function is in a different file than the program you are running. How do you proplery “include” functions in other files and directories? My secret is to use the $PSScriptRoot built-in variable. If you don’t fully qualify the path, then I’ve […]
How Call a SQL Stored Procedure from Powershell This blog discusses how to call a stored procedure that takes several input parms, but doesn’t return any data. For instance, you are calling a stored proc to insert data into one or more database tables. When you are not expecting data back, you don’t need the […]